How old are your computers
Lately I have been asked “Can you use ConfigMgr to see how old our computers are”.
And the answer is: YES with some modifications/limitations, and it only works if you haven’t deleted the computer object in the Active Directory every time you re-install your computers.
Now you can use this attribute in collections or reports to get a good picture on how many computers that might need to be replaced during the following years.
And the query in a text box :)
select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System where SMS_R_System.ResourceId in (select ResourceID from SMS_R_System where DATEDIFF(day,whenCreated,GetDate()) between 730 and 1095) and SMS_R_System.OperatingSystemNameandVersion like "%Workstation%"
This is just a way to get a hint on the age of your computers. It’s not as accurate as looking in to invoices and so on.
Have a nice day Johnny