search cancel

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


Article ID: 49990


Updated On:


CA Client Automation


How do I match software delivery job output in the %SDROOT%\ASM\LIBRARY\OUTPUT
folder, with the computer it belongs to?



Client Automation - All versions


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, "" was the name
of the folder from X:\Program Files (x86)\CA\DSM\SD\ASM\LIBRARY\output.