Get-AzSecuritySqlVulnerabilityAssessmentScanRecord

  • Referencia
Módulo:
Az.Security

Obtiene el resumen del examen de evaluación de vulnerabilidades de SQL.

Sintaxis

Get-AzSecuritySqlVulnerabilityAssessmentScanRecord
   [-ScanId <String>]
   -ResourceId <String>
   -WorkspaceId <String>
   -Server <String>
   -Database <String>
   [-DefaultProfile <IAzureContextContainer>]
   [<CommonParameters>]
Get-AzSecuritySqlVulnerabilityAssessmentScanRecord
   [-ScanId <String>]
   -WorkspaceId <String>
   -Server <String>
   -Database <String>
   -ComputerName <String>
   -VmUuid <String>
   -AgentId <String>
   -WorkspaceResourceId <String>
   [-DefaultProfile <IAzureContextContainer>]
   [<CommonParameters>]

Description

Obtiene el resumen del examen de evaluación de vulnerabilidades de SQL.

Ejemplos

Ejemplo 1: obtener el resumen del examen para obtener el examen más reciente de SQL Database.

Get-AzSecuritySqlVulnerabilityAssessmentScanRecord -WorkspaceResourceId /subscriptions/f26d1f13-67d5-4ad6-9012-67ca12d2436f/resourcegroups/ahmadtesting/providers/microsoft.operationalinsights/workspaces/ahabas-workspace -ComputerName ahabas-dev01.middleeast.corp.microsoft.com -AgentId 49640166-652f-4ee6-b48b-cfb840b8afe2 -VmUuid 4c4c4544-0030-4b10-8039-b8c04f4a3332 -WorkspaceId  ba7c9d0e-a6e3-4997-b575-cf7a18a98a49 -Server AHABASDEV01SRV -Database master -ScanId "latest"

TriggerType                    : Recurring
State                          : Failed
Server                         : AHABASDEV01SRV
Database                       : master
SqlVersion                     : 14.0.1000.169
StartTime                      : 3/17/2021 1:11:10 AM
EndTime                        : 12/31/9999 9:59:59 PM
HighSeverityFailedRulesCount   : 9
MediumSeverityFailedRulesCount : 2
LowSeverityFailedRulesCount    : 5
TotalPassedRulesCount          : 43
TotalFailedRulesCount          : 16
TotalRulesCount                : 59
IsBaselineApplied              : True
Id                             : /subscriptions/f26d1f13-67d5-4ad6-9012-67ca12d2436f/resourcegroups/ahmadtesting/providers/microsoft.operationalinsights/workspaces/ahabas-workspace/onpremisemachines/ahabas-dev01.middleeast.corp.microsoft.com_49640166-652f-4ee6-b48b-cfb840b8afe2_4c4c4544-0030-4b10-8039-b8c04f4a3332/
                                 sqlServers/AHABASDEV01SRV/databases/master/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/bdbdf860-5d58-464b-ad9a-0125af63c162
Name                           : bdbdf860-5d58-464b-ad9a-0125af63c162
Type                           : Microsoft.Security/sqlVulnerabilityAssessments/scans

Ejemplo de uso de scan id = "latest".

Ejemplo 2: Obtener todos los resúmenes de examen en SQL Database.

Get-AzSecuritySqlVulnerabilityAssessmentScanRecord -WorkspaceResourceId /subscriptions/f26d1f13-67d5-4ad6-9012-67ca12d2436f/resourcegroups/ahmadtesting/providers/microsoft.operationalinsights/workspaces/ahabas-workspace -ComputerName ahabas-dev01.middleeast.corp.microsoft.com -AgentId 49640166-652f-4ee6-b48b-cfb840b8afe2 -VmUuid 4c4c4544-0030-4b10-8039-b8c04f4a3332 -WorkspaceId  ba7c9d0e-a6e3-4997-b575-cf7a18a98a49 -Server AHABASDEV01SRV -Database master

