it is an MDX query for SSAS
SELECT
session_spid as spid
, session_user_name as user
, session_last_command as command
, session_current_database as db
, session_cpu_time_ms as time
, session_elapsed_time_ms as elapsedtime
, session_start_time as startTime
, session_last_command_start_time as LastCommandStartTime
, session_last_command_end_time as LastCommandEndTime
FROM $system.discover_sessions
ORDER BY session_elapsed_time_ms desc