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 for Shares

Hi, can someone tell me how to make a report to see open shared folders

lemr by Engaged Sweeper
  • 4627 Views
  • 2 replies
  • 0 kudos

Resolved! Proper way to strip out text in columns in custom fields?

I don't use SQL too much so I am probably doing this wrong, but what is the correct way to remove strings from a table?In a custom report I have a column that displays the OU the computer is in. I want it to just show the final OU that the computer i...

feffrey by Engaged Sweeper
  • 6475 Views
  • 2 replies
  • 0 kudos

List of Lansweeper scanning servers

The report below lists machines that have the Lansweeper Server service installed (i.e. scanning servers) and whose service has connected to your Lansweeper database in the last 7 days. Note that this report may list some non-scanning servers as well...

Susan_A by Lansweeper Alumni
  • 6753 Views
  • 0 replies
  • 2 kudos

Resolved! List all local accounts

POssible to generate a report of all local accounts? Psexec against the machines running net user works but slow and not very pretty

greyclear by Engaged Sweeper III
  • 8898 Views
  • 2 replies
  • 0 kudos

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
  • 4841 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
  • 4817 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
  • 5033 Views
  • 1 replies
  • 0 kudos