What is new in Configuration Manager 1910 reporting

Microsoft has released update 1910 for SCCM which is now termed as Microsoft Endpoint Configuration Manager (#MEMCM) and is available as in-console update ONLY. You can apply this update on sites that runs on 1810 and later. For more information, please read

If you want to install a new Configuration Manager site, you can download 1902 as a baseline from the volume licensing portal.

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

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

You also need to update your Configuration Manager clients to the latest version (1910) to newly supported client features.

With this update 1910, there are a bunch of new features added. This means, there is 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/SMS tables for custom reporting.

v_AppGroupDisplayProperties

v_AppGroupTargetingDeploymentInfo

v_BLM_AvailableCollections

v_BLM_CI_ID_AND_COLL_ID

v_BLM_CI_IDs

v_BLM_ComplianceStatus

v_GS_BITLOCKER_DETAILS

v_GS_MBAM_POLICY

v_GS_OFFICE_CLIENTMETRIC

v_GS_OFFICE_DEVICESUMMARY

v_GS_OFFICE_DOCUMENTSOLUTION

v_GS_OFFICE_MACROERROR

v_GS_OPERATING_SYSTEM_EXT

v_R_ProvisioningSystem

vCMGS_DeviceExtInfo

vDeviceActionsHistory

vSMS_OfficeActualHealthSummary

vSMS_OfficeAddinHealthDetail

vSMS_OfficeDevicesReadyToDeploy

vSMS_OfficeMacroHealthDetail

vSMS_OfficeMacroHealthSummary

vSMS_OfficePilot

vSMS_OfficePilotAddInsHealth

vSMS_OfficePilotDevicesHealth

vSMS_OfficePilotDevicesReadyToDeploy

vSMS_OfficePilotMacrosHealth

vSMS_OrchestrationGroup

vSMS_OrchestrationGroupMembers

vStateMsgErrorStats

we can make use of these SQL views and create variety of dashboards.

Some of the interesting things that will be useful are:

v_GS_BITLOCKER_DETAILS

vDeviceActionsHistory

vSMS_Office*

Download Microsoft endpoint configuration manager (#MEMCM) SQL views documentation for 1910 from TechNet  https://gallery.technet.microsoft.com/SCCM-Configmgr-2012-R2-SQL-5fefdd3b

For more information about Configuration manager 1910 ,please read http://eskonr.com/2019/11/configuration-manager-update-1910-is-now-available-as-microsoft-endpoint-configuration-manager-current-branch/

Happy reporting!

Leave a Reply