After the release of Configmgr V1511,really busy setting up the new lab,upgrading the stuff from Configmgr 2012 R2 SP1 to SCCM Configmgr V1511 (In Place) and doing things with it.
This post is about,what are the SQL views in SCCM Configmgr V1511 that helps you to write custom SSRS /SQL queries.
As you know,there are lot many changes/updates in newly released Configmgr V1511 from its previous version I.e Configmgr 2012 R2 SP1 ,along with it,there are also newly added SQL views that help you to generate reports for the newly added features.So for this,we need to have that information in hand when writing custom reports else you will stuck and spend lot of time in getting what you need.
I use this SQL views documentation spreadsheet a lot when writing the custom SSRS Reports and I always make this as reference for any such custom reports and it help a lot without searching here and there for ex: where does the information stored about IP address or software update scan ,task sequence package information or software update scan results etc.
Download SCCM Configmgr V1511 SQL views documentation from TechNet Gallery here .
I have color coded (Black color Bold) the SQL views that are added newly in Configmgr V1511 from Configmgr 2012 R2 for your information.
Happy SSRS/SQL Reporting .