asked on

How do I effectively get SCCM 2007 R2 to inventory computers by serial number and date it first hit the network.

We currently have a wierd way of inventorying, for when computers were purchased so that we know when to have the computers replaced. I'm looking for a way to be able to have SCCM pull up a query or collection or something, that will be based on serial number and the date that serial number first hit the network. I need to be able to determine which computers are 5 years old. Once a computer is five years old, needs to be repalced. . I am new to SCCM so please be as detailed as possible, thanks.

Abdul Jalil Abou Alzahab

This report may help you. but it's without determining which computers are 5 years old, take a look
http://www.ms-csm.com/SCCM/?p=190

ASKER CERTIFIED SOLUTION

socrates2012

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ChemungAdmin

ASKER

socrates2012

I used what you gave me and it gives me lots of good stuff. Except its not giving me the origonal date that the serial hit the network (if thats possible :\ ). Ill give an example with what you gave me:

Name, User Name, Serial Number, Release Date, Operating System Name, ServicePack, Install Date, Manufacturer, Model, Current Physical Memory (MB)

CCIT-18L gsscott FGSSTL1 7/30/2010 Microsoft Windows NT Workstation 6.1 1/19/2011 8:46:00 PM Dell Inc. Precision M6400 4083

CCIT-18L gsscott FGSSTL1 7/30/2010 Microsoft Windows NT Workstation 6.1 2/11/2011 12:47:00 PM Dell Inc. Precision M6400 4083

Now this is my computer. I know for a fact that my boss had this computer befor me at the beging of last year and the reason you see 2 is because i just reinstalled the os. It would be fine not to see his user name and all, but I need to see some other date that stays constant even if I were to say upgrade the bios or reinstall the os. Is there a way to pull up a report that has atleast the computer name and serial # based upon this mystery date? I could, if all els fails, used the bios release date. It would just be thrown off alittle if I end up doing a bios up date on one of our computers.

SOLUTION

socrates2012

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ChemungAdmin

ASKER

One last thing and I think I will be all set. I was looking and couldnt see a way to add a colume for what AD group its associated with (along with the report given to me by socrates2012). Is it because its not there or did i just overlook it?

socrates2012

The views you might be able to use for that are v_RA_System_SystemOUName for OUs or v_RA_System_SystemGroupName for AD groups. I haven't attempted to tie AD groups and OUs inside of SCCM and don't use the discovery tools for anything other than AD system discovery. If you are discovering everything you may make better use of those than I, wish I could be more help in that respect.

ChemungAdmin

ASKER

So I talked to one of our database admins and he said in sql he is going to add a triger that send all the info do a separate database that wont allow the bios release date to chage, but it will allow every thing els to up date properly. So now I should be able to pull up a report that from that data base separatly with out changing the origonal. Only down side, so far, is that if micrsoft pushes an update it might change, triger. So we will have to put it back in if it does.

ChemungAdmin

ASKER

Thank you very much. : )