SoftwareInstanceVirtualMachine_ci (Staging Table)

FlexNet Manager Suite 2022 R1 (On-Premises)

Data in this staging table may also be saved in SoftwareInstanceVirtualMachine.xml on the staging server.

BMC Discovery query

This query extracts data from the SoftwareInstance node in the BMC Discovery datastore, and provides the aliases for properties referenced in the table below (note that the regex is wrapped for printing, and should appear all on one line):

SEARCH SoftwareInstance
   WHERE (NODECOUNT(TRAVERSE RunningSoftware:HostedSoftware:Host:Host) > 0)
    AND vm_type IS DEFINED
   SHOW
    vm_type AS 'VMType',
    (zone_uuid OR vm_bios_serial) AS 'VMSerial',
    (zonename OR vm_name) AS 'VMName',
    (zoneid OR
      (vm_type = 'VMware Virtual Machine'
       AND extract(vm_uuid, regex "^(..) (..) (..) (..) (..) (..) (..) 
                                    (..)-(..) (..) (..) (..) (..) (..) 
                                    (..) (..)$",
        regex "\1\2\3\4-\5\6-\7\8-\9\10-\11\12\13\14\15\16")
       OR vm_uuid
      )
     ) AS VMID,
    vm_guest_os AS 'GuestFullName',
    zonepath AS 'VMPath',
    formatTime(last_update_success, "%FT%T") as 'LastUpdateSuccess',
    single(#HostContainer:HostContainment:ContainedHost:Host.key) 
       AS 'GuestHostKey',
    single(#RunningSoftware:HostedSoftware:Host:Host.key) AS 'HostKey'

Mapping into SoftwareInstanceVirtualMachine_ci

Source alias	SoftwareInstanceVirtualMachine_ci property	Type	Max
GuestFullName	GuestFullName	nvarchar	512
GuestHostKey	GuestHostKey	varchar	64
HostKey	HostKey	varchar	64
LastUpdateSuccess	LastUpdateSuccess	datetime
VMID	VMID	nvarchar	255
VMName	VMName	nvarchar	512
VMPath	VMPath	nvarchar	512
VMSerial	VMSerial	nvarchar	255
VMType	VMType	nvarchar	255