Querying the Threshold Tables for Threshold Configurations
| Task | Command | Example |
|---|---|---|
|
Retrieving the threshold configuration of a particular test |
egdbcli -managerid <ManagerID> -test <TestName> -type Threshold |
egdbcli -managerid mid -test Disk Space -type Threshold
|
|
Retrieving the threshold configuration of a particular test for specific components |
egdbcli -managerid <ManagerID> -host <Comma-separated list of IP/Nick names of components> -test <TestName> -type Threshold |
egdbcli -managerid mid -test DiskActvity -host ora1,sql28 -type Threshold |
|
Retrieving the threshold configuration of specific measures reported by particular test for specific components |
egdbcli -managerid <ManagerID> -host <Comma-separated list of IP/Nick names of components> -test <TestName> -measures <Comma-separated list of measure display names in double quotes> -type Threshold |
egdbcli -managerid mid -test DiskActvity -host ora1,sql28 --measures "Disk busy,Disk read rate" -type Threshold |
|
Retrieving the threshold configuration of a single descriptor for specific measures reported by a particular test for specific components |
egdbcli -managerid <ManagerID> -host <Comma-separated list of IP/Nick names of components> -test <TestName> -measures <Comma-separated list of measure display names in double quotes> -info <Descriptor name> -type Threshold |
egdbcli -managerid mid -host ora1,sql28 -test DiskActivity - measures "Disk busy,Disk read rate" -info C -type Threshold |
|
Retrieving the threshold details of multiple descriptors supported by a test |
egdbcli -managerid <ManagerID> -test <TestName> -info <Comma-separated list of descriptors> -type Threshold |
egdbcli -managerid mid -test DiskActivity -info C,D -type Trend |
|
Retrieving the threshold configuration of a non-info-based test associated with an Oracle database server with multiple SIDs |
egdbcli -managerid <ManagerID> -test <TestName> -host <IP/Nick name of Oracle server> -port <Port number of Oracle server> -info <Comma-separated list of SIDs, with each SID suffixed by a + sign> -type Threshold |
egdbcli -managerid mid -test MemoryDetails -host ora12 -port 1521 -info egurkha+,egdemo+ -type Threshold
|
|
Retrieving the threshold configuration of an info-based test associated with an Oracle database server with multiple SIDs |
egdbcli -managerid <ManagerID> -test <TestName> -host <IP/Nick name of Oracle server> -port <Port number of Oracle server> -info <Comma-separated list of SID-Info pairs, where each pair is of the format sid+info> -type Threshold |
egdbcli -managerid mid -test DiskActivity -host ora12 -port 1521 -info egurkha+C,egurkha+D,egdemo+C,egdemo+D -type Threshold |
|
Retrieving the threshold configuration of a test mapped to all components in a segment |
egdbcli -managerid <ManagerID> -test <TestName> -segment <SegmentName> -type Threshold |
egdbcli -managerid md86 -test DiskSpace -segment seg1 -type Threshold |
|
Retrieving the threshold configuration of a test mapped to a single component in a segment |
egdbcli -managerid <ManagerID> -test <TestName> -segment <SegmentName> -host <IP/Nick name of host> -port <PortNumber> -type Threshold |
egdbcli -managerid md86 -test DiskSpace -segment seg1 -host web98 -port 80 -type Threshold |
|
Retrieving the threshold configuration of a test mapped to specific components in a segment |
egdbcli -managerid <ManagerID> -test <TestName> -segment <SegmentName> -host <Comma-separated list of IP addresses/Nick names of hosts> -type Threshold |
egdbcli -managerid md86 -test DiskSpace -segment seg1 -host web98,wl80 -type Threshold |
|
Retrieving the threshold configuration of a test mapped to all components in a service |
egdbcli -managerid <ManagerID> -test <TestName> -service <ServiceName> -type Threshold |
egdbcli -managerid md86 -test DiskSpace -service ser1 -type Threshold |
|
Retrieving the threshold configuration of a test that is mapped to the components in a segment that are associated with a service |
egdbcli -managerid <ManagerID> -test <TestName> -segment <SegmentName> -service <ServiceName> -type Threshold |
egdbcli -managerid md86 -test DiskSpace -service ser1 -segment seg1 -type Threshold |
|
Retrieving the threshold configuration of a test mapped to a specific component in a service |
egdbcli -managerid <ManagerID> -test <TestName> -service <ServiceName> -host <IP/Nick name of component> -port <PortNumber> -type Threshold |
egdbcli -managerid md86 -test DiskSpace -service ser1 -host ad23 -port 389 -type Threshold |
|
Retrieving the threshold configuration of a test mapped to specific hosts in a service |
egdbcli -managerid <ManagerID> -test <TestName> -service <ServiceName> -host <Comma-separated list of IP addresses/Nick names of components> -type Threshold |
egdbcli -managerid md86 -test DiskSpace -segment seg1 -host ad123,wl98 -type Threshold |
|
Retrieving the threshold configuration of a specific test for components with nick names that match a specified set of search patterns |
egdbcli -managerid <ManagerID> -test <TestName> -searchhost "<Comma-separated list of search patterns>" -type Threshold |
egdbcli -managerid md86 -test DiskSpace -searchhost "*i*,win*,*ora*" -type Threshold |
|
Retrieving the threshold configuration of a specific test with descriptors that match a specified set of search patterns |
egdbcli -managerid <ManagerID> -test <TestName> -searchinfo "<Comma-separated list of search patterns>" -type Threshold |
egdbcli -managerid md86 -test DiskSpace -searchinfo "*C*,E" -type Threshold |
|
Retrieving the threshold configuration of a specific test mapped to a particular component with descriptors that match a specified set of search patterns |
egdbcli -managerid <ManagerID> -test <TestName> -host <IP/Nickname of component> -port <PortNumber> -searchinfo "<Comma-separated list of search patterns>" -type Threshold |
egdbcli -managerid md86 -test DiskSpace -host exch -port 25 -searchinfo "*C*,E" -type Threshold |
|
Retrieving the threshold configuration of a particular test across components, and grouping the result set by a specific column in the threshold table |
egdbcli -managerid <ManagerID> -test <TestName> -type Threshold -groupby <ColumnName> |
egdbcli -managerid md86 -test network -type Threshold -groupby trgt_host |
|
Retrieving the threshold configuration of a particular test across components, and sorting the result set in the ascending/descending order of the contents of a particular column in the threshold table |
egdbcli -managerid <ManagerID> -test <TestName> -type Threshold -orderby <ColumnName> |
egdbcli -managerid md86 -test network -type Threshold -orderby desc |
|
Requesting help with syntax while issuing commands for retrieving data from threshold tables |
egdbcli Help Thresholdparameters |
|
Note:
- In the command, make sure that you use the correct names of tests and measures; however, note that the test names, measure names, parameter names, and parameter values used in the command are case-insensitive.
- While you can use either internal test names or the display names that are assigned to them in the command, internal measure names cannot be used in the command - the command should include only the display names that map to the internal measure names.
- By default, the date format setting of the eG database applies to all date inputs provided in the command - i.e., the values for the -startDate and -endDate command parameters should be of the date format that applies to the eG database.
-
While issuing a command, if the values you provide for one/more command parameters embed white spaces, then such values should be enclosed within double-quotes. For instance, to retrieve the last recorded value of the measure Packet loss from the database, your command specification should be as follows:
egdbcli -managerid mid -test Network -measures "Packet loss"
