I'm looking for a custom report SQL query that can help us to keep an eye on Assets. If any asset is offline for more than a week then we should have the information about that. like last successful scan status on yyyy-mm-dd. and "not been contacted since12 days" etc.

The field requires CI Name, CI Type, Model, Product Name, Processor Name, Total Memory, Workstation Scan History (from history tab which inserts "last success scan and not been contacted by SDP since 14 days")

Workstation scan history contains scanned date and time (Scanned on 18/06/2020 01:01 PM) and  Scan Status: FAILED or SUCCESS

Thank You for the support.