Inventory report and how long since a device reported

Hi All

Kinda specific question but I want to to be able to run an inventory report against specific customers that will give you the last know state of their devices. The CMDB/Asset team don't care if a device is up , down or unresponsive (Idle) for a few days , but after a couple of weeks they start asking engineers to tidy it up any down/unreachable/offline devices. The reports go out to customers and they are usually keen about those things as costs to them are per device in the CMDB.

Standard Inventory reports don't give any indication of current state. System.resourceUpdatedOn and auto.lm.last_check_time only tell us the device is pingable , not that its in any useable state. BSOD boxes still ping.

As an aside, a device that gets misloaded (say the snmp or wmi creds were wrong when it was created) the device will get's a Minimal Monitoring status, it can sit there happily as a ping only device with no alerts or anything , we need to be able to pick these up as well.

TIA.