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 ...
Good morning folks. I am Looking for a report that will show Duplicate asset names (for Laptops and Desktops). I looked through the online stuff I could find, but nothing related to what I am looking for. Does anyone have or know where I can find ...
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 Community We 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. Un...
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...
