Reporting on Group property attributes

You can define the user-defined properties for Groups such as properties like vendor name, vendor or equipment type, location or speed to be displayed in a Group Summary Report.

1. Install the DBI module, which is needed to run the Perl script, on your Oracle or DB2 database.
   1. Download and install DBD-DB2-1.85.tar.gz and configure Perl environment to access data in DB2. See DB2 Perl Database.
   2. Download and install DBD-Oracle-1.75.tar.gz.
      1. Copy and extract DBD-Oracle-1.75.tar.gz into /tmp of the target server.
         Note: Make sure to source /opt/oracle/.profile. The ORACLE_HOME and LD_LIBRARY environment variables needs to be set as the Perl scripts refers to these variables.
      2. Run the following command: $ perl Makefile.PL
      3. Run the following commands to perform the test and install DBD Oracle:

             
         $ make
         $ make test
         $ make install

2. Log in to SQL Plus and run the scripts pvm_global.pks and pvm_global.pkb by using the following commands:

   
   bash-4.1$ sqlplus "pv_admin/PV@PV"
   
   SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 12 10:13:24 2016
   
   Copyright (c) 1982, 2014, Oracle.  All rights reserved.
   
   Last Successful login time: Tue Apr 12 2016 10:12:03 +05:30
   
   Connected to:
   Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
   With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
   
   SQL> @pvm_global.pks
   
   Package created.
   
   SQL> @pvm_global.pkb
   
   Package body created.
   
   
   SQL> exit
   Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
   With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
   

3. Run the following command to create a group property by using resmgr.
   Note: Make sure that you decide on the property name and data type. Once the properties are added, it will not be easy to delete from database.
   For example:

   
   # cd /opt/datamart/
   # source dataMart.env 
   # resmgr -import propertySE -colNames "name dataType defValue comment" -sep "|" -line "TestGSTProperty|string|none|property added for test of Group Properties|"
   Info : === insert : INSERT ON property ( TestGSTProperty ) (does not exist)
   

4. From an editor, create a file, segrp_properties, and add the following properties:
   • Group name
   • Subelement property name
   • Value

   The following example shows segrp_properties file with the required properties:

   
   Group Path|Property Name|Property Value 
   #~NOC Reporting| TestGSTProperty |avaya123
   #~NOC Reporting| TestGSTProperty |avaya123
   ~NOC Reporting| TestGSTProperty |lucent34
   ~NOC Reporting~Devices~Interfaces~10.200.17.84| TestGSTProperty |pune1
   #~NOC Reporting~Devices~Interfaces~tnpmsun1.persistent.co.in| TestGSTProperty |juniper1

   Note: Lines starting with # are commented.
5. Save the segrp_properties file.
6. Run the following commands.
   

   1. Source oracle environment variables by using the following command: . .profile.oracle
   2. Run ./upd_grp_prop.pl –f segrp_properties file -d oracle

   

   1. Source DB2 environment variables by using the following command: . .profile.db2
   2. Run ./upd_grp_prop.pl –f segrp_properties file -d db2
   Note: Updating the segrp_properties file and running upd_grp_prop.pl with proper parameters is the only way to update group properties.

   Important: It is best practice to maintain and backup segrp_properties file periodically. Keep this backup file in a separate folder for reference purposes and make sure that this backup folder is secured.
7. Add the newly created property to the reporter.
   1. From DV Navigator in Dashboard Application Services Hub, create a Group Summary Reporter or Resource Summary reporter.
      Note: For existing reporters, open the DV Navigator, select the reporter and click Sync.
   2. Choose the newly created property.

      For example, the newly created property is TestGSTProperty (created from step 5 - 7).

   3. Click Save and Sync the reporter.
   4. Open the reporter and verify that the Group property is available.

      The Group property is listed under GroupSummaryMediator option.

8. Verify the report in the Dashboard Application Services Hub portal.

   The property field is displayed in the report.