SQLAssessmentRecommendation

Recommendations generated by SQL assessments that are started through a scheduled task. When you schedule the assessment it runs by default every 7 days and upload the data into Azure Log Analytics

Table attributes

Attribute	Value
Resource types	microsoft.compute/virtualmachines, microsoft.conenctedvmwarevsphere/virtualmachines, microsoft.azurestackhci/virtualmachines, microsoft.scvmm/virtualmachines
Categories	Workloads
Solutions	AzureResources, SQLAssessment, SQLAssessmentPlus
Basic log	No
Ingestion-time transformation	Yes
Sample Queries	Yes

Columns

Column	Type	Description
ActionArea	string
ActionAreaId	string
AffectedObjectName	string
AffectedObjectResult	string
AffectedObjectType	string
AssessmentId	string
_BilledSize	real	The record size in bytes
Computer	string
CustomData	string
DatabaseName	string
Description	string
FocusArea	string
FocusAreaId	string
_IsBillable	string	Specifies whether ingesting the data is billable. When _IsBillable is false ingestion isn't billed to your Azure account
Recommendation	string
RecommendationId	string
RecommendationResult	string
RecommendationWeight	real
_ResourceId	string	A unique identifier for the resource that the record is associated with
SourceSystem	string	The type of agent the event was collected by. For example, OpsManager for Windows agent, either direct connect or Operations Manager, Linux for all Linux agents, or Azure for Azure Diagnostics
SqlInstanceName	string
_SubscriptionId	string	A unique identifier for the subscription that the record is associated with
Technology	string
TimeGenerated	datetime
Type	string	The name of the table