API tools faq
paste
Advertisement
Guest User

Untitled

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