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: 

Forum Posts

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
  • 1268 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
  • 1682 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
  • 1280 Views
  • 0 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
  • 1443 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
  • 1341 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 ...

Custom Action to pass user variable from asset action screen

I have created a custom action that uses the {email} variable on the user action pages fine.However, what I would like to be able to do is use that variable when viewing an asset and taking the currently logged on user's email address and passing it ...

ccdesktop by • Champion Sweeper
  • 2663 Views
  • 0 replies
  • 3 kudos