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

Adding computer type to Windows 10 report

We have a Windows 10 report that we would like to also show whether each asset is a desktop or a laptop. What do we need to add to the report to show these?Here is the Windows 10 report we have:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUn...

chenegh by • Engaged Sweeper II
  • 5795 Views
  • 3 replies
  • 1 kudos

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
  • 5682 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
  • 5728 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
  • 2224 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
  • 3963 Views
  • 2 replies
  • 0 kudos