How to get "Data last received" value from inventory data class
Last Updated February 21, 2007
Question I want to get a report that tells me some data of an inventory data class and also the date of the last time this inventory was received. Where do I get this information?
Answer The information you're looking for can be found in the ResourceUpdateSummary table, which contains the (among other information) modifieddate for each InventoryClass for each resource. It contains an InventoryClassGuid and ResourceGuid column that can be used to limit your query to the class/resource you want.
The information on the inventory classes themselves can be found in the DataClass table (the Guid - column in the DataClass table corresponds to the InventoryClassGuid in the ResourceUpdateSummary table).
If you only have one server the following query should show you the last updates of the 'AeX OS Operating System' inventory class for all systems.
select i.Name, rus.ModifiedDate from DataClass dc join ResourceUpdateSummary rus on dc.Guid=rus.InventoryClassGuid join Item i on rus.ResourceGuid=i.Guid where dc.Name='AeX OS Operating System'
Imported Document ID: HOWTO6778
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe