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