Gets summary of database stats for a particular day
| Requires authentication? | Yes (HTTP authentication using user name and API key) |
| Response formats | JSON |
api/database/detailsbydate?organisationId=5&startDate=2016-01-01 00:00
| 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 |
[
{
"ServerName": "TSM-ABC-01",
"DateTimeCreated": "2016-03-11T10:15:05",
"CapacityMB": 117760,
"UsedCapacity": 49305,
"PctUtilized": 41.0,
"BuffHitRatio": 99.3,
"FreeSpaceMB": 68454,
"LastBackupDate": "2016-03-11T06:00:26",
"LastReOrg": "2016-03-11T06:27:52",
"Location": "C:\\tsminst1\\tsmdbspace1\\db",
"CacheHitPct": 0.0,
"CacheWaitPct": 0.0,
"NodeGUID": "00000000-0000-0000-0000-000000000000"
},
{
"ServerName": "TSM-DEF-01",
"DateTimeCreated": "2016-03-11T10:15:05",
"CapacityMB": 117760,
"UsedCapacity": 49306,
"PctUtilized": 41.0,
"BuffHitRatio": 99.3,
"FreeSpaceMB": 68453,
"LastBackupDate": "2016-03-11T06:00:26",
"LastReOrg": "2016-03-11T06:27:52",
"Location": "C:\\tsminst1\\tsmdbspace2\\db",
"CacheHitPct": 0.0,
"CacheWaitPct": 0.0,
"NodeGUID": "00000000-0000-0000-0000-000000000000"
},
{
"ServerName": "TSM-GHI-01",
"DateTimeCreated": "2016-03-11T10:15:05",
"CapacityMB": 117760,
"UsedCapacity": 49306,
"PctUtilized": 41.0,
"BuffHitRatio": 99.3,
"FreeSpaceMB": 68453,
"LastBackupDate": "2016-03-11T06:00:26",
"LastReOrg": "2016-03-11T06:27:52",
"Location": "C:\\tsminst1\\tsmdbspace3\\db",
"CacheHitPct": 0.0,
"CacheWaitPct": 0.0,
"NodeGUID": "00000000-0000-0000-0000-000000000000"
},
{
"ServerName": "TSM-ABC-01",
"DateTimeCreated": "2016-03-11T10:15:05",
"CapacityMB": 117760,
"UsedCapacity": 49306,
"PctUtilized": 41.0,
"BuffHitRatio": 99.3,
"FreeSpaceMB": 68453,
"LastBackupDate": "2016-03-11T06:00:26",
"LastReOrg": "2016-03-11T06:27:52",
"Location": "C:\\tsminst1\\tsmdbspace4\\db",
"CacheHitPct": 0.0,
"CacheWaitPct": 0.0,
"NodeGUID": "00000000-0000-0000-0000-000000000000"
}]