Device based Group Membership list in Performance Management

Article Id: 142152
Status: Published
Updated On: 19-12-2019 15:22
Products:
CA Infrastructure Management , CA Performance Management - Usage and Administration , CA Performance Management - Data Polling , DX NetOps
Issue/Introduction:

In the Device Context page, in the Details page, in the Groups Membership list, the bottom shows the message:

  • Group list truncated. Displaying 10 of XX.

Where XX is the total number of Groups the given device is a member of.

Cause:

Group Membership list in the Details Context page is limited to 10 groups.

Environment:

All supported Performance Management releases

Resolution:

Bring up the Context page for the target device. The URL for the page in the browser will show the Performance Center data base ItemID for the device in "DeviceID=<ID>". For example in a lab test I have the URL:

Here the ID for the device is DeviceID=334.

Take the ID and log into the Performance Center web server. Go to (default path) /opt/CA/MySql/bin. Log into mysql using:

  • ./mysql -uroot -p netqosportal

When prompted enter the password to enter the mysql prompt.

Run the following query replacing <DeviceID> with the device ID from the URL found above.

  • select tg.itemid,tg.itemname from t_group tg inner join item_members im on tg.itemid=im.parentid where childid = <DeviceID>;

Sample output might look like the following from a lab test:

mysql> select tg.itemid,tg.itemname from t_group tg inner join item_members im on tg.itemid=im.parentid where childid = 334;
+--------+--------------------------+
| itemid | itemname                 |
+--------+--------------------------+
|      7 | Default Domain           |
|     32 | NULL                     |
|    113 | All Spectrum Devices     |
|    116 | HostName(0x1000000) |
|    574 | Servers                  |
|   1047 | TestGroup1               |
|   1049 | TestGroup2               |
|   1050 | TestGroup3               |
|   1051 | TestGroup4               |
|   1052 | TestGroup5               |
|   1053 | TestGroup6               |
|   1055 | TestGroup7               |
|   1056 | TestGroup8               |
|   1058 | TestGroup9               |
|   1060 | TestGroup10              |
|   1061 | TestGroup11              |
|   1062 | TestGroup12              |
+--------+--------------------------+
17 rows in set (0.01 sec)

Additional Information:

This is the only method for obtaining full Group membership listings for a given device. To request a change to this please submit an Enhancement Request. These are submitted via Idea posts submitted to the DxNetOps Community site which includes the Performance Management product.