GET monitor/{id}/sqlInfo?sqlInfoId={sqlInfoId}

Retrieves SQL Information for the specified SqlProfileId and SqlInfoId

Request Information

URI Parameters

NameDescriptionTypeAdditional information
id System.Guid Required
sqlInfoId System.Guid None

Body Parameters

None

Response Information

Resource Description

Epic.Customer.Api.ResponseModels.SqlResponses.SqlInfoResponse
NameDescriptionTypeAdditional 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