Microsoft released new version of SCCM Configmgr Current Branch 1606 (YY MM) with lot of new features and improvements to the existing features. You can install this update via in-console update.
With this new update ,there are also couple of newly added SQL views compared to its previous update (1602) which will help us to create reports in better way.
So ,what’s new in SCCM Configmgr CB 1606 SQL reporting ? Lets have a look at ,what are SQL views added newly and also have this SQL Views document handy for reporting ,otherwise , you may end up looking into the database for the correct information.
There are 3 SQL views added with this update version (1606) compared to its previous version 1602 ,listed below:
v_GS_ClientEvents
v_GS_OFFICE365PROPLUSCONFIGURATIONS
v_MDMDeviceCategory
Download the SQL View documentation for SCCM Configmgr Current Branch 1606 from TechNet Gallery.
For Other Configmgr version, you can download the SQL Views for Configmgr 1602, Configmgr 1511 , Configmgr 2012 R2 SP1, Configmgr 2012
Recommended Reading :
SQL Server Views in System Center 2012 Configuration Manager
2 Comments
Eswar,
Do you by chance have a report for all SQL versions/editions in enterprise, for License use and inventory???
Hi Charles,
I do have report(rdl) file for SQL versions and editions but it doesn't exist in SCCM database by default unless you modify the MOF file or use something like this https://home.configmgrftw.com/sql-server-inventory-using-configmgr/
If you still have questions ,i can write blog post on how did i achieved it using above link.
Regards,
Eswar