Hi, i try to build a report of the event-logs in last 7 days of id 1096.BUT i want every device to show up only once and not for every event.I use this Template:Event Log Cleared Audit - LansweeperCan you help me?Select Top 1000000 tblAssets.AssetID,...
Hi,I am trying to write a report which shows which computers don't have the WSUS registry or the correct one, I have seen a few examples but cant get to work.Below is the folder I am trying to search for and show the machines where its not found.[HKE...
LS has a powerful chart. It is Bar-diagram. It can show more than 2 column data.I have developed SQL-query for AD Users. It have to be used with this type chart.You should use report's name with prefix "Chart:".Chart: Status of AD usersQuery: Select ...
I need a report that will at least show CPU and RAM utilization...would like Disk Utilization as well (got GB used, but actual disk usage). I've found the CPU and RAM reports below, but I'm not sure how to combine these in to 1 report, and then add ...
Sorry, but i could not found a simple LS Cloud report showing me Workstations Assets with last ADUser and several AD informations about this user like E-Mail Address... in one report.
I am trying to write a report that will identify all laptops that do not have biometric hardware installed. I was able to find a report that includes all computers with that hardware. Was wondering if this was possible to create?
Hey everyone,we are currently working on an integration for another system. For that, we need a report with a specific set of columns. I've built a report with the needed columns and the result is useless, since it returns around 1 million results Wh...
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...
