Get group information

(imported topic written by cm6591)

Let us say I create 2 groups in BES Console - each with three machines in it. How can I get this information from an application running on the BES Console machine? If I integrate this application with DB API, what sql query will I use to get the group name and the machine IPs belonging to this group.

Thanks