< Concord
Content added Content deleted
imported>mutante m (despam) |
imported>mutante mNo edit summary |
||
(7 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
you can use sql to access Concord's database |
|||
first use the "sqlplus" command to open the SQL commandline interface |
|||
<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> |
SQL> |
||
</pre> |
</pre> |
||
you can use the DESCRIBE command to find detales about tables eg: |
|||
<pre>SQL> DESCRIBE NH_GROUP; |
|||
Name Null? Type |
Name Null? Type |
||
----------------------------------------- -------- ---------------------------- |
----------------------------------------- -------- ---------------------------- |
||
Line 24: | Line 24: | ||
EXPIRE_TIME NOT NULL NUMBER(11)</pre> |
EXPIRE_TIME NOT NULL NUMBER(11)</pre> |
||
<pre>SQL> DESCRIBE NH_ELEMENT; |
|||
Name Null? Type |
Name Null? Type |
||
----------------------------------------- -------- ---------------------------- |
----------------------------------------- -------- ---------------------------- |
||
Line 86: | Line 86: | ||
ie. to list the group names and there id numbers from the NH_GROUP table: |
ie. to list the group names and there id numbers from the NH_GROUP table: |
||
<pre>SQL> SELECT NAME,GROUP_ID from NH_GROUP |
|||
groupName1 00001 |
groupName1 00001 |
||
groupName2 00002</pre> |
groupName2 00002</pre> |
||
to list all elements with X ip address |
to list all elements with X ip address |
||
<pre>SQL> SELECT NAME from NH_ELEMENT where IP_ADDRESS='x.x.x.x'; |
|||
NAME |
NAME |
||
Line 109: | Line 109: | ||
this is a cool link about, [[http://www.stormloader.com/yonghuang/computer/OracleAndPerl.html OracleAndPerl]] |
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]