Download SCCM Configmgr 2012 SQL Views Documentation

Configuration Manager Queries SQL Server views in the Configmgr site database when retrieving the information displayed in reports .Configmgr database contains large information about computer,User related resource and other components as well.

If you are looking for some particular information while creating reports and if you are not sure which table the information has,you will stuck there else you will have guess the table/view to get what is desired.

SQL views contain the information you need for your reports to make reporting easier.

I cont find any document or related resources for SCCM 2012 SQL views .

Russ from Microsoft replied on the forums to get SQL views in SCCM 2012.

Here is the SQL query to get list of views with its columns Available in Configuration Manager 2012 Database.

Select distinct table_name,COLUMN_NAME From Information_Schema.columns

where table_name LIKE ('v_%')

Order by table_name

Download the excel sheet exported with Pivot Table from here

Creating Custom Reports By Using Configuration Manager 2007 SQL Views http://www.microsoft.com/en-us/download/details.aspx?id=22052

9 Responses to "Download SCCM Configmgr 2012 SQL Views Documentation"

  1. Good analysis - I loved the points - Does someone know where my business can acquire a fillable a form version to fill out ?

    Reply
  2. Hello Eswar,

    Could you please help me with some document that will help me what these views signify.

    I mean to understand the database better and prepare better reports.

    Reply
    1. Could you please help me with some document that will help me understand what these views signify.

      I mean so that i can understand the database better and prepare better reports.

      Reply
      1. All the names are self explanatory .for ex: V_R_system view contains information about computer,IP address,AD site,User name etc. What are you expecting more on the document ? This sheet will just help you to identity the information available in what view nothing more.

        Reply
    2. All the names are self explanatory .for ex: V_R_system view contains information about computer,IP address,AD site,User name etc. What are you expecting more on the document ? This sheet will just help you to identity the information available in what view nothing more.

      Reply

Leave a Reply