Active Directory: Users report not logged in past 90 days

[It_Department1]

Hi,

Its as simple as that mentioned in the subject I need a report that displays only users who have not logged into Active directory within the past 90 days.

Its a new audit requirement our company needs to do every 3 months.

Anyone create a report such as this?

Thanks,

Rob

[It_Department1]

Ill give that a shot...thanks guys for all the help. I love this LanSweeper product

[It_Department1]

IT Department at AudioNet wrote:
Ill give that a shot...thanks guys for all the help. I love this LanSweeper product

It worked

[It_Department1]

Ou Outstanding!!!!!!!.....thank you. However, in that code is it possible to exclude "disable accounts" I have an OU setup that I move disabled accounts to called "use's disabled" that I dont want included on the report. I want to ONLY show current active users in AD over 90 days.

[Paul_Blackman]

Same as above but

CODE:

Select Top 1000000 Case
    When tblADusers.Displayname Is Null Or
      tblADusers.Displayname = '' Then tblADusers.Userdomain + '\' +
      tblADusers.Username
    Else tblADusers.Displayname
  End As Displayname,
  tblADusers.Department,
  tblADusers.Title,
  tblADusers.Username,
  tblADusers.Userdomain,
  tblADusers.IsEnabled As EnabledInAD,
  'usersm.png' As Icon,
  tblADusers.LastLogon
From tblADusers
Where tblADusers.IsEnabled = 'True' And tblADusers.LastLogon Is Not Null And
  DateDiff(DAY, tblADusers.LastLogon, GetDate()) > 90
Order By tblADusers.LastLogon,
  Displayname

[Andy_Sismey]

Hi Rob,

Is this what your after? :

Select Top 1000000 Case
    When tblADusers.Displayname Is Null Or
      tblADusers.Displayname = '' Then tblADusers.Userdomain + '\' +
      tblADusers.Username
    Else tblADusers.Displayname
  End As Displayname,
  tblADusers.Department,
  tblADusers.Title,
  tblADusers.Username,
  tblADusers.Userdomain,
  tblADusers.IsEnabled As EnabledInAD,
  'usersm.png' As Icon,
  tblADusers.LastLogon
From tblADusers
Where tblADusers.LastLogon Is Not Null And DateDiff(DAY, tblADusers.LastLogon,
  GetDate()) > 90
Order By tblADusers.LastLogon,
  Displayname