Uses windows event log Microsoft-Windows-WER-SystemErrorReporting and code 1001Select Distinct Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblADusers.Displayname, tblAssets.OScode, tblNtlog.Eventcode, Max(tblNtlog.TimeGenerated) As LastO...
Hi Guys,I've got a report that shows all of the devices that don't have are AV on it, want I want to be able to add now is to show only the devices that have been seen this year.I know you can do it for like the last however many days using Where tbl...
This report shows you all assets that aren't assigned to the right scanning server based on IP range scanning configuration.select *From tblAssets Inner Join (Select tsysIPScanRanges.Servername As servername, Convert(numeric(18),ParseName(tsy...
Hello i found this post to help create a report along the lines of what i would like to implement, searching and reporting for Event IDs relating to a logon failure:https://www.lansweeper.com/forum/yaf_postsm49283_Invalid-login-attempts-on-Workstatio...
Is it possible to build a report that shows all scanned Linux servers with a count if nic each Linux asset has? I see that the names if the interfaces are in the database for each server. Would it be possible to count them somehow? I have a report st...
Has anyone created a report or similar report that will give me this details? Our organization has a powershell script that runs and disabled any account that hasn't been logged into for 90 days but I'd a report that gives me the same details to revi...
Hi Lansweeper Community, I'm trying to return all hosts that have a specific software application installed but the software name includes '. I have Like 'blah%' which returns numerous results per host as its a three part application. Is there a was ...
