1 of 1 people found this helpful
Hi George, which BMC product is this query associated with? Is it Discovery?
I will help move it to the right product community, so the experts can help you.
Its is with ADDM discovery 10.2. thank you
2 of 2 people found this helpful
You really need to upgrade 10.2 is no longer in even limited support.
So you want a list of packages on Windows Hosts scanned in the last 90 days? You are being rather vague.
WHERE os_class = "Windows"
AND last_update_success >= (currentTime() - 90 * 86400 * 10000000)
thank you. it worked