Reports & Analytics

Full asset report with and without ad relationship

I am trying to get a full report that shows assets with and without ad relationship. My query currently just shows the assets that have a relation to tblAssetUserRelations. If there isn't any relationship, i want show NULL if there isn't any. here is...

Report BitLocker protection status for all fixed internal drives

I am currently using the built in report 'Computer: Encryptable volumes' to list the BitLocker Protection status of drives. But I found out that this includes all drive types that support BitLocker. So it is including external USB drives. We are only...

Resolved! Report Request - List out of date software but include date it was installed/last updated

This is the code I use to list assets that have an out of date version of 7-ZIP.Select Top 1000000 tblassets.AssetID, tblassets.AssetName, tblassets.Username, tsysAssetTypes.AssetTypeIcon10 As icon, tblassets.IPAddress, tblassets.Lastseen, tblS...

Show newly discovered software

The report below list newly discovered software (software not previously discovered by Lansweeper) in the last 7 days, and the asset it has been installed on. Please note that this report compares the first 10 characters of recently scanned software ...

Resolved! LSAgent Report

Need help modifying the lsagent not seen in 7 days report to show only active devices. Any help is always appreciated.

Local Admin logged on to workstations report from last 24 hours

Needing a report that shows workstations has a local admin logged on from last 24 hours I appreciate it and thanks in advance

Regular expression in query builder

Hi,I want to filter out certain assetnames that have specific structure (first two letters, then 6 numbers). I want to use regex for this, but I can't get it to work. I'm sure my regex works (verified it at https://regexr.com/), but when I use it in ...

Resolved! Report for specific IP range

The short of what I want is to create a disk space report for a specific subnet range. So I want to scan 192.168.0.x and I'm using the following script. The alternative would be to add the names of the servers i want in the report somehow but its cur...

Reports & Analytics

Forum Posts

Full asset report with and without ad relationship

Report BitLocker protection status for all fixed internal drives

Resolved! Report Request - List out of date software but include date it was installed/last updated

Show newly discovered software

Resolved! LSAgent Report

Local Admin logged on to workstations report from last 24 hours

Regular expression in query builder

Resolved! Report for specific IP range

Report on the history of changes on the device in ...

Report on changes in the hardware of the virtual m...

search for a pc to see who was logged in last

Exclude devices from report Windows Update Audit

asset count by asset type

Report for specific Registry Key Missing

How to get a user's computer machineName for Power...

certificates report | thumbprint

Collect Lansweeper Audit Logs (e.g. Login events)

Report on custom date field