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! 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
  • 3912 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
  • 5867 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
  • 5500 Views
  • 2 replies
  • 0 kudos

Resolved! Report help

How would i go about creating a report with machine information related to this event log error. Product: Sophos AutoUpdate -- Internal Error 2324do i need to turn on event log scanning? this can be seen on PC's when i look at them in lansweeper. i a...

chads by • Lansweeper Alumni
  • 7542 Views
  • 2 replies
  • 0 kudos

Resolved! IP Range and Location REport

I recently upgraded to version 5.0.0.52 and I am trying to edit a custom report to show the Location of my assets. I had IP Locations set up in the previous version and it looks like they are now called Asset Groups. I need to add the location to thi...

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

Resolved! Report help

Need some help with this report I have currently, It is searching for machines without "Websense Endpoint". The problem I have is I am trying to only show Windows 7 x86 and x64 and Windows XP x86 and x64 machines. Anyone help me here?Select Top 10000...

rberg by • Engaged Sweeper
  • 4170 Views
  • 1 replies
  • 0 kudos

Resolved! last reboot

Hello,We use lansweeper v5.I scan the file "bootstat.dat" to show how long the computer runs without powering down.The date is shown as "05/02/2013 11:13:00".How can i filter out the current day?I tried it with "GetDate()" but that doesn't work. .....

Lindner by • Engaged Sweeper III
  • 15953 Views
  • 7 replies
  • 0 kudos