I need a query to find all records that has "does not meet the requirement:" in the Fault_Message Field...See Table below...Thanks
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
SITE_ID | ACCOUNT | Bill Day | FAULT_MESSAGE |
2 | 14779802 | 1 | ICB0350:CBM3700:Service EE200 does not meet the requirement: 1B Include if all |
2 | 711424601 | 1 | ICB0350:CBM3700:Service ML256 does not meet the requirement: 1A Include if one |
2 | 722692602 | 1 | ICB0350:CBM3700:Service ML257 does not meet the requirement: 1A Include if one |
2 | 705159001 | 1 | ICB0350:CBM3700:Service ML267 does not meet the requirement: 1A Include if one |
2 | 466843501 | 1 | ICB0350:CBM3700:Service ML455 does not meet the requirement: 1A Include if one |
2 | 8052303 | 1 | ICB0350:CBM3700:Service ML987 does not meet the requirement: 1A Include if one |
2 | 30808708 | 1 | ICB0350:CBM3700:Service ML987 does not meet the requirement: 1A Include if one |
2 | 347946901 | 1 | ICB0350:CBM3700:Service ML987 does not meet the requirement: 1A Include if one |
2 | 458678001 | 1 | ICB0350:CBM3700:Service ML987 does not meet the requirement: 1A Include if one |
2 | 451897302 | 1 | GatewayError: RC=9999, MSGNO=CBM5578, MSGTEXT=Account must be active, or must have a pending Install WO., SourceLocation=ICB0312 OrderException_1{#0,Key=null,ReturnCode=9999,MessageNumber=CBM5578,MessageText=Account must be active, or must have a pen |
2 | 463648202 | 1 | GatewayError: RC=9999, MSGNO=CBM5578, MSGTEXT=Account must be active, or must have a pending Install WO., SourceLocation=ICB0312 OrderException_1{#0,Key=null,ReturnCode=9999,MessageNumber=CBM5578,MessageText=Account must be active, or must have a pen |
2 | 731785501 | 1 | GatewayError: RC=9999, MSGNO=CBM5578, MSGTEXT=Account must be active, or must have a pending Install WO., SourceLocation=ICB0312 OrderException_1{#0,Key=null,ReturnCode=9999,MessageNumber=CBM5578,MessageText=Account must be active, or must have a pen |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>