I'm trying to find a way to use Lansweeper to create a complete point-in-time configuration record for an individual asset.If I open an asset in Lansweeper online, it provides a detailed inventory of hardware, software, versions, shares, and much mor...
I need to add state does not equal Closed or In Audit. Can anyone give me a leg up?Select Top 1000000 htblticket.date As CreationDate,htblticketstates.statename As State,htblticket.agentid,htblticket.ticketid,htblticket.subject,htblticket.fromuserid...
Running Lansweeper Classic v12 - I'm trying to modify the "Software: Changes in the last 7 days report" so that it only shows NEW installs. I see a few older posts but they didn't show how to filter in the SQL.I asked Copilot to update the code and ...
Hello, I am looking for a report that can filter by ticket type and by month and THEN time spent on average for the month on said ticket type.
Hi, I'm in need of a report showing ONLY physical laptops and desktops regardless of the OS (we have Linux, Mac, and Windows). I can get bits and pieces of this information from other reports but I have no luck making a single report that covers it a...
Dear CommunityWe have lots of Servers with Unallocated Disk Space, and its very time consuming to manually check each Server, whenever we need disk space for other VM's. Right now there is no community made, or Built in Report for this Function. Una...
Due to a problem with someone cloning our virtual systems and not adjusting the MAC address I need to build a report for what is supposedly impossible...to find duplicate MAC's. I attempted to modify the duplicate serial number report to work as int...
All our Windows Server 2019/2016/2012 have the same Problem in the Lansweeper overview:There is a S in the Build version, but if I check on the Microsoft Page there is no S in the Build versions.also it shows me the Build 10.0.17763S.4492 but if I ch...
