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

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
  • 4393 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
  • 3006 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
  • 9913 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
  • 2633 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...

Resolved! Report: Not Encrypted

I am new to this but I can't seem to find a way to do this.Wondering if there is a way to add a column showing whether or not an asset has a TPM chip?I also need to add the OS column but I think I can get that.Thanks!Select Top 1000000 tsysAssetTypes...

MHScripts by • Engaged Sweeper II
  • 5686 Views
  • 3 replies
  • 0 kudos