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! 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
  • 5412 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
  • 5799 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
  • 17053 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
  • 5196 Views
  • 2 replies
  • 0 kudos

Resolved! Adding IP locations to "Out of Warranty" report

Would appreciate some help on adding IP location to the query below. I'll freely admit that I've no clue about reporting, as our resident SQL/report monkey appears to be missing in action right now.... All help gratefully accepted and I'd give whoe...

Resolved! Report trouble - Master list

I used to run the following report on a different server. I have since then reloaded Lansweeper on a different server from scratch. I copied the report below, but It isn't working. It isn't recognizing the Upgrade_ txt.Select Top 1000000 upgrade_t...

crichie by • Engaged Sweeper
  • 4007 Views
  • 1 replies
  • 0 kudos

Resolved! IP Range Location add to current report

I need to be able to add the IP location to this report so I know which city the device is located in. I had it in version 4.x but version 5.x is kicking my butt. Here is the code I currently have,Select Top 1000000 tblAssets.Username As Username, ...

rathm by • Engaged Sweeper
  • 5984 Views
  • 2 replies
  • 0 kudos

Resolved! MS Hotfixes

HiI've found some references in the forums on creating a report to list a certain MS hotfix but they only seem to be applicable to version 4.2 and don't list all the hotfixes that are installed on computers. Please could someone help me out with crea...

grnat by • Engaged Sweeper
  • 5604 Views
  • 2 replies
  • 0 kudos