Get-AzSecuritySqlVulnerabilityAssessmentScanRecord

  • リファレンス
モジュール:
Az.Security

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 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

スキャン ID = "latest" を使用する例。

例 2: 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

スキャン ID が指定されていない場合に、すべてのスキャン レコードを一覧表示する例。

例 3: リソース ID パラメーターを使用してスキャンの概要を取得する。

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 リソース ID パラメーターの使用例。 サポートされているリソースは次のとおりです。

  • ARC: /subscriptions/{subscriptionId}/resourceGroups/{resourceGroup}/providers/Microsoft.HybridCompute/machines/{machineName}
  • VM: /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

エージェント ID - オンプレミス パラメーター

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

コマンドを呼び出すセキュリティ リソースの ID。 サポートされているリソースは次のとおりです。

  • ARC: /subscriptions/{subscriptionId}/resourceGroups/{resourceGroup}/providers/Microsoft.HybridCompute/machines/{machineName}
  • VM: /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

脆弱性評価スキャン ID - 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

ワークスペース ID。

Type:String
Position:Named
Default value:None
Required:True
Accept pipeline input:False
Accept wildcard characters:False

-WorkspaceResourceId

ワークスペース リソース ID - オンプレミス パラメーター

Type:String
Position:Named
Default value:None
Required:True
Accept pipeline input:False
Accept wildcard characters:False

入力

None

出力

PSSqlVulnerabilityAssessmentScanRecord