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

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders 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

SQL to run report

I want to create a report that I will then be able to parse out how many IPs per domain within our network. So ideally a list of all IPs and their domains. All it is giving me is all computers. I want to be able to allocate IPs of any device with an ...

cwhite19 by • Engaged Sweeper
  • 1584 Views
  • 0 replies
  • 0 kudos

Remote scanning servers installation with a different SQL port

Hello,For some obscure reasons my dba team decided to change the default listening port of our Lansweeper's database. Of course, only this new port is allowed on the firewall between the future scanning servers and the main Lansweeper's database ser...

Sylvie by • Engaged Sweeper III
  • 2121 Views
  • 0 replies
  • 0 kudos

Track Package Name in Deployments of an Asset

Deployment packages titles sometimes are modified with newer version of the program deployed, for example "Update to PRG version 1.1.1" one month ago and now "Update to PRG version 2.0.0"The problem is that when I go to Asset's deployment page I can ...

ufficioced by • Champion Sweeper
  • 1642 Views
  • 0 replies
  • 0 kudos

Resolved! Cleanup Actions

I have this Setting active:Set assets to non-active if not seen in the last [180] daysI have some assets, which are offline by default. Lansweeper sets them to offline, too. It would be nice if i can mark these assets to be "always active", like this...

Icebreaker by • Engaged Sweeper II
  • 4168 Views
  • 1 replies
  • 0 kudos

Custom License Report

I found the following on this site somewhere. (Thank to the author)Select Top 1000000 tblLicenses.softwareName As [Software Name], InUseCount.InUseLicenses As [In Use], LicenseCount.PurchasedLicenses As Purchased, (InUseCount.InUseLicenses - Licen...

bcaulkins by • Engaged Sweeper
  • 1794 Views
  • 0 replies
  • 0 kudos

Previous Computer Logons

I know how to pull the most recent logon from a laptop/desktop. Is there a report you can run that will show say, the last 5 - 10 logons and what users logged in?

nadmin1 by • Engaged Sweeper
  • 1659 Views
  • 0 replies
  • 0 kudos

Add "Error Type Count" to existing asset report

I've inherited Lansweeper ownership at my site and have little SQL knowledge - taking tutorials, but felt the need to reach out on this one. My asset report is below - it contains everything I need, except for scanning errors. What I am looking to ...