Reports & Analytics

Adding HotFixID to report to show just 1 result per PC

I'm trying to add the HOTFIXID to this report to show the KB update that was installed. But when I try to add it, it adds multiple rows for each Workstation.Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysOS.OSname, tblAssets.Userna...

LANSweeper script issue

Below is the script I have but it's only showing Windows Servers, nothing else. Any help would be greatlt appreciated:Select Top 1000000 tsysOS.Image As icon, tblAssets.AssetID, tblAssets.AssetName, tblAssets.IPAddress, tsysOS.OSname As OS, tbl...

Find that Dinosaur in Your Network?? doesn't show Linux machines?

I have a question about https://www.lansweeper.com/tutorial/find-that-dinosaur-in-your-network/How can you make this report show Linux machines as well?

End of year report

Hi i want to get a detailed end of year reportid like a list of all tickets closed for the previous year, 2019, to include call typeand what agent closed it.Once i get that into CSV i should be able to get the information that i need.thanks

Tickets opened/closed/per month by Type

HI,I have tried my hand at writing a report. My objective was to get a report that shows how many tickets were created in a month and how many tickets were closed that month and have it group by type. I have 4 types of tickets in my system. Here is w...

Asset Out of Warranty & Asset Out of Warranty in 60 Days Reports

I am having a tough time trying to manipulate the reports of Asset Out of Warranty and Asset Out of Warranty in 60 Days. We want to not only keep the manufacturer's report of when that warranty expires, but we also have set a standard where 5 years ...

Report Showing custom registry keys scanned

Hi,I need a report which shows all Windows PC's along with their custom registry keys scanned in a report. For example, I want to be able to show Asset name, Software Version (Symantec Endpoint Protection) and two different registry keys which I have...

Report to compare softwareVersion

This report returns all computers with Office versions whose third number is less than 12228.Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Username, tsysOS.Image As icon, tblSoftwareUni.softwareName, tblSoftware.softwareVe...

Reports & Analytics

Topics in this forum

Adding HotFixID to report to show just 1 result per PC

LANSweeper script issue

Find that Dinosaur in Your Network?? doesn't show Linux machines?

End of year report

Tickets opened/closed/per month by Type

Asset Out of Warranty & Asset Out of Warranty in 60 Days Reports

Report Showing custom registry keys scanned

Report to compare softwareVersion

Query inside of another query?

DiskPartition Changes Report

Report - KB report details for the month of Februa...

Query Report al Instance DB SQL e no SQL

Report to see what machine upgrade Windows

Hyper-V report with CPU information

Windows devices with Uptime more than 30 days

Windows 11 readiness report - storage not working ...

Report for Local Administrator accounts on All Ass...

meaning of diffrent valus for tblComputersystem.Po...