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
The Lansweeper Community will be under construction as of March 2nd, 2026. This site will move to a static version—join us on Reddit to keep the conversations going. More info here.
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

Filter Column to only display CVE values

Hi,Is there a way in SQL to select certain values from a Description column and display just those values in a new column or the same Column, for example I have a table containing CVE information, I'm trying to just identify the CVE Values so this :"...

Andy_Sismey by • Champion Sweeper III
  • 4636 Views
  • 2 replies
  • 0 kudos

Exclude specific computers from report

Currently using this report to find out what machines are missing Trend Micro. I have a few I would like to exclude, can anyone advise on how to accomplish this? Sorry not an expert in this area!Select Top 1000000 tsysOS.Image As icon, tblAssets.Ass...

seand by • Engaged Sweeper II
  • 8917 Views
  • 4 replies
  • 0 kudos

Windows 11 reporting

I'm wondering about reporting on Windows 11 devices in LanSweeper.Currently I can go off of tsysOS.OSCode = '10.0.22000', however, the tsysOS.OSName for that ID is still 'Win 10'. Using tsys.OSCode will allow me to report on Windows 11 machines, howe...

cand by • Engaged Sweeper
  • 2924 Views
  • 0 replies
  • 2 kudos

Chart: Microsoft Office 365 Versions

It took me a while to get this working, mainly due to my lack of knowledge in doing these queries. This will grab the version number of the Office 365 installation and give the total amount of clients with that version. In turn it can be used for cha...

suspect0 by • Engaged Sweeper
  • 18683 Views
  • 4 replies
  • 4 kudos

Printer Network Interfaces Database Table?

I'm trying to build a report showing all the network interfaces present across our printer fleet regardless of connection status. The individual printer asset pages can show multiple interfaces, but I can't find where this is stored to pull it into a...

ChrisParr by • Engaged Sweeper II
  • 2035 Views
  • 0 replies
  • 0 kudos

Resolved! small change to "Software: List of software by computer"

Hi, Can someone kindly help me figuring this out. i have no SQL query experience, hence this problem.The builtin report: Software: List of software by computeris for my purpose missing Fullname (instead of username) and the Company attribute from AD....

snigah by • Engaged Sweeper II
  • 4428 Views
  • 2 replies
  • 0 kudos