GET api/database/summary

Gets summary of database stats based on the date range specified

Resource Information
Requires authentication? Yes (HTTP authentication using user name and API key)
Response formats JSON
Example URL
  api/database/summary?organisationId=5&startDate=2016-01-01 00:00&split=true&reportType=Performace  
Parameters
Name Description
organisationId
required
Id of the organisation
nodeGuid
optional
Unique identifier for the predatar agent
startDate
optional
Start date in the format yyyy-MM-dd HH:mm. If not specified, then the default value will be used, which will be seven days before the current date
endDate
optional
End date in the format yyyy-MM-dd HH:mm. If not specified, then the default value will be used, which will be the current date
split
optional
Can be true or false. If true then stats of individual TSM servers will be retrieved, otherwise results will be combined for all the TSM servers. The default value is false.
reportType
optional
Type of report for which the data is to be retrieved. It can be Capacity Or Performace. If not specified, then the default value Capacity will be used.
Example Result
[
  {
    "DateCreated": "2016-03-11T00:00:00",
    "MaxCapacityMB": 235520,
    "MaxUsedCapacity": 92137,
    "MaxPercentUtilized": 39.120669157608695,
    "FreeMB": 143382,
    "PercentFree": 60.87890625,
    "MinCacheHitPct": 0.0,
    "MaxCacheWaitPct": 0.0,
    "MaxBuffHitRatio": 0.0,
    "ServerName": "TSM-ABC-01",
    "NodeGUID": "7E08BD44-752F-4839-9F2A-840E5CB028A6"
  },
  {
    "DateCreated": "2016-03-10T00:00:00",
    "MaxCapacityMB": 235520,
    "MaxUsedCapacity": 92090,
    "MaxPercentUtilized": 39.100713315217391,
    "FreeMB": 143430,
    "PercentFree": 60.8992866847826,
    "MinCacheHitPct": 0.0,
    "MaxCacheWaitPct": 0.0,
    "MaxBuffHitRatio": 0.0,
    "ServerName": "TSM-XYZ-01",
    "NodeGUID": "6E08BD44-752F-4839-9F2A-840E5CB028A6"
  },
  {
    "DateCreated": "2016-03-09T00:00:00",
    "MaxCapacityMB": 235520,
    "MaxUsedCapacity": 92058,
    "MaxPercentUtilized": 39.087126358695649,
    "FreeMB": 143462,
    "PercentFree": 60.912873641304344,
    "MinCacheHitPct": 0.0,
    "MaxCacheWaitPct": 0.0,
    "MaxBuffHitRatio": 0.0,
    "ServerName": "TSM-ABC-01",
    "NodeGUID": "7E08BD44-752F-4839-9F2A-840E5CB028A6"
  },
  {
    "DateCreated": "2016-03-08T00:00:00",
    "MaxCapacityMB": 235520,
    "MaxUsedCapacity": 92050,
    "MaxPercentUtilized": 39.083729619565219,
    "FreeMB": 143469,
    "PercentFree": 60.915845788043477,
    "MinCacheHitPct": 0.0,
    "MaxCacheWaitPct": 0.0,
    "MaxBuffHitRatio": 0.0,
    "ServerName": "TSM-XYZ-01",
    "NodeGUID": "6E08BD44-752F-4839-9F2A-840E5CB028A6"
  }]