Tuesday
Good Afternoon All!
I'm trying to set up a report to determine what accounts have been changed between enabled/disabled within the past day so I can create a regular email notification for auditing and tracking purposes. I see that Lansweeper can determine the status (enabled/disabled) but when I try to adjust by "whenchanged" or "lastchanged" I get a lot of false positives. I was wondering if anyone had any suggestions on how to make it more accurate. It may not be possible due to the nature of the system, but I also am not the best report creator so I might be missing something.
I currently have this basic report:
"Select Top 1000000 adu.Displayname,
Case
When Coalesce(adu.IsEnabled, 0) = 0 Then 'False'
Else 'True'
End As EnabledInAD,
adu.Username,
adu.Userdomain,
adu.Name,
'usersm.png' As Icon,
adu.whenChanged,
adu.Lastchanged,
adu.IsEnabled,
adu.LastLogon
From tblADusers adu
Where adu.whenChanged > GetDate() - 1
Order By adu.IsEnabled Desc,
adu.Username"
Any advice would be appreciated on getting a report that simply tells me what accounts have been enabled or disabled in the past day.
Thanks much!
Wednesday
Good to know! Thanks for the info!
Wednesday
Table tblADusers doesn't have history, so there is no way to create report for tracking user's status.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now