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

→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

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

Resolved! Show full OS build

I have a report that has been created by my team which can be found below. It is great but I would like for the report to show full OS build. Currently it is only showing the OS version but not Edition. Ie Windows 2012 R2, where as I would like the r...

Ismail by • Engaged Sweeper II
  • 5289 Views
  • 1 replies
  • 0 kudos

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
  • 4829 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
  • 4180 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
  • 5932 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
  • 3024 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...