Endpoint query in campaign

[NM]

Hi Team,

We have a use case where we have to launch campaign via user update rule and it is supposed to be launched for all child endpoint of logical AD application not parent.

we tried few queries by using join and subquery including parent endpoint key and security system key but it didn't work.

Has anyone used query for endpoint configuration?

Query tried - 

and ep.id in (Select epc.endpointkey from endpoints epc, endpoints epp where epc.parentendpointkey = epp.endpointkey and epp.endpointname = 'Applications')

and ep.id in (select e.endpointkey from endpoints e where e.securitysystemkey in (select ss.systemkey from securitysystems ss where ss.systemname ='') and ep.endpointname!=''

[rushikeshvartak]

and ep.id in (select epc.id from Endpoints epc, Endpoints epp where epc.parentEndpointkey= epp.id and epp.endpointname = 'Applications') 

[NM]

@rushikeshvartak didn't work. endpoint query didn't work ... sub query shows record in Saviynt data analyzer

error- 

Thanks

[rushikeshvartak]

use simple query 

and ep.parentEndpointkey=11

[NM]

@rushikeshvartak shows invalid SQL Query in campaign configuration.

[indra_hema_95]

Hi @NM Can you try this once?

Select epc.endpointkey from endpoints epc where epc.parentendpointkey = (Select epp.endpointkey from endpoints epp where epp.endpointkey=epc.parentendpointkey) and epc.endpointname like '%AD%';

Regards,

Indra

[NM]

@indra_hema_95 , where in data analyzer .. endpoint query in campaign doesn't support select query.

[indra_hema_95]

@NM I have just given you the inside query to check in data analyzer first.

Then you can frame it. 

and ep.id in (Select epc.endpointkey from endpoints epc where epc.parentendpointkey = (Select epp.endpointkey from endpoints epp where epp.endpointkey=epc.parentendpointkey) and epc.endpointname like '%AD%')

Regards,

Indra

[NM]

@indra_hema_95 I have already tried similar result was same no campaign created.

I even tried with security system key .. same case.

[rushikeshvartak]

• I used and ep.parentEndpointkey=1 and its working 
• 

[NM]

@rushikeshvartak 2 questions 

Which version and is this entitlement owner campaign?

With user manager it doesn't give right result..

[rushikeshvartak]

• Yes Entitlement owner campaign
• 23.9 
• I will validate for UM

[NM]

Yes Thank you ..

Whenever I add above query it says invalid SQL for UM

[NM]

@rushikeshvartak any update??

[rushikeshvartak]

Its working for UM also 

[NM]

@rushikeshvartak can you please share the filter??

[rushikeshvartak]

[NM]

Hi @rushikeshvartak , not working for yes.. we are on 24.5 so maybe a bug in the version.

[NM]

@rushikeshvartak could it be a bug?

We are on 24.5 

[rushikeshvartak]

You can raise support ticket they can confirm on specific version

[dgandhi]

Use this simple query

For all the child endpoint, set CP25='Yes'

[NM]

@dgandhi , we have this approach in our bucket already, but keeping it as a second option because we have around 100 child application.