cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
shawn
Engaged Sweeper II
The built in report for AD Password Expired is listing users as Expired when they are set to Never Expire. And with no way to filter out those results, which makes this report worthless since I will have to manually verify each one to see which users ACTUALLY have EXPIRED passwords.

1. Is there a place to report this issue so it is fixed for everyone's LANsweeper server install in a future update?

2. Can someone assist with creating a new report that actually works for this?

This is the URL of the built in report with the issue.
<server>/Report/report.aspx?det=Web50repAdPasswordExpired&title=Users%3a+AD+password+expired

I then went to the Report Libarary which has a report titled "Active Directory Password Expired Audit" , but it turns out to be the exact same report that is built in.
https://www.lansweeper.com/report/active-directory-password-expired-audit/
1 REPLY 1
mferraby
Engaged Sweeper
I know this is an old post, but thought I'd respond as I found the post when doing a search for a similar question.

The built-in report "Users: AD password expired" can be updated with tblADusers.PasswordNeverExpires = 'False'

I also included tblADusers.IsEnabled = 'True' to make sure that disabled accounts are not included.

So I have:

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.PasswordExpirationDate,
tblADusers.Lastchanged,
tblADusers.PasswordNeverExpires,
tblADusers.PasswordLastSet
From tblADusers
Where tblADusers.IsEnabled = 'True' And tblADusers.PasswordExpirationDate <
GetDate() And tblADusers.PasswordNeverExpires = 'False'
Order By tblADusers.PasswordExpirationDate,
Displayname