Long ago,posted Configmgr SP1 SQL Views in spreadsheet which you can download it via post http://eskonr.com/2013/04/download-sccm-2012-sql-views-documentation/.
SQL Views are very useful while working with reports and it saves lot of time in searching the particular information if you are unsure where it resides.
SQL Views provides the information help you in creating custom reports, determine which configmgr 2012 R2 SQL views contain the information you need for your reports, and identify the path between the necessary SQL views and determine what columns can be used to join them.
With the release of Configmgr 2012 R2,there has been some SQL Views added extra from its previous version (i.e Configmgr 2012 SP1),with this,i would like to share the updated spread sheet with the available SQL Views.
Total number of SQL Views in Configmgr 2012 R2:1434 and columns :21104,for list of total sql views,its column and its datatype (int,varchar,varbinary etc) Download the spreadsheet from TechNet gallery
1 Comment
Pingback: SQL query to obtain list of SCCM SQL views for report building. | System Center Guru