Can some one help me with SQL query for the assets which are not scanned from last 30 /45 days with the last scanned date. This is little urgent.
i fiddle with SQL queries a while ago, but for your need to could probably just create an asset group with those criteria, then invoke it in the report of your choice, or just export it to CSV if it is a onetime only.
the criteria of the asset group would be “vulnerabilities assessed” / “earlier than” , value = 30 days ago
FYI: both dates exist in asset group criteria :
last scan date (can be any scan, a discovery scan , or a full audit one)
vulnerabilities assessed (last time vulnerabilities got assessed, either with scan or via Agent)