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

Help Adding Mac workstations to report

I tried replacing all the tblLinuxSoftware with tblMacOSInfo but keeps giving me an error on the tblsoftwareuniAnyone have Ideas?Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename, tsysAssetTypes.AssetTypeIcon1...

Twinter by • Engaged Sweeper
  • 5491 Views
  • 1 replies
  • 0 kudos

Help Desk Reports

Hi,I'm not familiar with SQL queries and I'm needing a few reports for help desk metrics. All reports below are based on our fiscal year (July 1 - June 30).Also, we have an SLA created in the help desk with 2 hour initial response and 1 day for reso...

dfountain by • Engaged Sweeper
  • 6170 Views
  • 1 replies
  • 0 kudos

SNMP Switch Interface Report

Hello,i want a report that looks like the summary page of a switch. I need the interface name, alias, vlan and if connected the asset name and also not used interfaces. Like the report from a windows pc.Can someone help me to get this created via sql...

Resolved! Duplicate Assests Displayed in Report

Good Day, I have created the query below to find all members of the Local Administrators group on all Scanned Windows Systems (excluding Domain admins).The issue with this report is that it duplicates all assests and renders the report useless.What a...

mrfite by • Engaged Sweeper
  • 5003 Views
  • 2 replies
  • 0 kudos

New Hardware detail report

I have the following report.Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUnique, tblAssets.Domain, tblAssets.Processor, tblAssets.Memory, tblAssets.IPAddress, tblVideoController.Caption, tblNetworkAdapter.Name, tblIDEController.Captio...

MrPatrick by • Engaged Sweeper
  • 5212 Views
  • 1 replies
  • 0 kudos

Resolved! monitor report

Hello,I was wondering if there was a way to run the monitor report but add a column to show what resolution the monitor is.Dominic

Dtyner by • Engaged Sweeper II
  • 9079 Views
  • 5 replies
  • 0 kudos