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

Resolved! Reports through a AssetGroups Dymanic

I would like to be able to make a report on the basis of an AssetGroups Dymanic?Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename, tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.IPAddress, tblAssets.Lasts...

Martind by • Engaged Sweeper II
  • 3728 Views
  • 1 replies
  • 0 kudos

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
  • 5265 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
  • 5879 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
  • 4584 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
  • 4924 Views
  • 1 replies
  • 0 kudos