Password Never Expires

[Dennis_Harris]

Does anyone have a report that shows users with passwords set to never expire?

[pryan67]

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

[FNB_Cliff]

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?

[JaapRuijgrok]

Oops, I just saw that the built in report "Users: AD user attributes" does list this attribute (PasswordNeverExpires true/false)...

[JaapRuijgrok]

Hi, did you by any chance made a report for this? And if so, would you like to share the code?
Many thanks!