CA Client Automation

Expand all | Collapse all

DSM Reporter - Customize failed Software jobs report

Jump to Best Answer
  • 1.  DSM Reporter - Customize failed Software jobs report

    Posted 08-24-2020 04:33 AM
    Hi,

    I am trying to customize the failed software jobs report with the following filter based on status and SW Package name but i get all failed jobs and not the specific one that i am looking for.  Please assist.  Below is the filter being applied.

    Status[Deployment Jobs]
    =
    5
    OR
    Status[Deployment Jobs]
    =
    6
    OR
    Status[Deployment Jobs]
    =
    10
    OR
    Status[Deployment Jobs]
    =
    14
    OR
    Status[Deployment Jobs]
    =
    15
    OR
    Status[Deployment Jobs]
    =
    16
    AND
    SW Package Name[Deployment Jobs]
    LIKE
    %{b66e0ad3-13b3-41cf-8a3d-6890daa0895c}%



    Regards,
    Yogan

    ------------------------------
    CA Consultant
    Ecomm Technologies
    ------------------------------


  • 2.  RE: DSM Reporter - Customize failed Software jobs report
    Best Answer

    Posted 08-24-2020 04:51 AM

    Hi Yogan,

     

    My best guess is you need to enclose all the OR clauses in parentheses, otherwise your filter is ambiguous. Try:

     

    (

    Status[Deployment Jobs]
    =
    5
    OR
    Status[Deployment Jobs]
    =
    6
    OR
    Status[Deployment Jobs]
    =
    10
    OR
    Status[Deployment Jobs]
    =
    14
    OR
    Status[Deployment Jobs]
    =
    15
    OR
    Status[Deployment Jobs]
    =
    16

    )
    AND
    SW Package Name[Deployment Jobs]
    LIKE
    %{b66e0ad3-13b3-41cf-8a3d-6890daa0895c}%

     

     

    Steve McCormick