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: 

Forum Posts

Resolved! Chart report grouping criteria

I have a chart report that works well but I want to refine it a little bit. The report queries a group of workstations, determines what version of java is installed and presents that in a bar chart with totals for each version. Currently, there are 3...

GMFDE by Engaged Sweeper III
  • 7783 Views
  • 5 replies
  • 1 kudos

Helpdesk report request

Hi folks,My SQL is still rubbish. I have tried to work this out combining aspects from other reports, but I am getting nowhere.I need a helpdesk report that shows time worked per ticket type in the last 7 days.Sorted by:1. Ticket Type2. Time Worked3...

Resolved! tblAssets.AssetName: how to add multiple asset names

What is the proper syntax for this operation? I have tried the following:Where tblAssets.AssetName = In ('asset name 1', 'asset name 2', 'asset name 3', 'asset name 4', 'asset name 5')orWhere tblAssets.AssetName = In "'asset name 1, 'asset name 2'I h...

GMFDE by Engaged Sweeper III
  • 3960 Views
  • 1 replies
  • 0 kudos

Warranty report missing computers

I am running the following report, however, I am missing computers, the built in Asset report detects it, I think the common denominator is no user logged onSelect Top 1000000 tsysOS.Image As icon, tblAssetCustom.AssetID, tblAssets.AssetName, tblA...

miek_g by Engaged Sweeper III
  • 2639 Views
  • 1 replies
  • 0 kudos

How to report latest eventlog message only

Hi guys, struggling with this one. I'm putting together a report for Windows 10 Feature Updates and I want to pull the last feature update error event log only. Can anyone help? This is my report:Select Top 1000000 tsysOS.Image As icon, tblAssets.As...

heybobby1 by Engaged Sweeper III
  • 8598 Views
  • 8 replies
  • 1 kudos

NOT installed report

Hi all, any help appreciated. I am looking to run a report to find any device that DOES NOT have a particular version of software installed - Software is: Check Point Endpoint Security: Version 80.82.4063... I would like the below fields incl...

kmoc by Engaged Sweeper
  • 2365 Views
  • 1 replies
  • 0 kudos

Resolved! ReportBuilder - can not edit or create reports

I have problem with create/edit reports in Report Builder. The reports work fine with presenting the result, but when I want to edit a report the Report Builder doesn't show anything. The same if I want to create a new report. See the image below.I h...