Reports & Analytics

Resolved! User Last Login (If Any)

Hi, I am trying to run a report based on AD Users and when was the LAST TIME, or if they have ever logged on.I am using this code:Select Top 1000000 tblADusers.Displayname, tblADusers.Firstname, tblADusers.Lastname, tblADusers.Department, tblADus...

A Report to find a single file

I was wondering if anyone has already built a report that can simply enough find any asset or server that has one specific file in this case ATMFD.DLL Has someone already created a report like that?

Report on Computers/Servers - check if specific folder exists using user profile variable

Hello,I am trying to check if a specific folder exists into users folder but Lansweeper does not seem to accept user profile variable (%USERPROFILE%).Example of folder: %USERPROFILE%\appdata\specialfoldernameIs there a way to create a report for this...

CoronaVirus - Reports

Management has asked for a report on each laptop and what VPNs have been configured on each. I started by scanning the registry for Software\Microsoft\Windows\CurrentVersion\Internet Settings\Connections but that has proven unreliable. I was thinki...

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...

Reports & Analytics

Topics in this forum

Resolved! User Last Login (If Any)

A Report to find a single file

Report on Computers/Servers - check if specific folder exists using user profile variable

CoronaVirus - Reports

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)

new report laptops and notebooks

IP Scanning versus IP Locations Report

Report for SQL SysAdmin Role

Installed Microsoft Office

Windows 11 Compatibility report

Report for Software but only in PCs

Report showing Excluded IP's and reasons for being...

Linux Missing Software

Create a Lansweeper Report for Timemachine Status

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