MDM Reporting Services provides a reporting and data access service across all feature areas of MDM. MDM Reporting Services is based on and integrated with SQL Server Reporting Services 2005 (SSRS).
You can download the MDM Reporting Services from this Microsoft Web site: http://go.microsoft.com/fwlink/?LinkID=116247. The MDM Reporting Services User Guide, included in the download, provides information to help you understand and run MDM reports. For more information about MDM Reporting Services, see Reporting Services User's Guide for MDM 2008.
The Device Asset Report is a useful report to use with Exchange Server integration. This report provides a history of each managed device, including the system identifier (ID) that the managed device has been assigned based upon the hardware ID — that is, the IMEI, MEID, or ESN number. The report also lists the people to whom the managed device has been assigned, based on their system ID and the device hardware ID.
The Group Policy Objects Report describes MDM Group Policy information for groups of items, such as the number of managed devices to which a specific Group Policy setting has been applied. The report also lists the success and failure of specific Group Policy actions that MDM Group Policy has attempted to apply to each managed device. The report rolls up Group Policy information based upon the following aspects:
-
The number of devices affected by a specific Group Policy
-
The success rate of Group Policy objects
-
The failure rate of Group Policy objects
For each line in the report, you can drill down to view the details for each managed device.
You can use the following parameters to filter the results of the report:
-
Device Domain
-
Device OU
-
Policy Name
-
Status
The Group Policy Settings Report describes MDM Group Policy information for groups of items, such as the number of managed devices to which a specific Group Policy has been applied. You can also list the success and failure rates of specific Group Policy settings performed on each managed device. This report rolls up Group Policy information based upon the following aspects:
-
The number of devices affected by a specific Group Policy
-
The success rate of Group Policy settings
-
The percentage failure rate of Group Policy settings
For each line of the report, users can drill down through the report details to view the details of each device.
You can use the following parameters to filter the results of the report:
-
Device Domain
-
Device OU
-
Device Name
-
Category
-
Policy
-
Status
To create custom reports, you can use the SQL Server Report Builder tool together with the report models provided with MDM Reporting Services. Report Builder has a report layout template that contains predefined data regions. You can select a predefined report model, which contains report items such as data fields; then drag-and-drop the report items onto the data regions in the template. You can apply filters to the report to refine the data to be displayed. The MDM report model contains all of the information required for Report Builder to automatically generate a query to retrieve the requested data.