Reports & Analytics

Excluding "Performance Logs and Alerts" from Services report

Since most of our systems are configured for the "Performance Logs and Alerts" service to be set to Automatic but usually is not in Running state, I'd like to exclude it from the two reports for "Services: Automatic services which are stopped on serv...

Differentiate between MSDE and full blown SQL Server

Hi Guysfor licensing purposes I need to know how to differntiate SQL-Servers from MSDEs.Scanning for Software throws out lots of "Microsoft SQL Server 200x". As far as I can see there are a lot of Desktop Engines among the result. I do need to identi...

List of all computers returns severl entries for some PC's

I am using the following query anmd it give me multiple lines for some PC's, is there a way to resolve this please?Select tblComputers.Computer, tblComputers.LastknownIP, dbo.tblComputersystem.Manufacturer, dbo.tblComputersystem.Model, tblComputerS...

Double entries when running report.

Hello,I have a report that I have been running without a problem for quite some time.It is a code that shows all computers with MS office along the install date, last changed, last known IP and a custom field called Department.Select Top 1000000 tblC...

Report Basics

Hello EveryoneI have LanSweeper Premium installed and I would like to know how to create and view reports. I see the built in reports listed under Reports, but how do I run one and see the results? In tried right clicking the report to see if it wo...

Query event view

How can I query from event viewer.I can find 2 tables but no connection with computertsysEventAlertstsysEventfilter

Filter out NULLS

I would like to run this report, but have it only show the results if a value is present in dbo.tblRegistry.Value Select Distinct Top (1000000) dbo.tblComputers.Computer, dbo.tblComputers.Description, dbo.tblComputers.Username, dbo.tblRegistry.Value...

Evetlog Summary search

Is there a way to search the Eventlog Summary for either Event ID numbers or context with out running a report?Thank you,Niles

Reports & Analytics

Topics in this forum

Excluding "Performance Logs and Alerts" from Services report

Differentiate between MSDE and full blown SQL Server

List of all computers returns severl entries for some PC's

Double entries when running report.

Report Basics

Query event view

Filter out NULLS

Evetlog Summary search

How to get assets lists based on each DHCP server ...

Win 10 ESU report

Browser report request

September 2025 Patch audit report

Asset to Users Relations Audit Report Not Working

Need help to get a Report that shows 2 extension a...

Different assets counts results between 2 differen...

Lansweeper scanning server history logging report

Modify Report to Exclude Certain Publishers

report to show service accounts, that have not had...