Querying the Trend Tables for Trend Data
|
Task |
Command |
Example |
|---|---|---|
|
Retrieving trend data related to a particular test |
egdbcli -managerid <ManagerID> -test <TestName> -type Trend |
egdbcli -managerid mid -test DiskSpace -type Trend |
|
Retrieving trend computations related to a particular test for specific hosts |
egdbcli -managerid <ManagerID> -test <TestName> -host <Comma-separated list of hosts> -type Trend |
egdbcli -managerid mid -test DiskSpace -type Trend -host gen10,lin12 |
|
Retrieving trend data related to a particular test for a specific application |
egdbcli -managerid <ManagerID> -test <TestName> -host <IP/Nick name of application > -port <Port number of application> -type Trend |
egdbcli -managerid mid -test DiskActivity -host 192.168.10.8 -port 80 -type Trend |
|
Retrieving the trend data computed for a particular test during a specific period |
egdbcli -managerid <ManagerID> -test <TestName> -startDate "<StartDate/Time>" -endDate "<EndDate/Time>" -type Trend |
egdbcli -managerid mid -test DiskActivity -startDate "2010-05-14 23:49:29.0" -endDate "2010-05-15 05:41:12.0" -type Trend |
|
Retrieving the trend data for a test in a desired date format |
egdbcli -managerid <ManagerID> -test <TestName> -dateformat "<DateFormat>" -type Trend |
egdbcli -managerid mid -test DiskActivity -dateformat "dd-MM-yyyy" -type Trend |
|
Retrieving the trend computations for specific measures reported by a test |
egdbcli -managerid <ManagerID> -test <TestName> -measures <Comma-separated list of measure column numbers> -type Trend OR egdbcli -managerid <ManagerID> -test <TestName> -measures <Comma-separated list of measure display names in double-quotes> -type Trend |
egdbcli -managerid mid -test DiskActivity -measures 1,2 -type Trend OR egdbcli -managerid mid -test Network -measures "Avg network delay,Min network delay" -type Trend |
|
Retrieving the trend data of a test and saving 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> -type Trend |
egdbcli -managerid mid -test DiskActivity -format csv -filename c:\diskact -type Trend |
|
Retrieving the trend data of a test and saving the data to an existing file by overwriting it |
egdbcli -managerid <ManagerID> -test <TestName> -format <csv/txt/xml> -filename <Full path to the file> -append false -type Trend |
egdbcli -managerid mid -test DiskActivity -format csv -filename c:\diskact -append false -type Trend |
|
Retrieving the trend data of a test and saving the data to an existing file by appending to it |
egdbcli -managerid <ManagerID> -test <TestName> -format <csv/txt/xml> -filename <Full path to the file> -append true -type Trend |
egdbcli -managerid mid -test DiskActivity -format csv -filename c:\diskact -append true -type Trend |
|
Retrieving the trend data for a specific descriptor supported by a test |
egdbcli -managerid <ManagerID> -test <TestName> -info <Descriptor> -type Trend |
egdbcli -managerid mid -test DiskActivity -info C,D -type Trend |
|
Retrieving the trend data for multiple descriptors supported by a test |
egdbcli -managerid <ManagerID> -test <TestName> -info <Comma-separated list of descriptors> -type Trend |
egdbcli -managerid mid -test DiskActivity -info C,D -type Trend |
|
Retrieving the trend data for a particular measurement host |
egdbcli -managerid <ManagerID> -test <TestName> -msmthost <Measurement host> -type Trend |
egdbcli -managerid mid -test Network -msmt 192.168.10.8 -type Trend |
|
Retrieving the trend data pertaining to a specific web site |
egdbcli -managerid <ManagerID> -test <TestName> -site <Sitename> -type Trend |
egdbcli -managerid mid -test WebTransactions -site www.egi.com -type Trend |
|
Retrieving the trend data pertaining to specific hosts associated with a web site |
egdbcli -managerid <ManagerID> -test <TestName> -site <Sitename> -host <Comma-separated list of hosts> -type Trend |
egdbcli -managerid mid -test DiskSpace -site www.egi.com -host web7,ora9 -type Trend |
|
Retrieving the trend data related to 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 Trend |
egdbcli -managerid mid -test MemoryDetails -host ora12 -port 1521 -info egurkha+,egdemo+ -type Trend
|
|
Retrieving the trend data computed for 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 Trend |
egdbcli -managerid mid -test DiskActivity -host ora12 -port 1521 -info egurkha+C,egurkha+D,egdemo+C,egdemo+D -type Trend
|
|
Retrieving the hourly summary of data for a test during a specific time period |
egdbcli -managerid <ManagerID> -test <TestName> -startDate "<StartDate/Time>" -endDate "<EndDate/Time>" -type Trend -period hs |
egdbcli -managerid mid -test DiskActivity -startDate "2010-05-14 23:49:29.0" -endDate "2010-05-15 05:41:12.0" -type Trend -period hs |
|
Retrieving the hourly data for a test during a specific time period |
egdbcli -managerid <ManagerID> -test <TestName> -startDate "<StartDate/Time>" -endDate "<EndDate/Time>" -type Trend -period h |
egdbcli -managerid mid -test DiskActivity -startDate "2010-05-14 23:49:29.0" -endDate "2010-05-15 05:41:12.0" -type Trend -period h |
|
Retrieving the daily summary data for a test during a specific time period |
egdbcli -managerid <ManagerID> -test <TestName> -startDate "<StartDate/Time>" -endDate "<EndDate/Time>" -type Trend -period ds |
Egdbcli -managerid mid -test DiskActivity -startDate "2010-05-14 23:49:29.0" -endDate "2010-05-20 05:41:12.0" -type Trend -period ds |
|
Retrieving the daily data for a test during a specific time period |
egdbcli -managerid <ManagerID> -test <TestName> -startDate "<StartDate/Time>" -endDate "<EndDate/Time>" -type Trend -period d |
egdbcli -managerid mid -test DiskActivity -startDate "2010-05-14 23:49:29.0" -endDate "2010-05-20 05:41:12.0" -type Trend -period d |
|
Retrieving the monthly summary data for a test during a specific time period |
egdbcli -managerid <ManagerID> -test <TestName> -startDate "<StartDate/Time>" -endDate "<EndDate/Time>" -type Trend -period ms |
egdbcli -managerid mid -test DiskActivity -startDate "2010-05-14 23:49:29.0" -endDate "2010-07-15 05:41:12.0" -type Trend -period ms |
|
Retrieving the monthly data for a test during a specific time period |
egdbcli -managerid <ManagerID> -test <TestName> -startDate "<StartDate/Time>" -endDate "<EndDate/Time>" -type Trend -period m |
egdbcli -managerid mid -test DiskActivity -startDate "2010-05-14 23:49:29.0" -endDate "2010-07-15 05:41:12.0" -type Trend -period m |
|
Retrieving the trend data of a test mapped to all components in a segment |
egdbcli -managerid <ManagerID> -test <TestName> -segment <SegmentName> -type Trend |
egdbcli -managerid md86 -test DiskSpace -segment seg1 -type Trend |
|
Retrieving the trend data of a test mapped to one component in a segment |
egdbcli -managerid <ManagerID> -test <TestName> -segment <SegmentName> -host < IP/Nick name of host> -port<PortNumber> -type Trend |
egdbcli -managerid md86 -test DiskSpace -segment seg1 -host web83 port 80 -type Trend |
|
Retrieving the trend data of a test mapped to specific components in a segment |
egdbcli -managerid <ManagerID> -test <TestName> -segment <SegmentName> -host <Comma-separated list of IP/Nick names of hosts> -type Trend |
egdbcli -managerid md86 -test DiskSpace -segment seg1 -host wl98,web83 -type Trend |
|
Retrieving the hourly trend data of a test mapped to all components in a segment during a specific period |
egdbcli -managerid <ManagerID> -test <TestName> -segment <SegmentName> -startDate "<StartDate/Time>" -endDate "<EndDate/Time>" -type Trend -period h |
egdbcli -managerid mid -test DiskActivity -segment seg1 -startDate "2010-05-14 23:49:29.0" -endDate "2010-05-15 05:41:12.0" -type Trend -period h |
|
Retrieving the hourly summary data of a test mapped to all components in a segment during a specific period |
egdbcli -managerid <ManagerID> -test <TestName> -segment <SegmentName> -startDate "<StartDate/Time>" -endDate "<EndDate/Time>" -type Trend -period hs |
egdbcli -managerid mid -test DiskActivity -segment seg1 -startDate "2010-05-14 23:49:29.0" -endDate "2010-05-15 05:41:12.0" -type Trend -period hs |
|
Retrieving the daily trend data of a test mapped to all components in a segment during a specific period |
egdbcli -managerid <ManagerID> -test <TestName> -segment <SegmentName> -startDate "<StartDate/Time>" -endDate "<EndDate/Time>" -type Trend -period d |
egdbcli -managerid mid -test DiskActivity -segment seg1 -startDate "2010-05-14 23:49:29.0" -endDate "2010-05-20 05:41:12.0" -type Trend -period d |
|
Retrieving the daily summary data of a test mapped to all components in a segment during a specific period |
egdbcli -managerid <ManagerID> -test <TestName> -segment <SegmentName> -startDate "<StartDate/Time>" -endDate "<EndDate/Time>" -type Trend -period ds |
egdbcli -managerid mid -test DiskActivity -segment seg1 -startDate "2010-05-14 23:49:29.0" -endDate "2010-05-20 05:41:12.0" -type Trend -period ds |
|
Retrieving the monthly trend data of a test mapped to all components in a segment during a specific period |
egdbcli -managerid <ManagerID> -test <TestName> -segment <SegmentName> -startDate "<StartDate/Time>" -endDate "<EndDate/Time>" -type Trend -period m |
egdbcli -managerid mid -test DiskActivity -segment seg1 -startDate "2010-05-14 23:49:29.0" -endDate "2010-07-15 05:41:12.0" -type Trend -period m |
|
Retrieving the monthly summary data of a test mapped to all components in a segment during a specific period |
egdbcli -managerid <ManagerID> -test <TestName> -segment <SegmentName> -startDate "<StartDate/Time>" -endDate "<EndDate/Time>" -type Trend -period ms |
egdbcli -managerid mid -test DiskActivity -segment seg1 -startDate "2010-05-14 23:49:29.0" -endDate "2010-07-15 05:41:12.0" -type Trend -period ms |
|
Retrieving the trend data of a test mapped to all components in a web site or non-web site service |
egdbcli -managerid <ManagerID> -test <TestName> -service <ServiceName> -type Trend |
egdbcli -managerid md86 -test DiskSpace -service ser1 -type Trend |
|
Retrieving the trend data 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 Trend |
egdbcli -managerid md86 -test DiskSpace -service ser1 -segment seg1 -type Trend |
|
Retrieving the trend data 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 Trend |
egdbcli -managerid md86 -test DiskSpace -service ser1 -host ad23 -port 389 -type Trend |
|
Retrieving the trend data of a test mapped to specific components in a service |
egdbcli -managerid <ManagerID> -test <TestName> -service <ServiceName> -host <Comma-separated list of IP addresses / Nick names of components> -type Trend |
egdbcli -managerid md86 -test DiskSpace -service ser1 -host ad23,iis80 -type Trend |
|
Retrieving the hourly trend data, pertaining to a specific time period, for a test mapped to all components in a service |
egdbcli -managerid <ManagerID> -test <TestName> -service <ServiceName> -startDate "<StartDate/Time>" -endDate "<EndDate/Time>" -type Trend -period h |
egdbcli -managerid mid -test DiskActivity -service ser1 -startDate "2010-05-14 23:49:29.0" -endDate "2010-05-15 05:41:12.0" -type Trend -period h |
|
Retrieving the hourly summary data, pertaining to a specific time period, for a test mapped to all components in a service |
egdbcli -managerid <ManagerID> -test <TestName> -service <ServiceName> -startDate "<StartDate/Time>" -endDate "<EndDate/Time>" -type Trend -period hs |
egdbcli -managerid mid -test DiskActivity -service ser1 -startDate "2010-05-14 23:49:29.0" -endDate "2010-05-15 05:41:12.0" -type Trend -period hs |
|
Retrieving the daily trend data, pertaining to a specific time period, for a test mapped to all components in a service |
egdbcli -managerid <ManagerID> -test <TestName> -service <ServiceName> -startDate "<StartDate/Time>" -endDate "<EndDate/Time>" -type Trend -period d |
egdbcli -managerid mid -test DiskActivity -service ser1 -startDate "2010-05-14 23:49:29.0" -endDate "2010-05-20 05:41:12.0" -type Trend -period d |
|
Retrieving the daily summary data, pertaining to a specific time period, for a test mapped to all components in a service |
egdbcli -managerid <ManagerID> -test <TestName> -service <ServiceName> -startDate "<StartDate/Time>" -endDate "<EndDate/Time>" -type Trend -period ds |
egdbcli -managerid mid -test DiskActivity -service ser1 -startDate "2010-05-14 23:49:29.0" -endDate "2010-05-20 05:41:12.0" -type Trend -period ds |
|
Retrieving the monthly trend data, pertaining to a specific time period, for a test mapped to all components in a service |
egdbcli -managerid <ManagerID> -test <TestName> -service <ServiceName> -startDate "<StartDate/Time>" -endDate "<EndDate/Time>" -type Trend -period m |
egdbcli -managerid mid -test DiskActivity -service ser1 -startDate "2010-05-14 23:49:29.0" -endDate "2010-07-15 05:41:12.0" -type Trend -period m |
|
Retrieving the monthly summary data, pertaining to a specific time period, for a test mapped to all components in a service |
egdbcli -managerid <ManagerID> -test <TestName> -service <ServiceName> -startDate "<StartDate/Time>" -endDate "<EndDate/Time>" -type Trend -period ms |
egdbcli -managerid mid -test DiskActivity -service ser1 -startDate "2010-05-14 23:49:29.0" -endDate "2010-07-15 05:41:12.0" -type Trend -period ms |
|
Retrieving the trend data 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 Trend |
egdbcli -managerid md86 -test DiskSpace -searchhost "*i*,win*,*ora*" -type Trend |
|
Retrieving the hourly/daily/monthly trend data 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 Trend -period <h/d/m based on type of trend data required - hourly, daily, or monthly> |
egdbcli -managerid md86 -test DiskSpace -searchhost "*i*,win*,*ora*" -type Trend -period h (to retrieve hourly trends) |
|
Retrieving the hourly/daily/monthly summary data 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 Trend -period <hs/ds/ms based on type of summary data required - hourly, daily, or monthly> |
egdbcli -managerid md86 -test DiskSpace -searchhost "*i*,win*,*ora*" -type Trend -period hs (to retrieve hourly summary) |
|
Retrieving the trend data 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 Trend |
egdbcli -managerid md86 -test DiskSpace -searchinfo "*C*,E" -type Trend |
|
Retrieving the hourly/daily/monthly trend data 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 Trend -period <h/d/m based on type of trend data required - hourly, daily, or monthly> |
egdbcli -managerid md86 -test DiskSpace -searchinfo "*C*,E" -type Trend -period h (to retrieve hourly trends) |
|
Retrieving the hourly/daily/monthly summary data of a specific test with nick names that match a specified set of search patterns |
egdbcli -managerid <ManagerID> -test <TestName> -searchinfo "<Comma-separated list of search patterns>" -type Trend -period <hs/ds/ms based on type of summary data required - hourly, daily, or monthly> |
egdbcli -managerid md86 -test DiskSpace -searchinfo "*C*,E" -type Trend -period hs (to retrieve hourly summary) |
|
Retrieving the trend data 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 Trend |
egdbcli -managerid md86 -test DiskSpace -host exch -port 25 -searchinfo "*C*,E" -type Trend |
|
Retrieving the hourly/daily/monthly trend data 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 Trend -period <h/d/m based on type of trend data required - hourly, daily, or monthly> |
egdbcli -managerid md86 -test DiskSpace -host exch -port 25 -searchinfo "*C*,E" -type Trend -period h (to retrieve hourly trends) |
|
Retrieving the hourly/daily/monthly summary data 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 Trend -period <hs/ds/ms based on type of summary data required - hourly, daily, or monthly> |
egdbcli -managerid md86 -test DiskSpace -host exch -port 25 -searchinfo "*C*,E" -type Trend -period hs (to retrieve hourly summary) |
|
Retrieving the trend data pertaining to a specific time period for a particular test across components, and grouping the result set by a specific column in the trend table |
egdbcli -managerid <ManagerID> -test <TestName> -type Trend -startDate "<StartDate/Time>" -endDate "<EndDate/Time> -groupby <ColumnName> |
egdbcli -managerid md86 -test network -type Trend -startDate "04/06/2011 16:42:00" -endDate "04/06/2011 17:42:00" -groupby trgt_host |
|
Retrieving the trend data pertaining to a specific time period for a particular test across components, and sorting the result set in the ascending/descending order of the contents of a particular column in the trend table |
egdbcli -managerid <ManagerID> -test <TestName> -type Trend -startDate "<StartDate/Time>" -endDate "<EndDate/Time> -orderby <ColumnName> |
egdbcli -managerid md86 -test network -type Trend -startDate "04/06/2011 16:42:00" -endDate "04/06/2011 17:42:00" -orderby desc |
|
Requesting help with syntax while issuing commands for retrieving data from trend tables |
egdbcli Help Trendparameters |
|
