LastLoggedOnUserDetail_ci (Staging Table)

IT Asset Management (Cloud)

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

BMC Discovery query

This query extracts data from the Detail node in the BMC Discovery datastore, and provides the aliases for properties referenced in the table below:
   WHERE (NODECOUNT(TRAVERSE Detail:Detail:ElementWithDetail:Host) > 0)
    AND (type = 'FNMP_LastLoggedOnUser')
   SHOW name AS 'UserName',
    #Detail:Detail:ElementWithDetail:Host.key AS 'HostKey'

Mapping into LastLoggedOnUserDetail_ci

Source alias LastLoggedOnUserDetail_ci property Type Max
HostKey HostKey varchar 64
UserName UserName nvarchar 255

IT Asset Management (Cloud)