This board contains archived posts from the retired Lansweeper Forum and Insiders Community.
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...
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?
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 ...
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 ...
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...
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...
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
Hello, we noticed that in the HyperVGuest table guest assetnames are not updated if the guest VM has been renamed or merged. This can lead to problems when generating a report for a Hyper-V environment since the guest table will hold old names instea...
