→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

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

New Warranty report which includes Device Location

Hi,I am trying to create a report that shows assets that are out of warranty by a set time.  I have modified a previous report that I found to include the Asset Location The Asset location is set here for each asset Sometimes there is an asset which ...

Report.jpg location.jpg Location Missing.jpg

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
  • 1087 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
  • 1183 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
  • 1000 Views
  • 0 replies
  • 0 kudos