Use cases for filtering reports by using property values

You can filter report data in TrueSight Smart Reporting - Platform by using the property values on objects in TrueSight Server Automation. 

Example 1

Consider that an Inventory report lists all the servers that are used in all the environments in your organization. You want a list of all the Windows servers used in the production environment. 

To achieve this, you must create Environment and OS Name filters. Do the following:

1. In TrueSight Server Automation, create a server property. Do the following:
   
   1. In the Name field, enter Environment.
   2. In the Type section, select the Simple option.
   3. From the list of available types, select String enumeration.
   4. In the Possible values field, add the following values:
      
      • Demo
      • QA
      • Production
        
   5. Select the Required and Used in reports check boxes.
   6. Click OK.
2. Run the ETL process.
3. In TrueSight Smart Reporting - Platform, open the Inventory Summary by OS report.
4. Edit the report.
5. Search and drag the Environment property to the Columns field and Filters section.
6. Search and drag the OS Name field to the Filters section.
7. Publish and save the report.

Example 2

Consider that a Job Details report lists all the jobs that are executed in your environment. You want a list of all the jobs that are executed on all the Windows 2016 and RHEL 7 servers used in your environment.

To achieve this, you must create smart groups for the operating systems and Target_Server_Smart_Groups filter. Do the following:

1. In TrueSight Server Automation, create Windows 2016 and  RHEL 7 smart groups.

2. In TrueSight Server Automation, create a job property. Do the following:
   
   1. In the Name field, enter Target_Server_Smart_Groups.
   2. In the Type section, select the Simple option.
   3. From the list of available types, select String enumeration.
   4. In the Possible values field, add the following values:
      
      • Windows 2016
      •  RHEL 7
   5. Select the Required and Used in reports check boxes.
   6. Click OK.
3. Run the ETL process.
4. In TrueSight Smart Reporting - Platform, open the Job Details report.
5. Edit the report.
6. Search and drag the Target_Server_Smart_Groups property to the Columns field and Filters section.

7. Publish and save the report.