Freigeben über

Configuration Manager 2012 SP1 All-Inclusive SQL Database Views Listing

  • Artikel

Happy MMS 2013 everyone!  Only 2 days, 12 hours, and 20 minutes to go according to the MMS 2013 official countdown clock.  I’m looking forward to seeing all the old faces and meeting some new ones.  I’ll be lab proctoring in the HOL B labs Tuesday from 8:30-11:30, and HOL A labs Wednesday and Thursday from 8:30-11:30.  If you’re stopping by, I really like my coffee with a couple or three Splendas (I really don’t mind putting the Splenda in myself!!!)  If it’s before 9am, don’t be too alarmed if I’m talking to you with my eyes shut while laying under the tables.

So the following question came up today on MyITForum’s amazingly helpful MSSMS e-mail list (https://myitforum.com/myitforumwp/services/email-lists/) which I highly recommend every SCCM admin subscribes to:

Q: Microsoft used to post the SQL views for ConfigMgr 2007, Does anyone know where I can find the SQL views for ConfigMgr 2012?

A: So I ran the following query against my CM_xxx database:

Select distinct table_name,COLUMN_NAME From Information_Schema.columns
where table_name LIKE ('v%')
Order by table_name

I saved the results out to a .RPT file, imported it into Excel, Inserted a PivotTable, and viola, a list of all SQL views and their associated columns for Configuration Manager 2012. 

Download link for the spreadsheet : https://sdrv.ms/16zxy8I

Anyone feel like typing in a description for each?

image 

Comments

  • Anonymous
    April 05, 2013
    Thanks for nice document.Blogged on eskonr.com/.../download-sccm-2012-sql-views-documentation  upon seeing your Email ;) for reference,

  • Anonymous
    July 23, 2013
    Hi Russ, thanks for this useful information. We are working on a new version of the SQL views documentation and hope to get it out to everyone in the near future. Thanks! Rob

  • Anonymous
    August 09, 2013
    thanks for the documentation.  I hope an official document is forthcoming soon.

  • Anonymous
    October 21, 2013
    Great, thanks Russ

  • Anonymous
    October 22, 2013
    Hi Russ.. I wanted to know that, where does the edition of a particular software for eg. SQL SERVER 2008 R2, gets stored in SCCM database? I mean, there would be some table or view in SMS_CEN database, where edition information is stored. I am having SCCM 2007 installtion. Kindly suggest..

  • Anonymous
    October 23, 2013
    Ashay, check this link, I've used this in the past for this purpose and it worked well myitforum.com/.../installed-sql-05-and-08-version-information-via-configmgr-hardware-inventory.aspx

  • Anonymous
    December 19, 2014
    Any update on this? Looking for a list of SQL tables and description of each