get group

Description

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:

**Table 9-15: 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:

**Table 9-16: 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.