Is it possible to change the column headers in a filter

Products

• Client Management Suite
• IT Management Suite

Issue/Introduction

You are using a custom SQL filter query and would like to have the column headers reflected according to your SQL query.  When you run this query in SQL it looks correct, however, in the SMP Console, it's missing the custom column headers.

Environment

Release: 8.6

Cause

This is working as designed.  Filters should only be set up to return a GUID from any query.  That GUID should be the computers that are a result of that query.  Nothing else should be included.  If you want to see the custom column, from your query, create a report.

Resolution

Create a report with your SQL query instead of a filter.