Concord/Sqlplus

you can use sql to access Concord's database 

first use the "sqlplus" command to open the SQL commandline

then you can use the DESCRIBE command to find detales about tables eg:

• SQL>  DESCRIBE NH_GROUP;

Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
GROUP_ID                                  NOT NULL NUMBER(11)
GROUP_TYPE                                NOT NULL NUMBER(11)
MACHINE_ID                                NOT NULL NUMBER(11)
CREATE_TIME                               NOT NULL NUMBER(11)
MODIFY_TIME                               NOT NULL NUMBER(11)
NAME                                      NOT NULL VARCHAR2(64)
CONTAINER_TYPE                            NOT NULL NUMBER(11)

EXPIRE_TIME NOT NULL NUMBER(11)

next to list the group names and there id numbers from the NH_GROUP table:

• SQL> SELECT NAME,GROUP_ID from NH_GROUP

groupName1      00001

groupName2 00002