Is there a good way to find out the age of a PC from SNOW? Or possibly the average age of all the computers in our environment from SLM?
this is not an easy question, as we need data source to retreive the date from. I was looking at possible sources:
I think, the only correct and possible way is to maintain the financial data for each computer object. There is a field for purchasing date and this is possible to analyze.
The BIOS date is not a reliable way to determine the age of a computer. We have 4 years old computer with the BIOS date 22.02.2018. In times of Meltdown and Spectre we will get many BIOS updates in the future.
Sadly, I don't think there is a reliable or accurate way of doing this. Purchase date and warranty information may be your best bet, but this requires a lot of manual input to be honest.
Adding in purchase data and warranty data from the CMDB/procurement tools is our method.
Computer manufacturers usually have the purchase date and warranty end date open for public lookup. When you go online you can in most cases use your serial number to get the details. This means if you are competent in scripting, you can probably use Powershell to get this data automaticly populated for all your computers that are from a manufacturer that supports this.
We do this for all our HP computers. The data is populated to SCCM every night, and then Snow gets the data from SCCM trough a scheduled import. Here is the manual warranty check for HP (https://support.hp.com/us-en/checkwarranty), and this is a discussion regarding an API for resolving that issue for HP computers (https://developers.hp.com/css/forum/httpsdevelopershpcomcssapiproduct-warranty-apiqueriespostqueries).
I cannot provide the scripts I'm afraid, but a competent scripter should be able to figure this out.
I found, that this has previously been done for Dell. You need an API key, which can be created here. Unfortunately, I cannot share the script here without approval. Please reach out to your local Services Organization and refer to Oliver.Berger for more information.
Retrieving data ...