inventory_items

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

Overview

Name	inventory_items
Type	Resource
Id	azure_isv.connected_vsphere.inventory_items

Fields

vw_inventory_items

Name	Datatype	Description
inventoryItemName	text	field from the properties object
inventory_type	text	field from the properties object
kind	text	Metadata used by portal/tooling/etc to render different UX experiences for resources of the same type; e.g. ApiApps are a kind of Microsoft.Web/sites type. If supported, the resource provider must validate and persist this value.
managed_resource_id	text	field from the properties object
mo_name	text	field from the properties object
mo_ref_id	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
vcenterName	text	field from the properties object

inventory_items

Name	Datatype	Description
kind	string	Metadata used by portal/tooling/etc to render different UX experiences for resources of the same type; e.g. ApiApps are a kind of Microsoft.Web/sites type. If supported, the resource provider must validate and persist this value.
properties	object	Describes the properties of an Inventory Item.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	inventoryItemName, resourceGroupName, subscriptionId, vcenterName	Implements InventoryItem GET method.
list_by_v_center	SELECT	resourceGroupName, subscriptionId, vcenterName	Returns the list of inventoryItems of the given vCenter.
create	INSERT	inventoryItemName, resourceGroupName, subscriptionId, vcenterName, data__properties	Create Or Update InventoryItem.
delete	DELETE	inventoryItemName, resourceGroupName, subscriptionId, vcenterName	Implements inventoryItem DELETE method.

SELECT examples

Returns the list of inventoryItems of the given vCenter.

vw_inventory_items

SELECT
inventoryItemName,
inventory_type,
kind,
managed_resource_id,
mo_name,
mo_ref_id,
provisioning_state,
resourceGroupName,
subscriptionId,
vcenterName
FROM azure_isv.connected_vsphere.vw_inventory_items
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vcenterName = '{{ vcenterName }}';

inventory_items

SELECT
kind,
properties
FROM azure_isv.connected_vsphere.inventory_items
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vcenterName = '{{ vcenterName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_isv.connected_vsphere.inventory_items (
inventoryItemName,
resourceGroupName,
subscriptionId,
vcenterName,
data__properties,
properties,
kind
)
SELECT 
'{{ inventoryItemName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ vcenterName }}',
'{{ data__properties }}',
'{{ properties }}',
'{{ kind }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: inventoryType
          value: []
        - name: managedResourceId
          value: string
        - name: moRefId
          value: string
        - name: moName
          value: string
        - name: provisioningState
          value: []
    - name: kind
      value: string

DELETE example

Deletes the specified inventory_items resource.

/*+ delete */
DELETE FROM azure_isv.connected_vsphere.inventory_items
WHERE inventoryItemName = '{{ inventoryItemName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vcenterName = '{{ vcenterName }}';