Identify workflow based on name of wkf tables

Hi everyone,

Our system engineer sometimes provides us with the names of the wkf-tables created by workflows causing trouble on the system.

Usually it's possible to derive the workflow directly from these id's, but not always.

Example 1

The table with name wkf539349321_11438_1 is created by the workflow with primary key 539.349.321.

This key is directly derived from the name.

Example 2

When we derive the primary key using the same method out of wkf3312884954_218_1 we get 3.312.884.954.

However, the primary key cannot be greater than 2.147.483.647, so you will never get a result for this key.

Remark: A lot of our workflows currently get negative primary keys.

We assume these out of range id's might be created by workflows with a negative primary key. However, until now we haven't found a way to translate those id's back to the primary keys, if this is even possible.

Our question:

• Is there indeed a link between the primary key and the name used for wkf tables?
• And if so, is there a way to find the workflow responsible for creating this wkf table just by looking at the name and using the Adobe Campaign client? Is there maybe a formula which we can apply on the id? Or a place in AC where we can look up which workflow created id ...

Any help would be welcome!

Wesley