SQL view and tables in Config Manager 2012

Hi All,

We all are aware of CreatingCustomReportsByUsingSQLViews.msi which has the excel and Visio diagram for SQL table and views for Configuration Manager 2007.

Please let us know if you have one for Configuration Manager 2012? If not what are the newly / changed table / views in Config manager 2012. We require this information to verify the current reports (We dont use Config Manager now) can be met when Config Manager 2012 implemented.

Thanks & Regards,

May 15th, 2012 6:29pm

There's no updated version available yet.
Free Windows Admin Tool Kit Click here and download it now
May 15th, 2012 7:14pm

Any idea when will this be available ?
May 22nd, 2012 5:21pm

I haven't heard of any announcements yet.
Free Windows Admin Tool Kit Click here and download it now
May 22nd, 2012 5:30pm

My guess would be ~2-5 months from now, aka when the SDK is released. The SDK is scheduled to be released 3-6 months after RTM, which happened April 17<sup>th</sup>, so October 17<sup>th</sup>, is my guess.

Honestly there is that much of a big difference between the CM07 and CM12 with respect to views. I would work with the CM07 doc and if you have specific question, I would post them in the SDK forum.

May 22nd, 2012 5:33pm

Any update on this?  These are really critical to getting the most out of reporting.  I'm specifically looking for UDA views but obviously the entire view schema would be nice.
Free Windows Admin Tool Kit Click here and download it now
March 6th, 2013 5:16am

Nothing has been announced yet.
March 6th, 2013 10:20am

Anyone has any idea on when it will be avaliable?
Free Windows Admin Tool Kit Click here and download it now
April 17th, 2013 6:43am

No.   
April 17th, 2013 9:57am

While searching for some help I got some info. I think it will be helpful, below is the query you can run to find out all available views:

Select distinct table_name,COLUMN_NAME From Information_Schema.columns
where table_name LIKE 'V_%'
Order by table_name

To Download the excel sheet exported with Pivot Table please go to the below URL:

http://eskonr.com/2013/04/download-sccm-2012-sql-views-documentation/

Free Windows Admin Tool Kit Click here and download it now
April 17th, 2013 6:47pm

Yep, or you could just look at the 'Views' section of your DB in SQL Management Studio.  Either way still leaves it to you to figure out the relationships between views, which just requires a bit more work.  I was hoping Microsoft would just hand it to us :)
April 17th, 2013 6:55pm

Yep, or you could just look at the 'Views' section of your DB in SQL Management Studio.  Either way still leaves it to you to figure out the relationships between views, which just requires a bit more work.  I was hoping Microsoft would just hand i
Free Windows Admin Tool Kit Click here and download it now
April 17th, 2013 7:50pm

Hi,

Is it available now for SCCM 2012 ?

Regards,

Vinod

May 28th, 2013 10:16am

Hi,

No there is still no such download available.

Regards,
Jrgen

Free Windows Admin Tool Kit Click here and download it now
May 28th, 2013 10:22am

Hi, just wanted to let you know that a new version of this doc for Configuration Manager 2012 is currently being tested and is due for release sometime in December.
November 6th, 2013 1:30am

Hi, just wanted to let you know that a new version of this doc for Configuration Manager 2012 is currently being tested and is due for release sometime in December.

Hi Rob, Will it also cover RBA too? ;-) If I give you a beer, can I get an advance copy? <Grin>
Free Windows Admin Tool Kit Click here and download it now
November 6th, 2013 2:01am

Any news on this?
February 5th, 2014 12:48pm

Any news on
Free Windows Admin Tool Kit Click here and download it now
February 5th, 2014 1:55pm

ah.. i was hoping it would be a msi like in sccm sql views.. listed out as a visio diagram.
February 5th, 2014 3:04pm

You can still use the CM07 one, not much has changed, except for RBA stuff.

Free Windows Admin Tool Kit Click here and download it now
February 5th, 2014 3:18pm

And User Device Affinity
February 5th, 2014 4:15pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics