Modules

Browse queries by module.

All Modules

ARS Requests ARS Tasks Accounts Accounts, Endpoint Accounts, Endpoints Analytics Audit Logs Audit Trail Campaign Certification Connections Connections, Job Control Panel Endpoints Job Control Panel Roles Rules Security Systems User Group Users Users, Accounts Users, Accounts, Endpoint Users, Entitlements Users, Roles Users, SAV ROLES

Connections JSON- MODIFYUSERDATAJSON, User Import Jobs

Module: Connections, Job Control Panel
Description

Get all Jobs that are user import (include schema user import job, user import from database, user import from connection) and as a next step for those jobs get what is configured in MODIFYUSERDATAJSON

Dynamic Input

nan

Execute in

Analytics

SQL Query 
SELECT ecm.jobid,
ecm.jobname,
exc.connectionname,
xcv.attributekey,
xcv.attributevalue
FROM ecmimportjob ecm
JOIN externalconnection exc
ON ecm.externalconnection = exc.connectionname
INNER JOIN externalconnattvalue xcv
ON exc.externalconnectionkey = xcv.connectiontype
WHERE xcv.attributekey = 'MODIFYUSERDATAJSON'
AND ecm.jobname IN ( 'ApplicationDataImportJob', 'UserImportJob', 'SchemaUserJob' );
Comments

nan

Query copied!