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

Lansweeper NOT doesn't work as expected
by  KevinA-REJIS   Go to last post Go to first unread
Last post: Yesterday at 5:49:29 PM(UTC)
Lansweeper Combined Vulnerability Report Q1 2019
by  Leslie Stroobant  
Go to last post Go to first unread
Last post: Yesterday at 3:27:42 PM(UTC)
Lansweeper All Devices with WINS Service Running on the Network
by  Andy.S   Go to last post Go to first unread
Last post: Yesterday at 2:44:56 PM(UTC)
Lansweeper Physical Laptops and Desktops Only
by  pryan67  
Go to last post Go to first unread
Last post: Yesterday at 1:51:56 PM(UTC)
Lansweeper Assistance With AV & Bitlocker Report
by  Andy.S   Go to last post Go to first unread
Last post: Yesterday at 12:50:47 PM(UTC)
Lansweeper Count of completed KB installation Report
by  jamie21  
Go to last post Go to first unread
Last post: 6/4/2020 11:49:57 AM(UTC)
Lansweeper local admin users of a specific device
by  Andy.S   Go to last post Go to first unread
Last post: 6/4/2020 10:42:23 AM(UTC)
Lansweeper Bitlocker Report not contain all computers
by  Andy.S  
Go to last post Go to first unread
Last post: 6/3/2020 6:20:53 PM(UTC)