→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !
‎08-07-2013 08:50 PM
Solved! Go to Solution.
‎08-09-2013 06:26 PM
Select Top 1000000 tblADusers.Username,
tblADusers.Userdomain,
SubQuery1.Lastlogon
From tblADusers
Left Join (Select Top 1000000 tblCPlogoninfo.Username,
tblCPlogoninfo.Domain As Userdomain,
Max(tblCPlogoninfo.logontime) As Lastlogon
From tblCPlogoninfo
Group By tblCPlogoninfo.Username,
tblCPlogoninfo.Domain) SubQuery1 On SubQuery1.Username = tblADusers.Username
And SubQuery1.Userdomain = tblADusers.Userdomain
Where (SubQuery1.Lastlogon Is Null) Or
(SubQuery1.Lastlogon < GetDate() - 90)
Order By tblADusers.Userdomain,
tblADusers.Username
‎04-11-2014 10:38 PM
‎04-18-2014 01:15 PM
bdowell wrote:
Back to looking at this again and thinking to ask is there no way to hide/deactivate users like can be done on assets? If I could do that, I think I'd be good for what I was looking for since it would seem to stop showing me information about the hidden/deactivated users.
‎04-05-2014 04:06 AM
‎03-28-2014 04:45 PM
‎03-28-2014 06:05 PM
bdowell wrote:
Just realized that I have one more related question - is there a way to get a report that shows users that haven't changed password in some variable period of time? For example, can I get a report that shows users that haven't changed passwords in >= 60 days? (or 90, or whatever other period I need to check against)
‎03-27-2014 02:44 PM
‎03-27-2014 04:19 PM
Lansweeper wrote:
Disabled domain accounts aren't actually scanned at the moment, so it wouldn't make sense to store the account status in the database. A disabled domain account can only be present in your database if it was enabled at some point. If you submit a new OU for Domain User Scanning and that OU contains users that are disabled, those users will not be scanned.
Scanning disabled domain accounts and storing the account status are features currently on our customer wish list, but we do not have a release date for them.
‎03-28-2014 06:04 PM
bdowell wrote:
It would be nice if we could send different reports on different schedules
‎03-26-2014 05:58 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now