Reports & Analytics

Local admin group report based on domain role

/** Select required fields from tables **/Select Top 1000000 t1.AssetID, t1.AssetName, t2.Username, t2.Domainname, t2.Groupname, t3.Domainrole,/** Sets naming convention based on domain role **/ Case t3.Domainrole When 1 Then 'WORKSTATION' ...

Modify "....less than 1GB free HD..." Report

How would I go about modifying the built-in report for Servers and Workstations, the "Disk: ....less than 1 GB HD" report, to exclude "RECOVERY" drive letters and other non-boot drives, regardless of drive letter? Working on proactive maintenance, I...

List of Active Guest users

Help please -I need List all Guest users on all assets who have Disabled = 'False'.

Helpdesk: Count of tickets created per year and month (Built-in)

Added in v.6.0.100The report below gives back a count of the tickets that have been created during each year/month.The report will only take count tickets that meet all of the following criteria:The ticket has not been set to ‘Ignore’Select Top 10000...

Report NB and Workstation

Hey There,we are trying to get a Report for all our Workstations and Notebooks of the Company. All Notebooks have the "NB" in their Name and all Workstations have "WS" in it.so theoreticaly i can filter withWhere tsysAssetTypes.AssetTypename Like '%...

List of all non-installed windows updates on Windows server 2016.

Hi Sweepers. I have been tasked with creating a list of all updates missing on all of our Win 2016 servers. I have found articles that show how to make a query for a single specific KB on a single server. The problem is i have 71 servers that i need ...

Asset location report with count ? (NO IP, LOCATION map)

Good morning.I found this to be perfect, but it does count based on the ip and not the location map. How can I replace the location with the iplocation?Select Top 1000000 tblSoftwareUni.softwareName As Software, tblSoftware.softwareVersion As Versio...

Modified file last 24 hours

I want to have a report that would show if a specific file on a users C drive has been modified in the last 24 hours. Is anyone able to create this for me?

Reports & Analytics

Topics in this forum

Local admin group report based on domain role

Modify "....less than 1GB free HD..." Report

List of Active Guest users

Helpdesk: Count of tickets created per year and month (Built-in)

Report NB and Workstation

List of all non-installed windows updates on Windows server 2016.

Asset location report with count ? (NO IP, LOCATION map)

Modified file last 24 hours

Create a Lansweeper Report for Timemachine Status

Patch Tuesday April 2025 Lansweeper On-Prem Query ...

Dashboard - Scan Issues only active assets

Save Automated Reports to Network Drive or URL

Linux and Windows Hardware Inventory Report

Report for Missing Software Using Another Software...

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