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
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Topics in this forum

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

2jk7860 by • Engaged Sweeper
  • 1185 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=domin...

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
  • 337 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.Lastse...

TRAGAR by • Engaged Sweeper III
  • 1502 Views
  • 5 replies
  • 0 kudos

Custom Help Desk report - Tickets closed by Agent

Has anyone created a custom help desk report to capture the number of tickets closed by each help desk agent for the week, even if the agent didn't pick up the ticket? I can add the column "Last Editor" in my closed ticket queue, so I can see who clo...

TLS version report

Hi,As Microsoft requires all resources which interact with Azure services to be using TLS 1.2 or higher as of 31 October 2024 we were looking to create a Lansweeper report which can identify the TLS version used in our network. On our DC's we've alre...