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
We’re currently experiencing a high volume of support requests, which may result in longer response times — thank you for your patience and understanding.
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

Resolved! Tweak LanSweepers Bios Version Audit to show Last Seen

Hello everybody... I need some help here.https://www.lansweeper.com/report/bios-version-audit/I cannot figure out why it wont let me add Last Seen to the report. It keeps giving me an error "All queries combined using a UNION, INTERSECT or EXCEPT ope...

Tythesly by • Engaged Sweeper III
  • 3885 Views
  • 2 replies
  • 1 kudos

Resolved! Patch Volume Across Fleet

Hi, I can't work out how to create a report for the number of patches applied over the past year. This is just a calculation of applied patches on all Windows systems.Any thoughts?Appreciate the help!Darren

Report of list of assets

Hello!i want to create a report with a list of assets that are not servers nor workstations(only laptops) and that have e.g a java version lower than 291 It has to include the list of assets (hostname, user that uses that machine).Is posible to av...

Get value from Combo Box

New to Lansweeper and need to create a report for tickets that show Assigned Agent, County Department (that end user selected), and Time Worked from the notes. Everything I need is working except for the County Department. I cannot figure out how to ...

acasper by • Engaged Sweeper II
  • 3541 Views
  • 2 replies
  • 1 kudos

SCAP Reporting

As part of NIST compliance, our company has needed to run SCAP Compliance reports for a while now. From what I can tell, LanSweeper is already pulling all of the same required data for these reports. I would love for these to be able to be done rig...

Resolved! Add displayname or email to existing report

Can someone help me adding user displayname and/or full email adress to the native report called "Asset: Out of warranty"Default it looks like this :Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.AssetID, tblAssets.AssetName, ...

Morten by • Engaged Sweeper
  • 4566 Views
  • 2 replies
  • 0 kudos

Tickets Created and Closed per month on one report

Hi All,I am trying to get a report that shows created and closed tickets on the same report or SQL query.I have attempted to use a combination of the pre-loaded reports for Created and closed but am unable to get the details on the same report. Is th...

dan-jones by • Engaged Sweeper
  • 3068 Views
  • 1 replies
  • 0 kudos

USB printers with toner levels

Hi there,I was wondering if there was a report that can be made that can pull all of the USB printers that are connected to computers (I have some code below that I pulled from a different thread)but also have a column for toner. Is this possible?Sel...

ajokerst by • Engaged Sweeper II
  • 5085 Views
  • 3 replies
  • 0 kudos