×
Create a new article
Write your page title here:
We currently have 3,189 articles on s23. Type your article name above or create one of the articles listed here!



    s23
    3,189Articles

    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]

    Back to Concord Index

    Cookies help us deliver our services. By using our services, you agree to our use of cookies.
    Cookies help us deliver our services. By using our services, you agree to our use of cookies.