Re: Query mult joblogs for string

[Javier Sanchez <javiersanchezbarquero@xxxxxxxxx>]

Very nice that one too, Rob.

El mar, 5 abr 2022 a las 10:16, Rob Berendt (<rob@xxxxxxxxx>) escribió:

> Something like this:
>   select a.job_name, b.message_id, b.message_text, b.*
>    from table(qsys2.job_info(
>    JOB_USER_FILTER => 'QUSER')) a,
>    lateral (select * from table(qsys2.joblog_info(a.job_name)) x) b
>    where a.job_name like('%QZLSFILET%')
>       and b.message_id in('CPIAD12');
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  7310 Innovation Blvd, Suite 104
>           Ft. Wayne, IN 46818
> Ship to:  7310 Innovation Blvd, Dock 9C
>           Ft. Wayne, IN 46818
> http://www.dekko.com
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
> Justin Taylor
> Sent: Tuesday, April 5, 2022 11:17 AM
> To: MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>
> Subject: Query mult joblogs for string
>
> CAUTION: This email originated from outside of the organization. Do not
> click links or open attachments unless you recognize the sender and know
> the content is safe.
>
>
> Anyone know a good way to search multiple job logs for a given string?
>
> I tried this, but JOBLOG_INFO doesn't support wildcard jobs.
> SELECT * FROM TABLE(QSYS2.JOBLOG_INFO('*/QUSER/QZRCSRVS')) A WHERE
> MESSAGE_TEXT =
>
>
> Any ideas?
>
> TIA
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com