API Documentation

Last Update: 28 December 2022

POST api/MSSQLDatabaseIndexFragmentation



Request Information


URI Parameters

None.


Body Parameters
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.
Request Formats
application/json, text/json
Sample: 
{
  "ID": 1,
  "ReportDate": "2024-11-21T06:28:43.2735892+00: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
}

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-11-21T06:28:43.2735892+00: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
}