SoftwareInstance_ci (Staging Table)

FlexNet Manager Suite 2021 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
   SHOW
    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