09-06-2022 05:30 PM - last edited on 09-08-2022 02:08 PM by ErikT
Hello Everyone
I am currently working on a Report to list the last Logon Time of all our Windows Devices in our Infrastructure and I found this query for it:
Select Top 1000000 UserInfo.Username, UserInfo.Domain As Userdomain, UserInfo.LastLogon As UserLastLogon, tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tblAssets.IPAddress, tsysIPLocations.IPLocation, tblAssetCustom.Manufacturer, tblAssetCustom.Model, tsysOS.OSname As OS, tblAssets.SP, tblAssets.Lastseen, tblAssets.Lasttried From tblAssets Inner Join tblCPlogoninfo On tblAssets.AssetID = tblCPlogoninfo.AssetID Inner Join (Select Top 1000000 tblCPlogoninfo.Username, tblCPlogoninfo.Domain, Max(tblCPlogoninfo.logontime) As LastLogon From tblCPlogoninfo Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblCPlogoninfo.AssetID Inner Join tblState On tblState.State = tblAssetCustom.State Where tblState.Statename = 'Active' Group By tblCPlogoninfo.Username, tblCPlogoninfo.Domain) As UserInfo On tblCPlogoninfo.Domain = UserInfo.Domain And tblCPlogoninfo.logontime = UserInfo.LastLogon And tblCPlogoninfo.Username = UserInfo.Username Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tblState On tblState.State = tblAssetCustom.State Left Join tsysOS On tblAssets.OScode = tsysOS.OScode Where tblState.Statename = 'Active' Order By Userdomain, UserInfo.Username
The query unfortuantely only gives me about 800 Devices, but Lansweeper shows me that we have over 1400 Windows devices in total. After some comparing my guess is that it only shows devices that are discoverable/online for Lansweeper at that moment. Is it possible to expand this list by all the devices that are currently not reachable for Lansweeper, meaning every single device?
I already tried to remove the "Active"-Flag, but it did not work.
Thank you for your help.
Kind regards,
Gabriel
09-08-2022 02:09 PM - edited 09-08-2022 02:10 PM
@gabe, I updated your post adding the Finished Reports and Report Center labels so that your post will get more traction.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now