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
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, "AB8119EC-8B42-46B1-A680-420E0F8D2BEF.app" was the name of the folder from X:\Program Files (x86)\CA\DSM\SD\ASM\LIBRARY\output.