< Concord
Revision as of 18:33, 11 January 2005 by imported>DrOwl
you can use sql to access Concord's database
first use the "sqlplus" command to open the SQL commandline interface
host# sqlplus user/pass
you can turn off the table headers (this is usefull if you are scripting)
increase the number of pages / lines in each page.
SQL>SQL> set pages 100 lines 1000 head off
SQL>
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)
SQL> DESCRIBE NH_ELEMENT;
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)
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:
SQL> SELECT NAME,GROUP_ID from NH_GROUP
groupName1 00001
groupName2 00002
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]