Active Users per Year

[Tomas]

hi,

how would i perform a query which shows AD Users for a given year.
I.E.

Year - Users
2014 - 1500
2015 - 1600
2016 - 1650
2017 - 1700

Using the "Date Created" and "Last Scaned" to determin if a user was active at the time.

[Tomas]

Thank you,

in our case 'modified' would work, because there a scripts in place that update some info on the AD user regularly.

[Nick_VDB · Accepted solution]

It is unfortunately not possible to determine if a user was active during a specific year and then report this information. Lansweeper will only give back the date when the user was created but not scan if the user was enabled/disabled. The Lastscanned field will also not help in this situation as this field will only give back the date when the tblADObjects table was modified.

We did add a report below that will give back a count of all the AD users created per year.

Select Top 1000000 DatePart(yyyy, tblADusers.whenChanged) As Year,
  Count(tblADusers.ADUserID) As Users
From tblADusers
Group By DatePart(yyyy, tblADusers.whenChanged)