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.
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.
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.
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?
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/
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
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
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>
November 6th, 2013 2:01am
Any news on this?
February 5th, 2014 12:48pm
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.
February 5th, 2014 3:18pm
And User Device Affinity
February 5th, 2014 4:15pm