I have a manager requesting all machines 'under' him, and their warranty.Can somebody help make a report to gather this information?I see under any given manager "Direct Reports" but it only shows 4 (example) people. I need the people under them, and...
I am currently using the following bit of code to format System Uptime: Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 / 24))) + ' d ' + Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 % 2...
The report below lists your Windows computers and the date/time Lansweeper last detected a new Windows update on each computer. The report will only list assets that meet all of the following criteria:The asset is a Windows computer.The computer's st...
I'm using Lansweeper to pull my windows event logs, and I'm getting some old data that I'd like to avoid. I'd also like to filter some events out of the finished report as well.My report code is:Select Top 1000000 tblNtlog.TimeGenerated, tsysAssetTy...
List of computers with connected monitors to them (1 row per computer)Note: This report can't be used on SQL compactMeets all the following criteria:- Active asset- Windows asset- one or more monitors connectedSorted on:- Asset name- Monitor model na...
Hello,Could someone help me with this, on our network we began installing Windows 10 after the release in July 2015 but I am unable to use Lansweeper to tell me which computers are on Windows 10 build 10240 and 10586 (Update 1511).It was quite easy b...
Hi so i have a network where we have a large number of computers with Teamviewer Host 10 installed. I can run a report to check which computers have the software, but i don't know how to make a report to display computers that don't have it. Any help...
