Concord/Sqlplus

you can use sql to access Concord's database

first use the "sqlplus" command to open the SQL commandline interface you can turn off the table headers (this is usefull if you are scripting) increase the number of pages / lines in each page. SQL>
 * host# sqlplus user/pass
 * SQL>SQL> set pages 100 lines 1000 head off

you can use the DESCRIBE command to find detales about tables eg: 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)
 * SQL> DESCRIBE NH_GROUP;

Name                                     Null? Type -  ELEMENT_ID                                NOT NULL NUMBER(11) MACHINE_ID                                        NUMBER(11) NAME                                     NOT NULL VARCHAR2(64) NAME_LOWERCASE                           NOT NULL VARCHAR2(64) ALIAS                                             VARCHAR2(64) ALIAS_LOWERCASE                                   VARCHAR2(64) IP_ADDRESS                                        VARCHAR2(21) IF_IP_ADDRESS                                     CHAR(15) MTF_NAME                                          VARCHAR2(64) ELEMENT_TYPE                             NOT NULL NUMBER(11) LATENCY_PARTNER                                   VARCHAR2(64) LATENCY_SOURCE                                    NUMBER(11) INDEX1                                            NUMBER(11) INDEX2                                            VARCHAR2(256) INDEX3                                            VARCHAR2(256) INDEX4                                            VARCHAR2(256) SPEED                                             NUMBER(38,7) SPEED1                                            NUMBER(38,7) DEVICE_SPEED                                      NUMBER(38,7) DEVICE_SPEED2                                     NUMBER(38,7) RESPONSE_LIMIT                                    NUMBER(11) POLL_RATE                                         NUMBER(11) POLL_TIMEOUT                                      NUMBER(11) POLL_RETRIES                                      NUMBER(11) COMMUNITY_STRING                                  VARCHAR2(64) READ_COMMUNITY                                    VARCHAR2(64) STORE_IN_DB                                       NUMBER(1) CISCO_PING                                        NUMBER(1) REMOTELY_POLLED                                   NUMBER(1) MONITOR_LE                                        NUMBER(1) FULL_DUPLEX                                       NUMBER(1) INC_IN_LW_RPTS                                    NUMBER(1) HOSTNAME                                          VARCHAR2(64) SYS_NAME                                          VARCHAR2(64) SYS_DESCR                                         VARCHAR2(256) DISCOVER_KEY                                      VARCHAR2(128) VIRTUAL_ID                                        VARCHAR2(32) UNIQUE_DEV_ID                                     VARCHAR2(128) NMS_KEY                                           VARCHAR2(128) NMS_STATE                                         NUMBER(11) IF_PHYS_ADDRESS                                   CHAR(17) DEVICE_HASH_KEY                                   VARCHAR2(16) ELEM_TIMEZONE                                     VARCHAR2(20) APP_TYPE                                          NUMBER(11) APP_KEY                                           VARCHAR2(64) CLIENT_ACCESS                                     NUMBER(11) CAPTION                                           VARCHAR2(64) USER_STRING                                       VARCHAR2(256) IMPORT_MODULE_NAME                                VARCHAR2(10) IMPORT_NMS_HOST                                   VARCHAR2(64) CREATE_TIME                              NOT NULL NUMBER(11) MODIFY_TIME                                       NUMBER(11)
 * SQL> DESCRIBE NH_ELEMENT;

you can use the SELECT command to list detale about elements in a table

ie. to list the group names and there id numbers from the NH_GROUP table: groupName1     00001 groupName2     00002
 * SQL> SELECT NAME,GROUP_ID from NH_GROUP

to list all elements with X ip address
 * SQL> SELECT NAME from NH_ELEMENT where IP_ADDRESS='x.x.x.x';

NAME

router-001-Serial0/0-dlci-1 router-001-Serial0/0-dlci-2 router-001-RH-Cpu-1 router-001-RH-Serial0/0 router-001-RH-Serial0/1 router-001-RH-Ethernet0/0 router-001-RH-Ethernet0/1 router-001-RH

8 rows selected.

this is a cool link about, [OracleAndPerl]