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

Resolved! Software report with icons for approval

I created the following query to give me a software report by Asset Group location. What I was looking to see if possible is to show the red/yellow/green icon for approved software in the report, is this possible?Select Top 1000000 tblAssetGroups.As...

mwrobo09 by • Champion Sweeper
  • 10248 Views
  • 8 replies
  • 0 kudos

Resolved! Report on custom date field

I'd like to create a custom report for assets that have a date filled into our tblassetcustom.Custom1 field but are older than 2 weeks from today's date. My current query is as follows but it returns a listing of assets I would expect and assets that...

2jk7860 by • Engaged Sweeper
  • 623 Views
  • 4 replies
  • 0 kudos

Resolved! OU-based report of computers

I need to create a computer report that contains a column with the OU and another where it indicates Win11, Anterior or X depending on the OU and sub OU:OU=Coworking, OU=Workstations Win11, DC=dominio, DC=localOU=Coworking, OU=Workstations, DC=domini...

Report showing assets with non active user relations

I am having issues building a report that will show assets that do not have an active user relationwe maintain user relations for record keeping, so devices have multiple user relations associated with them. active relations are relations that do not...

SLoubier by • Engaged Sweeper
  • 192 Views
  • 0 replies
  • 0 kudos

Resolved! Unable to add 'User' Column in Report

This Report runs without issue:Select Top 1000000 tblAssets.AssetID,tblAssets.AssetName,tblAssets.Username,tblAssetCustom.Model,tsysAssetTypes.AssetTypename,tsysAssetTypes.AssetTypeIcon10 As icon,tblAssets.Domain,tblAssets.IPAddress,tblAssets.Lastsee...

TRAGAR by • Engaged Sweeper II
  • 932 Views
  • 5 replies
  • 0 kudos

Resolved! Windows 11 compatibility report

Lansweeper published this great report template that checks your Windows assets for Windows 11 compatibility. Windows 11 Requirements Audit - Lansweeper IT Asset ManagementHowever, there is a flaw in this report in that it is marking an asset as fail...