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! Need a Report Displaying # of Processor Cores on Servers

I am trying to determine how many processor cores are in the CPU of each of our servers in our school district, here is what I have, but it's not displaying any results, any help would be great:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUn...

pwalach by • Engaged Sweeper III
  • 5485 Views
  • 1 replies
  • 0 kudos

Audit: Windows Servers with TS/RDS Role (App-Mode)

Select Top (1000000) tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tblAssets.IPAddress, tblAssets.Firstseen, tblAssets.Lastseen, tblAssets.Lasttried, tsysOS.Image As iconFrom tblAssets Inner Join tblRegistry As tblRegistrya On tbl...

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
  • 5199 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
  • 5450 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
  • 5195 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
  • 5984 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
  • 7863 Views
  • 3 replies
  • 0 kudos