검사 레코드 목록을 가져옵니다.
GET https://management.azure.com/{resourceId}/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans?api-version=2026-04-01-preview
선택적 매개 변수:
GET https://management.azure.com/{resourceId}/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans?api-version=2026-04-01-preview&databaseName={databaseName}
URI 매개 변수
| Name |
In(다음 안에) |
필수 |
형식 |
Description |
|
resourceId
|
path |
True
|
string
|
리소스의 완전 자격화된 Azure 리소스 관리자 식별자입니다.
|
|
api-version
|
query |
True
|
string
minLength: 1
|
이 작업에 사용할 API 버전입니다.
|
|
databaseName
|
query |
|
string
|
평가할 데이터베이스 이름입니다. API가 특정 데이터베이스 자원이 아닌 상위 리소스(예: 서버 수준)에서 호출될 때 필요한데, 데이터베이스 이름이 리소스 URI의 일부가 아니기 때문입니다. 이 방법은 시스템 데이터베이스(예: 마스터)를 평가하는 유일한 방법이며, URI 리소스에서 직접 참조할 수 없습니다.
|
응답
보안
azure_auth
Azure Active Directory OAuth2 흐름.
형식:
oauth2
Flow:
implicit
권한 부여 URL:
https://login.microsoftonline.com/common/oauth2/authorize
범위
| Name |
Description |
|
user_impersonation
|
사용자 계정 가장
|
예제
List scans on a resource (using databaseName parameter) - Sql Managed Instance
샘플 요청
GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/managedInstances/myManagedInstance/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans?api-version=2026-04-01-preview&databaseName=master
package armsecurity_test
import (
"context"
"log"
"github.com/Azure/azure-sdk-for-go/sdk/azcore/to"
"github.com/Azure/azure-sdk-for-go/sdk/azidentity"
"github.com/Azure/azure-sdk-for-go/sdk/resourcemanager/security/armsecurity"
)
// Generated from example definition: 2026-04-01-preview/sqlVulnerabilityAssessmentsScanOperations/ServerLevel_SqlManagedInstanceScans_List.json
func ExampleSQLVulnerabilityAssessmentScansClient_NewListPager_listScansOnAResourceUsingDatabaseNameParameterSqlManagedInstance() {
cred, err := azidentity.NewDefaultAzureCredential(nil)
if err != nil {
log.Fatalf("failed to obtain a credential: %v", err)
}
ctx := context.Background()
clientFactory, err := armsecurity.NewClientFactory("<subscriptionID>", cred, nil)
if err != nil {
log.Fatalf("failed to create client: %v", err)
}
pager := clientFactory.NewSQLVulnerabilityAssessmentScansClient().NewListPager("subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/managedInstances/myManagedInstance", &armsecurity.SQLVulnerabilityAssessmentScansClientListOptions{
DatabaseName: to.Ptr("master")})
for pager.More() {
page, err := pager.NextPage(ctx)
if err != nil {
log.Fatalf("failed to advance page: %v", err)
}
for _, v := range page.Value {
// You could use page here. We use blank identifier for just demo purposes.
_ = v
}
// If the HTTP response code is 200 as defined in example definition, your page structure would look as follows. Please pay attention that all the values in the output are fake values for just demo purposes.
// page = armsecurity.SQLVulnerabilityAssessmentScansClientListResponse{
// ScansV2: armsecurity.ScansV2{
// Value: []*armsecurity.ScanV2{
// {
// Name: to.Ptr("Scheduled-20200623"),
// Type: to.Ptr("Microsoft.Security/sqlVulnerabilityAssessments/scans"),
// ID: to.Ptr("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/managedInstances/myManagedInstance/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200623"),
// Properties: &armsecurity.ScanPropertiesV2{
// Database: to.Ptr("master"),
// EndTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:18.5765264Z"); return t}()),
// HighSeverityFailedRulesCount: to.Ptr[int32](0),
// IsBaselineApplied: to.Ptr(true),
// LastScanTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:18.5765264Z"); return t}()),
// LowSeverityFailedRulesCount: to.Ptr[int32](0),
// MediumSeverityFailedRulesCount: to.Ptr[int32](0),
// Server: to.Ptr("myManagedInstance"),
// SQLVersion: to.Ptr("15.0.4043"),
// StartTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:00.6455136Z"); return t}()),
// State: to.Ptr(armsecurity.ScanStatePassed),
// TotalFailedRulesCount: to.Ptr[int32](0),
// TotalPassedRulesCount: to.Ptr[int32](18),
// TotalRulesCount: to.Ptr[int32](18),
// TriggerType: to.Ptr(armsecurity.ScanTriggerTypeRecurring),
// },
// },
// {
// Name: to.Ptr("Scheduled-20200620"),
// Type: to.Ptr("Microsoft.Security/sqlVulnerabilityAssessments/scans"),
// ID: to.Ptr("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/managedInstances/myManagedInstance/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200620"),
// Properties: &armsecurity.ScanPropertiesV2{
// Database: to.Ptr("master"),
// EndTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:18.5765264Z"); return t}()),
// HighSeverityFailedRulesCount: to.Ptr[int32](1),
// IsBaselineApplied: to.Ptr(true),
// LastScanTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:18.5765264Z"); return t}()),
// LowSeverityFailedRulesCount: to.Ptr[int32](1),
// MediumSeverityFailedRulesCount: to.Ptr[int32](2),
// Server: to.Ptr("myManagedInstance"),
// SQLVersion: to.Ptr("15.0.4043"),
// StartTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:00.6455136Z"); return t}()),
// State: to.Ptr(armsecurity.ScanStateFailed),
// TotalFailedRulesCount: to.Ptr[int32](4),
// TotalPassedRulesCount: to.Ptr[int32](14),
// TotalRulesCount: to.Ptr[int32](18),
// TriggerType: to.Ptr(armsecurity.ScanTriggerTypeRecurring),
// },
// },
// },
// },
// }
}
}
To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue
샘플 응답
{
"value": [
{
"name": "Scheduled-20200623",
"type": "Microsoft.Security/sqlVulnerabilityAssessments/scans",
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/managedInstances/myManagedInstance/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200623",
"properties": {
"database": "master",
"endTime": "2020-06-23T06:49:18.5765264Z",
"highSeverityFailedRulesCount": 0,
"isBaselineApplied": true,
"lastScanTime": "2020-06-23T06:49:18.5765264Z",
"lowSeverityFailedRulesCount": 0,
"mediumSeverityFailedRulesCount": 0,
"server": "myManagedInstance",
"sqlVersion": "15.0.4043",
"startTime": "2020-06-23T06:49:00.6455136Z",
"state": "Passed",
"totalFailedRulesCount": 0,
"totalPassedRulesCount": 18,
"totalRulesCount": 18,
"triggerType": "Recurring"
}
},
{
"name": "Scheduled-20200620",
"type": "Microsoft.Security/sqlVulnerabilityAssessments/scans",
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/managedInstances/myManagedInstance/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200620",
"properties": {
"database": "master",
"endTime": "2020-06-20T06:49:18.5765264Z",
"highSeverityFailedRulesCount": 1,
"isBaselineApplied": true,
"lastScanTime": "2020-06-20T06:49:18.5765264Z",
"lowSeverityFailedRulesCount": 1,
"mediumSeverityFailedRulesCount": 2,
"server": "myManagedInstance",
"sqlVersion": "15.0.4043",
"startTime": "2020-06-20T06:49:00.6455136Z",
"state": "Failed",
"totalFailedRulesCount": 4,
"totalPassedRulesCount": 14,
"totalRulesCount": 18,
"triggerType": "Recurring"
}
}
]
}
List scans on a resource (using databaseName parameter) - Sql Server
샘플 요청
GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/servers/myServer/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans?api-version=2026-04-01-preview&databaseName=master
package armsecurity_test
import (
"context"
"log"
"github.com/Azure/azure-sdk-for-go/sdk/azcore/to"
"github.com/Azure/azure-sdk-for-go/sdk/azidentity"
"github.com/Azure/azure-sdk-for-go/sdk/resourcemanager/security/armsecurity"
)
// Generated from example definition: 2026-04-01-preview/sqlVulnerabilityAssessmentsScanOperations/ServerLevel_SqlServerScans_List.json
func ExampleSQLVulnerabilityAssessmentScansClient_NewListPager_listScansOnAResourceUsingDatabaseNameParameterSqlServer() {
cred, err := azidentity.NewDefaultAzureCredential(nil)
if err != nil {
log.Fatalf("failed to obtain a credential: %v", err)
}
ctx := context.Background()
clientFactory, err := armsecurity.NewClientFactory("<subscriptionID>", cred, nil)
if err != nil {
log.Fatalf("failed to create client: %v", err)
}
pager := clientFactory.NewSQLVulnerabilityAssessmentScansClient().NewListPager("subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/servers/myServer", &armsecurity.SQLVulnerabilityAssessmentScansClientListOptions{
DatabaseName: to.Ptr("master")})
for pager.More() {
page, err := pager.NextPage(ctx)
if err != nil {
log.Fatalf("failed to advance page: %v", err)
}
for _, v := range page.Value {
// You could use page here. We use blank identifier for just demo purposes.
_ = v
}
// If the HTTP response code is 200 as defined in example definition, your page structure would look as follows. Please pay attention that all the values in the output are fake values for just demo purposes.
// page = armsecurity.SQLVulnerabilityAssessmentScansClientListResponse{
// ScansV2: armsecurity.ScansV2{
// Value: []*armsecurity.ScanV2{
// {
// Name: to.Ptr("Scheduled-20200623"),
// Type: to.Ptr("Microsoft.Security/sqlVulnerabilityAssessments/scans"),
// ID: to.Ptr("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/servers/myServer/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200623"),
// Properties: &armsecurity.ScanPropertiesV2{
// Database: to.Ptr("master"),
// EndTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:18.5765264Z"); return t}()),
// HighSeverityFailedRulesCount: to.Ptr[int32](0),
// IsBaselineApplied: to.Ptr(true),
// LastScanTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:18.5765264Z"); return t}()),
// LowSeverityFailedRulesCount: to.Ptr[int32](0),
// MediumSeverityFailedRulesCount: to.Ptr[int32](0),
// Server: to.Ptr("myServer"),
// SQLVersion: to.Ptr("15.0.4043"),
// StartTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:00.6455136Z"); return t}()),
// State: to.Ptr(armsecurity.ScanStatePassed),
// TotalFailedRulesCount: to.Ptr[int32](0),
// TotalPassedRulesCount: to.Ptr[int32](18),
// TotalRulesCount: to.Ptr[int32](18),
// TriggerType: to.Ptr(armsecurity.ScanTriggerTypeRecurring),
// },
// },
// {
// Name: to.Ptr("Scheduled-20200620"),
// Type: to.Ptr("Microsoft.Security/sqlVulnerabilityAssessments/scans"),
// ID: to.Ptr("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/servers/myServer/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200620"),
// Properties: &armsecurity.ScanPropertiesV2{
// Database: to.Ptr("master"),
// EndTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:18.5765264Z"); return t}()),
// HighSeverityFailedRulesCount: to.Ptr[int32](1),
// IsBaselineApplied: to.Ptr(true),
// LastScanTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:18.5765264Z"); return t}()),
// LowSeverityFailedRulesCount: to.Ptr[int32](1),
// MediumSeverityFailedRulesCount: to.Ptr[int32](2),
// Server: to.Ptr("myServer"),
// SQLVersion: to.Ptr("15.0.4043"),
// StartTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:00.6455136Z"); return t}()),
// State: to.Ptr(armsecurity.ScanStateFailed),
// TotalFailedRulesCount: to.Ptr[int32](4),
// TotalPassedRulesCount: to.Ptr[int32](14),
// TotalRulesCount: to.Ptr[int32](18),
// TriggerType: to.Ptr(armsecurity.ScanTriggerTypeRecurring),
// },
// },
// },
// },
// }
}
}
To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue
샘플 응답
{
"value": [
{
"name": "Scheduled-20200623",
"type": "Microsoft.Security/sqlVulnerabilityAssessments/scans",
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/servers/myServer/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200623",
"properties": {
"database": "master",
"endTime": "2020-06-23T06:49:18.5765264Z",
"highSeverityFailedRulesCount": 0,
"isBaselineApplied": true,
"lastScanTime": "2020-06-23T06:49:18.5765264Z",
"lowSeverityFailedRulesCount": 0,
"mediumSeverityFailedRulesCount": 0,
"server": "myServer",
"sqlVersion": "15.0.4043",
"startTime": "2020-06-23T06:49:00.6455136Z",
"state": "Passed",
"totalFailedRulesCount": 0,
"totalPassedRulesCount": 18,
"totalRulesCount": 18,
"triggerType": "Recurring"
}
},
{
"name": "Scheduled-20200620",
"type": "Microsoft.Security/sqlVulnerabilityAssessments/scans",
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/servers/myServer/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200620",
"properties": {
"database": "master",
"endTime": "2020-06-20T06:49:18.5765264Z",
"highSeverityFailedRulesCount": 1,
"isBaselineApplied": true,
"lastScanTime": "2020-06-20T06:49:18.5765264Z",
"lowSeverityFailedRulesCount": 1,
"mediumSeverityFailedRulesCount": 2,
"server": "myServer",
"sqlVersion": "15.0.4043",
"startTime": "2020-06-20T06:49:00.6455136Z",
"state": "Failed",
"totalFailedRulesCount": 4,
"totalPassedRulesCount": 14,
"totalRulesCount": 18,
"triggerType": "Recurring"
}
}
]
}
List scans on a resource (using databaseName parameter) - Synapse
샘플 요청
GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Synapse/workspaces/myWorkspace/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans?api-version=2026-04-01-preview&databaseName=master
package armsecurity_test
import (
"context"
"log"
"github.com/Azure/azure-sdk-for-go/sdk/azcore/to"
"github.com/Azure/azure-sdk-for-go/sdk/azidentity"
"github.com/Azure/azure-sdk-for-go/sdk/resourcemanager/security/armsecurity"
)
// Generated from example definition: 2026-04-01-preview/sqlVulnerabilityAssessmentsScanOperations/ServerLevel_SynapseScans_List.json
func ExampleSQLVulnerabilityAssessmentScansClient_NewListPager_listScansOnAResourceUsingDatabaseNameParameterSynapse() {
cred, err := azidentity.NewDefaultAzureCredential(nil)
if err != nil {
log.Fatalf("failed to obtain a credential: %v", err)
}
ctx := context.Background()
clientFactory, err := armsecurity.NewClientFactory("<subscriptionID>", cred, nil)
if err != nil {
log.Fatalf("failed to create client: %v", err)
}
pager := clientFactory.NewSQLVulnerabilityAssessmentScansClient().NewListPager("subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Synapse/workspaces/myWorkspace", &armsecurity.SQLVulnerabilityAssessmentScansClientListOptions{
DatabaseName: to.Ptr("master")})
for pager.More() {
page, err := pager.NextPage(ctx)
if err != nil {
log.Fatalf("failed to advance page: %v", err)
}
for _, v := range page.Value {
// You could use page here. We use blank identifier for just demo purposes.
_ = v
}
// If the HTTP response code is 200 as defined in example definition, your page structure would look as follows. Please pay attention that all the values in the output are fake values for just demo purposes.
// page = armsecurity.SQLVulnerabilityAssessmentScansClientListResponse{
// ScansV2: armsecurity.ScansV2{
// Value: []*armsecurity.ScanV2{
// {
// Name: to.Ptr("Scheduled-20200623"),
// Type: to.Ptr("Microsoft.Security/sqlVulnerabilityAssessments/scans"),
// ID: to.Ptr("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Synapse/workspaces/myWorkspace/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200623"),
// Properties: &armsecurity.ScanPropertiesV2{
// Database: to.Ptr("master"),
// EndTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:18.5765264Z"); return t}()),
// HighSeverityFailedRulesCount: to.Ptr[int32](0),
// IsBaselineApplied: to.Ptr(true),
// LastScanTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:18.5765264Z"); return t}()),
// LowSeverityFailedRulesCount: to.Ptr[int32](0),
// MediumSeverityFailedRulesCount: to.Ptr[int32](0),
// Server: to.Ptr("myWorkspace"),
// SQLVersion: to.Ptr("15.0.4043"),
// StartTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:00.6455136Z"); return t}()),
// State: to.Ptr(armsecurity.ScanStatePassed),
// TotalFailedRulesCount: to.Ptr[int32](0),
// TotalPassedRulesCount: to.Ptr[int32](18),
// TotalRulesCount: to.Ptr[int32](18),
// TriggerType: to.Ptr(armsecurity.ScanTriggerTypeRecurring),
// },
// },
// {
// Name: to.Ptr("Scheduled-20200620"),
// Type: to.Ptr("Microsoft.Security/sqlVulnerabilityAssessments/scans"),
// ID: to.Ptr("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Synapse/workspaces/myWorkspace/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200620"),
// Properties: &armsecurity.ScanPropertiesV2{
// Database: to.Ptr("master"),
// EndTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:18.5765264Z"); return t}()),
// HighSeverityFailedRulesCount: to.Ptr[int32](1),
// IsBaselineApplied: to.Ptr(true),
// LastScanTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:18.5765264Z"); return t}()),
// LowSeverityFailedRulesCount: to.Ptr[int32](1),
// MediumSeverityFailedRulesCount: to.Ptr[int32](2),
// Server: to.Ptr("myWorkspace"),
// SQLVersion: to.Ptr("15.0.4043"),
// StartTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:00.6455136Z"); return t}()),
// State: to.Ptr(armsecurity.ScanStateFailed),
// TotalFailedRulesCount: to.Ptr[int32](4),
// TotalPassedRulesCount: to.Ptr[int32](14),
// TotalRulesCount: to.Ptr[int32](18),
// TriggerType: to.Ptr(armsecurity.ScanTriggerTypeRecurring),
// },
// },
// },
// },
// }
}
}
To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue
샘플 응답
{
"value": [
{
"name": "Scheduled-20200623",
"type": "Microsoft.Security/sqlVulnerabilityAssessments/scans",
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Synapse/workspaces/myWorkspace/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200623",
"properties": {
"database": "master",
"endTime": "2020-06-23T06:49:18.5765264Z",
"highSeverityFailedRulesCount": 0,
"isBaselineApplied": true,
"lastScanTime": "2020-06-23T06:49:18.5765264Z",
"lowSeverityFailedRulesCount": 0,
"mediumSeverityFailedRulesCount": 0,
"server": "myWorkspace",
"sqlVersion": "15.0.4043",
"startTime": "2020-06-23T06:49:00.6455136Z",
"state": "Passed",
"totalFailedRulesCount": 0,
"totalPassedRulesCount": 18,
"totalRulesCount": 18,
"triggerType": "Recurring"
}
},
{
"name": "Scheduled-20200620",
"type": "Microsoft.Security/sqlVulnerabilityAssessments/scans",
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Synapse/workspaces/myWorkspace/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200620",
"properties": {
"database": "master",
"endTime": "2020-06-20T06:49:18.5765264Z",
"highSeverityFailedRulesCount": 1,
"isBaselineApplied": true,
"lastScanTime": "2020-06-20T06:49:18.5765264Z",
"lowSeverityFailedRulesCount": 1,
"mediumSeverityFailedRulesCount": 2,
"server": "myWorkspace",
"sqlVersion": "15.0.4043",
"startTime": "2020-06-20T06:49:00.6455136Z",
"state": "Failed",
"totalFailedRulesCount": 4,
"totalPassedRulesCount": 14,
"totalRulesCount": 18,
"triggerType": "Recurring"
}
}
]
}
List scans on a resource - Arc Machine
샘플 요청
GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.HybridCompute/machines/MyMachine/sqlServers/server1/databases/master/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans?api-version=2026-04-01-preview
package armsecurity_test
import (
"context"
"log"
"github.com/Azure/azure-sdk-for-go/sdk/azidentity"
"github.com/Azure/azure-sdk-for-go/sdk/resourcemanager/security/armsecurity"
)
// Generated from example definition: 2026-04-01-preview/sqlVulnerabilityAssessmentsScanOperations/ArcMachineScans_List.json
func ExampleSQLVulnerabilityAssessmentScansClient_NewListPager_listScansOnAResourceArcMachine() {
cred, err := azidentity.NewDefaultAzureCredential(nil)
if err != nil {
log.Fatalf("failed to obtain a credential: %v", err)
}
ctx := context.Background()
clientFactory, err := armsecurity.NewClientFactory("<subscriptionID>", cred, nil)
if err != nil {
log.Fatalf("failed to create client: %v", err)
}
pager := clientFactory.NewSQLVulnerabilityAssessmentScansClient().NewListPager("subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.HybridCompute/machines/MyMachine/sqlServers/server1/databases/master", nil)
for pager.More() {
page, err := pager.NextPage(ctx)
if err != nil {
log.Fatalf("failed to advance page: %v", err)
}
for _, v := range page.Value {
// You could use page here. We use blank identifier for just demo purposes.
_ = v
}
// If the HTTP response code is 200 as defined in example definition, your page structure would look as follows. Please pay attention that all the values in the output are fake values for just demo purposes.
// page = armsecurity.SQLVulnerabilityAssessmentScansClientListResponse{
// ScansV2: armsecurity.ScansV2{
// Value: []*armsecurity.ScanV2{
// {
// Name: to.Ptr("Scheduled-20200623"),
// Type: to.Ptr("Microsoft.Security/sqlVulnerabilityAssessments/scans"),
// ID: to.Ptr("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.HybridCompute/machines/MyMachine/sqlServers/server1/databases/master/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200623"),
// Properties: &armsecurity.ScanPropertiesV2{
// Database: to.Ptr("master"),
// EndTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:18.5765264Z"); return t}()),
// HighSeverityFailedRulesCount: to.Ptr[int32](0),
// IsBaselineApplied: to.Ptr(true),
// LastScanTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:18.5765264Z"); return t}()),
// LowSeverityFailedRulesCount: to.Ptr[int32](0),
// MediumSeverityFailedRulesCount: to.Ptr[int32](0),
// Server: to.Ptr("server1"),
// SQLVersion: to.Ptr("15.0.4043"),
// StartTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:00.6455136Z"); return t}()),
// State: to.Ptr(armsecurity.ScanStatePassed),
// TotalFailedRulesCount: to.Ptr[int32](0),
// TotalPassedRulesCount: to.Ptr[int32](18),
// TotalRulesCount: to.Ptr[int32](18),
// TriggerType: to.Ptr(armsecurity.ScanTriggerTypeRecurring),
// },
// },
// {
// Name: to.Ptr("Scheduled-20200620"),
// Type: to.Ptr("Microsoft.Security/sqlVulnerabilityAssessments/scans"),
// ID: to.Ptr("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.HybridCompute/machines/MyMachine/sqlServers/server1/databases/master/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200620"),
// Properties: &armsecurity.ScanPropertiesV2{
// Database: to.Ptr("master"),
// EndTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:18.5765264Z"); return t}()),
// HighSeverityFailedRulesCount: to.Ptr[int32](1),
// IsBaselineApplied: to.Ptr(true),
// LastScanTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:18.5765264Z"); return t}()),
// LowSeverityFailedRulesCount: to.Ptr[int32](1),
// MediumSeverityFailedRulesCount: to.Ptr[int32](2),
// Server: to.Ptr("server1"),
// SQLVersion: to.Ptr("15.0.4043"),
// StartTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:00.6455136Z"); return t}()),
// State: to.Ptr(armsecurity.ScanStateFailed),
// TotalFailedRulesCount: to.Ptr[int32](4),
// TotalPassedRulesCount: to.Ptr[int32](14),
// TotalRulesCount: to.Ptr[int32](18),
// TriggerType: to.Ptr(armsecurity.ScanTriggerTypeRecurring),
// },
// },
// },
// },
// }
}
}
To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue
샘플 응답
{
"value": [
{
"name": "Scheduled-20200623",
"type": "Microsoft.Security/sqlVulnerabilityAssessments/scans",
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.HybridCompute/machines/MyMachine/sqlServers/server1/databases/master/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200623",
"properties": {
"database": "master",
"endTime": "2020-06-23T06:49:18.5765264Z",
"highSeverityFailedRulesCount": 0,
"isBaselineApplied": true,
"lastScanTime": "2020-06-23T06:49:18.5765264Z",
"lowSeverityFailedRulesCount": 0,
"mediumSeverityFailedRulesCount": 0,
"server": "server1",
"sqlVersion": "15.0.4043",
"startTime": "2020-06-23T06:49:00.6455136Z",
"state": "Passed",
"totalFailedRulesCount": 0,
"totalPassedRulesCount": 18,
"totalRulesCount": 18,
"triggerType": "Recurring"
}
},
{
"name": "Scheduled-20200620",
"type": "Microsoft.Security/sqlVulnerabilityAssessments/scans",
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.HybridCompute/machines/MyMachine/sqlServers/server1/databases/master/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200620",
"properties": {
"database": "master",
"endTime": "2020-06-20T06:49:18.5765264Z",
"highSeverityFailedRulesCount": 1,
"isBaselineApplied": true,
"lastScanTime": "2020-06-20T06:49:18.5765264Z",
"lowSeverityFailedRulesCount": 1,
"mediumSeverityFailedRulesCount": 2,
"server": "server1",
"sqlVersion": "15.0.4043",
"startTime": "2020-06-20T06:49:00.6455136Z",
"state": "Failed",
"totalFailedRulesCount": 4,
"totalPassedRulesCount": 14,
"totalRulesCount": 18,
"triggerType": "Recurring"
}
}
]
}
List scans on a resource - Sql Managed Instance
샘플 요청
GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/managedInstances/myManagedInstance/databases/db/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans?api-version=2026-04-01-preview
package armsecurity_test
import (
"context"
"log"
"github.com/Azure/azure-sdk-for-go/sdk/azidentity"
"github.com/Azure/azure-sdk-for-go/sdk/resourcemanager/security/armsecurity"
)
// Generated from example definition: 2026-04-01-preview/sqlVulnerabilityAssessmentsScanOperations/SqlManagedInstanceScans_List.json
func ExampleSQLVulnerabilityAssessmentScansClient_NewListPager_listScansOnAResourceSqlManagedInstance() {
cred, err := azidentity.NewDefaultAzureCredential(nil)
if err != nil {
log.Fatalf("failed to obtain a credential: %v", err)
}
ctx := context.Background()
clientFactory, err := armsecurity.NewClientFactory("<subscriptionID>", cred, nil)
if err != nil {
log.Fatalf("failed to create client: %v", err)
}
pager := clientFactory.NewSQLVulnerabilityAssessmentScansClient().NewListPager("subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/managedInstances/myManagedInstance/databases/db", nil)
for pager.More() {
page, err := pager.NextPage(ctx)
if err != nil {
log.Fatalf("failed to advance page: %v", err)
}
for _, v := range page.Value {
// You could use page here. We use blank identifier for just demo purposes.
_ = v
}
// If the HTTP response code is 200 as defined in example definition, your page structure would look as follows. Please pay attention that all the values in the output are fake values for just demo purposes.
// page = armsecurity.SQLVulnerabilityAssessmentScansClientListResponse{
// ScansV2: armsecurity.ScansV2{
// Value: []*armsecurity.ScanV2{
// {
// Name: to.Ptr("Scheduled-20200623"),
// Type: to.Ptr("Microsoft.Security/sqlVulnerabilityAssessments/scans"),
// ID: to.Ptr("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/managedInstances/myManagedInstance/databases/db/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200623"),
// Properties: &armsecurity.ScanPropertiesV2{
// Database: to.Ptr("db"),
// EndTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:18.5765264Z"); return t}()),
// HighSeverityFailedRulesCount: to.Ptr[int32](0),
// IsBaselineApplied: to.Ptr(true),
// LastScanTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:18.5765264Z"); return t}()),
// LowSeverityFailedRulesCount: to.Ptr[int32](0),
// MediumSeverityFailedRulesCount: to.Ptr[int32](0),
// Server: to.Ptr("myManagedInstance"),
// SQLVersion: to.Ptr("15.0.4043"),
// StartTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:00.6455136Z"); return t}()),
// State: to.Ptr(armsecurity.ScanStatePassed),
// TotalFailedRulesCount: to.Ptr[int32](0),
// TotalPassedRulesCount: to.Ptr[int32](18),
// TotalRulesCount: to.Ptr[int32](18),
// TriggerType: to.Ptr(armsecurity.ScanTriggerTypeRecurring),
// },
// },
// {
// Name: to.Ptr("Scheduled-20200620"),
// Type: to.Ptr("Microsoft.Security/sqlVulnerabilityAssessments/scans"),
// ID: to.Ptr("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/managedInstances/myManagedInstance/databases/db/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200620"),
// Properties: &armsecurity.ScanPropertiesV2{
// Database: to.Ptr("db"),
// EndTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:18.5765264Z"); return t}()),
// HighSeverityFailedRulesCount: to.Ptr[int32](1),
// IsBaselineApplied: to.Ptr(true),
// LastScanTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:18.5765264Z"); return t}()),
// LowSeverityFailedRulesCount: to.Ptr[int32](1),
// MediumSeverityFailedRulesCount: to.Ptr[int32](2),
// Server: to.Ptr("myManagedInstance"),
// SQLVersion: to.Ptr("15.0.4043"),
// StartTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:00.6455136Z"); return t}()),
// State: to.Ptr(armsecurity.ScanStateFailed),
// TotalFailedRulesCount: to.Ptr[int32](4),
// TotalPassedRulesCount: to.Ptr[int32](14),
// TotalRulesCount: to.Ptr[int32](18),
// TriggerType: to.Ptr(armsecurity.ScanTriggerTypeRecurring),
// },
// },
// },
// },
// }
}
}
To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue
샘플 응답
{
"value": [
{
"name": "Scheduled-20200623",
"type": "Microsoft.Security/sqlVulnerabilityAssessments/scans",
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/managedInstances/myManagedInstance/databases/db/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200623",
"properties": {
"database": "db",
"endTime": "2020-06-23T06:49:18.5765264Z",
"highSeverityFailedRulesCount": 0,
"isBaselineApplied": true,
"lastScanTime": "2020-06-23T06:49:18.5765264Z",
"lowSeverityFailedRulesCount": 0,
"mediumSeverityFailedRulesCount": 0,
"server": "myManagedInstance",
"sqlVersion": "15.0.4043",
"startTime": "2020-06-23T06:49:00.6455136Z",
"state": "Passed",
"totalFailedRulesCount": 0,
"totalPassedRulesCount": 18,
"totalRulesCount": 18,
"triggerType": "Recurring"
}
},
{
"name": "Scheduled-20200620",
"type": "Microsoft.Security/sqlVulnerabilityAssessments/scans",
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/managedInstances/myManagedInstance/databases/db/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200620",
"properties": {
"database": "db",
"endTime": "2020-06-20T06:49:18.5765264Z",
"highSeverityFailedRulesCount": 1,
"isBaselineApplied": true,
"lastScanTime": "2020-06-20T06:49:18.5765264Z",
"lowSeverityFailedRulesCount": 1,
"mediumSeverityFailedRulesCount": 2,
"server": "myManagedInstance",
"sqlVersion": "15.0.4043",
"startTime": "2020-06-20T06:49:00.6455136Z",
"state": "Failed",
"totalFailedRulesCount": 4,
"totalPassedRulesCount": 14,
"totalRulesCount": 18,
"triggerType": "Recurring"
}
}
]
}
List scans on a resource - Sql Server
샘플 요청
GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/servers/myServer/databases/db/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans?api-version=2026-04-01-preview
package armsecurity_test
import (
"context"
"log"
"github.com/Azure/azure-sdk-for-go/sdk/azidentity"
"github.com/Azure/azure-sdk-for-go/sdk/resourcemanager/security/armsecurity"
)
// Generated from example definition: 2026-04-01-preview/sqlVulnerabilityAssessmentsScanOperations/SqlServerScans_List.json
func ExampleSQLVulnerabilityAssessmentScansClient_NewListPager_listScansOnAResourceSqlServer() {
cred, err := azidentity.NewDefaultAzureCredential(nil)
if err != nil {
log.Fatalf("failed to obtain a credential: %v", err)
}
ctx := context.Background()
clientFactory, err := armsecurity.NewClientFactory("<subscriptionID>", cred, nil)
if err != nil {
log.Fatalf("failed to create client: %v", err)
}
pager := clientFactory.NewSQLVulnerabilityAssessmentScansClient().NewListPager("subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/servers/myServer/databases/db", nil)
for pager.More() {
page, err := pager.NextPage(ctx)
if err != nil {
log.Fatalf("failed to advance page: %v", err)
}
for _, v := range page.Value {
// You could use page here. We use blank identifier for just demo purposes.
_ = v
}
// If the HTTP response code is 200 as defined in example definition, your page structure would look as follows. Please pay attention that all the values in the output are fake values for just demo purposes.
// page = armsecurity.SQLVulnerabilityAssessmentScansClientListResponse{
// ScansV2: armsecurity.ScansV2{
// Value: []*armsecurity.ScanV2{
// {
// Name: to.Ptr("Scheduled-20200623"),
// Type: to.Ptr("Microsoft.Security/sqlVulnerabilityAssessments/scans"),
// ID: to.Ptr("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/servers/myServer/databases/db/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200623"),
// Properties: &armsecurity.ScanPropertiesV2{
// Database: to.Ptr("db"),
// EndTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:18.5765264Z"); return t}()),
// HighSeverityFailedRulesCount: to.Ptr[int32](0),
// IsBaselineApplied: to.Ptr(true),
// LastScanTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:18.5765264Z"); return t}()),
// LowSeverityFailedRulesCount: to.Ptr[int32](0),
// MediumSeverityFailedRulesCount: to.Ptr[int32](0),
// Server: to.Ptr("myServer"),
// SQLVersion: to.Ptr("15.0.4043"),
// StartTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:00.6455136Z"); return t}()),
// State: to.Ptr(armsecurity.ScanStatePassed),
// TotalFailedRulesCount: to.Ptr[int32](0),
// TotalPassedRulesCount: to.Ptr[int32](18),
// TotalRulesCount: to.Ptr[int32](18),
// TriggerType: to.Ptr(armsecurity.ScanTriggerTypeRecurring),
// },
// },
// {
// Name: to.Ptr("Scheduled-20200620"),
// Type: to.Ptr("Microsoft.Security/sqlVulnerabilityAssessments/scans"),
// ID: to.Ptr("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/servers/myServer/databases/db/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200620"),
// Properties: &armsecurity.ScanPropertiesV2{
// Database: to.Ptr("db"),
// EndTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:18.5765264Z"); return t}()),
// HighSeverityFailedRulesCount: to.Ptr[int32](1),
// IsBaselineApplied: to.Ptr(true),
// LastScanTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:18.5765264Z"); return t}()),
// LowSeverityFailedRulesCount: to.Ptr[int32](1),
// MediumSeverityFailedRulesCount: to.Ptr[int32](2),
// Server: to.Ptr("myServer"),
// SQLVersion: to.Ptr("15.0.4043"),
// StartTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:00.6455136Z"); return t}()),
// State: to.Ptr(armsecurity.ScanStateFailed),
// TotalFailedRulesCount: to.Ptr[int32](4),
// TotalPassedRulesCount: to.Ptr[int32](14),
// TotalRulesCount: to.Ptr[int32](18),
// TriggerType: to.Ptr(armsecurity.ScanTriggerTypeRecurring),
// },
// },
// },
// },
// }
}
}
To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue
샘플 응답
{
"value": [
{
"name": "Scheduled-20200623",
"type": "Microsoft.Security/sqlVulnerabilityAssessments/scans",
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/servers/myServer/databases/db/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200623",
"properties": {
"database": "db",
"endTime": "2020-06-23T06:49:18.5765264Z",
"highSeverityFailedRulesCount": 0,
"isBaselineApplied": true,
"lastScanTime": "2020-06-23T06:49:18.5765264Z",
"lowSeverityFailedRulesCount": 0,
"mediumSeverityFailedRulesCount": 0,
"server": "myServer",
"sqlVersion": "15.0.4043",
"startTime": "2020-06-23T06:49:00.6455136Z",
"state": "Passed",
"totalFailedRulesCount": 0,
"totalPassedRulesCount": 18,
"totalRulesCount": 18,
"triggerType": "Recurring"
}
},
{
"name": "Scheduled-20200620",
"type": "Microsoft.Security/sqlVulnerabilityAssessments/scans",
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Sql/servers/myServer/databases/db/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200620",
"properties": {
"database": "db",
"endTime": "2020-06-20T06:49:18.5765264Z",
"highSeverityFailedRulesCount": 1,
"isBaselineApplied": true,
"lastScanTime": "2020-06-20T06:49:18.5765264Z",
"lowSeverityFailedRulesCount": 1,
"mediumSeverityFailedRulesCount": 2,
"server": "myServer",
"sqlVersion": "15.0.4043",
"startTime": "2020-06-20T06:49:00.6455136Z",
"state": "Failed",
"totalFailedRulesCount": 4,
"totalPassedRulesCount": 14,
"totalRulesCount": 18,
"triggerType": "Recurring"
}
}
]
}
List scans on a resource - Synapse
샘플 요청
GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Synapse/workspaces/myWorkspace/sqlPools/myPool/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans?api-version=2026-04-01-preview
package armsecurity_test
import (
"context"
"log"
"github.com/Azure/azure-sdk-for-go/sdk/azidentity"
"github.com/Azure/azure-sdk-for-go/sdk/resourcemanager/security/armsecurity"
)
// Generated from example definition: 2026-04-01-preview/sqlVulnerabilityAssessmentsScanOperations/SynapseScans_List.json
func ExampleSQLVulnerabilityAssessmentScansClient_NewListPager_listScansOnAResourceSynapse() {
cred, err := azidentity.NewDefaultAzureCredential(nil)
if err != nil {
log.Fatalf("failed to obtain a credential: %v", err)
}
ctx := context.Background()
clientFactory, err := armsecurity.NewClientFactory("<subscriptionID>", cred, nil)
if err != nil {
log.Fatalf("failed to create client: %v", err)
}
pager := clientFactory.NewSQLVulnerabilityAssessmentScansClient().NewListPager("subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Synapse/workspaces/myWorkspace/sqlPools/myPool", nil)
for pager.More() {
page, err := pager.NextPage(ctx)
if err != nil {
log.Fatalf("failed to advance page: %v", err)
}
for _, v := range page.Value {
// You could use page here. We use blank identifier for just demo purposes.
_ = v
}
// If the HTTP response code is 200 as defined in example definition, your page structure would look as follows. Please pay attention that all the values in the output are fake values for just demo purposes.
// page = armsecurity.SQLVulnerabilityAssessmentScansClientListResponse{
// ScansV2: armsecurity.ScansV2{
// Value: []*armsecurity.ScanV2{
// {
// Name: to.Ptr("Scheduled-20200623"),
// Type: to.Ptr("Microsoft.Security/sqlVulnerabilityAssessments/scans"),
// ID: to.Ptr("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Synapse/workspaces/myWorkspace/sqlPools/myPool/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200623"),
// Properties: &armsecurity.ScanPropertiesV2{
// Database: to.Ptr("myPool"),
// EndTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:18.5765264Z"); return t}()),
// HighSeverityFailedRulesCount: to.Ptr[int32](0),
// IsBaselineApplied: to.Ptr(true),
// LastScanTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:18.5765264Z"); return t}()),
// LowSeverityFailedRulesCount: to.Ptr[int32](0),
// MediumSeverityFailedRulesCount: to.Ptr[int32](0),
// Server: to.Ptr("myWorkspace"),
// SQLVersion: to.Ptr("15.0.4043"),
// StartTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:00.6455136Z"); return t}()),
// State: to.Ptr(armsecurity.ScanStatePassed),
// TotalFailedRulesCount: to.Ptr[int32](0),
// TotalPassedRulesCount: to.Ptr[int32](18),
// TotalRulesCount: to.Ptr[int32](18),
// TriggerType: to.Ptr(armsecurity.ScanTriggerTypeRecurring),
// },
// },
// {
// Name: to.Ptr("Scheduled-20200620"),
// Type: to.Ptr("Microsoft.Security/sqlVulnerabilityAssessments/scans"),
// ID: to.Ptr("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Synapse/workspaces/myWorkspace/sqlPools/myPool/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200620"),
// Properties: &armsecurity.ScanPropertiesV2{
// Database: to.Ptr("myPool"),
// EndTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:18.5765264Z"); return t}()),
// HighSeverityFailedRulesCount: to.Ptr[int32](1),
// IsBaselineApplied: to.Ptr(true),
// LastScanTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:18.5765264Z"); return t}()),
// LowSeverityFailedRulesCount: to.Ptr[int32](1),
// MediumSeverityFailedRulesCount: to.Ptr[int32](2),
// Server: to.Ptr("myWorkspace"),
// SQLVersion: to.Ptr("15.0.4043"),
// StartTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:00.6455136Z"); return t}()),
// State: to.Ptr(armsecurity.ScanStateFailed),
// TotalFailedRulesCount: to.Ptr[int32](4),
// TotalPassedRulesCount: to.Ptr[int32](14),
// TotalRulesCount: to.Ptr[int32](18),
// TriggerType: to.Ptr(armsecurity.ScanTriggerTypeRecurring),
// },
// },
// },
// },
// }
}
}
To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue
샘플 응답
{
"value": [
{
"name": "Scheduled-20200623",
"type": "Microsoft.Security/sqlVulnerabilityAssessments/scans",
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Synapse/workspaces/myWorkspace/sqlPools/myPool/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200623",
"properties": {
"database": "myPool",
"endTime": "2020-06-23T06:49:18.5765264Z",
"highSeverityFailedRulesCount": 0,
"isBaselineApplied": true,
"lastScanTime": "2020-06-23T06:49:18.5765264Z",
"lowSeverityFailedRulesCount": 0,
"mediumSeverityFailedRulesCount": 0,
"server": "myWorkspace",
"sqlVersion": "15.0.4043",
"startTime": "2020-06-23T06:49:00.6455136Z",
"state": "Passed",
"totalFailedRulesCount": 0,
"totalPassedRulesCount": 18,
"totalRulesCount": 18,
"triggerType": "Recurring"
}
},
{
"name": "Scheduled-20200620",
"type": "Microsoft.Security/sqlVulnerabilityAssessments/scans",
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Synapse/workspaces/myWorkspace/sqlPools/myPool/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200620",
"properties": {
"database": "myPool",
"endTime": "2020-06-20T06:49:18.5765264Z",
"highSeverityFailedRulesCount": 1,
"isBaselineApplied": true,
"lastScanTime": "2020-06-20T06:49:18.5765264Z",
"lowSeverityFailedRulesCount": 1,
"mediumSeverityFailedRulesCount": 2,
"server": "myWorkspace",
"sqlVersion": "15.0.4043",
"startTime": "2020-06-20T06:49:00.6455136Z",
"state": "Failed",
"totalFailedRulesCount": 4,
"totalPassedRulesCount": 14,
"totalRulesCount": 18,
"triggerType": "Recurring"
}
}
]
}
List scans on a resource - Virtual Machine
샘플 요청
GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Compute/virtualMachines/myVm/sqlServers/server1/databases/master/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans?api-version=2026-04-01-preview
package armsecurity_test
import (
"context"
"log"
"github.com/Azure/azure-sdk-for-go/sdk/azidentity"
"github.com/Azure/azure-sdk-for-go/sdk/resourcemanager/security/armsecurity"
)
// Generated from example definition: 2026-04-01-preview/sqlVulnerabilityAssessmentsScanOperations/VirtualMachineScans_List.json
func ExampleSQLVulnerabilityAssessmentScansClient_NewListPager_listScansOnAResourceVirtualMachine() {
cred, err := azidentity.NewDefaultAzureCredential(nil)
if err != nil {
log.Fatalf("failed to obtain a credential: %v", err)
}
ctx := context.Background()
clientFactory, err := armsecurity.NewClientFactory("<subscriptionID>", cred, nil)
if err != nil {
log.Fatalf("failed to create client: %v", err)
}
pager := clientFactory.NewSQLVulnerabilityAssessmentScansClient().NewListPager("subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Compute/virtualMachines/myVm/sqlServers/server1/databases/master", nil)
for pager.More() {
page, err := pager.NextPage(ctx)
if err != nil {
log.Fatalf("failed to advance page: %v", err)
}
for _, v := range page.Value {
// You could use page here. We use blank identifier for just demo purposes.
_ = v
}
// If the HTTP response code is 200 as defined in example definition, your page structure would look as follows. Please pay attention that all the values in the output are fake values for just demo purposes.
// page = armsecurity.SQLVulnerabilityAssessmentScansClientListResponse{
// ScansV2: armsecurity.ScansV2{
// Value: []*armsecurity.ScanV2{
// {
// Name: to.Ptr("Scheduled-20200623"),
// Type: to.Ptr("Microsoft.Security/sqlVulnerabilityAssessments/scans"),
// ID: to.Ptr("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Compute/virtualMachines/myVm/sqlServers/server1/databases/master/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200623"),
// Properties: &armsecurity.ScanPropertiesV2{
// Database: to.Ptr("master"),
// EndTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:18.5765264Z"); return t}()),
// HighSeverityFailedRulesCount: to.Ptr[int32](0),
// IsBaselineApplied: to.Ptr(true),
// LastScanTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:18.5765264Z"); return t}()),
// LowSeverityFailedRulesCount: to.Ptr[int32](0),
// MediumSeverityFailedRulesCount: to.Ptr[int32](0),
// Server: to.Ptr("server1"),
// SQLVersion: to.Ptr("15.0.4043"),
// StartTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-23T06:49:00.6455136Z"); return t}()),
// State: to.Ptr(armsecurity.ScanStatePassed),
// TotalFailedRulesCount: to.Ptr[int32](0),
// TotalPassedRulesCount: to.Ptr[int32](18),
// TotalRulesCount: to.Ptr[int32](18),
// TriggerType: to.Ptr(armsecurity.ScanTriggerTypeRecurring),
// },
// },
// {
// Name: to.Ptr("Scheduled-20200620"),
// Type: to.Ptr("Microsoft.Security/sqlVulnerabilityAssessments/scans"),
// ID: to.Ptr("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Compute/virtualMachines/myVm/sqlServers/server1/databases/master/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200620"),
// Properties: &armsecurity.ScanPropertiesV2{
// Database: to.Ptr("master"),
// EndTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:18.5765264Z"); return t}()),
// HighSeverityFailedRulesCount: to.Ptr[int32](1),
// IsBaselineApplied: to.Ptr(true),
// LastScanTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:18.5765264Z"); return t}()),
// LowSeverityFailedRulesCount: to.Ptr[int32](1),
// MediumSeverityFailedRulesCount: to.Ptr[int32](2),
// Server: to.Ptr("server1"),
// SQLVersion: to.Ptr("15.0.4043"),
// StartTime: to.Ptr(func() time.Time { t, _ := time.Parse(time.RFC3339Nano, "2020-06-20T06:49:00.6455136Z"); return t}()),
// State: to.Ptr(armsecurity.ScanStateFailed),
// TotalFailedRulesCount: to.Ptr[int32](4),
// TotalPassedRulesCount: to.Ptr[int32](14),
// TotalRulesCount: to.Ptr[int32](18),
// TriggerType: to.Ptr(armsecurity.ScanTriggerTypeRecurring),
// },
// },
// },
// },
// }
}
}
To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue
샘플 응답
{
"value": [
{
"name": "Scheduled-20200623",
"type": "Microsoft.Security/sqlVulnerabilityAssessments/scans",
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Compute/virtualMachines/myVm/sqlServers/server1/databases/master/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200623",
"properties": {
"database": "master",
"endTime": "2020-06-23T06:49:18.5765264Z",
"highSeverityFailedRulesCount": 0,
"isBaselineApplied": true,
"lastScanTime": "2020-06-23T06:49:18.5765264Z",
"lowSeverityFailedRulesCount": 0,
"mediumSeverityFailedRulesCount": 0,
"server": "server1",
"sqlVersion": "15.0.4043",
"startTime": "2020-06-23T06:49:00.6455136Z",
"state": "Passed",
"totalFailedRulesCount": 0,
"totalPassedRulesCount": 18,
"totalRulesCount": 18,
"triggerType": "Recurring"
}
},
{
"name": "Scheduled-20200620",
"type": "Microsoft.Security/sqlVulnerabilityAssessments/scans",
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.Compute/virtualMachines/myVm/sqlServers/server1/databases/master/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/scans/Scheduled-20200620",
"properties": {
"database": "master",
"endTime": "2020-06-20T06:49:18.5765264Z",
"highSeverityFailedRulesCount": 1,
"isBaselineApplied": true,
"lastScanTime": "2020-06-20T06:49:18.5765264Z",
"lowSeverityFailedRulesCount": 1,
"mediumSeverityFailedRulesCount": 2,
"server": "server1",
"sqlVersion": "15.0.4043",
"startTime": "2020-06-20T06:49:00.6455136Z",
"state": "Failed",
"totalFailedRulesCount": 4,
"totalPassedRulesCount": 14,
"totalRulesCount": 18,
"triggerType": "Recurring"
}
}
]
}
정의
Common.CloudError
Object
실패한 작업에 대한 오류 세부 정보를 반환하는 모든 Azure Resource Manager API에 대한 일반적인 오류 응답입니다. 또한 OData 오류 응답 형식을 따릅니다.
| Name |
형식 |
Description |
|
error.additionalInfo
|
ErrorAdditionalInfo[]
|
오류 추가 정보입니다.
|
|
error.code
|
string
|
오류 코드입니다.
|
|
error.details
|
Common.CloudErrorBody[]
|
오류 세부 정보입니다.
|
|
error.message
|
string
|
오류 메시지입니다.
|
|
error.target
|
string
|
오류 대상입니다.
|
Common.CloudErrorBody
Object
오류 세부 정보입니다.
createdByType
열거형
리소스를 만든 ID의 형식입니다.
| 값 |
Description |
|
User
|
|
|
Application
|
|
|
ManagedIdentity
|
|
|
Key
|
|
ErrorAdditionalInfo
Object
리소스 관리 오류 추가 정보입니다.
| Name |
형식 |
Description |
|
info
|
object
|
추가 정보입니다.
|
|
type
|
string
|
추가 정보 유형입니다.
|
ScanPropertiesV2
Object
취약성 평가 검사 레코드 속성입니다.
| Name |
형식 |
Description |
|
database
|
string
|
데이터베이스 이름입니다.
|
|
endTime
|
string
(date-time)
|
검사 결과는 종료 시간(UTC)까지 유효합니다.
|
|
highSeverityFailedRulesCount
|
integer
(int32)
|
심각도가 높은 실패한 규칙의 수입니다.
|
|
isBaselineApplied
|
boolean
|
이 데이터베이스에 대해 만들어진 기준은 하나 이상의 규칙이 있습니다.
|
|
lastScanTime
|
string
(date-time)
|
마지막 검색 시간입니다.
|
|
lowSeverityFailedRulesCount
|
integer
(int32)
|
심각도가 낮은 실패한 규칙의 수입니다.
|
|
mediumSeverityFailedRulesCount
|
integer
(int32)
|
심각도가 중간인 실패한 규칙의 수입니다.
|
|
server
|
string
|
서버 이름입니다.
|
|
sqlVersion
|
string
|
SQL 버전입니다.
|
|
startTime
|
string
(date-time)
|
검사 시작 시간(UTC)입니다.
|
|
state
|
ScanState
|
검사 상태입니다.
|
|
totalFailedRulesCount
|
integer
(int32)
|
실패한 총 규칙 수입니다.
|
|
totalPassedRulesCount
|
integer
(int32)
|
통과된 총 규칙 수입니다.
|
|
totalRulesCount
|
integer
(int32)
|
평가된 총 규칙 수입니다.
|
|
triggerType
|
ScanTriggerType
|
검사 트리거 유형입니다.
|
ScanState
열거형
검사 상태입니다.
| 값 |
Description |
|
Failed
|
실패
|
|
FailedToRun
|
FailedToRun
|
|
InProgress
|
InProgress
|
|
Passed
|
전달
|
ScansV2
Object
취약성 평가 검사 레코드 목록입니다.
| Name |
형식 |
Description |
|
nextLink
|
string
|
|
|
value
|
ScanV2[]
|
취약성 평가 검사 레코드 목록입니다.
|
ScanTriggerType
열거형
검사 트리거 유형입니다.
| 값 |
Description |
|
OnDemand
|
OnDemand
|
|
Recurring
|
되풀이
|
ScanV2
Object
취약성 평가 검사 레코드입니다.
| Name |
형식 |
Description |
|
id
|
string
(arm-id)
|
리소스에 대한 정규화된 리소스 ID입니다. 예: "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
|
|
name
|
string
|
리소스의 이름
|
|
properties
|
ScanPropertiesV2
|
취약성 평가 검사 레코드 속성입니다.
|
|
systemData
|
systemData
|
createdBy 및 modifiedBy 정보가 포함된 Azure Resource Manager 메타데이터입니다.
|
|
type
|
string
|
리소스의 형식입니다. 예: "Microsoft.Compute/virtualMachines" 또는 "Microsoft.Storage/storageAccounts"
|
systemData
Object
리소스의 생성 및 마지막 수정과 관련된 메타데이터입니다.
| Name |
형식 |
Description |
|
createdAt
|
string
(date-time)
|
리소스 만들기의 타임스탬프(UTC)입니다.
|
|
createdBy
|
string
|
리소스를 만든 ID입니다.
|
|
createdByType
|
createdByType
|
리소스를 만든 ID의 형식입니다.
|
|
lastModifiedAt
|
string
(date-time)
|
리소스 마지막 수정의 타임스탬프(UTC)
|
|
lastModifiedBy
|
string
|
리소스를 마지막으로 수정한 ID입니다.
|
|
lastModifiedByType
|
createdByType
|
리소스를 마지막으로 수정한 ID의 형식입니다.
|