Russ Rimmerman - ConfigMgr Guy

Russ Rimmerman - Microsoft Sr. Premier Field Engineer - ConfigMgr / Configuration Manager

Configuration Manager 2012 SP1 All-Inclusive SQL Database Views Listing

Russ Rimmerman - ConfigMgr Guy

Russ Rimmerman - Microsoft Sr. Premier Field Engineer - ConfigMgr / Configuration Manager

Configuration Manager 2012 SP1 All-Inclusive SQL Database Views Listing

  • Comments 6
  • Likes

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 (http://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 : http://sdrv.ms/16zxy8I

Anyone feel like typing in a description for each?

image 

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

  • 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

  • thanks for the documentation.  I hope an official document is forthcoming soon.

  • Great, thanks Russ

  • 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..

  • 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

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment