Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

How to get the "Scheduled By" Login for Workflows In Adobe Campaign Classic?

Avatar

Avatar
Validate 1
Level 3
Sourav_Sadhu
Level 3

Likes

32 likes

Total Posts

24 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 3
Sourav_Sadhu
Level 3

Likes

32 likes

Total Posts

24 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
Sourav_Sadhu
Level 3

16-10-2019

Hi All,

As we know that if a Workflow is scheduled by someone's user id and if the operator's account get disabled, the workflow will be failed and below type of error message will show.

clipboard_image_0.png

Now its perfectly fine that if we reschedule that with some other's id which is active, the workflow will again work.

Now the requirement is to get the UserNames who has scheduled a workflow, so that if we can get this before, there will not be a single execution failure, we can schedule the workflow with someone else's id before make that Operator disabled.

Obviously if Adobe can understand that the Operator who scheduled the workflow is no more active now, hence shows error, there must be some table-attribute to get this "Scheduled By" login. Thanks for your help.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 50
MVP
Jyoti_Y
MVP

Likes

87 likes

Total Posts

123 posts

Correct Reply

55 solutions
Top badges earned
Boost 50
Shape 1
Boost 5
Give Back 5
Give Back 3
View profile

Avatar
Boost 50
MVP
Jyoti_Y
MVP

Likes

87 likes

Total Posts

123 posts

Correct Reply

55 solutions
Top badges earned
Boost 50
Shape 1
Boost 5
Give Back 5
Give Back 3
View profile
Jyoti_Y
MVP

18-10-2019

Hi,

You can achieve this from 'Workflow Login' table.

It stores userId of person who has created workflow. Login Id associated with each workflow.

Enrich your workflow with 'workflowLogin' table and update login column corresponding to workflow id.

Thanks.

Answers (9)

Answers (9)

Avatar

Avatar
Validate 1
Level 3
Sourav_Sadhu
Level 3

Likes

32 likes

Total Posts

24 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 3
Sourav_Sadhu
Level 3

Likes

32 likes

Total Posts

24 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
Sourav_Sadhu
Level 3

21-10-2019

Seems this may help. Thanks for the answer!

Avatar

Avatar
Validate 1
Level 3
Sourav_Sadhu
Level 3

Likes

32 likes

Total Posts

24 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 3
Sourav_Sadhu
Level 3

Likes

32 likes

Total Posts

24 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
Sourav_Sadhu
Level 3

18-10-2019

Hi..

Thanks for response. We are using 7.0.18 and the Audit trail is available on Version 19.1 onward [ Audit Trail  ].

Avatar

Avatar
Validate 1
Level 3
Sourav_Sadhu
Level 3

Likes

32 likes

Total Posts

24 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 3
Sourav_Sadhu
Level 3

Likes

32 likes

Total Posts

24 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
Sourav_Sadhu
Level 3

18-10-2019

Created by is tagged to that ID who has created the workflow, Modified by is that ID which user has last modification on it. Unfortunately if you schedule a workflow, the last Modified won't change.

Avatar

Avatar
Validate 1
Level 3
Sourav_Sadhu
Level 3

Likes

32 likes

Total Posts

24 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 3
Sourav_Sadhu
Level 3

Likes

32 likes

Total Posts

24 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
Sourav_Sadhu
Level 3

18-10-2019

No its created by another user. Basically I want to get a list like this for all workflow which are now in "Started" state.

Workflow Internal Name | Workflow Scheduled By

Avatar

Avatar
Contributor
MVP
Raj_bounteous
MVP

Likes

90 likes

Total Posts

97 posts

Correct Reply

32 solutions
Top badges earned
Contributor
Shape 1
Give Back 10
Give Back 5
Give Back 3
View profile

Avatar
Contributor
MVP
Raj_bounteous
MVP

Likes

90 likes

Total Posts

97 posts

Correct Reply

32 solutions
Top badges earned
Contributor
Shape 1
Give Back 10
Give Back 5
Give Back 3
View profile
Raj_bounteous
MVP

17-10-2019

Hi,

check if this helps

Audit trail

Avatar

Avatar
Validate 1
Level 3
asktam1410
Level 3

Likes

18 likes

Total Posts

37 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
asktam1410
Level 3

Likes

18 likes

Total Posts

37 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
asktam1410
Level 3

17-10-2019

Yes - go to 'all' workflows and add created by ( label ) and last modified by (Label).

Then map it with operator table and check the current account status whether it is active or disabled.

Avatar

Avatar
Contributor
Level 3
robertc66522596
Level 3

Likes

33 likes

Total Posts

37 posts

Correct Reply

2 solutions
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Contributor
Level 3
robertc66522596
Level 3

Likes

33 likes

Total Posts

37 posts

Correct Reply

2 solutions
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile
robertc66522596
Level 3

17-10-2019

Oh right, of course it does.

Does the same person create the workflow at your organization? If so you could use the created by field

Avatar

Avatar
Validate 1
Level 3
Sourav_Sadhu
Level 3

Likes

32 likes

Total Posts

24 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 3
Sourav_Sadhu
Level 3

Likes

32 likes

Total Posts

24 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
Sourav_Sadhu
Level 3

17-10-2019

Hello Robert,

Thanks for your response, checked that as well and it seems the CurrentOperator will show you the login you are currently using and not the login who scheduled the workflow.

Sourav

Avatar

Avatar
Contributor
Level 3
robertc66522596
Level 3

Likes

33 likes

Total Posts

37 posts

Correct Reply

2 solutions
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Contributor
Level 3
robertc66522596
Level 3

Likes

33 likes

Total Posts

37 posts

Correct Reply

2 solutions
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile
robertc66522596
Level 3

17-10-2019

Hi Sourav,

So you want to catch workflows that were scheduled by operators that are now disabled? There is a workflow logs table that might be useful for this purpose - xtk:workflowLog, which has a connection to currentOperator.

Also, you could take a slightly different approach around user governance -- if you use SSO and an enterprise ID you can deactivate the user from your Active Directory without needing to remove them from Campaign, so the workflows will continue. You'd likely want to periodically go through and clean it all up, however you would at least not be caught by surprise about workflows failling.

Good luck!