Concord/Sqlplus: Difference between revisions

Help

Content added Content deleted

Inline

Revision as of 06:33, 13 January 2005

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]

Revision as of 06:33, 13 January 2005

Recent changes