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

Count by Department

I am trying to get a count of our assets by department. I have created this report, but it only counts up to 554. When I look at our configuration/License page, it says we have 1779 licensed assets. I am not sure what is wrong with the report. Th...

JTempleton by • Engaged Sweeper III
  • 4895 Views
  • 3 replies
  • 0 kudos

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
  • 4896 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
  • 4490 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
  • 4407 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
  • 1814 Views
  • 0 replies
  • 0 kudos