I'm looking to create a report that report illustrates the physical/virtual ratio in our estate. I've created the following query, however, it will not work as a chart due to the fact it returns a single row:Select Distinct Top 1000000 SUM(Case tblA...
Hello all,New to Lansweeper and Lansweeper Cloud.I have recently started running into issues with viewing Custom Reports within our Lansweeper Site. All I see is a blank page when I try to view the results. I can however, edit the report and see the ...
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...
