
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-28-2012 06:30 PM
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!
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!
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-29-2012 02:09 PM
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
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-29-2012 02:09 PM
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
