DSM Reporter - Customize failed Software jobs report

[YOGAN PERUMAL]

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
------------------------------

[Stephen McCormick]

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