how find out all job chains with specific value for a job parameter mapping ?

[Former Member]

Hello,

We have a lot of chains with step "System_Mail_Send" where email addresses are different.

sometime we have to adapt one or more email addresses. an email address can be used in a couple of chains

how can I generate a report/list  with all concerned chains based on a specific "email address" ? or how can I display a list showing in one screen all System_Mail_Send and the specific value for the field "To" for each of them ?

thanks for your help.

Delphine

[Former Member]

Wel , thanks a lot for your suggestion and answer.

I know now that it's not so easy to have this report style ..

I'm not developer and specialist with script (SQL or redwood). I will try with colleague .

But last question :

where can I find the "tables & fields" list available to work with them in a redwood script ?

thanks,

Delphine

[h_carpenter]

Hi Delphine,

It is in a topic called data model, in the reference section of the Administration guide.

Regards,

HP

[Former Member]

thanks for information.

i 'll check with developer guy at office.

kind regards,

Delphine

[Former Member]

hi

   Why do not you try to use an event which triggered the direntes job containing the email addresses with this event you can launch as many want jobs.

I hope my contribution will serve

[h_carpenter]

Hi Delphine,

You can use intellisearch search for jobs:

I need to replace @ with [at] or scn will format it as a link..... you search for user@company.com in CPS, not user[at]company.com

p:To==user[at]company.com

You can separate multiple queries by a space:

p:To==user[at]company.com p:To==jdoe[at]company.com

You can also search for default values of job definitions in the job monitor (helpful if you or sombody changed the default):

p:To=user[at]company.com

You can create a job filter with all these email addresses, with that filter, you can create a report (Definitions > Reports - select your email filter).

Regards,

HP

Message was edited by: h. Carpenter replaced @ with [a] because scn thinks it is a link.

[Former Member]

Hi !

I'm happy to have a quick answer. Thanks a lot !

your suggestion works but the result is not really what I'm looking for.

With your suggestion, in the job monitoring,  I get back a list with the lowest level in a chain (= job definition) but from this result I don't still know what job Chains are linked, what job Chains have a step whit the specific value i'm looking for.

with other words, have you an idea about : how list all JobChain based on a criteria set the job definition of the step level ?

Kind regards,

Delphine

[h_carpenter]

Hi Delphine,

Bon, re-essayons. 😉 You cannot really display a job chain by searching for one of its children, at least, I do not know of a simple way in the job monitor. Then again, there is a way, but it would involve pretty complex SQL query.

You could do something like this:

Job.UniqueId in (select Job.ParentJob from Job where  Job.UniqueId in (select Job.ParentJob from Job where Job.UniqueId in (select JobParameter.Job from JobParameter where JobParameter.InValueString in ('user[@]comany.com', 'jdoe[at]company.com' ) and JobParameter.JobDefinitionParameter in (select JobDefinitionParameter.UniqueId from JobDefinitionParameter where JobDefinitionParameter.Name = 'To' ))))

This is not really maintainable and you would have to add another layer to get the job definition name (to make 100% sure).

You need this list because you want to be able to adapt email addresses, is this correct?

You could do this with RedwoodScript.

Regards,

HP

[Former Member]

Wel, tu as vu juste ! you are right ... the final target is "know what Jobchain should be adapted with the new email addresses.

If you have/know another way, approach  your are welcome.

after the week-end, on monday, I'll try your suggested SQL query/script.

Still thanks for your lights !

Delphine