Hey folks,Back in August, I put together an SQL query to help summarize the Microsoft Patch Tuesday reports published monthly by Lansweeper: https://www.lansweeper.com/blog/patch-tuesday/The goal is to pull only the most relevant information about as...
This can be used to get the most frequent logon account in the last 60 days. -- First query: Get the most frequent logon user for each AssetIDWITH LogonCountsAS (SELECT AssetID,username,COUNT(*) AS logon_count,ROW_NUMBER() OVER (PARTITION BY AssetID ...
Hi,I am using this report to see owners that owns 2 computers and more (owned by).I am using Custom7 for "common computer" (checkbox yes/no).Users that owns a common computer shows up in the report should be excluded. (Can that be done?Select Top 100...
I had a ticket open ages ago and lansweeper support indicated that the department was based on the last update user, not the user the ticket was assigned to.I eventually dove into the SQL and this is fairly easy to change.SQL for time worked, includi...
I'm looking for a report to have the weekly/monthly average power-on time for all assets. The information that is contained on the Uptime calendar when selecting a specific asset is what I want in a report format. I did see this previous post from 20...
Hello, I appologize if this has been asked already, but I did not find any posts on this issue. We have been marking software as "Approved" in the Sofware Authorization, but these seems to only show when the software is currently installed on a devic...
Hey guys, when I run the latest Sept patch audit report devices are showing red and out of date, when the device DOES have the KB installed. Has anyone else seen this behavior? Note: they do say reboot may be required or reboot required but I've re...
Hi. I'm trying to create a report that will tell me if syncing to the cloud has failed for more than X hours. Where is the sync status data stored in SQL so I can use it for my report? Thank you.