TriggerType                    : Recurring
State                          : Failed
Server                         : AHABASDEV01SRV
Database                       : master
SqlVersion                     : 14.0.1000.169
StartTime                      : 3/17/2021 1:11:10 AM
EndTime                        : 12/31/9999 9:59:59 PM
HighSeverityFailedRulesCount   : 9
MediumSeverityFailedRulesCount : 2
LowSeverityFailedRulesCount    : 5
TotalPassedRulesCount          : 43
TotalFailedRulesCount          : 16
TotalRulesCount                : 59
IsBaselineApplied              : True
Id                             : /subscriptions/f26d1f13-67d5-4ad6-9012-67ca12d2436f/resourcegroups/ahmadtesting/providers/microsoft.operationalinsights/workspaces/ahabas-workspace/onpremisemachines/ahabas-dev01.middleeast.corp.microsoft.com_49640166-652f-4ee6-b48b-cfb840b8afe2_4c4c4544-0030-4b10-8039-b8c04f4a3332/
                                 sqlServers/AHABASDEV01SRV/databases/master/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/bdbdf860-5d58-464b-ad9a-0125af63c162
Name                           : bdbdf860-5d58-464b-ad9a-0125af63c162
Type                           : Microsoft.Security/sqlVulnerabilityAssessments/scans

TriggerType                    : Recurring
State                          : Failed
Server                         : AHABASDEV01SRV
Database                       : master
SqlVersion                     : 14.0.1000.169
StartTime                      : 3/17/2021 12:41:14 AM
EndTime                        : 3/17/2021 1:11:10 AM
HighSeverityFailedRulesCount   : 2
MediumSeverityFailedRulesCount : 0
LowSeverityFailedRulesCount    : 0
TotalPassedRulesCount          : 57
TotalFailedRulesCount          : 2
TotalRulesCount                : 59
IsBaselineApplied              : True
Id                             : /subscriptions/f26d1f13-67d5-4ad6-9012-67ca12d2436f/resourcegroups/ahmadtesting/providers/microsoft.operationalinsights/workspaces/ahabas-workspace/onpremisemachines/ahabas-dev01.middleeast.corp.microsoft.com_49640166-652f-4ee6-b48b-cfb840b8afe2_4c4c4544-0030-4b10-8039-b8c04f4a3332/
                                 sqlServers/AHABASDEV01SRV/databases/master/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/8b2383c3-7c7e-4b6c-9b34-512ce99fd68a
Name                           : 8b2383c3-7c7e-4b6c-9b34-512ce99fd68a
Type                           : Microsoft.Security/sqlVulnerabilityAssessments/scans

TriggerType                    : Recurring
State                          : Passed
Server                         : AHABASDEV01SRV
Database                       : master
SqlVersion                     : 14.0.1000.169
StartTime                      : 2/14/2021 4:27:44 PM
EndTime                        : 3/17/2021 12:41:14 AM
HighSeverityFailedRulesCount   : 0
MediumSeverityFailedRulesCount : 0
LowSeverityFailedRulesCount    : 0
TotalPassedRulesCount          : 59
TotalFailedRulesCount          : 0
TotalRulesCount                : 59
IsBaselineApplied              : True
Id                             : /subscriptions/f26d1f13-67d5-4ad6-9012-67ca12d2436f/resourcegroups/ahmadtesting/providers/microsoft.operationalinsights/workspaces/ahabas-workspace/onpremisemachines/ahabas-dev01.middleeast.corp.microsoft.com_49640166-652f-4ee6-b48b-cfb840b8afe2_4c4c4544-0030-4b10-8039-b8c04f4a3332/
                                 sqlServers/AHABASDEV01SRV/databases/master/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/6845790d-6463-4f45-96e8-76286edf0267
Name                           : 6845790d-6463-4f45-96e8-76286edf0267
Type                           : Microsoft.Security/sqlVulnerabilityAssessments/scans

TriggerType                    : Recurring
State                          : Failed
Server                         : AHABASDEV01SRV
Database                       : master
SqlVersion                     : 14.0.1000.169
StartTime                      : 2/14/2021 3:57:44 PM
EndTime                        : 2/14/2021 4:27:44 PM
HighSeverityFailedRulesCount   : 2
MediumSeverityFailedRulesCount : 0
LowSeverityFailedRulesCount    : 0
TotalPassedRulesCount          : 57
TotalFailedRulesCount          : 2
TotalRulesCount                : 59
IsBaselineApplied              : True
Id                             : /subscriptions/f26d1f13-67d5-4ad6-9012-67ca12d2436f/resourcegroups/ahmadtesting/providers/microsoft.operationalinsights/workspaces/ahabas-workspace/onpremisemachines/ahabas-dev01.middleeast.corp.microsoft.com_49640166-652f-4ee6-b48b-cfb840b8afe2_4c4c4544-0030-4b10-8039-b8c04f4a3332/
                                 sqlServers/AHABASDEV01SRV/databases/master/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/2058a46e-cb5a-4a49-b28a-6576a540dd9d
