SoftwareInstance_ci (Staging Table)
IT Asset Management
(Cloud)
Data in this staging table may also be saved in SoftwareInstance.xml on
the staging server.
Tip: The
SoftwareInstanceKey
property is
ignored for IT Asset Management.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 |
IT Asset Management (Cloud)
Current