Notification

Icon
Error

Password Never Expires - Password Never Expires

Posted: Friday, October 11, 2019 12:34:14 PM(UTC)
CoolDood

CoolDood

Member Original PosterPosts: 9
0
Like
Does anyone have a report that shows users with passwords set to never expire?
JR
#1JR Member Posts: 2  
posted: 4/3/2020 11:21:17 AM(UTC)
Hi, did you by any chance made a report for this? And if so, would you like to share the code?
Many thanks!
JR
#2JR Member Posts: 2  
posted: 4/3/2020 12:50:58 PM(UTC)
Oops, I just saw that the built in report "Users: AD user attributes" does list this attribute (PasswordNeverExpires true/false)...
FNB_Cliff
#3FNB_Cliff Member Posts: 2  
posted: 4/14/2020 7:54:01 PM(UTC)
I also found it in user Attributes, but it would still be nice to have its own report.

Or is there a way to edit the code where it only shows "True" items for that column?
pryan67
#4pryan67 Member Posts: 76  
posted: 4/14/2020 10:32:53 PM(UTC)
How's this?

Select Top 1000000 Case
When tblADusers.Displayname Is Null Or
tblADusers.Displayname = '' Then tblADusers.Userdomain + '\' +
tblADusers.Username
Else tblADusers.Displayname
End As Displayname,
tblADusers.Username,
tblADusers.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Department,
tblADusers.email,
tblADusers.IsEnabled As EnabledInAD,
tblADusers.PasswordNeverExpires,
'usersm.png' As Icon,
tblADusers.Lastchanged
From tblADusers
Where tblADusers.PasswordNeverExpires = 'true'
Order By Displayname,
tblADusers.Userdomain,
tblADusers.Username

Active Discussions

Action Find lost space the easy way (spacesniffer.exe)
by  krozar   Go to last post Go to first unread
Last post: 5/5/2020 10:27:33 PM(UTC)
Lansweeper Querying a web server or web services
by  mmo  
Go to last post Go to first unread
Last post: 5/5/2020 9:00:36 PM(UTC)
Action Password Status
by  brodiemac-too   Go to last post Go to first unread
Last post: 4/23/2020 9:01:03 PM(UTC)
Action Email user
by  Michael Kop  
Go to last post Go to first unread
Last post: 4/7/2020 11:24:12 AM(UTC)
Lansweeper actualizacion de datos importando csv
by  jhon freddy   Go to last post Go to first unread
Last post: 3/31/2020 9:04:45 PM(UTC)
Lansweeper Asset Actions - RunAs Prompt
by  Socal_s197  
Go to last post Go to first unread
Last post: 3/26/2020 10:02:16 PM(UTC)
Lansweeper Remote Registry 2019
by  CyberCitizen   Go to last post Go to first unread
Last post: 3/6/2020 12:25:39 AM(UTC)
Lansweeper Installation Parameters
by  Florian_Eigsi  
Go to last post Go to first unread
Last post: 3/3/2020 10:17:18 AM(UTC)