Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- sessions.target_id AS "data.target_id"
- ,sessions.device_id AS "data.device_id"
- ,sessions.nativeSessionName AS "data.nativeSessionName"
- ,sessions.terminal AS "data.terminal"
- ,sessions.username AS "data.username"
- ,sessions.displayName AS "data.displayName"
- ,sessions.active AS "data.active"
- ,sessions.created AS "data.created"
- ,sessions.updated AS "data.updated"
- ,sessions.etag AS "data.etag"
- ,sessions.online AS "data.online"
- ,sessions_index.id
- ,sessions_index.etag
- ,sessions_activegroups.content AS "activegroups.content"
- ,sessions_activegroups.updated AS "activegroups.updated"
- ,sessions_activegroups.etag AS "activegroups.etag"
- ,sessions_activepolicies.content AS "activepolicies.content"
- ,sessions_activepolicies.updated AS "activepolicies.updated"
- ,sessions_activepolicies.etag AS "activepolicies.etag"
- ,sessions_applications.content AS "applications.content"
- ,sessions_applications.updated AS "applications.updated"
- ,sessions_applications.etag AS "applications.etag"
- ,sessions_directive.content AS "directive.content"
- ,sessions_directive.updated AS "directive.updated"
- ,sessions_directive.etag AS "directive.etag"
- ,sessions_properties.content AS "properties.content"
- ,sessions_properties.updated AS "properties.updated"
- ,sessions_properties.etag AS "properties.etag"
- FROM
- sessions_index LEFT JOIN sessions
- USING (id) LEFT JOIN sessions_activegroups
- USING (id) LEFT JOIN sessions_activepolicies
- USING (id) LEFT JOIN sessions_applications
- USING (id) LEFT JOIN sessions_directive
- USING (id) LEFT JOIN sessions_properties
- USING (id)
- WHERE
- sessions_index.deleted IS NULL
- UNION
- SELECT
- sessions.target_id
- ,sessions.device_id
- ,sessions.nativeSessionName
- ,sessions.terminal
- ,sessions.username
- ,sessions.displayName
- ,sessions.active
- ,sessions.created
- ,sessions.updated
- ,sessions.etag
- ,sessions.online
- ,sessions_index.id
- ,sessions_index.etag
- ,sessions_activegroups.content
- ,sessions_activegroups.updated
- ,sessions_activegroups.etag
- ,sessions_activepolicies.content
- ,sessions_activepolicies.updated
- ,sessions_activepolicies.etag
- ,sessions_applications.content
- ,sessions_applications.updated
- ,sessions_applications.etag
- ,sessions_directive.content
- ,sessions_directive.updated
- ,sessions_directive.etag
- ,sessions_properties.content
- ,sessions_properties.updated
- ,sessions_properties.etag
- FROM
- sessions LEFT JOIN sessions_properties
- USING (id) LEFT JOIN sessions_index
- USING (id) LEFT JOIN sessions_directive
- USING (id) LEFT JOIN sessions_applications
- USING (id) LEFT JOIN sessions_activepolicies
- USING (id) LEFT JOIN sessions_activegroups
- USING (id)
- WHERE
- sessions_index.deleted IS NULL
- AND sessions_index.id IS NOT NULL
- AND sessions.id IS NOT NULL
- UNION
- SELECT
- sessions.target_id
- ,sessions.device_id
- ,sessions.nativeSessionName
- ,sessions.terminal
- ,sessions.username
- ,sessions.displayName
- ,sessions.active
- ,sessions.created
- ,sessions.updated
- ,sessions.etag
- ,sessions.online
- ,sessions_index.id
- ,sessions_index.etag
- ,sessions_activegroups.content
- ,sessions_activegroups.updated
- ,sessions_activegroups.etag
- ,sessions_activepolicies.content
- ,sessions_activepolicies.updated
- ,sessions_activepolicies.etag
- ,sessions_applications.content
- ,sessions_applications.updated
- ,sessions_applications.etag
- ,sessions_directive.content
- ,sessions_directive.updated
- ,sessions_directive.etag
- ,sessions_properties.content
- ,sessions_properties.updated
- ,sessions_properties.etag
- FROM
- sessions_activegroups LEFT JOIN sessions_properties
- USING (id) LEFT JOIN sessions_index
- USING (id) LEFT JOIN sessions_directive
- USING (id) LEFT JOIN sessions_applications
- USING (id) LEFT JOIN sessions_activepolicies
- USING (id) LEFT JOIN sessions
- USING (id)
- WHERE
- sessions_index.deleted IS NULL
- AND sessions_index.id IS NOT NULL
- AND sessions.id IS NOT NULL
- UNION
- SELECT
- sessions.target_id
- ,sessions.device_id
- ,sessions.nativeSessionName
- ,sessions.terminal
- ,sessions.username
- ,sessions.displayName
- ,sessions.active
- ,sessions.created
- ,sessions.updated
- ,sessions.etag
- ,sessions.online
- ,sessions_index.id
- ,sessions_index.etag
- ,sessions_activegroups.content
- ,sessions_activegroups.updated
- ,sessions_activegroups.etag
- ,sessions_activepolicies.content
- ,sessions_activepolicies.updated
- ,sessions_activepolicies.etag
- ,sessions_applications.content
- ,sessions_applications.updated
- ,sessions_applications.etag
- ,sessions_directive.content
- ,sessions_directive.updated
- ,sessions_directive.etag
- ,sessions_properties.content
- ,sessions_properties.updated
- ,sessions_properties.etag
- FROM
- sessions_activepolicies LEFT JOIN sessions_properties
- USING (id) LEFT JOIN sessions_index
- USING (id) LEFT JOIN sessions_directive
- USING (id) LEFT JOIN sessions_applications
- USING (id) LEFT JOIN sessions_activegroups
- USING (id) LEFT JOIN sessions
- USING (id)
- WHERE
- sessions_index.deleted IS NULL
- AND sessions_index.id IS NOT NULL
- AND sessions.id IS NOT NULL
- UNION
- SELECT
- sessions.target_id
- ,sessions.device_id
- ,sessions.nativeSessionName
- ,sessions.terminal
- ,sessions.username
- ,sessions.displayName
- ,sessions.active
- ,sessions.created
- ,sessions.updated
- ,sessions.etag
- ,sessions.online
- ,sessions_index.id
- ,sessions_index.etag
- ,sessions_activegroups.content
- ,sessions_activegroups.updated
- ,sessions_activegroups.etag
- ,sessions_activepolicies.content
- ,sessions_activepolicies.updated
- ,sessions_activepolicies.etag
- ,sessions_applications.content
- ,sessions_applications.updated
- ,sessions_applications.etag
- ,sessions_directive.content
- ,sessions_directive.updated
- ,sessions_directive.etag
- ,sessions_properties.content
- ,sessions_properties.updated
- ,sessions_properties.etag
- FROM
- sessions_applications LEFT JOIN sessions_properties
- USING (id) LEFT JOIN sessions_index
- USING (id) LEFT JOIN sessions_directive
- USING (id) LEFT JOIN sessions_activepolicies
- USING (id) LEFT JOIN sessions_activegroups
- USING (id) LEFT JOIN sessions
- USING (id)
- WHERE
- sessions_index.deleted IS NULL
- AND sessions_index.id IS NOT NULL
- AND sessions.id IS NOT NULL
- UNION
- SELECT
- sessions.target_id
- ,sessions.device_id
- ,sessions.nativeSessionName
- ,sessions.terminal
- ,sessions.username
- ,sessions.displayName
- ,sessions.active
- ,sessions.created
- ,sessions.updated
- ,sessions.etag
- ,sessions.online
- ,sessions_index.id
- ,sessions_index.etag
- ,sessions_activegroups.content
- ,sessions_activegroups.updated
- ,sessions_activegroups.etag
- ,sessions_activepolicies.content
- ,sessions_activepolicies.updated
- ,sessions_activepolicies.etag
- ,sessions_applications.content
- ,sessions_applications.updated
- ,sessions_applications.etag
- ,sessions_directive.content
- ,sessions_directive.updated
- ,sessions_directive.etag
- ,sessions_properties.content
- ,sessions_properties.updated
- ,sessions_properties.etag
- FROM
- sessions_directive LEFT JOIN sessions_properties
- USING (id) LEFT JOIN sessions_index
- USING (id) LEFT JOIN sessions_applications
- USING (id) LEFT JOIN sessions_activepolicies
- USING (id) LEFT JOIN sessions_activegroups
- USING (id) LEFT JOIN sessions
- USING (id)
- WHERE
- sessions_index.deleted IS NULL
- AND sessions_index.id IS NOT NULL
- AND sessions.id IS NOT NULL
- UNION
- SELECT
- sessions.target_id
- ,sessions.device_id
- ,sessions.nativeSessionName
- ,sessions.terminal
- ,sessions.username
- ,sessions.displayName
- ,sessions.active
- ,sessions.created
- ,sessions.updated
- ,sessions.etag
- ,sessions.online
- ,sessions_index.id
- ,sessions_index.etag
- ,sessions_activegroups.content
- ,sessions_activegroups.updated
- ,sessions_activegroups.etag
- ,sessions_activepolicies.content
- ,sessions_activepolicies.updated
- ,sessions_activepolicies.etag
- ,sessions_applications.content
- ,sessions_applications.updated
- ,sessions_applications.etag
- ,sessions_directive.content
- ,sessions_directive.updated
- ,sessions_directive.etag
- ,sessions_properties.content
- ,sessions_properties.updated
- ,sessions_properties.etag
- FROM
- sessions_index LEFT JOIN sessions_properties
- USING (id) LEFT JOIN sessions_directive
- USING (id) LEFT JOIN sessions_applications
- USING (id) LEFT JOIN sessions_activepolicies
- USING (id) LEFT JOIN sessions_activegroups
- USING (id) LEFT JOIN sessions
- USING (id)
- WHERE
- sessions_index.deleted IS NULL
- AND sessions_index.id IS NOT NULL
- AND sessions.id IS NOT NULL
- UNION
- SELECT
- sessions.target_id
- ,sessions.device_id
- ,sessions.nativeSessionName
- ,sessions.terminal
- ,sessions.username
- ,sessions.displayName
- ,sessions.active
- ,sessions.created
- ,sessions.updated
- ,sessions.etag
- ,sessions.online
- ,sessions_index.id
- ,sessions_index.etag
- ,sessions_activegroups.content
- ,sessions_activegroups.updated
- ,sessions_activegroups.etag
- ,sessions_activepolicies.content
- ,sessions_activepolicies.updated
- ,sessions_activepolicies.etag
- ,sessions_applications.content
- ,sessions_applications.updated
- ,sessions_applications.etag
- ,sessions_directive.content
- ,sessions_directive.updated
- ,sessions_directive.etag
- ,sessions_properties.content
- ,sessions_properties.updated
- ,sessions_properties.etag
- FROM
- sessions_properties LEFT JOIN sessions_index
- USING (id) LEFT JOIN sessions_directive
- USING (id) LEFT JOIN sessions_applications
- USING (id) LEFT JOIN sessions_activepolicies
- USING (id) LEFT JOIN sessions_activegroups
- USING (id) LEFT JOIN sessions
- USING (id)
- WHERE
- sessions_index.deleted IS NULL
- AND sessions_index.id IS NOT NULL
- AND sessions.id IS NOT NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement