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

Show null vaules

I have added the Windows 10 end of life audit report to Lansweeper and am trying to edit it to include the OU the device is in. However, I do have some devices that are in Workgroups or have been imported from SCCM with no OU details. I would like th...

Add column to report to show Intune data

I have a 1909 End of Life report from Lansweeper.I'd like to add a column to it which displays the User Principal Name from Intune to that report.Mainly, so I have the user's email address included along with the report.When I try to add it myself it...

eatkins by Engaged Sweeper
  • 1148 Views
  • 0 replies
  • 0 kudos

I can't get htblnotes to show properly

I need the ticket detail section to show the htblnotes properly does any one have a solution??Select Top 1000000 htblticket.ticketid, '#' + Cast(htblticket.ticketid As nvarchar) As Ticket, htblticket.date As CreationDate, htblticket.updated As Las...

help getting ticket details text in into this report

I need this report but with the ticket details text included as well i'm not sure how to get it workingSelect Top 1000000 '#' + Cast(htblticket.ticketid As nvarchar) As Ticket, htblticket.date As CreationDate, htblticket.updated As LastUpdated, ht...

Distinct user logins per PC location map

I have found the following report which gives me the PC names, but I need it with the location map names. So we have created a location map here with all the pc's on it and I would like to see this name from the location map in my report.Select tblAs...

scoomans by Engaged Sweeper
  • 961 Views
  • 0 replies
  • 0 kudos

3 Software Versions on 1 row

Hello,I would like a report that lists a few software version numbers on one row. I did this at my last job... but I lost my notes. I will put the software name as the Column header... So the report would simply look like this.... on a single row.....

Resolved! List of all servers with flag for specific softwre

I am trying to create a report that will show all of the servers on my domain and add a Yes/No field to show the presence of a specific software package from Add/Remove list. I can get a list of only the servers with the software, but I want to see w...

malbanese1 by Engaged Sweeper II
  • 2914 Views
  • 2 replies
  • 0 kudos