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

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
  • 1266 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
  • 1433 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
  • 1330 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
  • 2646 Views
  • 0 replies
  • 3 kudos

SQL Question for Custom Fields

I'm running a report for All tickets, including a custom field result for appropriate tickets. I get the results I want using Case When, but the report also pulls a duplicate, blank result for the tickets with that custom field result.Select Distinct...

Help with Report with User Log In Time and Uptime

Trying to make a custom report where I can view the users' log-in time and users' PC uptime from a Static Group.Needs:1. Select From custom Static Group2. Have User LastLogon3. Have Asset uptimeSinceLastRebootI cannot find a way to combine the LastLo...

akira by • Engaged Sweeper II
  • 1937 Views
  • 0 replies
  • 1 kudos

set threshold to report

how i can set threshold for reports? for example wh have 1 DHCP and 1 DNS server. if it has changed then the report become green in dashbord report. otherwise it would be green or just information

farsad by • Engaged Sweeper
  • 1863 Views
  • 0 replies
  • 0 kudos

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now
Top Kudoed Authors
View all