Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

Forum Posts

Sorted by:

Create a post

List last Owner of Windows assets

I want a report that lists all windows asset with last owner (User Relations - last date Owned by value). If the asset have more Owned by value i want the last.1 asset - 1 line - 1 owned by valuePlease help. Thanks.

Detailed Asset + Last Logged on User Report

Hi All,I am looking for assistance for a report that provides the following details please:- Last Logged on User- Computer Description (From Active Directory)- Office Location from Last Logged on User (From Active Directory)- Users Job Title (From Ac...

Add a User via Email Dispatch rules

It would be really nice to be able to add a user or a CC user via email dispatch rules - For example:We have a dispatch rule set up to allow us to send a quick email to record helpdesk calls (the web GUI is nice but just not fast enough to be effecti...

List Owners of Windows and Linux assets

LanSweeper/SQL Newbie I found this great script, by user Susan A., which lists gets me about 90% of the way. This gets me all Windows Servers. I'm hoping for some help which will get me both Windows and Linux assets. Sorry if this is posted alre...

Win32_Reliability and Win32_ReliabilityRecords Scanning

It would be really handy to be able to see the reliability scores of machines and the associated records. This would really help identify problematic machines that are in need of proactive maintenance, and also arm the helpdesk with the information t...

System Audit

Select Top 1000000 tsysOS.Image As icon, tblAssetCustom.AssetID, tblAssets.AssetName, tblAssets.Processor, tblAssets.Memory, tblBIOS.SMBIOSBIOSVersion, tsysOS.OSname As OS, tblAssets.SP As SP, tblAssetCustom.Warrantydate As [Warranty Expirati...

PC's With Missing Drivers Report

Is there any possible way to have Lansweeper detect which PC's have missing drivers?Even if the report is something as simple as Yes/No so that we can log on and check manually etc.

Remove Duplicates

I go this query which generates a report of all assets with Windows and Linux, with IP. for some reason it shows duplicates on some of the assets. Can you help how to remove duplicates. Thanks,Select Top 100000 tsysIPLocations.IPLocation, tblAsset...

Top Kudoed Authors

User

Count

1