can I use an existing campaign to filter specific entitlements from a specific endpoint?

[theosveg]

I have a user manager campaign that targets a list of endpoints. Moving forward I would like to add one more endpoint and filter only specific entitlements from this endpoint, but keep the rest of the campaign endpoints/entitlements untouched, is this possible? and how would I go about achieving this?

[rushikeshvartak]

entitlementtypekey in (100,200,300 ) or entitlement_valuekey in (1,2,3)

• 100, 200,300 are other endpoints Entitlement Type key
• New Endpoints Entitlement Valuekey are 1.2.3
• 

[theosveg]

thanks, now does this filter impact other endpoints specified in the campaign as well? as we would like to see all the accounts and entitlements for them.

For example, need to see everything for endpoints A and B, for new endpoint C, only entitlements that are high privileged

[rushikeshvartak]

Yes 

• 100& 200 A&B endpoint entitlementtypekey
• 300 C endpoint and 1,2,3  entitlement_valuekey

[NM]

@theosveg it won't it will check the entitlement type and then value if one of them satisfy it moves forward.

[rushikeshvartak]

More optimized query 

entitlementtypekey in (select entitlementtypekey  from entitlement_types where endpointkey in (select endpointkey from endpoints where endpointname in ('A','B')))  or entitlement_valuekey in (select entitlement_valuekey from entitlement_values where status=1 and privileged =4 and entitlementtypekey in (select entitlementtypekey  from entitlement_types where endpointkey in (select endpointkey from endpoints where endpointname in ('C'))))

[theosveg]

Thank you @rushikeshvartak I will test this and come back to close the thread. 🙂