I am trying to add the most recent user to the following report for each asset name. It appear the data I want is in tblCPlogoninfo.Username. My problem is this file has multiple entries for each asset name based on the last login time and date so a ...
Hello all, I've had a look at the new Video Overview from Lansweeper and I've seen something very interesting and can't find it in the latest update that was available (v.5306).It's the line chart with "New Employees by Months" seen at 2m35s in the v...
Hi,We are currently undergoing a review/audit with Microsoft. I am looking to have a 90% completion and I am struggling to get some data using the MS tool provided as some machines are turned on.However, I should have this data available in Lansweep...
I am looking for a report that I can run that gives me the following output:Owner- whether it has one listed or notStatus- Active, broken, etcOS Type- Linux, Windows, etcManufacturerModelSerial NumberWarranty ExpirationAsset NameLast SeenDomainOU
Hi All, I'm quite new with Lansweeper so apologies if this is something I've missed/already been answered. In a nutshell our SD need the full list of Assets from Lansweeper so they can compare to their CMDB. They've agreed that they would like ALL in...
Trying to generate a report to show PCs expiring/expired between two set dates (company fiscal year). What is the SQL code for specifying a date range?