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
    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',
       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

FlexNet Manager Suite (On-Premises)

2022 R1