Documentation on SCCM database schema

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:

Documentation on SCCM database schema

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 >> Documentation on SCCM database schema

Page: [1]

Message

<< Older Topic Newer Topic >>

Documentation on SCCM database schema - 10/8/2008 8:29:12 AM

wnimmo

Posts: 220
Score: 6
Joined: 8/13/2002
Status: offline

Guys -

I know Microsoft wont do it, but before I dive too deep into the database, I wanted to know if anyone else has done any research on the database behind SCCM, in particular the new tables under the SCCM_ext schema?

In particular, I notice tables named sccm_ext.system_disc_dd - the columns are rowversion, itemkey, and delDate. Im going to go out on a limb and assume the itemkey references the resource ID of an asset, and DelDate leads me to think its a date data will be deleted for that asset?

Im wondering if these tables are where SCCM keeps track of which records it will purge from the database, and whether these could be used as a target list to check for corrupt clients..

Anyone figured out these new tables yet?

Will

Post #: 1

RE: Documentation on SCCM database schema - 10/8/2008 9:07:23 AM

gjones

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

It is unlikely that Itemkey is MachineID for that table.

Take a look at this: http://www.myitforum.com/forums/m.asp?m=186508&mpage=1&key=
It is recommend that you use the views and not the tables.

_____________________________

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 wnimmo)

Post #: 2

RE: Documentation on SCCM database schema - 10/8/2008 9:21:09 AM

wnimmo

Posts: 220
Score: 6
Joined: 8/13/2002
Status: offline

Yea - I know its reccomended to use the views.. We generally follow this guideline, but there are instances when this simply cant be followed - like when you want your custom app to write directly to SMS. (Yes - I know you can use the provider, but when you are adding 10k+ direct membership rules, you save huge amounts of time writing directly to the database.)

Im really hoping these tables will provide some insight as to when data shows up in the v_class__disc or _hist tables.. or when data is deleted from the database.. may be used for some entirely different reason, but Id like to know.

(in reply to gjones)

Post #: 3