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: 

Forum Posts

Sign in/Join

Hardware Inventory

I decided to publish some of my reports.Problem: collect HW inventory.Solution: LS HW Inventory Report.Select Distinct Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblBaseBoard.Manufacturer As MBManufacturer, tblBaseBoard.Product, tblAsset...

Cisco Duo and associated registry keys

Hoping that someone else has already tackled this. I'd like a report of all Windows devices with Duo installed ("Duo Authentication for Windows Logon"). The report should show the following registry values for each asset with the program installed. A...

dhoward by • Engaged Sweeper III
  • 4254 Views
  • 2 replies
  • 0 kudos

Resolved! Lansweeper custom report: AssetName from AD and IP location.

Dear Lady's and Gents,I been asked to make a custom lansweeper report but im not really a SQL expert :).I searched multiple lansweeper posts, but didnt quite found my answer. I was looking for the following:I need a custom report that shows: AssestNa...

Arend by • Engaged Sweeper
  • 4160 Views
  • 2 replies
  • 1 kudos

Calls closed within SLA

My SQL is not upto scratch, and I found this code, but would like it to just run for this current month.Here is the code and Select Top 1000000 htblteams.teamname As team, totalTickets.totalCount As [All Closed Tickets], onTimeTickets.onTimeCount A...

Tholmes by • Engaged Sweeper III
  • 1734 Views
  • 0 replies
  • 0 kudos

Report that ties O365 Group Member to Asset?

Hi,How would I go about making a report to list members of a specific O365 group with each asset the member "owns" (we setup an ownership relationship between an AD user and their computer - but using "last logged in" computer could work too)?...I as...

mgeertz by • Engaged Sweeper II
  • 3122 Views
  • 2 replies
  • 0 kudos

Resolved! Windows 10 Pro

I'm attempting to create a report containing all Windows 10 Pro operating systems, as we need to upgrade them to Enterprise. I've tried a number of SQL variables related to the OS but so far have had no luck returning a successful report. What's the ...