GET monitor/{id}/sqlInfo?sqlInfoId={sqlInfoId}
Retrieves SQL Information for the specified SqlProfileId and SqlInfoId
Request Information
URI Parameters
| Name | Description | Type | Additional information |
|---|---|---|---|
| id | System.Guid | Required | |
| sqlInfoId | System.Guid | None |
Body Parameters
None
Response Information
Resource Description
Epic.Customer.Api.ResponseModels.SqlResponses.SqlInfoResponse
| Name | Description | Type | Additional information |
|---|---|---|---|
| MachineId | System.Guid | None | |
| SqlProfileId | System.Guid | None | |
| SqlVersion | System.String | None | |
| SqlEdition | System.String | None | |
| ServerCurrentTimeUtc | System.DateTime | None | |
| ConnectionString | System.String | None | |
| CurrentTime | System.DateTimeOffset | None | |
| LastCollected | System.DateTimeOffset | None | |
| CollectIntervalMin | System.Int32 | None | |
| ModifiedDate | System.DateTimeOffset | None | |
| LastTimeCollectError | System.DateTimeOffset | None | |
| LastErrorMessage | System.String | None | |
| FriendlyName | System.String | None | |
| SessionInfo | Epic.Customer.Api.ResponseModels.SqlResponses.SessionInfoResponse | None | |
| ProcessInfo | Epic.Customer.Api.ResponseModels.SqlResponses.ProceInfoResponse | None | |
| MemoryInfo | Epic.Customer.Api.ResponseModels.SqlResponses.MemoryInfoResponse | None | |
| DatabaseInfo | Epic.Customer.Api.ResponseModels.SqlResponses.DatabaseInfoResponse | None | |
| WaitStatsInfo | Epic.Customer.Api.ResponseModels.SqlResponses.WaitStatsInfoResponse | None | |
| QueryInfo | Epic.Customer.Api.ResponseModels.SqlResponses.QueryInfoResponse | None | |
| PageInfo | Epic.Customer.Api.ResponseModels.SqlResponses.PageInfoResponse | None | |
| PacketInfo | Epic.Customer.Api.ResponseModels.SqlResponses.PacketInfoResponse | None | |
| IoStalInfo | Epic.Customer.Api.ResponseModels.SqlResponses.IoStalInfoResponse | None | |
| AzureInfo | Epic.Customer.Api.ResponseModels.SqlResponses.AzureInfoResponse | None | |
| AgBriefInfo | System.Collections.Generic.List`1[Epic.Customer.Api.ResponseModels.SqlResponses.AgBriefInfo] | None | |
| IoStallItems | System.Collections.Generic.List`1[Epic.Data.Models.IoStallItem] | None | |
| AzureGeoRepl | System.Collections.Generic.List`1[Epic.Customer.Api.ResponseModels.SqlResponses.AzureGeoReplResponse] | None | |
| SelectedSqlInfoId | System.Guid | None | |
| RefreshEnabled | System.Boolean | None | |
| CpuUsage | System.Decimal | None | |
| SqlConfigurations | System.Collections.Generic.List`1[Epic.Customer.Api.ResponseModels.SqlResponses.BriefSqlConfigurationItem] | None | |
| MinServerMemoryMb | System.Int32 | None | |
| MaxServerMemoryMb | System.Int32 | None | |
| ServerName | System.String | None | |
| IsOnline | System.Boolean | None | |
| SqlProfileStatus | System.String | None | |
| IsAzureDatabase | System.Boolean | None | |
| SqlInfoId | System.Guid | None | |
| TimeCollected | System.DateTimeOffset | None |