With the release of SCCM Configmgr current branch 1802 ,there are some exciting features added from its previous version 1710. When there are new features released ,certainly there will be changes to the database hence sql views/tables created which will help us to create some nice SSRS reports for reporting.
So with this current branch version 1802 ,what's new in SQL for reporting ?
There are about1586 unique SQL views with lots of information that you can retrieve the data from SQL database help you to analyze the data.
Out of these SQL view,there are about 19 SQL views which are newly added from its previous configmgr version 1710 listed below. There could be some SQL views that are common in this new version and old versions but some new data fields added which are not listed here.
Some of newly added SQL views listed below ,you might have already seen in Configmgr Technical preview releases , however they are now into production release.
As usual ,you can download the SQL views documentation from ConfigMgr 2012 to Configmgr Current Branch 1802 from Technet here
Happy reporting !