Device based Group Membership list in Performance Management
Article ID: 142152
Updated On:
Products
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.
Feedback
