→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
aplrich
Engaged Sweeper III
I'd like to create a report that will produce the following

A list of all users that are in a specific OU Group

AND

The last modified date is GREATER THAN 30 days from todays date.

I'm fairly sure this is possible but i'm not very clued up with the report parameters so would love some help with this.


Background Info:
Basically i'm looking to report on all users that have been disabled for more than 30 days so we can safely delete the account. I understand Lansweeper can't access the disabled attribute but using the account last modified date should be equally as effective.

Thanks in advance!
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Please try the report below. Replace "YourOU" with the OU you want to report on.
Select tblADusers.Userdomain, tblADusers.Username, tblADusers.Displayname,
tblADusers.OU, tblADusers.Lastchanged
From tblADusers
Where tblADusers.OU Like '%YourOU%' And tblADusers.Lastchanged > GetDate() -
30
Order By tblADusers.Userdomain, tblADusers.Username

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
Please try the report below. Replace "YourOU" with the OU you want to report on.
Select tblADusers.Userdomain, tblADusers.Username, tblADusers.Displayname,
tblADusers.OU, tblADusers.Lastchanged
From tblADusers
Where tblADusers.OU Like '%YourOU%' And tblADusers.Lastchanged > GetDate() -
30
Order By tblADusers.Userdomain, tblADusers.Username