Name                           : 2058a46e-cb5a-4a49-b28a-6576a540dd9d
Type                           : Microsoft.Security/sqlVulnerabilityAssessments/scans

Ejemplo para Enumerar todos los registros de examen cuando no se especifica un identificador de examen.

Ejemplo 3: Obtener el resumen del examen mediante parámetros de identificador de recurso.

Get-AzSecuritySqlVulnerabilityAssessmentScanRecord -ResourceId /subscriptions/f26d1f13-67d5-4ad6-9012-67ca12d2436f/resourcegroups/ahmadtesting/providers/microsoft.operationalinsights/workspaces/ahabas-workspace/onPremiseMachines/ahabas-dev01.middleeast.corp.microsoft.com_49640166-652f-4ee6-b48b-cfb840b8afe2_4c4c4544-0030-4b10-8039-b8c04f4a3332 -WorkspaceId  ba7c9d0e-a6e3-4997-b575-cf7a18a98a49 -Server AHABASDEV01SRV -Database master -ScanId 169a5f78-acff-4e05-b597-6252af7e6677

TriggerType                    : Recurring
State                          : Failed
Server                         : AHABASDEV01SRV
Database                       : master
SqlVersion                     : 14.0.1000.169
StartTime                      : 11/18/2020 1:10:34 AM
EndTime                        : 11/18/2020 1:40:20 AM
HighSeverityFailedRulesCount   : 9
MediumSeverityFailedRulesCount : 2
LowSeverityFailedRulesCount    : 5
TotalPassedRulesCount          : 43
TotalFailedRulesCount          : 16
TotalRulesCount                : 59
IsBaselineApplied              : True
Id                             : /subscriptions/f26d1f13-67d5-4ad6-9012-67ca12d2436f/resourcegroups/ahmadtesting/provid
                                 ers/microsoft.operationalinsights/workspaces/ahabas-workspace/onpremisemachines/ahabas
                                 -dev01.middleeast.corp.microsoft.com_49640166-652f-4ee6-b48b-cfb840b8afe2_4c4c4544-003
                                 0-4b10-8039-b8c04f4a3332/sqlServers/AHABASDEV01SRV/databases/master/providers/Microsof
                                 t.Security/sqlVulnerabilityAssessments/default/scans/169a5f78-acff-4e05-b597-6252af7e6
                                 677
Name                           : 169a5f78-acff-4e05-b597-6252af7e6677
Type                           : Microsoft.Security/sqlVulnerabilityAssessments/scans

Ejemplo de uso de parámetros de identificador de recurso de Azure. Los recursos admitidos son:

  • ARC: /subscriptions/{subscriptionId}/resourceGroups/{resourceGroup}/providers/Microsoft.HybridCompute/machines/{machineName}
  • VM: /subscriptions/{subscriptionId}/resourceGroups/{resourceGroup}/providers/Microsoft.Compute/virtualMachines/{machineName}
  • Local: /subscriptions/{subscriptionId}/resourceGroups/{resourceGroup}/providers/microsoft.operationalinsights/workspaces/{workspaceName}/onPremiseMachines/{machineName}

Ejemplo 4: Obtención del resumen del examen mediante parámetros locales.

Get-AzSecuritySqlVulnerabilityAssessmentScanRecord -WorkspaceResourceId /subscriptions/f26d1f13-67d5-4ad6-9012-67ca12d2436f/resourcegroups/ahmadtesting/providers/microsoft.operationalinsights/workspaces/ahabas-workspace -ComputerName ahabas-dev01.middleeast.corp.microsoft.com -AgentId 49640166-652f-4ee6-b48b-cfb840b8afe2 -VmUuid 4c4c4544-0030-4b10-8039-b8c04f4a3332 -WorkspaceId  ba7c9d0e-a6e3-4997-b575-cf7a18a98a49 -Server AHABASDEV01SRV -Database master -ScanId bdbdf860-5d58-464b-ad9a-0125af63c162

