Notification

Icon
Error

Built in report - AD Password Expired - Built in report is wrong - help needed to create new report.

Posted: Friday, July 17, 2020 10:05:39 PM(UTC)
_Shawn_

_Shawn_

Member Original PosterPosts: 13
0
Like
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.c...-password-expired-audit/
FezUSA
#1FezUSA Member Posts: 1  
posted: 10/21/2021 3:12:17 PM(UTC)
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

Active Discussions

Lansweeper Marking/Flagging VIP Customers
by  C Johnson   Go to last post Go to first unread
Last post: Yesterday at 11:43:22 PM(UTC)
Lansweeper Office 2016 key scanning
by  WaldoIT  
Go to last post Go to first unread
Last post: Yesterday at 3:40:41 PM(UTC)
Lansweeper Configuring SSL in IIS Express issue
by  saffo   Go to last post Go to first unread
Last post: Yesterday at 9:57:31 AM(UTC)
Lansweeper MDM Jamf School
by  Eugene  
Go to last post Go to first unread
Last post: 12/3/2021 6:21:44 PM(UTC)
Lansweeper HTTPS not secure
by  Luke Maslany   Go to last post Go to first unread
Last post: 12/3/2021 2:23:28 PM(UTC)
Lansweeper Problem with deploy software
by  Max90  
Go to last post Go to first unread
Last post: 12/3/2021 2:04:12 PM(UTC)
Lansweeper scanning target by range
by  Colombini   Go to last post Go to first unread
Last post: 12/3/2021 12:06:19 PM(UTC)
Lansweeper Log WIFI networks
by  BastiOn  
Go to last post Go to first unread
Last post: 12/3/2021 10:29:38 AM(UTC)