Hello, is there a report where I can see the date that a machine updated its Windows version? For example, when it was updated from Windows 10 to Windows 11?
Hi all,I have a report for reporting on the SystemDrive BitLocker encryption status. I would like to add if a Recovery Key exists in AD for the computer. I've done this but it now reports a computer more than once if there is more than one recovery k...
Hello, I am new to Lansweeper so I apologize in advance if this has already been answered. I need to run a report for ever usb device that is connected to a system on out network. The only exclusion would be mice and keyboards. I could not find how t...
I want to make a software audit report with installation date using the default report "Assets: Installed software by computer" as base.The error “All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressio...
Hello!I tried to merge 2 reports that works well but now I get 3-4 duplicates for each entries. The report return 1000 lines instead of 400.Someone can see my problem???HELP!!!!!!!! Select Top 1000000 tsysAssetTypes.AssetTypeIcon16 As icon, tblAsse...
Hi,I have a report which shows me all clients where a certain deployment is older than X days. Now I want to add to the same report the clients, where the deployments was never executed. Is this possible and if not, is it possible to creats this in a...
I'm attempting to run a report to find all devices that either have Config > User Info > Last logon as blank/null or that have a logon time older than X days but i keep getting blank results. Would someone be able to assist? Thank you.I've used thi...
I found the below script in the forum:Select Top 1000 tblAssets.AssetName, tblProcesses.CaptionFrom tblAssets Inner Join tblProcesses On tblAssets.AssetID = tblProcesses.AssetIDWhere tblProcesses.Caption = 'OneDrive.exe'https://www.lansweeper.com/f...
I searched the forums but could not find a solution. Using the following Select statement will allow me to click on the items in AssetName columnSelect Top 1000000 tblAssets.AssetID, tblAssets.AssetName,But if use a Column Name then the link is no ...