# Get all database usages recorded in Masking engine

Endpoint: GET /database-usage
Version: 5.1.45
Security: api_key

## Query parameters:

  - `start_date` (string)
    The date after which database usage should be retrieved. Date format is 'yyyy-MM-dd'.

  - `end_date` (string)
    The date before which database usage should be retrieved. Date format is 'yyyy-MM-dd'.

  - `database_name` (string)
    Name of the database for which usage should be retrieved.

  - `page_number` (integer)
    The page number for which to fetch database usage. This will default to the first page if excluded

  - `page_size` (integer)
    The maximum number of objects to return. This will default to the DefaultApiPageSize setting property if not provided

## Response 200 fields (application/json):

  - `_pageInfo` (object)

  - `_pageInfo.numberOnPage` (integer)
    The number of items on this page. This should always match the page size unless it is the last page.

  - `_pageInfo.total` (integer)
    The total number of items

  - `data` (array)
    Example: [{"name":"testDbName","dbType":"oracle","size":2695200768,"databaseProperties":{"port":1504,"databaseIdentifier":"testHost:testServiceName:testDbName"},"executionId":1,"failureReason":"","reportingDate":"2018-11-06T04:14:46.929+0000"}]

  - `data.name` (string)
    Name of the database.
    Example: "testDbName"

  - `data.dbType` (string)
    Type of the database.
    Example: "oracle"

  - `data.size` (number)
    Size of the database in bytes.
    Example: 2695200768

  - `data.databaseProperties` (object)
    Properties of the database.
    Example: {"port":1504,"databaseIdentifier":"testHost:testServiceName:testDbName"}

  - `data.executionId` (integer)
    The ID of the execution.
    Example: 1

  - `data.failureReason` (string)
    Reason in case unable to calculate database size.

  - `data.reportingDate` (string)
    Date with time and timezone information in string format.
    Example: "2018-11-06T04:14:46.929+0000"


## Response 401 fields