New members of AD group

[Ken1]

Hi,

Is it possible to make a report, to see new members in a group?

I use this script below to get a report of "Domain admins" members... but I would like to only see new members

Select Top 1000000 tblADusers.Username,
tblADusers.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Name,
tblADusers.Displayname,
tblADGroups.Name As [Group]
From tblADMembership
Inner Join tblADusers On tblADMembership.ChildAdObjectID =
tblADusers.ADObjectID
Inner Join tblADGroups On tblADMembership.ParentAdObjectID =
tblADGroups.ADObjectID
Where tblADGroups.Name = 'Domain Admins'
Order By tblADusers.Userdomain,
tblADusers.Username

[Ken1]

Now i just need this to work 🙂 

https://community.lansweeper.com/t5/forum/scanning-methods/td-p/54798

-------------------------

Could this be implemented?

I have a scanning for a specific group, and would like to scan every 5-10 min. like i can schedule in other scan types.

Would be GREAT, so we actually could use LanSweeper as an AD change monitor also.

-------------------------

[ErikT]

@Ken1 I updated the Label to Report Center as your question will likely get more traction there.

How will you distinguish the new users from existing users?

eg. You check for all users that have been changed in the last 7 days

Select Top 1000000 tblADusers.Username,
  tblADusers.Userdomain,
  tblADusers.Firstname,
  tblADusers.Lastname,
  tblADusers.Name,
  tblADusers.Displayname,
  tblADGroups.Name As [Group],
  tblADusers.whenCreated,
  tblADusers.whenChanged
From tblADMembership
  Inner Join tblADusers On tblADMembership.ChildAdObjectID =
      tblADusers.ADObjectID
  Inner Join tblADGroups On tblADMembership.ParentAdObjectID =
      tblADGroups.ADObjectID
Where tblADGroups.Name = 'Domain Admins' And tblADusers.whenChanged Between
  GetDate() - 7 And GetDate()
Order By tblADusers.Userdomain,
  tblADusers.Username