workspace_settings

Creates, updates, deletes, gets or lists a workspace_settings resource.

Overview

Name	workspace_settings
Type	Resource
Id	azure.security.workspace_settings

Fields

vw_workspace_settings

Name	Datatype	Description
id	text	Resource Id
name	text	Resource name
scope	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	Resource type
workspaceSettingName	text	field from the properties object
workspace_id	text	field from the properties object

workspace_settings

Name	Datatype	Description
id	string	Resource Id
name	string	Resource name
properties	object	Workspace setting data
type	string	Resource type

Methods

Name	Accessible by	Required Params	Description
get	SELECT	subscriptionId, workspaceSettingName	Settings about where we should store your security data and logs. If the result is empty, it means that no custom-workspace configuration was set
list	SELECT	subscriptionId	Settings about where we should store your security data and logs. If the result is empty, it means that no custom-workspace configuration was set
create	INSERT	subscriptionId, workspaceSettingName	creating settings about where we should store your security data and logs
delete	DELETE	subscriptionId, workspaceSettingName	Deletes the custom workspace settings for this subscription. new VMs will report to the default workspace
update	UPDATE	subscriptionId, workspaceSettingName	Settings about where we should store your security data and logs

SELECT examples

Settings about where we should store your security data and logs. If the result is empty, it means that no custom-workspace configuration was set

vw_workspace_settings

SELECT
id,
name,
scope,
subscriptionId,
type,
workspaceSettingName,
workspace_id
FROM azure.security.vw_workspace_settings
WHERE subscriptionId = '{{ subscriptionId }}';

workspace_settings

SELECT
id,
name,
properties,
type
FROM azure.security.workspace_settings
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new workspace_settings resource.

All Properties

/*+ create */
INSERT INTO azure.security.workspace_settings (
subscriptionId,
workspaceSettingName,
properties
)
SELECT 
'{{ subscriptionId }}',
'{{ workspaceSettingName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: workspaceId
          value: string
        - name: scope
          value: string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string

UPDATE example

Updates a workspace_settings resource.

/*+ update */
UPDATE azure.security.workspace_settings
SET 
properties = '{{ properties }}'
WHERE 
subscriptionId = '{{ subscriptionId }}'
AND workspaceSettingName = '{{ workspaceSettingName }}';

DELETE example

Deletes the specified workspace_settings resource.

/*+ delete */
DELETE FROM azure.security.workspace_settings
WHERE subscriptionId = '{{ subscriptionId }}'
AND workspaceSettingName = '{{ workspaceSettingName }}';