cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Dennis_Harris
Engaged Sweeper III
Does anyone have a report that shows users with passwords set to never expire?
4 REPLIES 4
pryan67
Champion Sweeper II
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
Engaged Sweeper
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
Engaged Sweeper
Oops, I just saw that the built in report "Users: AD user attributes" does list this attribute (PasswordNeverExpires true/false)...
JaapRuijgrok
Engaged Sweeper
Hi, did you by any chance made a report for this? And if so, would you like to share the code?
Many thanks!