Identifying Assets that Haven't Been Discovered/Validated in Set Period

[SebastianBarnes]

Hello everyone,

I am trying to determine a list of hardware assets that haven't been discovered or validated in the last 6 months. My criteria is below, but I'm unable to figure out how to filter my reports.

1. CI Most Recent Discovery Date > 6 months ago

2. Hasn't been updated by the system in > 6 months

3. Hasn't been scanned by a user (shows up as user = scanner) in > 6 months

Should this be possible to do through reporting, or should I go a different route? I'm having trouble specifically with the last two points, as I'm not sure how to determine when something was last updated by a specific user. Any other suggestions?

[Kumar Premankit]

Out of the box, we have an asset health dashboard that has the report for "Active assets -Not discovered". It uses a pre-defined script to come to active asset classes.  

Most recent discovery field is what it is looking for and including Most recent discovery being empty too. 

[SebastianBarnes]

Hi Kumar, this is very helpful - I will look in to this.

How would you go about also identifying assets that have not been updated by particular users within a certain period? For example, in addition to the discovery data, we want to know all of the records that haven't been updated by "User 123" in the last 90 days? Since the "Updated" and "Updated By" field get overwritten with the last update, it's hard to tell when a specific user last worked with the record.

[Premankit]

Oh i stumbled on that situation for some other table in cmdb, i think you would need to create a script include that looks into audit history and returns last human changes date.