MD
SELECT AccountIDAttribute.AttributeValueTXT AS AccountID ,APIKeyAttribute.AttributeValueTXT AS APIKey
FROM EDWAdmin.CatalystAdmin.ETLExecutionEnvironmentBASE ExecutionEnvironment LEFT JOIN EDWAdmin.CatalystAdmin.ETLObjectAttributeBASE AccountIDAttribute ON AccountIDAttribute.ObjectID = ExecutionEnvironment.ETLExecutionEnvironmentID AND AccountIDAttribute.ObjectTypeCD = 'Environment' AND AccountIDAttribute.AttributeNM = 'AccountID' LEFT JOIN EDWAdmin.CatalystAdmin.ETLObjectAttributeBASE APIKeyAttribute ON APIKeyAttribute .ObjectID = ExecutionEnvironment.ETLExecutionEnvironmentID AND APIKeyAttribute .ObjectTypeCD = 'Environment' AND APIKeyAttribute.AttributeNM = 'APIKey' WHERE ExecutionEnvironment.EnvironmentTypeCD = 'GuidedAnalyticsAPI' AND ExecutionEnvironment.EnvironmentVersionTXT IS NULL
asdasdas