Functional Analysis Tool

Global Parameters

Set COUNTRY_CODE

Set END_DATE

Set DB_SCHEMA

Multichannel & Digital Engagement

Events Management

Event Planning and Execution

SELECT id, email__sys FROM user__sys

Tokens:

SECURITY_PROFILE

Options:

Group By (comma-separated):

Approved Email for Events

SELECT id, email__sys FROM user__sys WHERE country_code__v = '{COUNTRY_CODE}' AND name__v = '{NAME}'

Tokens:

NAME

COUNTRY_CODE

Options:

Group By (comma-separated):

CLM Presentations

Custom Presentations

SELECT id, email__sys FROM user__sys WHERE country_code__v = '{COUNTRY_CODE}' AND security_profile__sys = '{SECURITY_PROFILE}'

Tokens:

SECURITY_PROFILE

Options:

Group By (comma-separated):

Media Library Search & Filtering

SELECT id, email__sys FROM user__sys WHERE country_code__v = '{COUNTRY_CODE}' AND name__v = '{NAME}'

Tokens:

NAME

Options:

Group By (comma-separated):

Core CRM & Account Management

Account Management

Account Profiles

SELECT id, email__sys FROM user__sys WHERE country_code__v = '{COUNTRY_CODE}' AND name__v = '{NAME}'

Tokens:

NAME

Options:

Group By (comma-separated):

Run Queries: a - Copy