Get-AzSecuritySqlVulnerabilityAssessmentScanRecord
Возвращает сводку проверки уязвимостей SQL.
Синтаксис
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>] Описание
Возвращает сводку проверки уязвимостей SQL.
Примеры
Пример 1. Получение сводки сканирования для последней проверки для База данных SQL.
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Пример использования идентификатора сканирования = "latest".
Пример 2. Получение всех сводок сканирования на База данных SQL.
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Пример для перечисления всех записей сканирования, если идентификатор сканирования не указан.
Пример 3. Получение сводки сканирования с помощью параметров идентификатора ресурса.
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Пример использования параметров идентификатора ресурса Azure. Поддерживаемые ресурсы:
- ARC: /subscriptions/{subscriptionId}/resourceGroups/{resourceGroup}/providers/Microsoft.HybridCompute/machines/{machineName}
- Виртуальная машина: /subscriptions/{subscriptionId}/resourceGroups/{resourceGroup}/providers/Microsoft.Compute/virtualMachines/{machineName}
- Локальная среда: /subscriptions/{subscriptionId}/resourceGroups/{resourceGroup}/providers/microsoft.operationalinsights/workspaces/{workspaceName}/onPremiseMachines/{machineName}
Пример 4. Получение сводки сканирования с помощью локальных параметров.
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Пример использования локальных параметров.
Параметры
-AgentId
Идентификатор агента — локальный параметр
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ComputerName
Полное имя компьютера — локальный параметр
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Database
Имя базы данных
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DefaultProfile
Учетные данные, учетная запись, клиент и подписка, используемые для взаимодействия с Azure.
| Type: | IAzureContextContainer |
| Aliases: | AzContext, AzureRmContext, AzureCredential |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ResourceId
Идентификатор ресурса безопасности, в который требуется вызвать команду. Поддерживаемые ресурсы:
- ARC: /subscriptions/{subscriptionId}/resourceGroups/{resourceGroup}/providers/Microsoft.HybridCompute/machines/{machineName}
- Виртуальная машина: /subscriptions/{subscriptionId}/resourceGroups/{resourceGroup}/providers/Microsoft.Compute/virtualMachines/{machineName}
- Локальная среда: /subscriptions/{subscriptionId}/resourceGroups/{resourceGroup}/providers/microsoft.operationalinsights/workspaces/{workspaceName}/onPremiseMachines/{machineName}
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ScanId
Идентификатор проверки уязвимостей — используйте scanId = "latest" для получения последних результатов
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Server
Имя сервера
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-VmUuid
Универсальный уникальный идентификатор виртуальной машины — локальный параметр
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-WorkspaceId
Идентификатор рабочей области.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-WorkspaceResourceId
Идентификатор ресурса рабочей области — локальный параметр
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Входные данные
None
Выходные данные
Совместная работа с нами на GitHub
Источник этого содержимого можно найти на GitHub, где также можно создавать и просматривать проблемы и запросы на вытягивание. Дополнительные сведения см. в нашем руководстве для участников.
Azure PowerShell
Обратная связь
Ожидается в ближайшее время: в течение 2024 года мы постепенно откажемся от GitHub Issues как механизма обратной связи для контента и заменим его новой системой обратной связи. Дополнительные сведения см. в разделе https://aka.ms/ContentUserFeedback.
Отправить и просмотреть отзыв по