HI All, I need to find out aged machines which is available in my Org. i need to write a query. please help me. Note: I've checked assetintelligence-hardware-02a report..same way i need to write a query how to write a query to find out CPU manupature date.

How would you define "aged"? CPU manufacturer data is provided by Asset Intelligence, but that data was not updated recently, so it's more or less useless. What do you want to know by querying that?Torsten Meringer | http://www.mssccmfaq.de

In even a somewhat standarized environment you should be able to identify what make/model is no longer supported in your organization. If you have Dell computers there's a couple of examples online how to pull the born on date into SCCM from Dell. John Marcum | http://myitforum.com/cs2/blogs/jmarcum/|

i want to get the report like aged machines like how many yeas like. below < 3yrs 3 yrs 4 yrs 5 yrs 6 yrs 7+ yrs is there any way that we can write a query manually to pull the report.

like <3yrs 3yrs 4 yrs like that

Hi Is there any attribute to find out processer manufatcure date. to get aged machines.

What's wrong with the "Hardware 02A - Estimated computer age by ranges within a collection" report then?Torsten Meringer | http://www.mssccmfaq.de

Hi, Torsten gave the best choice, "Hardware 02A - Estimated computer age by ranges within a collection" report. You can check the query of this report, it uses v_LU_CPU view CPU_Birth attribute to identify the age of computers. v_LU_CPU view lists information about the CPUs known to Asset Intelligence, including the manufacturer, CPU name, whether the CPU is on a mobile device, and so on. The information contained in this view can be displayed from the Processor Properties node in the Configuration Manager console. And v_LU_CPU view's data is from AI. Try this query: select v_R_System_Valid.ResourceID, v_R_System_Valid.Netbios_Name0, v_LU_CPU.CPU_Birth from v_GS_Processor inner join v_R_System_Valid on v_R_System_Valid.ResourceID = v_GS_Processor.ResourceID inner join v_FullCollectionMembership on v_FullCollectionMembership.ResourceID = v_GS_Processor.ResourceID left join v_LU_CPU on lower(v_LU_CPU.CPUHash) = lower(v_GS_Processor.CPUHash0) where v_FullCollectionMembership.CollectionID = 'One of the Collections' ID' and DATEDIFF(year, v_LU_CPU.CPU_Birth, GetDate()) > 3 Thanks

Hi Since the information in the table has never been updated since the AI product was bought by Microsoft (2006 if I remember well), this query is basically useless. see those posts for more information about how to update the table yourself. Note that this is totally unsupported. http://social.technet.microsoft.com/Forums/en-US/configmgrai/thread/f81a0632-6123-430e-85db-cfcf801c2f2f http://social.technet.microsoft.com/forums/en-US/configmgrai/thread/beceb8b4-ed1e-4462-aa4c-4328eb8821f7/ [I wouldn't worry about Microsoft overwriting your data however] brgdsbruno