Software Delivery: How to relate SD job output back to an agent in DSM Explorer

Document ID : KB000049990
Last Modified Date : 02/03/2018
Show Technical Document Details
How do I match software delivery job output in the %SDROOT%\ASM\LIBRARY\OUTPUT folder, with the computer it belongs to?

Client Automation (ITCM) -- any version.
Software Delivery "job output" is stored on the domain manager at the following location:

Ex. C:\Program Files (x86)\CA\DSM\SD\ASM\LIBRARY\output

Figure 1

Each <UUID>.app folder contains an "applic.res" file with the job output uploaded by the agent after the software delivery job execution.
The folder name used to store the job output is the "key" we need to link the job output back to an asset in the database. The folder name is a string formatted version of a unique identifier (UUID) in SQL. We need to convert the UUID to binary format first, then we can map the folder to a software job and corresponding target asset from the software delivery applications database table. Here is the query:

select host_name from ca_discovered_hardware where dis_hw_uuid in (
  select target from usd_applic where objectid in (
    select CONVERT(binary(16), CONVERT(uniqueidentifier, 'AB8119EC-8B42-46B1-A680-420E0F8D2BEF'))))

In the above query, "" was the name of the folder from X:\Program Files (x86)\CA\DSM\SD\ASM\LIBRARY\output.