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: 

Topics in this forum

Sign in/Join

Resolved! Filter by IP location Report

First off... I admit, I am new to LanSweeper and im not huge guru on SQL. I have a report that I have created to view a specific version of software and would like to filter it by IP location. When I run the report it has all the items from that loca...

Resolved! Report to show VM server hosts

Hi All,I have the below SQL script which gives me all I need. The only thing it does not report back are VM host servers, Can anyone point me in the right direction?Select Top 1000000 tblAssets.FQDN, tsysOS.Image As icon, tblAssets.AssetID, tblAs...

daniel890 by • Engaged Sweeper
  • 6322 Views
  • 1 replies
  • 0 kudos

Resolved! Exclude certain drives from low drive space report

I would like to exclude certain drives on certain workstations from the low drive space report.For example, I would like to exclude the E drive on workstation1 from the report. I know I can add Not Like '%workstation1%' to filter out the entire work...

archaic0 by • Engaged Sweeper II
  • 8538 Views
  • 6 replies
  • 0 kudos

Resolved! Printer with less Toner modification

There is a report as mentioned in the title.No i want to modify it so i can filter it by location.does anybody has a clue how to do that?I am pretty knew to ls and this query stuff.thank you for your answers.

soma by • Engaged Sweeper
  • 3708 Views
  • 1 replies
  • 0 kudos

Resolved! View HDD Free Space with 2 Decimal Places

I'd like to be able to view the Free in GB field on the 'Disk: HDD, Size, Type and Pct' report with two digits of usable data - eg 1/3GB = .33Here's what I've updated in the code to get the two decimals but all I see are two preceding zeros and not...

brianraley by • Engaged Sweeper III
  • 8538 Views
  • 3 replies
  • 0 kudos

Resolved! Report for 1 asset

Is there a way to produce a report wherein in it will prompt for the computername? I wanted to export all info for a device to a text file. Right now when you're on a device and click on Report tab it does not give you all the info from the Summary...

Resolved! Report: McAfee - AVEEngine +30 days

Hi friends!I have a custom report that show the reg key AVEngine (last time MCAfee was updated).Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName As Equipo, tblADusers.Name As Usuario, tblRegistry.Regkey As [Clave de registro x32 & x64], ...

javier by • Engaged Sweeper II
  • 5183 Views
  • 2 replies
  • 0 kudos