...
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
SELECT Hostname,Target,[Phase],State,Description,DisabledUntil FROM [history].[v_ScanHistoryStatusForTarget] WHERE Phase State= 'WaitingAccount Lockout Protection' AND ProjectID=1 |
This second version of the query also demonstrates finding targets that are part of a specific project if you estate is configured with multiple projects.