All Products
Search

This Product

    :RDS Hour Data

    Document Center

    :RDS Hour Data

    Last Updated:Jul 04, 2019

    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：

    1. https://business.aliyuncs.com/? Action=QueryUserOmsData
    2. &DataType=Hour
    3. &EndTime=2019-04-24T09:15:54Z
    4. &StartTime=2019-03-18T09:15:54Z
    5. &Table=rds

    Sample responses

    For Hour：

    1. {
    2.     "Data": {
    3.         "OmsData": [
    4.             {
    5.                 "DBVersion": "9.4",
    6.                 "InstanceId": "14163171",
    7.                 "NetworkIn": "0",
    8.                 "AdvancedMonitor": "off",
    9.                 "NetworkOut": "0",
    10.                 "Storage": "5368709120",
    11.                 "BackupCharged": "0",
    12.                 "ClassCode": "rds.pg.t1.small",
    13.                 "Memory": "1073741824",
    14.                 "Region": "cn-hangzhou",
    15.                 "ProviderId": "26842",
    16.                 "DBType": "PostgreSQL",
    17.                 "EndTime": "2019-04-23T10:00:00Z",
    18.                 "SqlCollected": "0",
    19.                 "StartTime": "2019-04-23T09:00:00Z",
    20.                 "InstanceUseType": "Primary",
    21.                 "InstanceName": "rm-bp12cz3ml9p020ef4"
    22.             },
    23.             {
    24.                 "DBVersion": "9.4",
    25.                 "InstanceId": "14163171",
    26.                 "NetworkIn": "0",
    27.                 "AdvancedMonitor": "off",
    28.                 "NetworkOut": "0",
    29.                 "Storage": "5368709120",
    30.                 "BackupCharged": "0",
    31.                 "ClassCode": "rds.pg.t1.small",
    32.                 "Memory": "1073741824",
    33.                 "Region": "cn-hangzhou",
    34.                 "ProviderId": "26842",
    35.                 "DBType": "PostgreSQL",
    36.                 "EndTime": "2019-04-23T11:00:00Z",
    37.                 "SqlCollected": "0",
    38.                 "StartTime": "2019-04-23T10:00:00Z",
    39.                 "InstanceUseType": "Primary",
    40.                 "InstanceName": "rm-bp12cz3ml9p020ef4"
    41.             },
    42.             {
    43.                 "DBVersion": "9.4",
    44.                 "InstanceId": "14163171",
    45.                 "NetworkIn": "0",
    46.                 "AdvancedMonitor": "off",
    47.                 "NetworkOut": "0",
    48.                 "Storage": "5368709120",
    49.                 "BackupCharged": "0",
    50.                 "ClassCode": "rds.pg.t1.small",
    51.                 "Memory": "1073741824",
    52.                 "Region": "cn-hangzhou",
    53.                 "ProviderId": "26842",
    54.                 "DBType": "PostgreSQL",
    55.                 "EndTime": "2019-04-23T12:00:00Z",
    56.                 "SqlCollected": "0",
    57.                 "StartTime": "2019-04-23T11:00:00Z",
    58.                 "InstanceUseType": "Primary",
    59.                 "InstanceName": "rm-bp12cz3ml9p020ef4"
    60.             },
    61.             {
    62.                 "DBVersion": "9.4",
    63.                 "InstanceId": "14163171",
    64.                 "NetworkIn": "0",
    65.                 "AdvancedMonitor": "off",
    66.                 "NetworkOut": "0",
    67.                 "Storage": "5368709120",
    68.                 "BackupCharged": "0",
    69.                 "ClassCode": "rds.pg.t1.small",
    70.                 "Memory": "1073741824",
    71.                 "Region": "cn-hangzhou",
    72.                 "ProviderId": "26842",
    73.                 "DBType": "PostgreSQL",
    74.                 "EndTime": "2019-04-23T13:00:00Z",
    75.                 "SqlCollected": "0",
    76.                 "StartTime": "2019-04-23T12:00:00Z",
    77.                 "InstanceUseType": "Primary",
    78.                 "InstanceName": "rm-bp12cz3ml9p020ef4"
    79.             },
    80.             {
    81.                 "DBVersion": "9.4",
    82.                 "InstanceId": "14163171",
    83.                 "NetworkIn": "0",
    84.                 "AdvancedMonitor": "off",
    85.                 "NetworkOut": "0",
    86.                 "Storage": "5368709120",
    87.                 "BackupCharged": "0",
    88.                 "ClassCode": "rds.pg.t1.small",
    89.                 "Memory": "1073741824",
    90.                 "Region": "cn-hangzhou",
    91.                 "ProviderId": "26842",
    92.                 "DBType": "PostgreSQL",
    93.                 "EndTime": "2019-04-23T14:00:00Z",
    94.                 "SqlCollected": "0",
    95.                 "StartTime": "2019-04-23T13:00:00Z",
    96.                 "InstanceUseType": "Primary",
    97.                 "InstanceName": "rm-bp12cz3ml9p020ef4"
    98.             },
    99.             {
    100.                 "DBVersion": "9.4",
    101.                 "InstanceId": "14163171",
    102.                 "NetworkIn": "0",
    103.                 "AdvancedMonitor": "off",
    104.                 "NetworkOut": "0",
    105.                 "Storage": "5368709120",
    106.                 "BackupCharged": "0",
    107.                 "ClassCode": "rds.pg.t1.small",
    108.                 "Memory": "1073741824",
    109.                 "Region": "cn-hangzhou",
    110.                 "ProviderId": "26842",
    111.                 "DBType": "PostgreSQL",
    112.                 "EndTime": "2019-04-23T15:00:00Z",
    113.                 "SqlCollected": "0",
    114.                 "StartTime": "2019-04-23T14:00:00Z",
    115.                 "InstanceUseType": "Primary",
    116.                 "InstanceName": "rm-bp12cz3ml9p020ef4"
    117.             },
    118.             {
    119.                 "DBVersion": "9.4",
    120.                 "InstanceId": "14163171",
    121.                 "NetworkIn": "0",
    122.                 "AdvancedMonitor": "off",
    123.                 "NetworkOut": "0",
    124.                 "Storage": "5368709120",
    125.                 "BackupCharged": "0",
    126.                 "ClassCode": "rds.pg.t1.small",
    127.                 "Memory": "1073741824",
    128.                 "Region": "cn-hangzhou",
    129.                 "ProviderId": "26842",
    130.                 "DBType": "PostgreSQL",
    131.                 "EndTime": "2019-04-23T16:00:00Z",
    132.                 "SqlCollected": "0",
    133.                 "StartTime": "2019-04-23T15:00:00Z",
    134.                 "InstanceUseType": "Primary",
    135.                 "InstanceName": "rm-bp12cz3ml9p020ef4"
    136.             },
    137.             {
    138.                 "DBVersion": "9.4",
    139.                 "InstanceId": "14163171",
    140.                 "NetworkIn": "0",
    141.                 "AdvancedMonitor": "off",
    142.                 "NetworkOut": "0",
    143.                 "Storage": "5368709120",
    144.                 "BackupCharged": "0",
    145.                 "ClassCode": "rds.pg.t1.small",
    146.                 "Memory": "1073741824",
    147.                 "Region": "cn-hangzhou",
    148.                 "ProviderId": "26842",
    149.                 "DBType": "PostgreSQL",
    150.                 "EndTime": "2019-04-23T17:00:00Z",
    151.                 "SqlCollected": "0",
    152.                 "StartTime": "2019-04-23T16:00:00Z",
    153.                 "InstanceUseType": "Primary",
    154.                 "InstanceName": "rm-bp12cz3ml9p020ef4"
    155.             },
    156.             {
    157.                 "DBVersion": "9.4",
    158.                 "InstanceId": "14163171",
    159.                 "NetworkIn": "0",
    160.                 "AdvancedMonitor": "off",
    161.                 "NetworkOut": "0",
    162.                 "Storage": "5368709120",
    163.                 "BackupCharged": "0",
    164.                 "ClassCode": "rds.pg.t1.small",
    165.                 "Memory": "1073741824",
    166.                 "Region": "cn-hangzhou",
    167.                 "ProviderId": "26842",
    168.                 "DBType": "PostgreSQL",
    169.                 "EndTime": "2019-04-23T18:00:00Z",
    170.                 "SqlCollected": "0",
    171.                 "StartTime": "2019-04-23T17:00:00Z",
    172.                 "InstanceUseType": "Primary",
    173.                 "InstanceName": "rm-bp12cz3ml9p020ef4"
    174.             },
    175.             {
    176.                 "DBVersion": "9.4",
    177.                 "InstanceId": "14163171",
    178.                 "NetworkIn": "0",
    179.                 "AdvancedMonitor": "off",
    180.                 "NetworkOut": "0",
    181.                 "Storage": "5368709120",
    182.                 "BackupCharged": "0",
    183.                 "ClassCode": "rds.pg.t1.small",
    184.                 "Memory": "1073741824",
    185.                 "Region": "cn-hangzhou",
    186.                 "ProviderId": "26842",
    187.                 "DBType": "PostgreSQL",
    188.                 "EndTime": "2019-04-23T19:00:00Z",
    189.                 "SqlCollected": "0",
    190.                 "StartTime": "2019-04-23T18:00:00Z",
    191.                 "InstanceUseType": "Primary",
    192.                 "InstanceName": "rm-bp12cz3ml9p020ef4"
    193.             },
    194.             {
    195.                 "DBVersion": "9.4",
    196.                 "InstanceId": "14163171",
    197.                 "NetworkIn": "0",
    198.                 "AdvancedMonitor": "off",
    199.                 "NetworkOut": "0",
    200.                 "Storage": "5368709120",
    201.                 "BackupCharged": "0",
    202.                 "ClassCode": "rds.pg.t1.small",
    203.                 "Memory": "1073741824",
    204.                 "Region": "cn-hangzhou",
    205.                 "ProviderId": "26842",
    206.                 "DBType": "PostgreSQL",
    207.                 "EndTime": "2019-04-23T20:00:00Z",
    208.                 "SqlCollected": "0",
    209.                 "StartTime": "2019-04-23T19:00:00Z",
    210.                 "InstanceUseType": "Primary",
    211.                 "InstanceName": "rm-bp12cz3ml9p020ef4"
    212.             },
    213.             {
    214.                 "DBVersion": "9.4",
    215.                 "InstanceId": "14163171",
    216.                 "NetworkIn": "0",
    217.                 "AdvancedMonitor": "off",
    218.                 "NetworkOut": "0",
    219.                 "Storage": "5368709120",
    220.                 "BackupCharged": "0",
    221.                 "ClassCode": "rds.pg.t1.small",
    222.                 "Memory": "1073741824",
    223.                 "Region": "cn-hangzhou",
    224.                 "ProviderId": "26842",
    225.                 "DBType": "PostgreSQL",
    226.                 "EndTime": "2019-04-23T21:00:00Z",
    227.                 "SqlCollected": "0",
    228.                 "StartTime": "2019-04-23T20:00:00Z",
    229.                 "InstanceUseType": "Primary",
    230.                 "InstanceName": "rm-bp12cz3ml9p020ef4"
    231.             },
    232.             {
    233.                 "DBVersion": "9.4",
    234.                 "InstanceId": "14163171",
    235.                 "NetworkIn": "0",
    236.                 "AdvancedMonitor": "off",
    237.                 "NetworkOut": "0",
    238.                 "Storage": "5368709120",
    239.                 "BackupCharged": "0",
    240.                 "ClassCode": "rds.pg.t1.small",
    241.                 "Memory": "1073741824",
    242.                 "Region": "cn-hangzhou",
    243.                 "ProviderId": "26842",
    244.                 "DBType": "PostgreSQL",
    245.                 "EndTime": "2019-04-23T22:00:00Z",
    246.                 "SqlCollected": "0",
    247.                 "StartTime": "2019-04-23T21:00:00Z",
    248.                 "InstanceUseType": "Primary",
    249.                 "InstanceName": "rm-bp12cz3ml9p020ef4"
    250.             },
    251.             {
    252.                 "DBVersion": "9.4",
    253.                 "InstanceId": "14163171",
    254.                 "NetworkIn": "0",
    255.                 "AdvancedMonitor": "off",
    256.                 "NetworkOut": "0",
    257.                 "Storage": "5368709120",
    258.                 "BackupCharged": "0",
    259.                 "ClassCode": "rds.pg.t1.small",
    260.                 "Memory": "1073741824",
    261.                 "Region": "cn-hangzhou",
    262.                 "ProviderId": "26842",
    263.                 "DBType": "PostgreSQL",
    264.                 "EndTime": "2019-04-23T23:00:00Z",
    265.                 "SqlCollected": "0",
    266.                 "StartTime": "2019-04-23T22:00:00Z",
    267.                 "InstanceUseType": "Primary",
    268.                 "InstanceName": "rm-bp12cz3ml9p020ef4"
    269.             },
    270.             {
    271.                 "DBVersion": "9.4",
    272.                 "InstanceId": "14163171",
    273.                 "NetworkIn": "0",
    274.                 "AdvancedMonitor": "off",
    275.                 "NetworkOut": "0",
    276.                 "Storage": "5368709120",
    277.                 "BackupCharged": "0",
    278.                 "ClassCode": "rds.pg.t1.small",
    279.                 "Memory": "1073741824",
    280.                 "Region": "cn-hangzhou",
    281.                 "ProviderId": "26842",
    282.                 "DBType": "PostgreSQL",
    283.                 "EndTime": "2019-04-24T00:00:00Z",
    284.                 "SqlCollected": "0",
    285.                 "StartTime": "2019-04-23T23:00:00Z",
    286.                 "InstanceUseType": "Primary",
    287.                 "InstanceName": "rm-bp12cz3ml9p020ef4"
    288.             },
    289.             {
    290.                 "DBVersion": "9.4",
    291.                 "InstanceId": "14163171",
    292.                 "NetworkIn": "0",
    293.                 "AdvancedMonitor": "off",
    294.                 "NetworkOut": "0",
    295.                 "Storage": "5368709120",
    296.                 "BackupCharged": "0",
    297.                 "ClassCode": "rds.pg.t1.small",
    298.                 "Memory": "1073741824",
    299.                 "Region": "cn-hangzhou",
    300.                 "ProviderId": "26842",
    301.                 "DBType": "PostgreSQL",
    302.                 "EndTime": "2019-04-24T01:00:00Z",
    303.                 "SqlCollected": "0",
    304.                 "StartTime": "2019-04-24T00:00:00Z",
    305.                 "InstanceUseType": "Primary",
    306.                 "InstanceName": "rm-bp12cz3ml9p020ef4"
    307.             },
    308.             {
    309.                 "DBVersion": "9.4",
    310.                 "InstanceId": "14163171",
    311.                 "NetworkIn": "0",
    312.                 "AdvancedMonitor": "off",
    313.                 "NetworkOut": "0",
    314.                 "Storage": "5368709120",
    315.                 "BackupCharged": "0",
    316.                 "ClassCode": "rds.pg.t1.small",
    317.                 "Memory": "1073741824",
    318.                 "Region": "cn-hangzhou",
    319.                 "ProviderId": "26842",
    320.                 "DBType": "PostgreSQL",
    321.                 "EndTime": "2019-04-24T02:00:00Z",
    322.                 "SqlCollected": "0",
    323.                 "StartTime": "2019-04-24T01:00:00Z",
    324.                 "InstanceUseType": "Primary",
    325.                 "InstanceName": "rm-bp12cz3ml9p020ef4"
    326.             },
    327.             {
    328.                 "DBVersion": "9.4",
    329.                 "InstanceId": "14163171",
    330.                 "NetworkIn": "0",
    331.                 "AdvancedMonitor": "off",
    332.                 "NetworkOut": "0",
    333.                 "Storage": "5368709120",
    334.                 "BackupCharged": "0",
    335.                 "ClassCode": "rds.pg.t1.small",
    336.                 "Memory": "1073741824",
    337.                 "Region": "cn-hangzhou",
    338.                 "ProviderId": "26842",
    339.                 "DBType": "PostgreSQL",
    340.                 "EndTime": "2019-04-24T03:00:00Z",
    341.                 "SqlCollected": "0",
    342.                 "StartTime": "2019-04-24T02:00:00Z",
    343.                 "InstanceUseType": "Primary",
    344.                 "InstanceName": "rm-bp12cz3ml9p020ef4"
    345.             },
    346.             {
    347.                 "DBVersion": "9.4",
    348.                 "InstanceId": "14163171",
    349.                 "NetworkIn": "0",
    350.                 "AdvancedMonitor": "off",
    351.                 "NetworkOut": "0",
    352.                 "Storage": "5368709120",
    353.                 "BackupCharged": "0",
    354.                 "ClassCode": "rds.pg.t1.small",
    355.                 "Memory": "1073741824",
    356.                 "Region": "cn-hangzhou",
    357.                 "ProviderId": "26842",
    358.                 "DBType": "PostgreSQL",
    359.                 "EndTime": "2019-04-24T04:00:00Z",
    360.                 "SqlCollected": "0",
    361.                 "StartTime": "2019-04-24T03:00:00Z",
    362.                 "InstanceUseType": "Primary",
    363.                 "InstanceName": "rm-bp12cz3ml9p020ef4"
    364.             },
    365.             {
    366.                 "DBVersion": "9.4",
    367.                 "InstanceId": "14163171",
    368.                 "NetworkIn": "0",
    369.                 "AdvancedMonitor": "off",
    370.                 "NetworkOut": "0",
    371.                 "Storage": "5368709120",
    372.                 "BackupCharged": "0",
    373.                 "ClassCode": "rds.pg.t1.small",
    374.                 "Memory": "1073741824",
    375.                 "Region": "cn-hangzhou",
    376.                 "ProviderId": "26842",
    377.                 "DBType": "PostgreSQL",
    378.                 "EndTime": "2019-04-24T05:00:00Z",
    379.                 "SqlCollected": "0",
    380.                 "StartTime": "2019-04-24T04:00:00Z",
    381.                 "InstanceUseType": "Primary",
    382.                 "InstanceName": "rm-bp12cz3ml9p020ef4"
    383.             }
    384.         ],
    385.         "HostId": "cn"
    386.     },
    387.     "Message": "Successful!",
    388.     "RequestId": "F9A2044E-71FA-4FC5-BD6D-432951BBFB7E",
    389.     "Success": true,
    390.     "Code": "Success"
    391. }