get group

Returns a result set that contains either a list of the groups and a roll-up status for each group, or status of each server in a group and a roll-up status for the specified group. Roll-up status shows the lowest status reported; for example, if any server in a group is not UP, then the group status is reported as “SUSPECT”.

Syntax

get group [group_name]

Parameters

group_name – Specifies the name of the group for which to retrieve the list of servers.

Examples

Example 1 – Returns a list of the groups names, and a roll-up status for each group:

get group

Group Name  State       State     Description               More        
            Constant                                        Descriptions
----------  --------    -------   ------------------------  ------------
group1      4           Suspect   inventory_rs1 is Suspect  False

Example 2 – Returns the status of each list of server names that the group “inventory_mra” contains and a roll-up status for the group:

get group inventory_mra

Group Name     Server Name  Server Type         Last Monitored            
-------------  -----------  ------------------  --------------------      
inventory_mra  RAObeta      Replication Agent    12/16/2005 13:38:30      

Version String
--------------------------------------------------------------------------
Sybase Replication Agent for Unix & Windows/12.6.0.5001/B/generic/
JDK 1.4.2/main/5001/VM: Sun Microsystems Inc. 1.4.2_05/OPT/Wed May  4
02:42:07 MDT 2005

State Constant  State   Description                    More Descriptions
--------------  ------  -----------------------------  -------------------
6                Admin    Waiting for operator command.    false

Usage

If you do not provide a group_name parameter, get group returns a result set that contains a roll-up status for each group:

Column Descriptions for get group (Group List, and Roll-Up for Each Group)
Column	Description
`Group Name`	The name of the group.
`State Constant`	The integer constant that defines the state of the group.
`State`	The description that defines the state of the group. This is a string representation of the State Constant column.
`Description`	The reason string that describes the state of the group. If there is more than one description, this field should contain the first description.
`More Descriptions`	A flag that indicates whether there is more than one description string that describes the status of the group.

If you provide a group_name parameter, get group returns a result set that contains the status of each server:

Column Descriptions for get group (Individual Server, and Roll-Up for Specified Group)
Column	Description
`Group Name`	The name of the group.
`Server Name`	The name of the server.
`Server Type`	The type of the server (Replication Server, Adaptive Server Enterprise, Replication Agent, and so on).
`Last Monitored`	A timestamp indicating that last time the server was monitored by the RMS. The timestamp is in the format `MM/DD/YYYY HH:MM:SS`.
`Version String`	Returns the server version string.
`State Constant`	The numeric status of the server.
`State`	The description that defines the state of the server. This is a string representation of the state constant.
`Description`	The reason string that describes the state of the server.
`More Descriptions`	Indicates whether additional information is available. If true, then the status of the server contains multiple descriptions. Use get status descriptions to retrieve a list of all descriptions for the server.