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
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

Resolved! tblOperatingsystem.Caption Laptop OS version

Hello, May i know how to remove the Microsoft Windows 10 and leave only the Professional, Enterprise and Pro in tblOperatingsystem.Caption OS Version. I Tried this report below but Microsoft Windows 10 still showing in my query report. Select Top 100...

MarkJonN by Engaged Sweeper II
  • 9111 Views
  • 6 replies
  • 0 kudos

Error while creating report: Newtonsoft.Json

Hello everybody. I am pretty new to LanSweeper and do not know much about it.Every time I try to create a new report or try to change an existing one an error occurs.I get the following error message:{"Error":"Internal server error: Could not load f...

SQL Server Report - Count Of Assets

Hi ,Does anyone have a SQL Server report which gives a count of SQL for each device, the issue I'm having is its returns multiple instances per device because of the number of SQL Server services running , also if its 86 or 86 and 64 , I just need a...

Andy_Sismey by Champion Sweeper III
  • 1276 Views
  • 0 replies
  • 0 kudos

Asset-User Relation Report

Hi,I got a report to display the Asset Description + the user + relationship type (like Used by). But for AD group, it just shows Used by blank.Anyway this is fine up until the report also displays disabled user using active asset. Then I had to put ...

IntelYPO by Engaged Sweeper
  • 1294 Views
  • 0 replies
  • 0 kudos

Windows 10 Version Chart

I'm trying to build a chart report that displays the different versions of Windows 10 we have in our environment. I'm trying to simplify it for management and using 'Case' to display the layman's versions but I keep getting errors trying to do it. ...

brodiemac2 by Champion Sweeper
  • 12480 Views
  • 7 replies
  • 0 kudos

Show Date Without Time

Hello,I am hoping to get some help with this report. I'd like the Creation Date and Last Update Date to show as DD/MM/YYYY WITHOUT showing the time.SELECT TOP (1000000) '#' + CAST(htblticket.ticketid AS nvarchar) AS Ticket, htblticket.date AS ...

nhouse24 by Engaged Sweeper II
  • 6321 Views
  • 5 replies
  • 1 kudos