A report to see devices where SAM Discovery Check has ran - ACC-V

[NeenaPatel]

Hi

Can you guide me how I can run a report on the below:

When was the last time that each of the 21,000 laptops had a successful "SAM Advanced Discovery" Check?

I understand majority information is in this table ecc_queue_list 

I would also like to understand whom the devices are assigned to and the users what BU do they work in.

Thanks

Neena

[Mark Manders]

What information is already available on the CI records? Does discovery update a field like 'last discovered on'  or something like that? 

If this information is only available on the ecc_queue, you will have an issue, since that list is cleaned and will only contain information from the last couple of days. And even if you have all 21K laptops in there, they will be in the payload, so there is no way to link it to the record itself.