Query Workstations with Recent Inventory Dates

To retrieve workstations with an inventory date less than a specified number of days, execute the following SQL query:

"Computer"."Last Hardware Scan Date" > GetDate() - x

Ref :

• How to Query for Devices Updated by Inventory Since X
• About Custom Database Queries: How they work, guidelines on creating them, and examples of them in action