This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Community FAQ

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Topics in this forum

Sign in/Join

Most Frequent Logon, Asset Owner, Primary User

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 ...

sqldba01 by • Engaged Sweeper III
  • 1075 Views
  • 3 replies
  • 3 kudos

Owner Report

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...

bilfdav by • Engaged Sweeper
  • 1835 Views
  • 1 replies
  • 0 kudos

Asset Uptime Report from Calendar

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...

Software Authorization - Once approved

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...

TasiaNAF by • Engaged Sweeper
  • 642 Views
  • 2 replies
  • 0 kudos

Resolved! September 2025 Patch audit report

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...

Daremo18 by • Engaged Sweeper II
  • 4030 Views
  • 13 replies
  • 2 kudos

Reporting on failed cloud sync status

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.

Resolved! Asset to Users Relations Audit Report Not Working

Hi,Long time Lansweeper business and need to get more out of the product in terms of asset to user relations. We recently fed back that there are far too many clicks involved to assign an asset to a user but that aside, want to report on those assign...