Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

Resolved! Warranty status by department

Need a report with warranty status by department.  I'd like to have department based off of the last logged on 'user' field and then drill into the AD user information to pull their department or manager or something to help inform managers and facil...

sqldba01 by Engaged Sweeper II
  • 366 Views
  • 3 replies
  • 0 kudos

Merged Ticket Report

I have an issue finding merged tickets in Lansweeper Helpdesk. When my agents merge tickets I have a difficult time finding them after the merge. Is there a report that shows an audit log of merged tickets?

Resolved! Software report with icons for approval

I created the following query to give me a software report by Asset Group location. What I was looking to see if possible is to show the red/yellow/green icon for approved software in the report, is this possible?Select Top 1000000 tblAssetGroups.As...

mwrobo09 by Champion Sweeper
  • 9945 Views
  • 8 replies
  • 0 kudos

Resolved! Report on custom date field

I'd like to create a custom report for assets that have a date filled into our tblassetcustom.Custom1 field but are older than 2 weeks from today's date. My current query is as follows but it returns a listing of assets I would expect and assets that...

2jk7860 by Engaged Sweeper
  • 377 Views
  • 4 replies
  • 0 kudos

Resolved! OU-based report of computers

I need to create a computer report that contains a column with the OU and another where it indicates Win11, Anterior or X depending on the OU and sub OU:OU=Coworking, OU=Workstations Win11, DC=dominio, DC=localOU=Coworking, OU=Workstations, DC=domini...

Report showing assets with non active user relations

I am having issues building a report that will show assets that do not have an active user relationwe maintain user relations for record keeping, so devices have multiple user relations associated with them. active relations are relations that do not...

SLoubier by Engaged Sweeper
  • 134 Views
  • 0 replies
  • 0 kudos