SoftwareInstance_ci (Staging Table)

FlexNet Manager Suite 2020 R1 (On-Premises)

Data in this staging table may also be saved in SoftwareInstance.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:
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'

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

FlexNet Manager Suite (On-Premises)

2020 R1