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

Topics in this forum

Sign in/Join

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
  • 1473 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
  • 1292 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
  • 3637 Views
  • 2 replies
  • 0 kudos

Need to document asset moves

I am by no means a SQL DBA. I am looking at the documentation provided by Lansweeper and looking at the training site they have linked to learn how to write this report, unfortunately It's Greek to me. What I need to do is run a report monthly that s...

Timothyf by • Engaged Sweeper
  • 2848 Views
  • 1 replies
  • 1 kudos