Data Dictionary for SCCM database? (Full Version)

All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager



Message

Winston Smith -> Data Dictionary for SCCM database? (9/24/2008 9:49:22 AM)

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.



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

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



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

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.



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

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



Winston Smith -> RE: Data Dictionary for SCCM database? (9/24/2008 2:25:56 PM)

That's great news. Thanks!



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

SWEET!!!



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

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



Winston Smith -> RE: Data Dictionary for SCCM database? (11/5/2008 9:26:37 AM)

Absolutely awesome! Thank you!



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.703125