CA Client Automation

 View Only
  • 1.  Software Deployment Jobs - Status Codes

    Broadcom Employee
    Posted Mar 16, 2018 02:31 AM

    Hello, I am looking for the definitions of the Software Status Codes for Deployment Jobs, specifically for DSM Reporting Purposes.

    ie. Signature Scan > Software Type 

    1 = Patch

    3 = Release

    Status[Deployment Jobs]

    9 = Ok

    etc

     

    In the DSM Reporter the Filter needs to be defined as a numeric field (status code) and the output is text.

    Alternatively if we can obtain the SQL Query to pull the definitions from the correct SQL Table.

     

    Thank You

    Wayne



  • 2.  Re: Software Deployment Jobs - Status Codes
    Best Answer

    Broadcom Employee
    Posted Mar 16, 2018 06:04 AM

    Hi,

     

    I'm not sure that my info is correct, but I'd like to share my finding.

     

    It seems Software Type is in ca_software_type table.

     

    Status is listed in a support case. The meanings are correct, but it seems string is not matched with Reporter.

     

    '0' = 'UNDEFINED'
    '1' = 'WAITING'
    '2' = 'DELIVERY_ORDERED'
    '3' = 'DELIVERING'
    '4' = 'DELIVERY_OK'
    '5' = 'DELIVERY_ERROR'
    '6' = 'ALREADY_DELIVERED'
    '7' = 'EXECUTION_ORDERED'
    '8' = 'EXECUTING'
    '9' = 'EXECUTION_OK'
    '10' = 'EXECUTION_ERROR'
    '11' = 'UNDELIVERY_ORDERED'
    '12' = 'UNDELIVERING'
    '13' = 'UNDELIVERY_OK'
    '14' = 'UNDELIVERY_ERROR'
    '15' = 'ALREADY_INSTALLED'
    '16' = 'MANIPULATION_NOT_ALLOWED'
    '17' = 'DELIVERY_SUSPEND_ORDERED'
    '18' = 'DELIVERY_SUSPEND_INPROGRESS'
    '19' = 'DELIVERY_SUSPENDED'
    '20' = 'DELIVERY_RESUME_ORDERED'
    '21' = 'DELIVERY_RESUME_INPROGRESS'
    '22' = 'UNDELIVERY_SUSPEND_ORDERED'
    '23' = 'UNDELIVERY_SUSPEND_INPROGRESS'
    '24' = 'UNDELIVERY_SUSPENDED'
    '25' = 'UNDELIVERY_RESUME_ORDERED'
    '26' = 'UNDELIVERY_RESUME_INPROGRESS'
    '27' = 'Execution_Order_Staged'

     

    I hope my info can help you.

     

    Thanks

    Yas



  • 3.  Re: Software Deployment Jobs - Status Codes

    Broadcom Employee
    Posted Mar 16, 2018 09:40 AM

    Hi Yas,

     

    Thank you very much, You are 100% correct. That is exactly what i was looking for. 

     

    Much appreciated.

    Regards

    Wayne