What is new in Configuration Manager 2002 reporting

Microsoft has released Microsoft Endpoint Manager Configuration Manager build 2002 (MEMCM) via the opt-in method (fast-ring) which will is now available for you to install and also baseline version however the baseline media is not yet available for the download. The baseline version will be released when the build is made available to the console via slow-ring.

If you want to install a new Configuration Manager sites (fresh build), you can download 1902 as a baseline from the volume licensing portal until 2002 is released.

For more information about how to perform the in-console update for configuration manager update 2002, please refer here

After the in-console update, you need to manually upgrade any secondary sites by right click on the site and choose the upgrade.

You also need to update your Configuration Manager clients to the latest version (2002) to avail the new client features that were added.

With this update 2002 build, there are a bunch of new features added. This means, there are also a number of SQL tables/views added which will help us to create some great custom reports.

The following are the newly added SQL views/tables/functions for custom reporting.

v_Applications
v_BoundaryGroup
v_CIRemediationHistory
v_ConsoleDistinctLatestStartUpDuration
v_ConsoleLatestStartUpDuration
v_ConsoleLatestStartUpDurationPerUser
v_DefaultBrowserData
v_DeviceApplicationState
v_GS_BROWSER_USAGE
v_HS_BROWSER_USAGE
vApp_TSDTAssignmentReferences
vApp_TSDTReferences
vCMGS_AppProgramSyncData
vCMGS_CollectionSyncData
vSMS_Azure_CloudServiceHist
vSMS_CM_FeatureStatusAll

Since the Technet gallery is retiring very soon, I have uploaded the Microsoft Endpoint Manager SQL Views for the build 2002 and also the previous builds to Github for your reference.

Download the SQL views for reporting from Github

Happy reporting!

Recommended reading:

SQL Server views in Configuration Manager

Creating custom reports by using SQL Server views in Configuration Manager

Leave a Reply