< Concord
Content added Content deleted
imported>DrOwl (some basic sql commands for Concord) |
imported>mutante mNo edit summary |
||
(15 intermediate revisions by 4 users not shown) | |||
Line 1:
<pre> host# sqlplus user/pass </pre>
you can turn off the table headers (this is usefull if you are scripting)<br>
increase the number of pages / lines in each page.
<pre>SQL>SQL> set pages 100 lines 1000 head off
SQL>
</pre>
Name Null? Type
----------------------------------------- -------- ----------------------------
Line 17 ⟶ 24:
EXPIRE_TIME NOT NULL NUMBER(11)</pre>
<pre>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)
</pre>
you can use the SELECT command to list detale about elements in a table
groupName1 00001
groupName2 00002</pre>
to list all elements with X ip address
<pre>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.
</pre>
this is a cool link about, [[http://www.stormloader.com/yonghuang/computer/OracleAndPerl.html OracleAndPerl]]
[[Concord|Back to Concord Index]]
[[Category:Concord]]
[[Category:Computer]]
[[Category:English]]
|
Latest revision as of 09:19, 10 September 2006
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]