API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 21st, 2019
133
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.48 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
  32. WHERE
  33. sessions_index.deleted IS NULL
  34. UNION
  35. SELECT
  36. sessions.target_id
  37. ,sessions.device_id
  38. ,sessions.nativeSessionName
  39. ,sessions.terminal
  40. ,sessions.username
  41. ,sessions.displayName
  42. ,sessions.active
  43. ,sessions.created
  44. ,sessions.updated
  45. ,sessions.etag
  46. ,sessions.online
  47. ,sessions_index.id
  48. ,sessions_index.etag
  49. ,sessions_activegroups.content
  50. ,sessions_activegroups.updated
  51. ,sessions_activegroups.etag
  52. ,sessions_activepolicies.content
  53. ,sessions_activepolicies.updated
  54. ,sessions_activepolicies.etag
  55. ,sessions_applications.content
  56. ,sessions_applications.updated
  57. ,sessions_applications.etag
  58. ,sessions_directive.content
  59. ,sessions_directive.updated
  60. ,sessions_directive.etag
  61. ,sessions_properties.content
  62. ,sessions_properties.updated
  63. ,sessions_properties.etag
  64. FROM
  65. sessions LEFT JOIN sessions_properties
  66. USING (id) LEFT JOIN sessions_index
  67. USING (id) LEFT JOIN sessions_directive
  68. USING (id) LEFT JOIN sessions_applications
  69. USING (id) LEFT JOIN sessions_activepolicies
  70. USING (id) LEFT JOIN sessions_activegroups
  71. USING (id)
  72. WHERE
  73. sessions_index.deleted IS NULL
  74. AND sessions_index.id IS NOT NULL
  75. AND sessions.id IS NOT NULL
  76. UNION
  77. SELECT
  78. sessions.target_id
  79. ,sessions.device_id
  80. ,sessions.nativeSessionName
  81. ,sessions.terminal
  82. ,sessions.username
  83. ,sessions.displayName
  84. ,sessions.active
  85. ,sessions.created
  86. ,sessions.updated
  87. ,sessions.etag
  88. ,sessions.online
  89. ,sessions_index.id
  90. ,sessions_index.etag
  91. ,sessions_activegroups.content
  92. ,sessions_activegroups.updated
  93. ,sessions_activegroups.etag
  94. ,sessions_activepolicies.content
  95. ,sessions_activepolicies.updated
  96. ,sessions_activepolicies.etag
  97. ,sessions_applications.content
  98. ,sessions_applications.updated
  99. ,sessions_applications.etag
  100. ,sessions_directive.content
  101. ,sessions_directive.updated
  102. ,sessions_directive.etag
  103. ,sessions_properties.content
  104. ,sessions_properties.updated
  105. ,sessions_properties.etag
  106. FROM
  107. sessions_activegroups LEFT JOIN sessions_properties
  108. USING (id) LEFT JOIN sessions_index
  109. USING (id) LEFT JOIN sessions_directive
  110. USING (id) LEFT JOIN sessions_applications
  111. USING (id) LEFT JOIN sessions_activepolicies
  112. USING (id) LEFT JOIN sessions
  113. USING (id)
  114. WHERE
  115. sessions_index.deleted IS NULL
  116. AND sessions_index.id IS NOT NULL
  117. AND sessions.id IS NOT NULL
  118. UNION
  119. SELECT
  120. sessions.target_id
  121. ,sessions.device_id
  122. ,sessions.nativeSessionName
  123. ,sessions.terminal
  124. ,sessions.username
  125. ,sessions.displayName
  126. ,sessions.active
  127. ,sessions.created
  128. ,sessions.updated
  129. ,sessions.etag
  130. ,sessions.online
  131. ,sessions_index.id
  132. ,sessions_index.etag
  133. ,sessions_activegroups.content
  134. ,sessions_activegroups.updated
  135. ,sessions_activegroups.etag
  136. ,sessions_activepolicies.content
  137. ,sessions_activepolicies.updated
  138. ,sessions_activepolicies.etag
  139. ,sessions_applications.content
  140. ,sessions_applications.updated
  141. ,sessions_applications.etag
  142. ,sessions_directive.content
  143. ,sessions_directive.updated
  144. ,sessions_directive.etag
  145. ,sessions_properties.content
  146. ,sessions_properties.updated
  147. ,sessions_properties.etag
  148. FROM
  149. sessions_activepolicies LEFT JOIN sessions_properties
  150. USING (id) LEFT JOIN sessions_index
  151. USING (id) LEFT JOIN sessions_directive
  152. USING (id) LEFT JOIN sessions_applications
  153. USING (id) LEFT JOIN sessions_activegroups
  154. USING (id) LEFT JOIN sessions
  155. USING (id)
  156. WHERE
  157. sessions_index.deleted IS NULL
  158. AND sessions_index.id IS NOT NULL
  159. AND sessions.id IS NOT NULL
  160. UNION
  161. SELECT
  162. sessions.target_id
  163. ,sessions.device_id
  164. ,sessions.nativeSessionName
  165. ,sessions.terminal
  166. ,sessions.username
  167. ,sessions.displayName
  168. ,sessions.active
  169. ,sessions.created
  170. ,sessions.updated
  171. ,sessions.etag
  172. ,sessions.online
  173. ,sessions_index.id
  174. ,sessions_index.etag
  175. ,sessions_activegroups.content
  176. ,sessions_activegroups.updated
  177. ,sessions_activegroups.etag
  178. ,sessions_activepolicies.content
  179. ,sessions_activepolicies.updated
  180. ,sessions_activepolicies.etag
  181. ,sessions_applications.content
  182. ,sessions_applications.updated
  183. ,sessions_applications.etag
  184. ,sessions_directive.content
  185. ,sessions_directive.updated
  186. ,sessions_directive.etag
  187. ,sessions_properties.content
  188. ,sessions_properties.updated
  189. ,sessions_properties.etag
  190. FROM
  191. sessions_applications LEFT JOIN sessions_properties
  192. USING (id) LEFT JOIN sessions_index
  193. USING (id) LEFT JOIN sessions_directive
  194. USING (id) LEFT JOIN sessions_activepolicies
  195. USING (id) LEFT JOIN sessions_activegroups
  196. USING (id) LEFT JOIN sessions
  197. USING (id)
  198. WHERE
  199. sessions_index.deleted IS NULL
  200. AND sessions_index.id IS NOT NULL
  201. AND sessions.id IS NOT NULL
  202. UNION
  203. SELECT
  204. sessions.target_id
  205. ,sessions.device_id
  206. ,sessions.nativeSessionName
  207. ,sessions.terminal
  208. ,sessions.username
  209. ,sessions.displayName
  210. ,sessions.active
  211. ,sessions.created
  212. ,sessions.updated
  213. ,sessions.etag
  214. ,sessions.online
  215. ,sessions_index.id
  216. ,sessions_index.etag
  217. ,sessions_activegroups.content
  218. ,sessions_activegroups.updated
  219. ,sessions_activegroups.etag
  220. ,sessions_activepolicies.content
  221. ,sessions_activepolicies.updated
  222. ,sessions_activepolicies.etag
  223. ,sessions_applications.content
  224. ,sessions_applications.updated
  225. ,sessions_applications.etag
  226. ,sessions_directive.content
  227. ,sessions_directive.updated
  228. ,sessions_directive.etag
  229. ,sessions_properties.content
  230. ,sessions_properties.updated
  231. ,sessions_properties.etag
  232. FROM
  233. sessions_directive LEFT JOIN sessions_properties
  234. USING (id) LEFT JOIN sessions_index
  235. USING (id) LEFT JOIN sessions_applications
  236. USING (id) LEFT JOIN sessions_activepolicies
  237. USING (id) LEFT JOIN sessions_activegroups
  238. USING (id) LEFT JOIN sessions
  239. USING (id)
  240. WHERE
  241. sessions_index.deleted IS NULL
  242. AND sessions_index.id IS NOT NULL
  243. AND sessions.id IS NOT NULL
  244. UNION
  245. SELECT
  246. sessions.target_id
  247. ,sessions.device_id
  248. ,sessions.nativeSessionName
  249. ,sessions.terminal
  250. ,sessions.username
  251. ,sessions.displayName
  252. ,sessions.active
  253. ,sessions.created
  254. ,sessions.updated
  255. ,sessions.etag
  256. ,sessions.online
  257. ,sessions_index.id
  258. ,sessions_index.etag
  259. ,sessions_activegroups.content
  260. ,sessions_activegroups.updated
  261. ,sessions_activegroups.etag
  262. ,sessions_activepolicies.content
  263. ,sessions_activepolicies.updated
  264. ,sessions_activepolicies.etag
  265. ,sessions_applications.content
  266. ,sessions_applications.updated
  267. ,sessions_applications.etag
  268. ,sessions_directive.content
  269. ,sessions_directive.updated
  270. ,sessions_directive.etag
  271. ,sessions_properties.content
  272. ,sessions_properties.updated
  273. ,sessions_properties.etag
  274. FROM
  275. sessions_index LEFT JOIN sessions_properties
  276. USING (id) LEFT JOIN sessions_directive
  277. USING (id) LEFT JOIN sessions_applications
  278. USING (id) LEFT JOIN sessions_activepolicies
  279. USING (id) LEFT JOIN sessions_activegroups
  280. USING (id) LEFT JOIN sessions
  281. USING (id)
  282. WHERE
  283. sessions_index.deleted IS NULL
  284. AND sessions_index.id IS NOT NULL
  285. AND sessions.id IS NOT NULL
  286. UNION
  287. SELECT
  288. sessions.target_id
  289. ,sessions.device_id
  290. ,sessions.nativeSessionName
  291. ,sessions.terminal
  292. ,sessions.username
  293. ,sessions.displayName
  294. ,sessions.active
  295. ,sessions.created
  296. ,sessions.updated
  297. ,sessions.etag
  298. ,sessions.online
  299. ,sessions_index.id
  300. ,sessions_index.etag
  301. ,sessions_activegroups.content
  302. ,sessions_activegroups.updated
  303. ,sessions_activegroups.etag
  304. ,sessions_activepolicies.content
  305. ,sessions_activepolicies.updated
  306. ,sessions_activepolicies.etag
  307. ,sessions_applications.content
  308. ,sessions_applications.updated
  309. ,sessions_applications.etag
  310. ,sessions_directive.content
  311. ,sessions_directive.updated
  312. ,sessions_directive.etag
  313. ,sessions_properties.content
  314. ,sessions_properties.updated
  315. ,sessions_properties.etag
  316. FROM
  317. sessions_properties LEFT JOIN sessions_index
  318. USING (id) LEFT JOIN sessions_directive
  319. USING (id) LEFT JOIN sessions_applications
  320. USING (id) LEFT JOIN sessions_activepolicies
  321. USING (id) LEFT JOIN sessions_activegroups
  322. USING (id) LEFT JOIN sessions
  323. USING (id)
  324. WHERE
  325. sessions_index.deleted IS NULL
  326. AND sessions_index.id IS NOT NULL
  327. 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!