sub_accounts

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

Overview

Name	sub_accounts
Type	Resource
Id	azure_isv.logz.sub_accounts

Fields

vw_sub_accounts

Name	Datatype	Description
id	text	ARM id of the monitor resource.
name	text	Name of the monitor resource.
identity	text	field from the properties object
liftr_resource_category	text	field from the properties object
liftr_resource_preference	text	field from the properties object
location	text	field from the properties object
logz_organization_properties	text	field from the properties object
marketplace_subscription_status	text	field from the properties object
monitorName	text	field from the properties object
monitoring_status	text	field from the properties object
plan_data	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subAccountName	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
tags	text	field from the properties object
type	text	The type of the monitor resource.
user_info	text	field from the properties object

sub_accounts

Name	Datatype	Description
id	string	ARM id of the monitor resource.
name	string	Name of the monitor resource.
identity	object
location	string
properties	object	Properties specific to the monitor resource.
systemData	object	Metadata pertaining to creation and last modification of the resource.
tags	object
type	string	The type of the monitor resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	monitorName, resourceGroupName, subAccountName, subscriptionId
list	SELECT	monitorName, resourceGroupName, subscriptionId
create	INSERT	monitorName, resourceGroupName, subAccountName, subscriptionId, data__location
delete	DELETE	monitorName, resourceGroupName, subAccountName, subscriptionId
update	UPDATE	monitorName, resourceGroupName, subAccountName, subscriptionId
vm_host_payload	EXEC	monitorName, resourceGroupName, subAccountName, subscriptionId

SELECT examples

vw_sub_accounts

SELECT
id,
name,
identity,
liftr_resource_category,
liftr_resource_preference,
location,
logz_organization_properties,
marketplace_subscription_status,
monitorName,
monitoring_status,
plan_data,
provisioning_state,
resourceGroupName,
subAccountName,
subscriptionId,
system_data,
tags,
type,
user_info
FROM azure_isv.logz.vw_sub_accounts
WHERE monitorName = '{{ monitorName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

sub_accounts

SELECT
id,
name,
identity,
location,
properties,
systemData,
tags,
type
FROM azure_isv.logz.sub_accounts
WHERE monitorName = '{{ monitorName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_isv.logz.sub_accounts (
monitorName,
resourceGroupName,
subAccountName,
subscriptionId,
data__location,
properties,
identity,
tags,
location
)
SELECT 
'{{ monitorName }}',
'{{ resourceGroupName }}',
'{{ subAccountName }}',
'{{ subscriptionId }}',
'{{ data__location }}',
'{{ properties }}',
'{{ identity }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: monitoringStatus
          value: []
        - name: marketplaceSubscriptionStatus
          value: []
        - name: logzOrganizationProperties
          value:
            - name: companyName
              value: string
            - name: id
              value: string
            - name: enterpriseAppId
              value: string
            - name: singleSignOnUrl
              value: string
        - name: userInfo
          value:
            - name: firstName
              value: string
            - name: lastName
              value: string
            - name: emailAddress
              value: string
            - name: phoneNumber
              value: string
        - name: planData
          value:
            - name: usageType
              value: string
            - name: billingCycle
              value: string
            - name: planDetails
              value: string
            - name: effectiveDate
              value: string
        - name: liftrResourceCategory
          value: []
        - name: liftrResourcePreference
          value: integer
    - name: identity
      value:
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: type
          value: []
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a sub_accounts resource.

/*+ update */
UPDATE azure_isv.logz.sub_accounts
SET 
properties = '{{ properties }}',
tags = '{{ tags }}'
WHERE 
monitorName = '{{ monitorName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subAccountName = '{{ subAccountName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified sub_accounts resource.

/*+ delete */
DELETE FROM azure_isv.logz.sub_accounts
WHERE monitorName = '{{ monitorName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subAccountName = '{{ subAccountName }}'
AND subscriptionId = '{{ subscriptionId }}';