TriggerType                    : Recurring
State                          : Failed
Server                         : AHABASDEV01SRV
Database                       : master
SqlVersion                     : 14.0.1000.169
StartTime                      : 3/17/2021 1:11:10 AM
EndTime                        : 12/31/9999 9:59:59 PM
HighSeverityFailedRulesCount   : 9
MediumSeverityFailedRulesCount : 2
LowSeverityFailedRulesCount    : 5
TotalPassedRulesCount          : 43
TotalFailedRulesCount          : 16
TotalRulesCount                : 59
IsBaselineApplied              : True
Id                             : /subscriptions/f26d1f13-67d5-4ad6-9012-67ca12d2436f/resourcegroups/ahmadtesting/providers/microsoft.operationalinsights/workspaces/ahabas-workspace/onpremisemachines/ahabas-dev01.middleeast.corp.microsoft.com_49640166-652f-4ee6-b48b-cfb840b8afe2_4c4c4544-0030-4b10-8039-b8c04f4a3332/
                                 sqlServers/AHABASDEV01SRV/databases/master/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/bdbdf860-5d58-464b-ad9a-0125af63c162
Name                           : bdbdf860-5d58-464b-ad9a-0125af63c162
Type                           : Microsoft.Security/sqlVulnerabilityAssessments/scans

Ejemplo de uso de parámetros locales.

Parámetros

-AgentId

Id. del agente: parámetro local

Tipo:String
Posición:Named
Valor predeterminado:None
Requerido:True
Aceptar entrada de canalización:False
Aceptar caracteres comodín:False

-ComputerName

Nombre completo del equipo: parámetro local

Tipo:String
Posición:Named
Valor predeterminado:None
Requerido:True
Aceptar entrada de canalización:False
Aceptar caracteres comodín:False

-Database

Nombre de la base de datos

Tipo:String
Posición:Named
Valor predeterminado:None
Requerido:True
Aceptar entrada de canalización:False
Aceptar caracteres comodín:False

-DefaultProfile

Credenciales, cuenta, inquilino y suscripción usados para la comunicación con Azure.

Tipo:IAzureContextContainer
Alias:AzContext, AzureRmContext, AzureCredential
Posición:Named
Valor predeterminado:None
Requerido:False
Aceptar entrada de canalización:False
Aceptar caracteres comodín:False

-ResourceId

Identificador del recurso de seguridad en el que desea invocar el comando. Los recursos admitidos son:

  • ARC: /subscriptions/{subscriptionId}/resourceGroups/{resourceGroup}/providers/Microsoft.HybridCompute/machines/{machineName}
  • VM: /subscriptions/{subscriptionId}/resourceGroups/{resourceGroup}/providers/Microsoft.Compute/virtualMachines/{machineName}
  • Local: /subscriptions/{subscriptionId}/resourceGroups/{resourceGroup}/providers/microsoft.operationalinsights/workspaces/{workspaceName}/onPremiseMachines/{machineName}
Tipo:String
Posición:Named
Valor predeterminado:None
Requerido:True
Aceptar entrada de canalización:False
Aceptar caracteres comodín:False

-ScanId

Identificador de examen de evaluación de vulnerabilidades: use scanId = "latest" para obtener los resultados más recientes.

Tipo:String
Posición:Named
Valor predeterminado:None
Requerido:False
Aceptar entrada de canalización:False
Aceptar caracteres comodín:False

-Server

Nombre del servidor

Tipo:String
Posición:Named
Valor predeterminado:None
Requerido:True
Aceptar entrada de canalización:False
Aceptar caracteres comodín:False

-VmUuid

Identificador único universal de máquina virtual: parámetro local

Tipo:String
Posición:Named
Valor predeterminado:None
Requerido:True
Aceptar entrada de canalización:False
Aceptar caracteres comodín:False

-WorkspaceId

Identificador de área de trabajo.

Tipo:String
Posición:Named
Valor predeterminado:None
Requerido:True
Aceptar entrada de canalización:False
Aceptar caracteres comodín:False

-WorkspaceResourceId

Identificador de recurso del área de trabajo: parámetro local

Tipo:String
Posición:Named
Valor predeterminado:None
Requerido:True
Aceptar entrada de canalización:False
Aceptar caracteres comodín:False

Entradas

None

Salidas

PSSqlVulnerabilityAssessmentScanRecord