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

book

Article ID: 49990

calendar_today

Updated On:

Products

CA Client Automation

Issue/Introduction

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

 

Environment

Client Automation - All versions

Resolution

Software Delivery "job output" is stored on the domain manager at the following location:


%SDROOT%\ASM\LIBRARY\OUTPUT


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.

Attachments