Microsoft has released update 2010 for Endpoint Manager Configuration Manager , the last build for this year with some great and enhanced features, for a complete list, please refer to https://docs.microsoft.com/en-us/mem/configmgr/core/plan-design/changes/whats-new-in-version-2010
This build version is currently available for you to install via opt-in method (fast-ring). You can download the script from and run it on your ConfigMgr site. To download the script, refer to https://docs.microsoft.com/en-us/mem/configmgr/core/servers/manage/checklist-for-installing-update-2010#early-update-ring
With this update 2010, there are a bunch of new features added. This means that, there are also a number of SQL tables/views added which will help us to create some great custom reports to our customers.
Lets see what are the newly added SQL views/tables/functions that we can use for custom reporting.
Following are some of the list which will add value to the business.
| v_DeviceScriptRunDetails |
| v_DeviceScriptStatus |
| v_GS_BATTERYCYCLECOUNT |
| v_GS_BATTERYFULLCHARGEDCAPACITY |
| v_GS_BATTERYRUNTIME |
| v_GS_BATTERYSTATICDATA |
| v_GS_BATTERYSTATUS |
| v_LU_LifecycleProductGroupsUnfiltered |
| v_ScriptInformation |
| v_SetupDiagErrorMachines |
| vSMS_CollectionEvaluationFull |
| vSMS_CollectionEvaluationIncremental |
For a complete list of SQL views available in Configuration Manager 2010 and what’s new in 2010 compared with its previous build 2006, please refer the documentation available at Github