Data Dictionary for SCCM database?

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Data Dictionary for SCCM database?

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Data Dictionary for SCCM database?

Page: [1]

Message

<< Older Topic Newer Topic >>

Data Dictionary for SCCM database? - 9/24/2008 9:49:22 AM

Winston Smith

Posts: 53
Score: 0
Joined: 12/18/2007
Status: offline

Does anyone know if there's a data dictionary for the SCCM database? I would be very helpful (as opposed to hunting around report views for the fields I need). I asked the chowder heads at MS Support, but they claim such a thing does not exist. If true, I would find this very surprising.

Post #: 1

RE: Data Dictionary for SCCM database? - 9/24/2008 10:38:38 AM

jnelson993

Posts: 899
Score: 127
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

I've asked the same thing. They say there isn't. There used to be in one of the appendices for SMS 1.2 or 2.0 I believe, but that's not quite going to cut it.

Garth was working on something like that a while ago I think, but I never heard where it went.

Of course, we've got the Dude from Dudeworks on staff here so he just hooks us up with some magic code to provide descriptions of WMI classes, fields and sample data...dudeworks.com

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to Winston Smith)

Post #: 2

RE: Data Dictionary for SCCM database? - 9/24/2008 11:58:47 AM

gjones

Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline

All I can say is "I have seen a prelease of something that is Wicked!" I will talk to my contacts at MS to see what they say the ETA is.

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx

(in reply to jnelson993)

Post #: 3

RE: Data Dictionary for SCCM database? - 9/24/2008 2:03:27 PM

deby301

Posts: 2
Score: 0
Joined: 4/1/2008
Status: offline

Hey Everyone,

I am the Technical Writer who has been working on the "Creating Custom Reports Using Configuration Manager SQL Views" document. This document will be much like the SMS 2003 version, but this time I will be bundling a Visio document that shows all of the views and which columns can be used to join them to other views - a relationship map by view category, and an Excel spreadsheet that lists the views and columns with the standard CHM file. The documents are currently going through our edit process and will hopefully be available to you on our download site by late October. I'll definitely let everyone know as soon as it's available.

Thanks!

Doug Eby
Senior Technical Writer - Microsoft

< Message edited by deby301 -- 9/24/2008 2:04:32 PM >

(in reply to gjones)

Post #: 4

RE: Data Dictionary for SCCM database? - 9/24/2008 2:25:56 PM

Winston Smith

Posts: 53
Score: 0
Joined: 12/18/2007
Status: offline

That's great news. Thanks!

(in reply to deby301)

Post #: 5

RE: Data Dictionary for SCCM database? - 9/25/2008 8:33:01 AM

hcortez463

Posts: 780
Score: 62
Joined: 4/8/2005
Status: offline

SWEET!!!

_____________________________

If it Helps, Please rate....

(in reply to Winston Smith)

Post #: 6

RE: Data Dictionary for SCCM database? - 10/29/2008 11:39:51 PM

deby301

Posts: 2
Score: 0
Joined: 4/1/2008
Status: offline

The "Creating Custom Reports by Using Configuration Manager 2007 SQL Views" documentation is now available for download!!!

Creating custom reports in Configuration Manager can be a challenge, not only to create the SQL statement for the report, but to figure out what SQL view contains the information you need and how the SQL views can be joined together. The Windows Installer CreatingCustomReportsByUsingSQLViews.msi package provides information that will help you to create custom reports, determine which Configuration Manager SQL views contain the information you need for your reports, and identify a path between the necessary SQL views and determine what columns can be used to join them. The download package includes the following files:

Before You Use – Readme document (BeforeYouUse_Readme.doc):
Provides information about how to use the other documents in the Windows Installer download package.

Using Configuration Manager 2007 SQL Views to Create Custom Reports help file (CM2007CustomReports.chm):
Provides an overview of the Configuration Manager 2007 SQL view schema and SQL views, an overview of the existing reports and associated reporting procedures, sample SQL statements for each Configuration Manager SQL view category, scenarios for creating custom reports, exercises for creating custom reports, an overview for writing report SQL statements, and an overview of the Configuration Manager Provider WMI schema. This documentation will be your main resource throughout the process of creating your custom report.

Configuration Manager 2007 SQL View Schema Microsoft Visio document (CM2007SQLViewsSchema.vsd):
Provides the Configuration Manager 2007 SQL views schema, organized by category.

Configuration Manager 2007 SQL Views Excel spreadsheet (CM2007SQLViews.xls):
Provides a list of the Configuration Manager 2007 SQL views with descriptions, a list of the SQL views and columns ordered by SQL view name, and a list of the SQL views and columns ordered by column name.

The Windows Installer CreatingCustomReportsByUsingSQLViews.msi package can be downloaded from: http://www.microsoft.com/downloads/details.aspx?FamilyId=87BBE64E-5439-4FC8-BECC-DEB372A40F4A&displaylang=en.

I am very interested to know what you think of the documentation. Please send any comments about the SQL views documentation to SMSDocs@microsoft.com.

Thanks!!

Doug

(in reply to deby301)

Post #: 7

RE: Data Dictionary for SCCM database? - 11/5/2008 9:26:37 AM

Winston Smith

Posts: 53
Score: 0
Joined: 12/18/2007
Status: offline

Absolutely awesome! Thank you!

(in reply to deby301)

Post #: 8