How to filter out duplicate entries from report on [discovery_device_history]?

[David77]

We need to run a report of CIs Discovered, grouped by Schedule.   The issue is we see multiple entries for various CIs.
Is there any method to filter those duplicates out? My goal is to get a report of CI's first discovered date by Schedule. Thanks!

[jake_mckenna]

Normally when i try to create a report for this table i filter or group based on discovery status field. Other option would be to do it based on the updated date, too.

[Ryan Zulli · Accepted solution]

Hi David,

  Look at this community post for a few of our most used/created Discovery Reports ::

Re: Some of my favourite reports

more specifically this report ::

New Devices:

Table cmdb_ci_hardware

Group by Class

Filtercreated relative after 48 hours ago (or however long you'd like to go back)

This can be modified to use the Discovery Log table to get the Schedule name

Hope this helps.

Thanks,

-Ryan