Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-13-2020 11:11 PM
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
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
Labels:
- Labels:
-
Report Center
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-14-2020 04:51 PM
Ill give that a shot...thanks guys for all the help. I love this LanSweeper product
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-14-2020 04:57 PM
IT Department at AudioNet wrote:
Ill give that a shot...thanks guys for all the help. I love this LanSweeper product
It worked
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-14-2020 03:26 PM
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.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-14-2020 04:26 PM
Same as above but
CODE:
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-14-2020 12:19 PM
Hi Rob,
Is this what your after? :
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