Custom Report help - users in specific OU AND last modified date > 30 days ago

[aplrich]

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!

[Hemoco · Accepted solution]

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