SoftwareInstance_ci (Staging Table)

FlexNet Manager Suite 2022 R1 (On-Premises)
Data in this staging table may also be saved in SoftwareInstance.xml on the staging server.
Tip: The SoftwareInstanceKey property is ignored for FlexNet Manager Suite.

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:
SEARCH SoftwareInstance
   WHERE (NODECOUNT(TRAVERSE RunningSoftware:HostedSoftware:Host:Host) > 0)
    AND vm_type IS NOT DEFINED
    type + (edition AND (' ' + edition) OR '') AS 'Name',
    product_version AS 'Version',
    (publisher OR single(#Element:Maintainer:Pattern:Pattern.publishers)) 
       AS 'Publisher',
    EXPLODE #RunningSoftware:HostedSoftware:Host:Host.key AS 'HostKey',
       key AS 'SoftwareInstanceKey'

Mapping into SoftwareInstance_ci

Source alias SoftwareInstance_ci property Type Max
HostKey HostKey varchar 64
Name Name nvarchar 255
Version Version nvarchar 255
Publisher Publisher nvarchar 255
SoftwareInstanceKey SoftwareInstanceKey nvarchar 512

FlexNet Manager Suite (On-Premises)

2022 R1