API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 21st, 2019
105
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.43 KB | None | 0 0
raw download clone embed print report
  1. SELECT
  2. sessions.target_id AS "data.target_id"
  3. ,sessions.device_id AS "data.device_id"
  4. ,sessions.nativeSessionName AS "data.nativeSessionName"
  5. ,sessions.terminal AS "data.terminal"
  6. ,sessions.username AS "data.username"
  7. ,sessions.displayName AS "data.displayName"
  8. ,sessions.active AS "data.active"
  9. ,sessions.created AS "data.created"
  10. ,sessions.updated AS "data.updated"
  11. ,sessions.etag AS "data.etag"
  12. ,sessions.online AS "data.online"
  13. ,sessions_index.id
  14. ,sessions_index.etag
  15. ,sessions_activegroups.content AS "activegroups.content"
  16. ,sessions_activegroups.updated AS "activegroups.updated"
  17. ,sessions_activegroups.etag AS "activegroups.etag"
  18. ,sessions_activepolicies.content AS "activepolicies.content"
  19. ,sessions_activepolicies.updated AS "activepolicies.updated"
  20. ,sessions_activepolicies.etag AS "activepolicies.etag"
  21. ,sessions_applications.content AS "applications.content"
  22. ,sessions_applications.updated AS "applications.updated"
  23. ,sessions_applications.etag AS "applications.etag"
  24. ,sessions_directive.content AS "directive.content"
  25. ,sessions_directive.updated AS "directive.updated"
  26. ,sessions_directive.etag AS "directive.etag"
  27. ,sessions_properties.content AS "properties.content"
  28. ,sessions_properties.updated AS "properties.updated"
  29. ,sessions_properties.etag AS "properties.etag"
  30. FROM
  31. sessions_index LEFT JOIN sessions
  32. USING (id) LEFT JOIN sessions_activegroups
  33. USING (id) LEFT JOIN sessions_activepolicies
  34. USING (id) LEFT JOIN sessions_applications
  35. USING (id) LEFT JOIN sessions_directive
  36. USING (id) LEFT JOIN sessions_properties
  37. USING (id)
  38. WHERE
  39. sessions_index.deleted IS NULL
  40. AND sessions_index.id IS NOT NULL
  41. AND sessions.id IS NOT NULL
  42. UNION
  43. SELECT
  44. sessions.target_id
  45. ,sessions.device_id
  46. ,sessions.nativeSessionName
  47. ,sessions.terminal
  48. ,sessions.username
  49. ,sessions.displayName
  50. ,sessions.active
  51. ,sessions.created
  52. ,sessions.updated
  53. ,sessions.etag
  54. ,sessions.online
  55. ,sessions_index.id
  56. ,sessions_index.etag
  57. ,sessions_activegroups.content
  58. ,sessions_activegroups.updated
  59. ,sessions_activegroups.etag
  60. ,sessions_activepolicies.content
  61. ,sessions_activepolicies.updated
  62. ,sessions_activepolicies.etag
  63. ,sessions_applications.content
  64. ,sessions_applications.updated
  65. ,sessions_applications.etag
  66. ,sessions_directive.content
  67. ,sessions_directive.updated
  68. ,sessions_directive.etag
  69. ,sessions_properties.content
  70. ,sessions_properties.updated
  71. ,sessions_properties.etag
  72. FROM
  73. sessions LEFT JOIN sessions_properties
  74. USING (id) LEFT JOIN sessions_index
  75. USING (id) LEFT JOIN sessions_directive
  76. USING (id) LEFT JOIN sessions_applications
  77. USING (id) LEFT JOIN sessions_activepolicies
  78. USING (id) LEFT JOIN sessions_activegroups
  79. USING (id)
  80. WHERE
  81. sessions_index.deleted IS NULL
  82. AND sessions_index.id IS NOT NULL
  83. AND sessions.id IS NOT NULL
  84. UNION
  85. SELECT
  86. sessions.target_id
  87. ,sessions.device_id
  88. ,sessions.nativeSessionName
  89. ,sessions.terminal
  90. ,sessions.username
  91. ,sessions.displayName
  92. ,sessions.active
  93. ,sessions.created
  94. ,sessions.updated
  95. ,sessions.etag
  96. ,sessions.online
  97. ,sessions_index.id
  98. ,sessions_index.etag
  99. ,sessions_activegroups.content
  100. ,sessions_activegroups.updated
  101. ,sessions_activegroups.etag
  102. ,sessions_activepolicies.content
  103. ,sessions_activepolicies.updated
  104. ,sessions_activepolicies.etag
  105. ,sessions_applications.content
  106. ,sessions_applications.updated
  107. ,sessions_applications.etag
  108. ,sessions_directive.content
  109. ,sessions_directive.updated
  110. ,sessions_directive.etag
  111. ,sessions_properties.content
  112. ,sessions_properties.updated
  113. ,sessions_properties.etag
  114. FROM
  115. sessions_activegroups LEFT JOIN sessions_properties
  116. USING (id) LEFT JOIN sessions_index
  117. USING (id) LEFT JOIN sessions_directive
  118. USING (id) LEFT JOIN sessions_applications
  119. USING (id) LEFT JOIN sessions_activepolicies
  120. USING (id) LEFT JOIN sessions
  121. USING (id)
  122. WHERE
  123. sessions_index.deleted IS NULL
  124. AND sessions_index.id IS NOT NULL
  125. AND sessions.id IS NOT NULL
  126. UNION
  127. SELECT
  128. sessions.target_id
  129. ,sessions.device_id
  130. ,sessions.nativeSessionName
  131. ,sessions.terminal
  132. ,sessions.username
  133. ,sessions.displayName
  134. ,sessions.active
  135. ,sessions.created
  136. ,sessions.updated
  137. ,sessions.etag
  138. ,sessions.online
  139. ,sessions_index.id
  140. ,sessions_index.etag
  141. ,sessions_activegroups.content
  142. ,sessions_activegroups.updated
  143. ,sessions_activegroups.etag
  144. ,sessions_activepolicies.content
  145. ,sessions_activepolicies.updated
  146. ,sessions_activepolicies.etag
  147. ,sessions_applications.content
  148. ,sessions_applications.updated
  149. ,sessions_applications.etag
  150. ,sessions_directive.content
  151. ,sessions_directive.updated
  152. ,sessions_directive.etag
  153. ,sessions_properties.content
  154. ,sessions_properties.updated
  155. ,sessions_properties.etag
  156. FROM
  157. sessions_activepolicies LEFT JOIN sessions_properties
  158. USING (id) LEFT JOIN sessions_index
  159. USING (id) LEFT JOIN sessions_directive
  160. USING (id) LEFT JOIN sessions_applications
  161. USING (id) LEFT JOIN sessions_activegroups
  162. USING (id) LEFT JOIN sessions
  163. USING (id)
  164. WHERE
  165. sessions_index.deleted IS NULL
  166. AND sessions_index.id IS NOT NULL
  167. AND sessions.id IS NOT NULL
  168. UNION
  169. SELECT
  170. sessions.target_id
  171. ,sessions.device_id
  172. ,sessions.nativeSessionName
  173. ,sessions.terminal
  174. ,sessions.username
  175. ,sessions.displayName
  176. ,sessions.active
  177. ,sessions.created
  178. ,sessions.updated
  179. ,sessions.etag
  180. ,sessions.online
  181. ,sessions_index.id
  182. ,sessions_index.etag
  183. ,sessions_activegroups.content
  184. ,sessions_activegroups.updated
  185. ,sessions_activegroups.etag
  186. ,sessions_activepolicies.content
  187. ,sessions_activepolicies.updated
  188. ,sessions_activepolicies.etag
  189. ,sessions_applications.content
  190. ,sessions_applications.updated
  191. ,sessions_applications.etag
  192. ,sessions_directive.content
  193. ,sessions_directive.updated
  194. ,sessions_directive.etag
  195. ,sessions_properties.content
  196. ,sessions_properties.updated
  197. ,sessions_properties.etag
  198. FROM
  199. sessions_applications LEFT JOIN sessions_properties
  200. USING (id) LEFT JOIN sessions_index
  201. USING (id) LEFT JOIN sessions_directive
  202. USING (id) LEFT JOIN sessions_activepolicies
  203. USING (id) LEFT JOIN sessions_activegroups
  204. USING (id) LEFT JOIN sessions
  205. USING (id)
  206. WHERE
  207. sessions_index.deleted IS NULL
  208. AND sessions_index.id IS NOT NULL
  209. AND sessions.id IS NOT NULL
  210. UNION
  211. SELECT
  212. sessions.target_id
  213. ,sessions.device_id
  214. ,sessions.nativeSessionName
  215. ,sessions.terminal
  216. ,sessions.username
  217. ,sessions.displayName
  218. ,sessions.active
  219. ,sessions.created
  220. ,sessions.updated
  221. ,sessions.etag
  222. ,sessions.online
  223. ,sessions_index.id
  224. ,sessions_index.etag
  225. ,sessions_activegroups.content
  226. ,sessions_activegroups.updated
  227. ,sessions_activegroups.etag
  228. ,sessions_activepolicies.content
  229. ,sessions_activepolicies.updated
  230. ,sessions_activepolicies.etag
  231. ,sessions_applications.content
  232. ,sessions_applications.updated
  233. ,sessions_applications.etag
  234. ,sessions_directive.content
  235. ,sessions_directive.updated
  236. ,sessions_directive.etag
  237. ,sessions_properties.content
  238. ,sessions_properties.updated
  239. ,sessions_properties.etag
  240. FROM
  241. sessions_directive LEFT JOIN sessions_properties
  242. USING (id) LEFT JOIN sessions_index
  243. USING (id) LEFT JOIN sessions_applications
  244. USING (id) LEFT JOIN sessions_activepolicies
  245. USING (id) LEFT JOIN sessions_activegroups
  246. USING (id) LEFT JOIN sessions
  247. USING (id)
  248. WHERE
  249. sessions_index.deleted IS NULL
  250. AND sessions_index.id IS NOT NULL
  251. AND sessions.id IS NOT NULL
  252. UNION
  253. SELECT
  254. sessions.target_id
  255. ,sessions.device_id
  256. ,sessions.nativeSessionName
  257. ,sessions.terminal
  258. ,sessions.username
  259. ,sessions.displayName
  260. ,sessions.active
  261. ,sessions.created
  262. ,sessions.updated
  263. ,sessions.etag
  264. ,sessions.online
  265. ,sessions_index.id
  266. ,sessions_index.etag
  267. ,sessions_activegroups.content
  268. ,sessions_activegroups.updated
  269. ,sessions_activegroups.etag
  270. ,sessions_activepolicies.content
  271. ,sessions_activepolicies.updated
  272. ,sessions_activepolicies.etag
  273. ,sessions_applications.content
  274. ,sessions_applications.updated
  275. ,sessions_applications.etag
  276. ,sessions_directive.content
  277. ,sessions_directive.updated
  278. ,sessions_directive.etag
  279. ,sessions_properties.content
  280. ,sessions_properties.updated
  281. ,sessions_properties.etag
  282. FROM
  283. sessions_properties LEFT JOIN sessions_index
  284. USING (id) LEFT JOIN sessions_directive
  285. USING (id) LEFT JOIN sessions_applications
  286. USING (id) LEFT JOIN sessions_activepolicies
  287. USING (id) LEFT JOIN sessions_activegroups
  288. USING (id) LEFT JOIN sessions
  289. USING (id)
  290. WHERE
  291. sessions_index.deleted IS NULL
  292. AND sessions_index.id IS NOT NULL
  293. AND sessions.id IS NOT NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!