The table tblADusers.Lastchanged shows the last time the table record was changed.
Is it possible to also show what was changed?
Also, if I remove the table tblADusers.Userdomain from the query below I lose the ability to click on the Display Names
Select Top 1000000 tblADusers.Displayname,
tblADusers.Username,
tblADusers.email,
tblADusers.City,
tblADusers.Userdomain,
tblADusers.Lastchanged
From tblADusers
Where tblADusers.Lastchanged > GetDate() - 30
Order By tblADusers.Lastchanged Desc
