→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
yallah
Engaged Sweeper II
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
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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.

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
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.