API Documentation

Last Update: 28 December 2022

GET api/MSSQLDatabaseIndexFragmentation/{id}



Request Information


URI Parameters
Name Description Type Additional information
id

integer

Required

Body Parameters

None.

Response Information


Resource Description
MSSQLDatabaseIndexFragmentation
Name Description Type Additional information
ID

integer

None.

ReportDate

date

None.

DatabaseLocalID

integer

None.

HostID

integer

None.

DatabaseGuid

string

None.

TableName

string

None.

IndexID

integer

None.

IndexName

string

None.

FragmentationPercent

integer

None.

FragmentCount

integer

None.

AvgFragmentSizeInPages

integer

None.

TotalPageCount

integer

None.

RecordStatus

integer

None.

Response Formats
application/json, text/json
Sample:
{
  "ID": 1,
  "ReportDate": "2024-02-29T18:32:12.9392817+01:00",
  "DatabaseLocalID": 3,
  "HostID": 4,
  "DatabaseGuid": "sample string 5",
  "TableName": "sample string 6",
  "IndexID": 7,
  "IndexName": "sample string 8",
  "FragmentationPercent": 9,
  "FragmentCount": 10,
  "AvgFragmentSizeInPages": 11,
  "TotalPageCount": 12,
  "RecordStatus": 13
}