Resource Type: Azure > SQL Virtual Machine Service

The SQL Virtual Machine service allows users to launch and manage virtual servers, known as instances, that can run SQL Server workloads in the cloud. These instances can host databases, applications, and services.

Resource Types

The SQL Virtual Machine Service service includes these resource types:

SQL Virtual Machine

In Your Workspace

Developers

Resource Type URI

tmod:@turbot/azure-sqlvirtualmachine#/resource/types/sqlVirtualMachineService

Category URI

tmod:@turbot/turbot#/resource/categories/cloudService

GraphQL

query resource(id: "tmod:@turbot/azure-sqlvirtualmachine#/resource/types/sqlVirtualMachineService") { … }

query resourceActivities(filter: "resourceId:'tmod:@turbot/azure-sqlvirtualmachine#/resource/types/sqlVirtualMachineService'") { … }

mutation createResource(input: { … })

mutation updateResource(input: { … })

CLI

Get Resource

turbot graphql resource --id "tmod:@turbot/azure-sqlvirtualmachine#/resource/types/sqlVirtualMachineService"

Steampipe Query

Get Resource

select * from guardrails_resource where resource_type_uri = 'tmod:@turbot/azure-sqlvirtualmachine#/resource/types/sqlVirtualMachineService';

Get Policy Settings (By Resource ID)

select * from guardrails_policy_setting where filter = 'resourceTypeId:"tmod:@turbot/azure-sqlvirtualmachine#/resource/types/sqlVirtualMachineService"';

Get Resource Notification

select * from guardrails_notification where resource_type_uri = 'tmod:@turbot/azure-sqlvirtualmachine#/resource/types/sqlVirtualMachineService' and notification_type in ('resource_updated', 'resource_created');