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

Start a conversation

Windows 11 24H2 CPU Requirement Report

Hi,I just read an article that repots that Windows 11 24H2 requires something called POPCNT instruction support (SSE4.2). Has anyone created a report that will tell you which computers cannot be upgraded to 24H2?Here is the article:  https://www.ghac...

Help Desk with Root Cause

I have seen this asked several times but never with a clear answer. How do we get the root cause displayed in a Help Desk report?What I need is the built in report Helpdesk: All tickets that have been created but add a column for root cause.Bonus po...

chogan201 by • Engaged Sweeper III
  • 2945 Views
  • 1 replies
  • 1 kudos

Report to show all tickets that aren't assigned?

I'm trying to find a report that will show me a list of all tickets that have been opened but not "picked up" yet. Any suggestions? I've tried this with no luck:Select Top 1000000 htblticket.ticketid As [Ticket Number], htblticket.date As [Date Op...

pryan67 by • Champion Sweeper II
  • 4771 Views
  • 3 replies
  • 0 kudos

Resolved! Uptime report ordering

But at the moment, it goes down the list for 1,12,13,14,2,20,23,24,3,30,34 etcWe wold like it to be sequential, like 1,2,3,10,12,14,19,20,21etc, I hope that makes senseHere is my code.Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon, tblAss...

Tholmes by • Engaged Sweeper III
  • 3086 Views
  • 2 replies
  • 0 kudos

ALL Inventory - Dockin Station connected - Report

Anyone, know how to write the report script?Select Distinct Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblBaseBoard.Manufacturer As MBManufacturer, tblUSBController.*From tblAssets Inner Join tblBaseBoard On tblAssets.AssetID = tblBaseBo...

Problem filtering out Software from report

Hi,See below code. Why am I still getting Veeam Backup for Office 365 in my report?Thank you!Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tblSoftwareUni.softwareName As software, tblSoftware.softwareVersion As vers...

Johnny by • Engaged Sweeper II
  • 2095 Views
  • 1 replies
  • 0 kudos

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now