StevensNet.com

...Because someone's gotta tell the story...

Blogs

To return to the main Blog List, click Full Blog Listing.

Tags

SCCM
System Center
Visual Basic

Keeping a historical user inventory in SCCM (Part 1)

Tuesday, October 19, 2010 in System Center (Views: 4094)
So, in the introduction, we spoke on the steps needed to keep this historical data for users in SCCM. In Part 1, we are going to talk about how to move this data from the SMS/SCCM database to another server, where we can keep the data.

One question people might ask is, wouldn't it just be okay to leave SMS client data in the database a little longer? Who cares if it is old data, it's not hurting anyone.. This would be to the contrary. SMS client data is useful for building collections, and collections have things advertised to them, they have specific policies and need to check in on occasion. They have software updates deployed to them, and by now you get the point. If that client is say, off the network for a year, it will mess up your compliance reporting and the success you have in advertising software.

So, the first step is to get the user IDs from the database. You can move them in a variety of ways, through DTS, or just programmatically. I used VB to move this data.

Simply put, it's a one line query to get the data.

- SELECT Name0, Model0, UserName0 from COMPUTER_SYSTEM_DATA

What I did was took the results of this query and copied the data to a new table. In Part 2, we are going to look at inserting this data.

 

Related Blogs You May Be Interested In:


To leave a comment, please log in and/or register.