Report on Filters Created by Using the Query Builder

Products

• Client Management Suite

Issue/Introduction

There are filters created by technicians in certain roles using the query builder, and a report is needed to identify what filters exist and who created them.

Environment

ITMS 8.x

Cause

If not careful, query builder-based filters can target undesired computer resources.

Resolution

Note: This query is provided as is as an example only, as support does not create custom queries. This query is an example to show options for creating custom reports to meet certain needs not built into the platform.

To create a custom report, navigate to Reports > All Reports. Choose or create a folder to house this report (right-click a location > New > Folder). Right-click the folder and select New > Report > Base Report. Give the report a name and then choose SQL report in the Report type drop-down. Click Create. 

In the new report, click the Edit button in the upper right (or right-click the report name in the left pane and select edit)

In the Parameterized Query tab (opens by default), replace the existing code (this is used for scoping reports and will not be covered here) with this SQL code:

select  i.name as 'Filter',  i.ModifiedBy,  i.ModifiedDate,  i.CreatedBy,  i.CreatedDate

from item i

where state like '%dataSource typeGuid="a8d23c9d-61ec-4e9e-a148-3175a2416f88"%' and i.Attributes = 0

order by i.name

Click Save Changes.