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! All Asset Report - Almost where I need it

Greetings. I have an all asset report almost where I need it but I need a few tweaks that I can't figure out. I need the following items added to my report.On the monitors that are listed in this report I want them to tie back to the computer they ...

Niley by • Engaged Sweeper II
  • 4087 Views
  • 1 replies
  • 1 kudos

Resolved! User and PC Names Report

I have the following report:Select Top 1000000 SubQuery.Username, SubQuery.Domain As Userdomain, SubQuery.LastLogon, tblAssets.AssetName, tblADusers.DisplaynameFrom tblCPlogoninfo Inner Join (Select Top 1000000 tblCPlogoninfo.Username, tblCPl...

Resolved! monitors connected to PCs on 2 subnets / 1 IP location

Hey guys,I know very very little about SQL.Could someone help me to get together a report which would give meall LCDs having an Asset relation "Connected To" to all computers in one of our IP Locations pls?BTW: 1) we have two subnets there 172.20.102...

jozin_cz by • Engaged Sweeper
  • 4608 Views
  • 1 replies
  • 0 kudos

Resolved! Which tables for the Software License Compliance?

I am trying to create a report which will allow me to run a Software license report for different departments. The built-in reports works well for ALL of the license and associated software but I need to have a different report for each department. I...

jaysands by • Engaged Sweeper
  • 4272 Views
  • 1 replies
  • 0 kudos

Resolved! Inventory help

Hello All,I am trying to get a server list from are network. I want the list to include Asset name, IP address, OS Type (Including Linux, RedHAT).. Can someone help me with this?Thanks...

gamero by • Engaged Sweeper
  • 4179 Views
  • 1 replies
  • 0 kudos

Resolved! Inventory Ethernet MAC And Wireless MAC

I want to create an inventory report that shows:Comp Name: -- Model: -- Serial: -- Wireless MAC: -- Ethernet MAC:PC-01............NCS.......T001.......34:FE:22:54:23......00:11:22:33:44Right now everything is working except I can not dif...

coverthis by • Engaged Sweeper
  • 10005 Views
  • 6 replies
  • 0 kudos

Resolved! Report Help - Equal to or less than

This report gives me all the computers with Flash player that is a certain version. How can I modify it so that it's a equal to or less than that version?Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUnique, tblSoftwareUni.softwareName, tb...

sullivane by • Champion Sweeper III
  • 11609 Views
  • 6 replies
  • 0 kudos

Resolved! Server Uptime as a %

Ive seen a lot of report with the server uptime in Days but I am trying to create a report that uses the Uptime Calendar information to calculate a % value against a given period i.e. Calendar Month.Has anyone tried this and succeeded?

RobertMcD by • Engaged Sweeper
  • 5495 Views
  • 1 replies
  • 0 kudos

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now