In the Device Context page, in the Details page, in the Groups Membership list, the bottom shows the message:
Where XX is the total number of Groups the given device is a member of.
Group Membership list in the Details Context page is limited to 10 groups.
All supported Performance Management releases
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:
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.
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)
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.