API Documentation

Last Update: 28 December 2022

GET api/HostMSSQL/{id}



Request Information


URI Parameters
Name Description Type Additional information
id

integer

Required

Body Parameters

None.

Response Information


Resource Description
HostMSSQL
Name Description Type Additional information
ID

integer

None.

ReportDate

date

None.

HostID

integer

None.

AuditLevel

string

None.

BackupDirectory

string

None.

BrowserServiceAccount

string

None.

BrowserStartMode

string

None.

BuildClrVersionString

string

None.

Collation

string

None.

DefaultFile

string

None.

DefaultLog

string

None.

Edition

string

None.

ErrorLogPath

string

None.

FilestreamLevel

string

None.

InstallDataDirectory

string

None.

InstallSharedDirectory

string

None.

InstanceName

string

None.

IsCaseSensitive

string

None.

IsClustered

string

None.

IsFullTextInstalled

string

None.

IsHadrEnabled

string

None.

IsSingleUser

string

None.

IsXTPSupported

string

None.

Language

string

None.

LoginMode

string

None.

MasterDBLogPath

string

None.

MasterDBPath

string

None.

MaxPrecision

integer

None.

NamedPipesEnabled

string

None.

NumberOfLogFiles

integer

None.

PerfMonMode

string

None.

Product

string

None.

ProductLevel

string

None.

ResourceLastUpdateDateTime

string

None.

ResourceVersionString

string

None.

RootDirectory

string

None.

ServiceAccount

string

None.

ServiceInstanceID

string

None.

ServiceName

string

None.

ServiceStartMode

string

None.

SqlCharSet

string

None.

SqlCharSetName

string

None.

SqlDomainGroup

string

None.

SqlSortOrder

integer

None.

SqlSortOrderName

string

None.

Status

string

None.

TcpEnabled

string

None.

VersionMajor

string

None.

VersionMinor

string

None.

Version

string

None.

DefaultTextMode

string

None.

RecordStatus

integer

None.

Response Formats
application/json, text/json
Sample:
{
  "ID": 1,
  "ReportDate": "2024-10-31T04:08:25.505354+00:00",
  "HostID": 3,
  "AuditLevel": "sample string 4",
  "BackupDirectory": "sample string 5",
  "BrowserServiceAccount": "sample string 6",
  "BrowserStartMode": "sample string 7",
  "BuildClrVersionString": "sample string 8",
  "Collation": "sample string 9",
  "DefaultFile": "sample string 10",
  "DefaultLog": "sample string 11",
  "Edition": "sample string 12",
  "ErrorLogPath": "sample string 13",
  "FilestreamLevel": "sample string 14",
  "InstallDataDirectory": "sample string 15",
  "InstallSharedDirectory": "sample string 16",
  "InstanceName": "sample string 17",
  "IsCaseSensitive": "sample string 18",
  "IsClustered": "sample string 19",
  "IsFullTextInstalled": "sample string 20",
  "IsHadrEnabled": "sample string 21",
  "IsSingleUser": "sample string 22",
  "IsXTPSupported": "sample string 23",
  "Language": "sample string 24",
  "LoginMode": "sample string 25",
  "MasterDBLogPath": "sample string 26",
  "MasterDBPath": "sample string 27",
  "MaxPrecision": 28,
  "NamedPipesEnabled": "sample string 29",
  "NumberOfLogFiles": 30,
  "PerfMonMode": "sample string 31",
  "Product": "sample string 32",
  "ProductLevel": "sample string 33",
  "ResourceLastUpdateDateTime": "sample string 34",
  "ResourceVersionString": "sample string 35",
  "RootDirectory": "sample string 36",
  "ServiceAccount": "sample string 37",
  "ServiceInstanceID": "sample string 38",
  "ServiceName": "sample string 39",
  "ServiceStartMode": "sample string 40",
  "SqlCharSet": "sample string 41",
  "SqlCharSetName": "sample string 42",
  "SqlDomainGroup": "sample string 43",
  "SqlSortOrder": 44,
  "SqlSortOrderName": "sample string 45",
  "Status": "sample string 46",
  "TcpEnabled": "sample string 47",
  "VersionMajor": "sample string 48",
  "VersionMinor": "sample string 49",
  "Version": "sample string 50",
  "DefaultTextMode": "sample string 51",
  "RecordStatus": 52
}