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! Report to show computers using the same network printer

How would I create a report to show computers using the same network printer. I want to be able to run a report with the printers DNS name or IP address and have it show me all the workstations that are using the printer.Thanks

tundra96 by • Engaged Sweeper
  • 4822 Views
  • 1 replies
  • 0 kudos

Resolved! Asset assigned to User

I have the following query for finding Monitors 'used by' users, but I ran into one hiccup. I also need to be able to see the monitors that don't have the 'used by' relation set as well.Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, Con...

crashff by • Champion Sweeper
  • 5040 Views
  • 1 replies
  • 0 kudos

Resolved! Forum itself: [code] segment bugged

Hi, me again with another forum issue:See the screenshots, it's just a visual bug, copying to notepad works.Tested with IE9, Firefox 31 and Chrome 39 - same result.http://www.lansweeper.com/Forum/yaf_postst10498_Deploy-click-to-run-technologies.aspx#...

stiwa by • Champion Sweeper
  • 4376 Views
  • 1 replies
  • 0 kudos

Resolved! Create report to show service status (Windows Update)

Hello,I always keep 'Windows Update' service disabled on all my servers.How can I write a report that would: - list just servers- Echo the Start Mode status of the 'Windows Update' service- Echo the State of the Windows Update ServiceOutput would loo...

Resolved! Report from SQL to LS

So we are trying to make a SQL query into a LS report but the LS report editor doesn't like anything we throw at it. This is the SQL code;with spie as(select tos.Image As icon, ta.AssetID, ta.AssetName, ta.Domain, ta.Username, ta.Userdomai...

chads by • Lansweeper Alumni
  • 5314 Views
  • 1 replies
  • 0 kudos

Resolved! List all Laptops and if they have software on them

Hello - Been working on this for a few days based on already built reports in LS and online. I have 2 reports I am looking to merge into 1. I want to list all laptops in our environment (Report 1) and indicate if they have PGP or Symantec Encryptio...

billiams by • Engaged Sweeper
  • 7160 Views
  • 3 replies
  • 0 kudos

Resolved! Identifying full-disk encrypted drives

I'm advised that our hardware people are going to start installing Symantec Endpoint on some computers and enabling full-disk encryption. I assume that I'll be able to detect the presence of the software just like any other properly-installed applica...

RCorbeil by • Honored Sweeper II
  • 6177 Views
  • 1 replies
  • 0 kudos

Resolved! Adding warranty field breaks the report...

The following report works find and produces a list of 4,700+ devices.Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename, tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.IPAddress, tblAssets.Lastseen, tblA...