DiscoveredInstalledPackages_ci (Staging Table)

IT Asset Management (Cloud)

Data in this staging table may also be saved in DiscoveredInstalledPackages.xml on the staging server.

BMC Discovery query

This query extracts data from the Host node in the BMC Discovery datastore to find installed packages, and provides the aliases for properties referenced in the table below:
        STEP IN Host:HostedSoftware:InstalledSoftware:Package
                #:InstalledSoftware:Package.key AS 'PackageKey',
                #:Host:Host.key as 'HostKey'

Mapping into DiscoveredInstalledPackages_ci

Source alias DiscoveredPackages_ci property Type Max
PackageKey PackageKey nvarchar 450
HostKey HostKey varchar 64

IT Asset Management (Cloud)