Missing Manager in Attestation campaign

[MK_0o7]

Hi Team,

Need some help with attestation module in Saviynt.

I see that Manager is missing in the campaign for one of the campaigns. Can someone help me in understanding the issue here. Is this a bug in the version??

[pmahalle]

Can you provide more details like where it's missing or screenshot of it.

[MK_0o7]

PFA.

[dgandhi]

This seems to be an issue with the elastic services. Can you please check if the elastic server is up and running?

[smitg]

Hi @MK_0o7 ,

Can you elaborate more on the issue.

what is the type of campaign? Please provide related screenshots if any

Thanks,
Smitha

[pmahalle]

Hi @MK_0o7 ,

Seems like no certification got selected in your Campaign. Are you launching it for specific certifier who is not manager of active users? Or are you providing any advanced queries which are not giving any users to be certified

Can you provide Campaign configuration.

[rushikeshvartak]

• Does user is manager ?
• Does manager is active?
• Does manager have subordinates ?

[MK_0o7]

Hi @rushikeshvartak , @dgandhi @pmahalle @smitg ,

Manager is active and subordinate is active.

Same is happening with other subordinates as well. This is a user manager campaign.

Below is the advanced query that is being user to find the users.

username in (select username from users where regioncode ='AFR' and employeeType in ('Third Party') and customproperty46 = curdate())

[pmahalle]

Hi @MK_0o7 ,

Try below query to find users and check once.

username in (select username from users where regioncode ='AFR' and employeeType in ('Third Party') and datediff(STR_TO_DATE(USR3.CUSTOMPROPERTY46,"%m-%d-%Y"), curdate())=0)

If not worked, let me know in which format you are storing date in CP46.

[dgandhi]

Did you run this query in data analyser and if yes do you get expected result?

select username from users where regioncode ='AFR' and employeeType in ('Third Party') and customproperty46 = curdate()

[DixshantValecha]

Please Try below query:-

SELECT username
FROM users
WHERE regioncode = 'AFR'
AND employeeType = 'Third Party'
AND DATEDIFF(CURDATE(), STR_TO_DATE(CUSTOMPROPERTY46, '%m-%d-%Y')) = 0;