Get an Overview of All Windows Computers Without a Screensaver Password
Check which computers are still missing screensaver passwords or which ones might still need to be disabled. Screensaver passwords are used for limiting open and unlocked computers so that there is less chance that people can get access to someone's computer.
Display Screensaver without Password Query
Select Top 1000000 tblAssets.AssetUnique,
tblAssets.AssetID,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tsysOS.Image As icon,
tblDesktop.Name,
tblDesktop.ScreenSaverExecutable,
tblDesktop.ScreenSaverTimeout,
tblDesktop.Lastchanged
From tblAssets
Inner Join tblDesktop On tblAssets.AssetID = tblDesktop.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblDesktop.ScreenSaverSecure = 0 And tblAssetCustom.State = 1
Order By tblAssets.AssetName
