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! Show all software for all devices by location

Hello all,I'm trying to make a query for showing all my asset with all softwares installed with IP location in column.In my test, I do not show all my computer and I have a lot of duplicate...Here is my query : Something is wornd ?Select Top 1000000 ...

Kreg by • Engaged Sweeper II
  • 5649 Views
  • 2 replies
  • 0 kudos

Resolved! Modify Built-in report to include Assetname and IPLocation

Hi,I am looking for a report, similar to the built-in Lansweeper v5 report 'Software: All Microsoft software'.It needs to tell me how many computers at each IPLocation have each type of Microsoft Software installed. I'm not too worried about the 'Ver...

Hogester by • Engaged Sweeper
  • 4189 Views
  • 1 replies
  • 0 kudos

Resolved! AssetName clickable

What modifications are needed to make the resuting tblAssets.AssetName a hyperlink, so I can drill down to the resulting device from the report?Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.AssetID, tblAssets.AssetName As [De...

harringg by • Champion Sweeper
  • 4233 Views
  • 1 replies
  • 0 kudos

Resolved! IP Locations Report with Specfic Wildcard AssetName

I would like pull a report exiting following code but with the specific wild card asset names beginiing with UKTRT only. But with the Last User Display name form the AD Display Name which shows the full name of the AD account last logged in.Select To...

RDizzle by • Engaged Sweeper II
  • 5321 Views
  • 2 replies
  • 0 kudos

Resolved! IP Locations

My organization is trying to retire an old domain and i need to find the machines that have static DNS entries pointing to those servers and what location they are in. I can get the network information but when i try to add the IP Location data i get...

Malbanese by • Engaged Sweeper III
  • 5691 Views
  • 2 replies
  • 0 kudos

Resolved! Reporting on switch port information

Love the SNMP port mapping feature in v5, but having difficulty integrating connection data into reports. I'd like to report on workstations for which this information is present (and conversly those that haven't populated), for example Hostname, Com...

RJAH by • Engaged Sweeper II
  • 16420 Views
  • 8 replies
  • 1 kudos

Resolved! Report with specific IPLocation

Hi,i'm using LS 5 (5052) and i'm trying to modify already existing reports for specific IPLocations.For example i need the "Unrated Software" report for a specific IPLocation -> "Location - #All". I have added tsysIPLocations.IPLocation and entered t...

FrankW by • Engaged Sweeper III
  • 5086 Views
  • 2 replies
  • 0 kudos