I need help with a report that shows sleeptime for systems. Something like this: SELECT Name AS ‘Computer Name’, LastWakeTime, LastSleepTime, DATEDIFF(MINUTE, LastWakeTime, LastSleepTime) AS ‘Minutes Asleep’ FROM Computers WHERE LastSleepTime IS NOT...
I successfully generated a report for my UPS's but when I look for the serial number what I get is the serial number for the network card and not the UPS. Anyone know how to gather that information? Thanks to anyone for viewing this.
I am trying to create a report that shows systems that have an application installed "x" and when installed the version is not "y" or "z". I have several of these type reports that work fine when I am only looking at one version. With the version b...
With the pandemic, we are trying to see all our monitors that were sent out to people to be able to work at home. I have created the following report, but it shows the complete history of the monitors that were connected. The issue is with Laptops...
Is there a possibility to create a time chart to be used in the time chart widget?I noticed this is not working the same as with the chart report widget for which you can create a report which name starts with Chart:This doesn't work for time charts ...
Hello, I was wondering if it would be possible to do the following, and how I could potentially do it. I am new to Lansweeper and my company uses a program that does not show up as a program in the Windows Control panel and is not detected by Lanswe...
Hi everyone! I have a report that to bring any informations of the my customers and I need just to add the column Warranty and Purchased of my asset in this report.Thsi information:In here:My report actual: Select Top 1000000 tsysOS.Image As icon, ...
I need an explaination of the purpose of this report. With "expired" does it mean I have to renew te license, or that there is a new version of the software?
