inventory_items

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

Overview

Name	inventory_items
Type	Resource
Id	azure.system_center_vm_manager.inventory_items

Fields

vw_inventory_items

Name	Datatype	Description
inventoryItemResourceName	text	field from the properties object
inventory_item_name	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
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
uuid	text	field from the properties object
vmmServerName	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	Defines the resource properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	inventoryItemResourceName, resourceGroupName, subscriptionId, vmmServerName	Shows an inventory item.
list_by_vmm_server	SELECT	resourceGroupName, subscriptionId, vmmServerName	Returns the list of inventoryItems in the given VmmServer.
create	INSERT	inventoryItemResourceName, resourceGroupName, subscriptionId, vmmServerName	Create Or Update InventoryItem.
delete	DELETE	inventoryItemResourceName, resourceGroupName, subscriptionId, vmmServerName	Deletes an inventoryItem.

SELECT examples

Returns the list of inventoryItems in the given VmmServer.

vw_inventory_items

SELECT
inventoryItemResourceName,
inventory_item_name,
inventory_type,
kind,
managed_resource_id,
provisioning_state,
resourceGroupName,
subscriptionId,
uuid,
vmmServerName
FROM azure.system_center_vm_manager.vw_inventory_items
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vmmServerName = '{{ vmmServerName }}';

inventory_items

SELECT
kind,
properties
FROM azure.system_center_vm_manager.inventory_items
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vmmServerName = '{{ vmmServerName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.system_center_vm_manager.inventory_items (
inventoryItemResourceName,
resourceGroupName,
subscriptionId,
vmmServerName,
properties,
kind
)
SELECT 
'{{ inventoryItemResourceName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ vmmServerName }}',
'{{ properties }}',
'{{ kind }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: inventoryType
          value: []
        - name: managedResourceId
          value: string
        - name: uuid
          value: string
        - name: inventoryItemName
          value: string
        - name: provisioningState
          value: []
    - name: kind
      value: string

DELETE example

Deletes the specified inventory_items resource.

/*+ delete */
DELETE FROM azure.system_center_vm_manager.inventory_items
WHERE inventoryItemResourceName = '{{ inventoryItemResourceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vmmServerName = '{{ vmmServerName }}';