Querying the Test Tables for Performance Statistics
| Task | Command |
Example |
|---|---|---|
|
Retrieving statistics collected by a particular test from across all the managed components in the environment |
egdbcli -managerid <ManagerID> -test <TestName> |
egdbcli -managerid mid -test DiskSpace |
|
Retrieving statistics collected by a particular test from specific hosts |
egdbcli -managerid <ManagerID> -test <TestName> -host <Comma-separated list of hosts> |
egdbcli -managerid mid -test DiskSpace -host gen10,sun01
|
|
Retrieving statistics collected by a particular test from a specific application |
egdbcli -managerid <ManagerID> -test <TestName> -host <IP/Nickname of application> -port <Port number of application> |
egdbcli -managerid mid -test SystemDetails -host mssql7 -port 1433 |
|
Retrieving only the last measure values reported by a test for a specific application |
egdbcli -managerid <ManagerID> -test <TestName> -host <IP/Nickname of application> -port <Port number of application> -lastmeasure <True/False> |
egdbcli -managerid mid -test MsSqlProcesses -host mssql7 -port 1433 -lastmeasure true |
|
Retrieving the performance data reported by a test during a specific time period |
egdbcli -managerid <ManagerID> -test <TestName> -startDate "<StartDate/Time>" -endDate "<EndDate/Time>" |
egdbcli -managerid mid -test DiskActivity -startDate "2010-05-14 23:49:29.0" -endDate "2010-05-15 05:41:12.0" |
|
Retrieving the performance data reported by a test in a desired date format |
egdbcli -managerid <ManagerID> -test <TestName> -dateformat "<DateFormat>" |
egdbcli -managerid mid -test DiskActivity -dateformat "dd-MM-yyyy" |
|
Retrieving the last measure values for specific measures reported by a test |
egdbcli -managerid <ManagerID> -test <TestName> -lastmeasure <True/False> -measures <Comma-separated list of measure column numbers> |
egdbcli -managerid mid -test DiskActivity -lastmeasure true -measures 1,2 OR egdbcli -managerid mid -test Network -lastmeasure true -measures "Avg network delay,Min network delay" |
|
Retrieving the performance data reported by a test and storing the data to a new file of a specific format |
egdbcli -managerid <ManagerID> -test <TestName> -format <csv/txt/xml> -filename <Full path to the file> |
egdbcli -managerid mid -test DiskActivity -format csv -filename c:\diskact |
|
Retrieving the performance data reported by a test and storing the data to a file that pre-exists by overwriting that file |
egdbcli -managerid <ManagerID> -test <TestName> -format <csv/txt/xml> -filename <Full path to the file> -append false |
egdbcli -managerid mid -test DiskActivity -format csv -filename c:\diskact -append false |
|
Retrieving the performance data reported by a test and storing the data to a file that pre-exists by appending the new data to that file |
egdbcli -managerid <ManagerID> -test <TestName> -format <csv/txt/xml> -filename <Full path to the file> -append true |
egdbcli -managerid mid -test DiskActivity -format csv -filename c:\diskact -append true |
|
Retrieving the performance data for specific descriptors supported by a test |
egdbcli -managerid <ManagerID> -test <TestName> -info <Descriptor> |
egdbcli -managerid mid -test DiskActivity -info C,D |
|
Retrieving the performance data collected by a particular measurement host |
egdbcli -managerid <ManagerID> -test <TestName> -msmthost <Measurement host> |
egdbcli -managerid mid -test Network -msmt 192.168.10.8 |
|
Retrieving the performance data pertaining to a specific web site |
egdbcli -managerid <ManagerID> -test <TestName> -site <Sitename> |
egdbcli -managerid mid -test WebTransactions -site www.egi.com |
|
Retrieving the performance data pertaining to specific hosts associated with a web site |
egdbcli -managerid <ManagerID> -test <TestName> -site <Sitename> -host <Comma-separated list of hosts> |
egdbcli -managerid mid -test DiskSpace -site www.egi.com -host web7,ora9 |
|
Retrieving the performance data reported by 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> |
egdbcli -managerid mid -test MemoryDetails -host ora12 -port 1521 -info egurkha+,egdemo+
|
|
Retrieving the performance data reported by 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> |
egdbcli -managerid mid -test DiskActivity -host ora12 -port 1521 -info egurkha+C,egurkha+D,egdemo+C,egdemo+D
|
|
Retrieving the detailed diagnosis associated with all the measures of a particular test |
egdbcli -managerid <ManagerID> -test <TestName> -type dd |
egdbcli -managerid md86 -test SystemDetails -type dd |
|
Retrieving the detailed diagnosis associated with all the measures of a particular test for a particular component |
egdbcli -managerid <ManagerID> -test <TestName> -host <IP/Nick name of component> -port <PortNumber> -type dd |
egdbcli -managerid md86 -test SystemDetails -host gen34 -type dd (this is a non-port-based component; hence the -port parameter has been omitted) |
|
Retrieving the detailed diagnosis related to a particular measure of a particular test for a specific component |
egdbcli -managerid <ManagerID> -test <TestName> -measure "<MeasureDisplayName>" -host <IP/Nick name of component> -type dd OR egdbcli -managerid <ManagerID> -test <TestName> -measure <Measure column number> -host <IP/Nick name of component> -type dd |
egdbcli -managerid md86 -test SystemDetails -measure "Free memory" -host gen34 -type dd (this is a non-port-based component; hence the -port parameter has been omitted) OR egdbcli -managerid md86 -test SystemDetails -measure 11 -host gen34 -type dd (this is a non-port-based component; hence the -port parameter has been omitted) |
|
Retrieving the last measurement values of a test mapped to all components in a segment |
egdbcli -managerid <ManagerID> -test <TestName> -segment <SegmentName> -lastmeasure <true/false> |
egdbcli -managerid md86 -test DiskSpace -segment seg1 -lastmeasure true |
|
Retrieving the last measurement values of a test mapped to all components in a service |
egdbcli -managerid <ManagerID> -test <TestName> -service <ServiceName> -lastmeasure <true/false> |
egdbcli -managerid md86 -test DiskSpace -service ser1 -lastmeasure true |
|
Retrieving the last measurement values 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> -lastmeasure <true/false> |
egdbcli -managerid md86 -test DiskSpace -service ser1 -segment seg1 -lastmeasure true |
|
Retrieving the last measurement values 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> -lastmeasure <true/false> |
egdbcli -managerid md86 -test DiskSpace -service ser1 -host ad23 -port 389 -lastmeasure true |
|
Retrieving the last measurement values of a test mapped to a specific component in a segment |
egdbcli -managerid <ManagerID> -test <TestName> -segment <SegmentName> -host <IP/Nick name of component> -port <PortNumber> -lastmeasure <true/false> |
egdbcli -managerid md86 -test DiskSpace -segment seg1 -host ad123 -port 389 -lastmeasure true |
|
Retrieving the last measurement values 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>" -lastmeasure <true/false> |
egdbcli -managerid md86 -test DiskSpace -searchhost "*i*,win*,*ora*" -lastmeasure true |
|
Retrieving the last measurement values 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>" -lastmeasure <true/false> |
egdbcli -managerid md86 -test DiskSpace -searchinfo "*C*,E" -lastmeasure true |
|
Retrieving the last measurement values 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>" -lastmeasure <true/false> |
egdbcli -managerid md86 -test DiskSpace -host exch -port 25 -searchinfo "*C*,E" -lastmeasure true |
|
Retrieving the last measurement values of a particular test across components, and grouping the result set by a specific column in the test table |
egdbcli -managerid <ManagerID> -test <TestName> -lastmeasure <true/false> -groupby <ColumnName> |
egdbcli -managerid md86 -test network -lastmeasure true -groupby trgt_host |
|
Retrieving the last measurement values 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 test table |
egdbcli -managerid <ManagerID> -test <TestName> -lastmeasure <true/false> -orderby <ColumnName> |
egdbcli -managerid md86 -test network -lastmeasure true -orderby desc |
|
Retrieving the detailed diagnosis (DD) of a test, and grouping the DD result by a specific column in the DD |
egdbcli -managerid <ManagerID> -test <TestName> -type dd -groupby <ColumnName> |
egdbcli -managerid md86 -test "System - Guest" -type dd -groupby trgt_host |
|
Retrieving the detailed diagnosis of a particular test, and sorting the result set in the ascending/descending order of the contents of a particular column in the DD |
egdbcli -managerid <ManagerID> -test <TestName> -type dd -orderby <ColumnName> |
egdbcli -managerid md86 -test "System - Guest" -type dd -orderby desc |
|
Requesting help with syntax while issuing commands for accessing test tables |
egdbcli Help Testparameters |
|
