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: 

Forum Posts

Sign in/Join

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
  • 6316 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
  • 6616 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
  • 8680 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
  • 4725 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! 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
  • 4896 Views
  • 1 replies
  • 0 kudos