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

Endpoints Details

Module: Endpoints
Description

Get Endpoint details

Dynamic Input

nan

Execute in

Data Analyzer, Analytics

SQL Query 
SELECT
e.endpointkey,
e.endpointname,
e.displayName,
e.description,
ss.systemname,
CASE
WHEN e.status=0 THEN 'Disabled'
WHEN e.status=1 THEN 'Enabled'
ELSE 'Unknown'
END AS STATUS,
e.accessquery,
e.accountTypeForServiceAccount,
e.disableaccountrequest,
e.createDate,
uc.username AS Created_By,
e.endpointConfig,
e.requestowner,
e.serviceAccountAccessQuery,
e.updateDate,
uu.username AS Updated_By,
e.createdFrom,
e.lastImport
FROM endpoints e
LEFT JOIN securitysystems ss
ON e.securitysystemkey = ss.systemkey
LEFT JOIN users uc
ON e.createdBy = uc.userkey
LEFT JOIN users uu
ON e.updatedBy = uu.userkey
ORDER BY e.endpointkey;
Comments

nan

Query copied!