This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject

→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !

Community FAQ

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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

Sign in/Join

User machine behaviour

Hi all, we are trying to run some analysis to identify if staff are away from their machines more when working from home or in the office...We can identify machines that are working remotely as they will be on a different subnet to the office, each u...

Elexon by • Engaged Sweeper
  • 1256 Views
  • 0 replies
  • 0 kudos

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
  • 1348 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
  • 1157 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.....