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: 

Forum Posts

Sign in/Join

Creating a count

I am struggling with editing a report and getting it to create a count of how many assets have each software in my report. I then want to take this and display on my report the software that has 5 or less assets assigned to it and the details of whi...

Some reports shows dublicated assets

Hello everyone,I have a new installation of Lansweeper, the current config looks like this:Automatic scanning of all assets is disabled except printers.All workstations are scanned through LsAgentThere is an issue that some reports show the same asse...

metador by • Engaged Sweeper
  • 2411 Views
  • 1 replies
  • 0 kudos

Adding "multi-part" Conditions to Reports

I'm building a few reports based on stored inventory vs. deployed inventory.Without getting into the details of the individual reports, I am making simple reports based on 5 separate types of assets (10 reports total = deployed & stored per asset): ...

mhammond by • Champion Sweeper
  • 4240 Views
  • 3 replies
  • 0 kudos

Looking some help with SQL

I want to delete the Renamed ITORG\SSW0820\1 to BUFFALO\SSW0820\1 comments that are generated when computers are rename. I have a query, but I do not know how to delete the comments. any help would be greatSelect Top 1000000 tblAssets.AssetID, tbl...

Richard_A by • Engaged Sweeper II
  • 1349 Views
  • 0 replies
  • 0 kudos

Report showing only Wi-Fi Devices and MAC addresses

Is there a way to report which devices in Lansweeper have Wi-Fi adapters and show what their Wi-Fi MAC addresses are? This would include Windows, Mac, printers, smartTVs, or anything in Lansweeper that uses Wi-Fi. If that's not possible, is there a w...

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
  • 2985 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