API Name
QueryUserOmsData
Overview
You can call this API to get original usage data of RDS product.
Request parameters
Name | Type | Required | Description |
---|---|---|---|
Table | String | Yes | rds |
DataType | String | Yes | Time type, normally value is Hour |
StartTime | String | Yes | Data start time, format:yyyy-mm-ddThh:mm:ssZ |
EndTime | String | Yes | Data end time, format:yyyy-mm-ddThh:mm:ssZ |
Maker | String | No | Tag of last records of current request, using this parameter you can start next request with continuous records |
PageSize | Integer | No | 1~200,by default is 100 |
Response parameters
Name | Type | Required |
---|---|---|
HostId | String | User owned site |
DBVersion | String | Database version |
InstanceId | String | Instance Id |
AdvancedMonitor | String | |
Storage | Integer | Storage space, in Bytes |
NetworkIn | Integer | The amount of data flowing into the RDS from the external network that occurred during the StartTime and EndTime , in Bytes |
NetworkOut | Integer | The amount of data flowing out of the RDS to the external network that occurred during the StartTime and EndTime , in Bytes |
BackupCharged | String | |
ClassCode | String | Class Code |
Memory | Integer | Memory capacity, in Bytes |
Region | String | Region |
ProviderId | String | Product supplier number, default 26842 |
DBType | String | Database type |
SqlCollected | String | |
InstanceUseType | String | Instance Use Type |
InstanceName | String | Instance Name |
EndTime | String | Billing data end time |
StartTime | String | Billing data start time |
Sample requests
For Hour:
https://business.aliyuncs.com/? Action=QueryUserOmsData
&DataType=Hour
&EndTime=2019-04-24T09:15:54Z
&StartTime=2019-03-18T09:15:54Z
&Table=rds
Sample responses
For Hour:
{
"Data": {
"OmsData": [
{
"DBVersion": "9.4",
"InstanceId": "14163171",
"NetworkIn": "0",
"AdvancedMonitor": "off",
"NetworkOut": "0",
"Storage": "5368709120",
"BackupCharged": "0",
"ClassCode": "rds.pg.t1.small",
"Memory": "1073741824",
"Region": "cn-hangzhou",
"ProviderId": "26842",
"DBType": "PostgreSQL",
"EndTime": "2019-04-23T10:00:00Z",
"SqlCollected": "0",
"StartTime": "2019-04-23T09:00:00Z",
"InstanceUseType": "Primary",
"InstanceName": "rm-bp12cz3ml9p020ef4"
},
{
"DBVersion": "9.4",
"InstanceId": "14163171",
"NetworkIn": "0",
"AdvancedMonitor": "off",
"NetworkOut": "0",
"Storage": "5368709120",
"BackupCharged": "0",
"ClassCode": "rds.pg.t1.small",
"Memory": "1073741824",
"Region": "cn-hangzhou",
"ProviderId": "26842",
"DBType": "PostgreSQL",
"EndTime": "2019-04-23T11:00:00Z",
"SqlCollected": "0",
"StartTime": "2019-04-23T10:00:00Z",
"InstanceUseType": "Primary",
"InstanceName": "rm-bp12cz3ml9p020ef4"
},
{
"DBVersion": "9.4",
"InstanceId": "14163171",
"NetworkIn": "0",
"AdvancedMonitor": "off",
"NetworkOut": "0",
"Storage": "5368709120",
"BackupCharged": "0",
"ClassCode": "rds.pg.t1.small",
"Memory": "1073741824",
"Region": "cn-hangzhou",
"ProviderId": "26842",
"DBType": "PostgreSQL",
"EndTime": "2019-04-23T12:00:00Z",
"SqlCollected": "0",
"StartTime": "2019-04-23T11:00:00Z",
"InstanceUseType": "Primary",
"InstanceName": "rm-bp12cz3ml9p020ef4"
},
{
"DBVersion": "9.4",
"InstanceId": "14163171",
"NetworkIn": "0",
"AdvancedMonitor": "off",
"NetworkOut": "0",
"Storage": "5368709120",
"BackupCharged": "0",
"ClassCode": "rds.pg.t1.small",
"Memory": "1073741824",
"Region": "cn-hangzhou",
"ProviderId": "26842",
"DBType": "PostgreSQL",
"EndTime": "2019-04-23T13:00:00Z",
"SqlCollected": "0",
"StartTime": "2019-04-23T12:00:00Z",
"InstanceUseType": "Primary",
"InstanceName": "rm-bp12cz3ml9p020ef4"
},
{
"DBVersion": "9.4",
"InstanceId": "14163171",
"NetworkIn": "0",
"AdvancedMonitor": "off",
"NetworkOut": "0",
"Storage": "5368709120",
"BackupCharged": "0",
"ClassCode": "rds.pg.t1.small",
"Memory": "1073741824",
"Region": "cn-hangzhou",
"ProviderId": "26842",
"DBType": "PostgreSQL",
"EndTime": "2019-04-23T14:00:00Z",
"SqlCollected": "0",
"StartTime": "2019-04-23T13:00:00Z",
"InstanceUseType": "Primary",
"InstanceName": "rm-bp12cz3ml9p020ef4"
},
{
"DBVersion": "9.4",
"InstanceId": "14163171",
"NetworkIn": "0",
"AdvancedMonitor": "off",
"NetworkOut": "0",
"Storage": "5368709120",
"BackupCharged": "0",
"ClassCode": "rds.pg.t1.small",
"Memory": "1073741824",
"Region": "cn-hangzhou",
"ProviderId": "26842",
"DBType": "PostgreSQL",
"EndTime": "2019-04-23T15:00:00Z",
"SqlCollected": "0",
"StartTime": "2019-04-23T14:00:00Z",
"InstanceUseType": "Primary",
"InstanceName": "rm-bp12cz3ml9p020ef4"
},
{
"DBVersion": "9.4",
"InstanceId": "14163171",
"NetworkIn": "0",
"AdvancedMonitor": "off",
"NetworkOut": "0",
"Storage": "5368709120",
"BackupCharged": "0",
"ClassCode": "rds.pg.t1.small",
"Memory": "1073741824",
"Region": "cn-hangzhou",
"ProviderId": "26842",
"DBType": "PostgreSQL",
"EndTime": "2019-04-23T16:00:00Z",
"SqlCollected": "0",
"StartTime": "2019-04-23T15:00:00Z",
"InstanceUseType": "Primary",
"InstanceName": "rm-bp12cz3ml9p020ef4"
},
{
"DBVersion": "9.4",
"InstanceId": "14163171",
"NetworkIn": "0",
"AdvancedMonitor": "off",
"NetworkOut": "0",
"Storage": "5368709120",
"BackupCharged": "0",
"ClassCode": "rds.pg.t1.small",
"Memory": "1073741824",
"Region": "cn-hangzhou",
"ProviderId": "26842",
"DBType": "PostgreSQL",
"EndTime": "2019-04-23T17:00:00Z",
"SqlCollected": "0",
"StartTime": "2019-04-23T16:00:00Z",
"InstanceUseType": "Primary",
"InstanceName": "rm-bp12cz3ml9p020ef4"
},
{
"DBVersion": "9.4",
"InstanceId": "14163171",
"NetworkIn": "0",
"AdvancedMonitor": "off",
"NetworkOut": "0",
"Storage": "5368709120",
"BackupCharged": "0",
"ClassCode": "rds.pg.t1.small",
"Memory": "1073741824",
"Region": "cn-hangzhou",
"ProviderId": "26842",
"DBType": "PostgreSQL",
"EndTime": "2019-04-23T18:00:00Z",
"SqlCollected": "0",
"StartTime": "2019-04-23T17:00:00Z",
"InstanceUseType": "Primary",
"InstanceName": "rm-bp12cz3ml9p020ef4"
},
{
"DBVersion": "9.4",
"InstanceId": "14163171",
"NetworkIn": "0",
"AdvancedMonitor": "off",
"NetworkOut": "0",
"Storage": "5368709120",
"BackupCharged": "0",
"ClassCode": "rds.pg.t1.small",
"Memory": "1073741824",
"Region": "cn-hangzhou",
"ProviderId": "26842",
"DBType": "PostgreSQL",
"EndTime": "2019-04-23T19:00:00Z",
"SqlCollected": "0",
"StartTime": "2019-04-23T18:00:00Z",
"InstanceUseType": "Primary",
"InstanceName": "rm-bp12cz3ml9p020ef4"
},
{
"DBVersion": "9.4",
"InstanceId": "14163171",
"NetworkIn": "0",
"AdvancedMonitor": "off",
"NetworkOut": "0",
"Storage": "5368709120",
"BackupCharged": "0",
"ClassCode": "rds.pg.t1.small",
"Memory": "1073741824",
"Region": "cn-hangzhou",
"ProviderId": "26842",
"DBType": "PostgreSQL",
"EndTime": "2019-04-23T20:00:00Z",
"SqlCollected": "0",
"StartTime": "2019-04-23T19:00:00Z",
"InstanceUseType": "Primary",
"InstanceName": "rm-bp12cz3ml9p020ef4"
},
{
"DBVersion": "9.4",
"InstanceId": "14163171",
"NetworkIn": "0",
"AdvancedMonitor": "off",
"NetworkOut": "0",
"Storage": "5368709120",
"BackupCharged": "0",
"ClassCode": "rds.pg.t1.small",
"Memory": "1073741824",
"Region": "cn-hangzhou",
"ProviderId": "26842",
"DBType": "PostgreSQL",
"EndTime": "2019-04-23T21:00:00Z",
"SqlCollected": "0",
"StartTime": "2019-04-23T20:00:00Z",
"InstanceUseType": "Primary",
"InstanceName": "rm-bp12cz3ml9p020ef4"
},
{
"DBVersion": "9.4",
"InstanceId": "14163171",
"NetworkIn": "0",
"AdvancedMonitor": "off",
"NetworkOut": "0",
"Storage": "5368709120",
"BackupCharged": "0",
"ClassCode": "rds.pg.t1.small",
"Memory": "1073741824",
"Region": "cn-hangzhou",
"ProviderId": "26842",
"DBType": "PostgreSQL",
"EndTime": "2019-04-23T22:00:00Z",
"SqlCollected": "0",
"StartTime": "2019-04-23T21:00:00Z",
"InstanceUseType": "Primary",
"InstanceName": "rm-bp12cz3ml9p020ef4"
},
{
"DBVersion": "9.4",
"InstanceId": "14163171",
"NetworkIn": "0",
"AdvancedMonitor": "off",
"NetworkOut": "0",
"Storage": "5368709120",
"BackupCharged": "0",
"ClassCode": "rds.pg.t1.small",
"Memory": "1073741824",
"Region": "cn-hangzhou",
"ProviderId": "26842",
"DBType": "PostgreSQL",
"EndTime": "2019-04-23T23:00:00Z",
"SqlCollected": "0",
"StartTime": "2019-04-23T22:00:00Z",
"InstanceUseType": "Primary",
"InstanceName": "rm-bp12cz3ml9p020ef4"
},
{
"DBVersion": "9.4",
"InstanceId": "14163171",
"NetworkIn": "0",
"AdvancedMonitor": "off",
"NetworkOut": "0",
"Storage": "5368709120",
"BackupCharged": "0",
"ClassCode": "rds.pg.t1.small",
"Memory": "1073741824",
"Region": "cn-hangzhou",
"ProviderId": "26842",
"DBType": "PostgreSQL",
"EndTime": "2019-04-24T00:00:00Z",
"SqlCollected": "0",
"StartTime": "2019-04-23T23:00:00Z",
"InstanceUseType": "Primary",
"InstanceName": "rm-bp12cz3ml9p020ef4"
},
{
"DBVersion": "9.4",
"InstanceId": "14163171",
"NetworkIn": "0",
"AdvancedMonitor": "off",
"NetworkOut": "0",
"Storage": "5368709120",
"BackupCharged": "0",
"ClassCode": "rds.pg.t1.small",
"Memory": "1073741824",
"Region": "cn-hangzhou",
"ProviderId": "26842",
"DBType": "PostgreSQL",
"EndTime": "2019-04-24T01:00:00Z",
"SqlCollected": "0",
"StartTime": "2019-04-24T00:00:00Z",
"InstanceUseType": "Primary",
"InstanceName": "rm-bp12cz3ml9p020ef4"
},
{
"DBVersion": "9.4",
"InstanceId": "14163171",
"NetworkIn": "0",
"AdvancedMonitor": "off",
"NetworkOut": "0",
"Storage": "5368709120",
"BackupCharged": "0",
"ClassCode": "rds.pg.t1.small",
"Memory": "1073741824",
"Region": "cn-hangzhou",
"ProviderId": "26842",
"DBType": "PostgreSQL",
"EndTime": "2019-04-24T02:00:00Z",
"SqlCollected": "0",
"StartTime": "2019-04-24T01:00:00Z",
"InstanceUseType": "Primary",
"InstanceName": "rm-bp12cz3ml9p020ef4"
},
{
"DBVersion": "9.4",
"InstanceId": "14163171",
"NetworkIn": "0",
"AdvancedMonitor": "off",
"NetworkOut": "0",
"Storage": "5368709120",
"BackupCharged": "0",
"ClassCode": "rds.pg.t1.small",
"Memory": "1073741824",
"Region": "cn-hangzhou",
"ProviderId": "26842",
"DBType": "PostgreSQL",
"EndTime": "2019-04-24T03:00:00Z",
"SqlCollected": "0",
"StartTime": "2019-04-24T02:00:00Z",
"InstanceUseType": "Primary",
"InstanceName": "rm-bp12cz3ml9p020ef4"
},
{
"DBVersion": "9.4",
"InstanceId": "14163171",
"NetworkIn": "0",
"AdvancedMonitor": "off",
"NetworkOut": "0",
"Storage": "5368709120",
"BackupCharged": "0",
"ClassCode": "rds.pg.t1.small",
"Memory": "1073741824",
"Region": "cn-hangzhou",
"ProviderId": "26842",
"DBType": "PostgreSQL",
"EndTime": "2019-04-24T04:00:00Z",
"SqlCollected": "0",
"StartTime": "2019-04-24T03:00:00Z",
"InstanceUseType": "Primary",
"InstanceName": "rm-bp12cz3ml9p020ef4"
},
{
"DBVersion": "9.4",
"InstanceId": "14163171",
"NetworkIn": "0",
"AdvancedMonitor": "off",
"NetworkOut": "0",
"Storage": "5368709120",
"BackupCharged": "0",
"ClassCode": "rds.pg.t1.small",
"Memory": "1073741824",
"Region": "cn-hangzhou",
"ProviderId": "26842",
"DBType": "PostgreSQL",
"EndTime": "2019-04-24T05:00:00Z",
"SqlCollected": "0",
"StartTime": "2019-04-24T04:00:00Z",
"InstanceUseType": "Primary",
"InstanceName": "rm-bp12cz3ml9p020ef4"
}
],
"HostId": "cn"
},
"Message": "Successful!",
"RequestId": "F9A2044E-71FA-4FC5-BD6D-432951BBFB7E",
"Success": true,
"Code": "Success"
}