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: 

Topics in this forum

Resolved! Hardware/Software Poll

The information I am seeking are the following fields:Last known userOSIP addressIP locationLast seenLast triedComputer nameCPUI have basically taken the built in report named "OS: Operating system overview", added in the "tsysIPLocation" table and c...

dalbright by Engaged Sweeper
  • 5800 Views
  • 3 replies
  • 0 kudos

Resolved! Support for nested queries?

I want to list all assets from a hard-coded list and next to each asset, the version of CrashPlan installed, or blank where it is not installed.Here is my query:Select tblAssets.Username , (select s.softwareVersion from tblSoftware s inner join t...

Resolved! Combining two reports

We track our software usage & purchases by Department. I have added a Department code to Software Purchase information in the Comments field. I am able to create a report to show me the count of purchases by DepartmentsSelect Cast(tblSublicensesOrd...

Resolved! How to add pinned location to a report

Greetings,I am a newbie and I don't know the system well enough to do what I am looking to do. I have defined locations (IT, Marketing ...). I have pinned locations to some assets. I created a report to give me all Windows systems with the query belo...

joled by Engaged Sweeper
  • 5005 Views
  • 2 replies
  • 0 kudos

Resolved! Windows 10 Report that includes Build Version

I'm very new to building Lansweeper reports. I'm not sure if someone has posted this already but I was seeing if someone could please walk me through creating a report for Windows 10 machines that includes the OS build version? Thank you in advance!

ARGOIT by Engaged Sweeper
  • 6616 Views
  • 1 replies
  • 0 kudos

Resolved! Helpdesk Report SQL Statement

I've tried various SQL statements but cant get it to format correctly. Basically, I need to see all my closed and open cases for the last 7 days with the subject, date, user name, and notes (all of them not just the initial notes). Can somebody help ...

JBS_Admin by Engaged Sweeper
  • 3612 Views
  • 1 replies
  • 0 kudos

Report hardware grouped by server group

Hello, We recently went through and added every asset that exists in LanSweeper to one or more groups based on the line of business they belong to. What I am trying to do now is make a report that will shows me total amount of CPU/CPU Cores/Memory in...

Resolved! Computers with SQL, Visio and Project

I am been trying to create a single report that includes all the SQL Server (any version), MS Visio and MS Project installed in my environment, so far, haven't been able to do so, has anyone ran into this type of report before?

PROSUser by Engaged Sweeper II
  • 4877 Views
  • 1 replies
  • 0 kudos