→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Dennis_Harris
Engaged Sweeper III
I have filters in some reports but doesn't seem to work.
I don't need to know if a user has not logged in for thirty days if his account is not enabled.


tblADusers.IsEnabled = 'True'
1 REPLY 1
Andy_Sismey
Champion Sweeper III
So the below should give you only ENABLED assets based on their AD Status (since last scan), is this not working for you ?

Also do you have the Server options set for "Remove users disabled in Active Directory from the Lansweeper database" ?

Select Top 1000000 tblADusers.Username,
tblADusers.IsEnabled,
tblADusers.Name
From tblADusers
Where tblADusers.IsEnabled = 'true'