
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-27-2015 02:48 AM
I have an audit report showing all AD users created in the last 7 days (as per below) - is it possible to do the same for any AD groups created in the last 7 days? I looked in tblADGroups but there is no creation date field.
Users report:
Select Top 1000000 tblADusers.Username,
tblADusers.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Name,
tblADusers.Displayname,
tblADusers.email,
tblADusers.whenCreated
From tblADusers
Where tblADusers.whenCreated > GetDate() - 7
Order By tblADusers.Userdomain,
tblADusers.Username
Users report:
Select Top 1000000 tblADusers.Username,
tblADusers.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Name,
tblADusers.Displayname,
tblADusers.email,
tblADusers.whenCreated
From tblADusers
Where tblADusers.whenCreated > GetDate() - 7
Order By tblADusers.Userdomain,
tblADusers.Username
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
‎06-30-2015 04:05 PM
For AD groups, no creation date is being scanned. You could use tblADGroups.LastChanged in your report, but this will get updated on every change which was scanned on the same group.
Note that scanning all AD groups works best by submitting the OU(s) of your AD groups for Domain User scanning. Otherwise you might not get all groups scanned.
Note that scanning all AD groups works best by submitting the OU(s) of your AD groups for Domain User scanning. Otherwise you might not get all groups scanned.
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-30-2015 04:05 PM
For AD groups, no creation date is being scanned. You could use tblADGroups.LastChanged in your report, but this will get updated on every change which was scanned on the same group.
Note that scanning all AD groups works best by submitting the OU(s) of your AD groups for Domain User scanning. Otherwise you might not get all groups scanned.
Note that scanning all AD groups works best by submitting the OU(s) of your AD groups for Domain User scanning. Otherwise you might not get all groups scanned.
