JSON:
"results": {
"A": {
"refId": "A",
"meta": {
"rowCount": 54392,
"sql": "SELECT email, passwd, api_password_encrypted, top_client, full_name, phone FROM accounts;"
},
"series": null,
"tables": [{
"columns": [{
"text": "email"
}, {
"text": "passwd"
}, {
"text": "api_password_encrypted"
}, {
"text": "top_client"
}, {
"text": "full_name"
}, {
"text": "phone"
}],
"rows": [
["minhnd@vega.com.vn", "$2y$13$xLWpj2L7zH40x2jdijUmA.HN238jYXUVfKyidQAvOrbircxW7QOv.", "tjN2JCAtN5Ayunf3ATqNdGrSoLXCOpDKE5FWjs39sH8B4huSwprbEcnArKoe9Btp$yJJGzv1kbqQCTHyakFbQYA==", null, "Nguyen Duc Minh", null],
["rghcinhnt395173951@163.com", "$2y$13$MzyNE2QJGeSXyZMI4YRue.AN9IXcfGalPtZZ6Jw1WpANsu3ck00lq", "zrN9p9wTcqP7z/NScGfvnsMoN4cJ0euhpYxqGps16r06G4SVHLiHwQ4eyG5Eikli$Ea58jYumasAiSJz3KENlMw==", null, "Jewell Showalter", null],
["arbitrary.software.llc@gmail.com", "$2y$13$QuOKY4okmBaJzglNBfrHlOwOYdqRFb7HjVyje7DJ75MegEYbxu8..", "lvUmgQXloajKXIB90RA5VhMlAeHk2neW900KZcKjAnApWYHGl1PsXKC3D77lgtCc$B6Z6YkGIEu4dtpQEs+sBxg==", null, "David Rostowsky", null],
["tony@moustacherepublic.com", "$2y$13$elBh8/HNWk96sMr/Fp7KfOzkcCRL/SMhjnRyZP3yxTGlyGrI1mJYe", "NH3CWGvelPcPx+D3wtUXBsRagIe2oAam9DPBMVrcsYOoDLHhaB42vVgLJ+SfbZPs$4ZTe/Z5U50smglsjD3ikSg==", null, "Tony Hou", null],
["marat.dyatko@mirado.com", "$2y$13$U0n/I9JrsOGCW.Oka6GqmeMSf4WNcC.jLcTzq9Il6i/h6zg4HWzDG", "AeARqrE1ZvOOnNTRSQ0bta3R72XEgb2LP3NhfGSu6B6q694mkdOyZ9ZTydU8EhGk$QMYSp9TqGz8ZxIha1LuJfA==", null, "Marat Dyatko", null],
["ferdinand@grandisen.com", "$2y$13$NVgotAzheeERr.wvzJXEKujOqf52FsivzBEwB8EEkSt8rIBJGwIjK", "l2HCH/KvtrbUPMomphemOxKV4MM6XK6tSvaCgTI22HuWkwpyww/kY8Q+oJcHt+wg$KaXaMP1nj0ZCoHdCgyW06Q==", null, "Ferdinand Louise", "+6289695007227"],
JSON:
{
"results": {
"A": {
"refId": "A",
"meta": {
"rowCount": 54384,
"sql": "SELECT * FROM accounts;"
},
"series": null,
"tables": [{
"columns": [{
"text": "id"
}, {
"text": "email"
}, {
"text": "created"
}, {
"text": "company"
}, {
"text": "full_name"
}, {
"text": "time_zone"
}, {
"text": "access_sent"
}, {
"text": "first_order_ip"
}, {
"text": "billingon"
}, {
"text": "country"
}, {
"text": "expiredtrial"
}, {
"text": "suspended"
}, {
"text": "suspended_reason"
}, {
"text": "role"
}, {
"text": "phone"
}, {
"text": "renewal_upper_limit"
}, {
"text": "passwd"
}, {
"text": "last_password_change"
}, {
"text": "subscribed"
}, {
"text": "who_suspended"
}, {
"text": "skype"
}, {
"text": "top_client"
}, {
"text": "admin_email"
}, {
"text": "api_password_encrypted"
}, {
"text": "sponsored_client"
}, {
"text": "parent_id"
}, {
"text": "testing"
}, {
"text": "promo_code_id"
}, {
"text": "two_step_auth_secret"
}],
"rows": [
[43592, "minhnd@vega.com.vn", "2017-06-20T10:34:23.80936Z", null, "Nguyen Duc Minh", null, "2017-06-20T10:34:24.023408Z", "118.70.124.143", false, "VN", "2017-06-20T10:34:50.493855Z", "2017-06-20T10:39:26.162697Z", "debtor", "user", null, null, "$2y$13$xLWpj2L7zH40x2jdijUmA.HN238jYXUVfKyidQAvOrbircxW7QOv.", "2017-06-20T10:34:24Z", true, 37677, null, null, null, "tjN2JCAtN5Ayunf3ATqNdGrSoLXCOpDKE5FWjs39sH8B4huSwprbEcnArKoe9Btp$yJJGzv1kbqQCTHyakFbQYA==", null, null, false, null, null],
[58665, "rghcinhnt395173951@163.com", "2019-03-04T18:18:56.628203Z", null, "Jewell Showalter", null, "2019-03-04T18:18:57.529268Z", "218.50.4.25", false, "KR", null, null, null, "user", null, null, "$2y$13$MzyNE2QJGeSXyZMI4YRue.AN9IXcfGalPtZZ6Jw1WpANsu3ck00lq", "2019-03-04T18:18:57Z", true, null, null, null, "rghcinhnt395173951@163.com", "zrN9p9wTcqP7z/NScGfvnsMoN4cJ0euhpYxqGps16r06G4SVHLiHwQ4eyG5Eikli$Ea58jYumasAiSJz3KENlMw==", null, null, false, null, null],
[33518, "arbitrary.software.llc@gmail.com", "2016-05-31T14:47:31.255714Z", null, "David Rostowsky", null, "2016-05-31T14:47:31.565395Z", "24.22.168.227", false, "US", "2016-06-01T03:13:32.136773Z", null, null, "user", null, 199, "$2y$13$QuOKY4okmBaJzglNBfrHlOwOYdqRFb7HjVyje7DJ75MegEYbxu8..", "2016-05-31T14:47:31Z", true, null, null, null, null, "lvUmgQXloajKXIB90RA5VhMlAeHk2neW900KZcKjAnApWYHGl1PsXKC3D77lgtCc$B6Z6YkGIEu4dtpQEs+sBxg==", null, null, false, null, null],
[10958, "tony@moustacherepublic.com", "2013-04-25T04:37:25.012828Z", null, "Tony Hou", null, "2013-04-25T04:37:25.388281Z", "111.69.33.19", false, "NZ", "2013-10-09T23:50:14.846936Z", "2018-07-14T14:55:07.450464Z", "credit_expired_termination", "user", null, null, "$2y$13$elBh8/HNWk96sMr/Fp7KfOzkcCRL/SMhjnRyZP3yxTGlyGrI1mJYe", "2017-06-14T05:22:50Z", true, 10958, null, null, null, "NH3CWGvelPcPx+D3wtUXBsRagIe2oAam9DPBMVrcsYOoDLHhaB42vVgLJ+SfbZPs$4ZTe/Z5U50smglsjD3ikSg==", null, null, false, null, null],
[60402, "marat.dyatko@mirado.com", "2019-05-05T18:41:43.931168Z", null, "Marat Dyatko", null, "2019-05-05T18:41:44.852883Z", "213.185.20.190", false, "SE", "2019-05-05T18:42:42.855959Z", "2019-05-22T13:00:11.964469Z", "end_of_trial", "user", null, null, "$2y$13$U0n/I9JrsOGCW.Oka6GqmeMSf4WNcC.jLcTzq9Il6i/h6zg4HWzDG", "2019-05-05T18:41:45Z", true, 60402, null, null, null, "AeARqrE1ZvOOnNTRSQ0bta3R72XEgb2LP3NhfGSu6B6q694mkdOyZ9ZTydU8EhGk$QMYSp9TqGz8ZxIha1LuJfA==", null, null, false, null, null],
[49786, "ferdinand@grandisen.com", "2018-03-13T14:46:22.648633Z", null, "Ferdinand Louise", null, "2018-03-13T14:46:23.498043Z", "36.84.62.207", false, "ID", "2018-03-13T14:47:28.745354Z", "2018-03-14T04:52:09.599607Z", "clients_request", "user", "+6289695007227", null, "$2y$13$NVgotAzheeERr.wvzJXEKujOqf52FsivzBEwB8EEkSt8rIBJGwIjK", "2018-03-13T14:46:23Z", true, 49786, null, null, null, "l2HCH/KvtrbUPMomphemOxKV4MM6XK6tSvaCgTI22HuWkwpyww/kY8Q+oJcHt+wg$KaXaMP1nj0ZCoHdCgyW06Q==", null, null, false, null, null],
[25282, "tirto@adskom.com", "2015-09-08T06:14:52.288786Z", null, "Tirto Adji", null, "2015-09-08T06:14:52.482871Z", "114.124.3.156", false, "ID", "2016-08-18T00:00:00Z", "2019-04-28T14:55:03.074609Z", "credit_expired_termination", "user", "+6281316682406", 199, "$2y$13$G5CHvc.GtCGL6MpKpdzGK.VsVxI4VD.xlLdrZzK3cF.Murh3Lif9a", "2017-08-31T01:52:29Z", true, 25282, null, null, null, "ICOBkM36X4yQmM3iUPrzarO5KwvaA6nbY/WRd+Tj4p8bdm180vVU3x1cwVhOnuxB$cdhsyMJgo/RGPYsvg8ui8w==", null, null, false, null, null],
[63557, "189837674@qq.com", "2019-10-26T05:36:28.290725Z", null, "finder", null, "2019-10-26T05:36:29.150348Z", "124.236.119.2", false, "CN", "2019-10-26T05:37:35.103762Z", "2019-11-12T13:00:02.243686Z", "end_of_trial", "user", null, null, "$2y$13$qZHCr8T4ANq1GRLWgzs74u7XBaTNJHcI5LsyD.f3onOJXVcWlTpa.", "2019-10-26T05:36:29Z", true, 63557, null, null, null, "tjHMiMJR9tIdhi8EZq0iiNpn40p7ArKsN09ke2er3U1WFjMp+V348m4ixV0Nmkqa$KcTw875bg6wImdiW9w45UA==", null, null, false, null, null],
[44742, "ridwan@gatra.com", "2017-08-12T18:17:38.985351Z", null, "Samuel Ridwan", null, "2017-08-12T18:17:39.791662Z", "103.22.137.66", false, "ID", "2017-08-12T18:18:52.489523Z", "2017-08-28T06:38:18.272558Z", "Other: end of the trial", "user", null, null, "$2y$13$OsN81nVhizb0z9aDS50bfejgK1iAv0dNRJFn7utRAWzs4bjv4zXea", "2017-08-12T18:17:40Z", true, 32769, null, null, null, "t/6HLj8X04d5t5j+8q9Mf70kNanyiv3UELd2qGw3zDBSGycRL4L/RwGXiGLcDPTw$aKGmYqHGp9vGoCVWdhovGw==", null, null, false, null, null],
[60690, "contact.imaxtv@gmail.com", "2019-05-23T04:31:04.745718Z", null, "moody", null, "2019-05-23T04:31:05.616172Z", "202.166.175.242", false, "PK", null, null, null, "user", null, null, "$2y$13$omERZU/JbM4qd8mZ/fskNuyHenjmpIyrGqEpiMFttDpSd9IudjpEy", "2019-05-23T04:31:05Z", true, null, null, null, null, "iKp4DcHxd2ajkxsHeRXQ+bBGDl8e2kkiudZwLNJOvSY1MAfLoTvNHFZMkKH0/0El$X/1EEP2wxd/s7FLkbKK2hA==", null, null, false, null, null],
[60407, "shutsus@hotmail.com", "2019-05-06T00:58:07.031177Z", null, "Shutsus", null, "2019-05-06T00:58:07.886659Z", "14.207.16.181", false, "TH", "2019-05-06T00:58:45.804267Z", "2019-05-23T13:00:09.197209Z", "end_of_trial", "user", null, null, "$2y$13$G0npZi8Jx7JHM0syuVY/aezZ53CmycJhdPq51A2ot76v9pGk24HEa", "2019-05-06T00:58:08Z", true, 60407, null, null, null, "KcRbNt0ZxfYg6Vt//JHh/8/8Op03n4w4UB4BB+4vavJimykS0wvomxxXbLngxP8p$53p3Fwcc7/oF2ns2he8EIQ==", null, null, false, null, null],
[62251, "jflqfjqe3782d23da@gmail.com", "2019-08-09T15:10:25.360614Z", null, "adam wozniak", null, "2019-08-09T15:10:26.214317Z", "178.235.3.202", false, "PL", "2019-08-09T15:21:46.690005Z", "2019-08-26T13:00:03.409934Z", "end_of_trial", "user", null, null, "$2y$13$kh6HY0pMsddwwPuy4LBWQ.ot2vSVCeRnwj9CS3uBlCqCTZ./OJ.92", "2019-08-09T15:10:26Z", true, 62251, null, null, null, "fThSbGu8eMNUcguv6aij/T+PAtLPNmxNGVw4KLZBbfSGuk5lkH9RJ7R8iGnF+4mT$aAnNa4e49c8Y4nMewgpsZw==", null, null, false, null, null],
[60479, "ehsan.saeidpoor@yahoo.com", "2019-05-09T13:00:27.537466Z", null, "ehsan saeidpour", null, "2019-05-09T13:00:28.335316Z", "109.169.65.209", false, "GB", "2019-05-09T13:01:00.728561Z", "2019-05-26T13:00:03.333764Z", "end_of_trial", "user", null, null, "$2y$13$bbh3.u1CGam.V735FAKzXuq5jKOUDtAADVUBEImfK2Qb9vgtqQHEC", "2019-05-09T13:00:28Z", true, 60479, null, null, null, "5+Z0uSTvt4Yi4GudxPoDU7Ecy6vPM9TGNeVK0T5bvrZiqQa8zEpkHPFvXUq1e18z$8rqtLV52DYff725A9rTItw==", null, null, false, null, null],
[14490, "cristian.sucila@gmail.com", "2014-01-21T10:35:26.693874Z", null, "Sucila Liviu Cristian", "Europe/Bucharest", "2014-01-21T10:35:28.968605Z", "5.15.115.136", false, "RO", "2014-01-21T10:38:21.519711Z", "2017-12-05T15:24:46.273336Z", "credit_expired_termination", "user", null, null, "$2y$13$RmrS/lp0a8xJM6nenTRfQu6Lw9Q/a.vaEXiZ8be1z3Up0doupR.VW", "2014-01-21T11:43:31Z", true, 14490, null, null, null, "vTTnCUdsICq5qRSJFsI2erW7TnejBLfpHjiLhKXx4SyXs4FJI3uYgAuHjGzzjT04$ZBjTjOBrEV/cZ5ra8msOoA==", null, null, false, null, null],
[62224, "info@qoasha.com", "2019-08-08T06:19:11.803701Z", null, "Shakib Rahman", null, "2019-08-08T06:19:12.674013Z", "118.179.216.129", false, "BD", "2019-08-08T06:20:21.58226Z", "2019-08-25T13:00:02.330295Z", "end_of_trial", "user", null, null, "$2y$13$ddYbLYQZiY6Wc31GdL/.bu16Cf2MRwDJRXCSiVRcIC7EvMn46YaUe", "2019-08-08T06:19:13Z", true, 62224, null, null, null, "b8aRiWCAupGvYXgoZU3QeqHWEKx9RLDt7OvO+4ZHjIAQo/rIwT1+DGHDT9mpPokO$JJy2zra4TUgCV6pOA4kbIA==", null, null, false, null, null],
[62263, "fred@onlinelive.nl", "2019-08-10T07:57:33.702732Z", null, "Fred de Jong", null, "2019-08-10T07:57:34.553834Z", "94.209.113.252", false, "NL", "2019-08-10T07:58:39.995813Z", "2019-08-27T13:00:07.047919Z", "end_of_trial", "user", null, null, "$2y$13$phkLUMLdQlzPH7cG5fjxeO2MB.8j/ZtxrfrSIu7ZABi46aCaNIL7O", "2019-08-10T07:57:34Z", true, 62263, null, null, null, "z/1LpXQBRMt1SuXaeFJeDCTdgvoy8dqrMm6O6UG0Hv5z1hdvvWT6tS3l5n61uE99$Mxtgz3QwQSfHEP7vcGrQww==", null, null, false, null, null],
[62274, "xx8br4@mozej.com", "2019-08-11T05:21:14.664668Z", null, "xx8br4", null, "2019-08-11T05:21:15.602049Z", "217.23.3.92", false, "NL", "2019-08-11T05:22:59.743513Z", "2019-08-28T13:00:05.855626Z", "end_of_trial", "user", null, null, "$2y$13$xjWejUCu0zm.tAY13KYr4uESo.hNi4M6HRgUjVWIzd/uUC7aTu/GK", "2019-08-11T05:21:15Z", true, 62274, null, null, null, "G4yHC53BmEuCIBn9veBhNBP2sHGQ6e4xw4MpvgLfRZdl6B6K2fa69egK+WG/rToh$AozsF4AsfqOupaim0e5z+g==", null, null, false, null, null],
[62252, "georgerobandrade@gmail.com", "2019-08-09T17:10:21.298804Z", null, "George Andrade", null, "2019-08-09T17:10:22.171372Z", "107.77.225.12", false, "US", "2019-08-09T17:28:16.128732Z", "2019-08-26T13:00:03.843753Z", "end_of_trial", "user", null, null, "$2y$13$LE3zVqhDefmxs2M3j0UwIur2hFiNLJFKwcvQ4vyCP/wqj8jajhoTK", "2019-08-09T17:10:22Z", true, 62252, null, null, null, "UWedwwQGlt2rN8LRX/MooU4fe3u3HVs7EGPj4Lqs1lndJfRmY98YvhELrXMm0HlN$WB58pFRzQ2rRpkH03DLPVw==", null, null, false, null, null],
[62276, "contact@flotflot.com", "2019-08-11T11:18:02.349608Z", null, "Dejan Simic", null, "2019-08-11T11:18:03.208654Z", "87.116.179.27", false, "RS", "2019-08-11T11:18:47.288717Z", "2019-08-28T13:00:07.066891Z", "end_of_trial", "user", null, null, "$2y$13$WpqXltbVJ.STfWuGjcmch.oWXmpSgwsZZuUh6QZ9pk5q7K4eEiVNG", "2019-08-11T11:18:03Z", true, 62276, null, null, null, "uvQQbPoW2gTzJyhJ6TYgwJHXZhDBo4AlHpf46PWvpjzysPRgiENm6YxU/6L87WOw$FZG5fXCcUCwjO+B9JOTNBQ==", null, null, false, null, null],
[65232, "rodrigo@idealsinteractive.com", "2020-01-03T01:42:43.182367Z", null, "rodrigo", null, "2020-01-03T01:42:44.056964Z", "181.121.36.108", false, "PY", "2020-01-03T01:43:17.873351Z", "2020-01-20T13:00:01.893936Z", "end_of_trial", "user", null, null, "$2y$13$4agyaye3rArWgmzWj2sMC.raRT.aYctQh8rUwxdO4KkhDI0CcDrDi", "2020-01-03T01:42:44Z", true, 65232, null, null, null, "jfOLr+tftJa6ifQMvo0/E6LaFihuFYs/X4DMZG0L1mX3rDUFTELZuoLpYeTbZZrD$s5K3sv0j/CneusAZZsXzNw==", null, null, false, null, null],
[62294, "milan.fitzek@sunteq.com", "2019-08-12T12:35:50.190942Z", null, "Milan Fitzek", null, "2019-08-12T12:35:51.045166Z", "77.247.225.215", false, "SK", "2019-08-12T12:37:03.589405Z", "2019-08-29T13:00:05.404594Z", "end_of_trial", "user", null, null, "$2y$13$6cxjJLMxtl5dXNFyeIUs5./tgU10nMz8.J1CaxS7eoop9ApiU/JwK", "2019-08-12T12:35:51Z", true, 62294, null, null, null, "BnS5hQQUKul4WV2sjmFAmRyDY9PcArtxqb4I/NdZLJzf70RkPWBP7d7OLTXa8HQI$fCqmS4oUDZ5EDCEyFEOCLQ==", null, null, false, null, null],
[45169, "gianghuynh.niit@gmail.com", "2017-09-01T09:59:53.973843Z", null, "Giang Huynh", null, "2017-09-01T09:59:54.784468Z", "118.68.195.24", false, "VN", "2017-09-01T10:01:03.842347Z", "2017-09-22T13:01:05.711314Z", "end_of_trial", "user", null, null, "$2y$13$hJUQll7O41jVAE8JxYrDbu/azs8MOASWqrlfl2mC/czWFDQ/tU.1.", "2017-09-01T09:59:55Z", true, 45169, null, null, null, "m1/rPHhCT/FJ6g0CqYBaaTGjlU7Wmd6EhyeVQYLqdZj+rBIrz4Ejtks4PNwCHff7$Kw0NR6cRNZZ31WZCG8sVag==", null, null, false, null, null],
[62297, "garagedoorcowboys@gmail.com", "2019-08-12T15:53:58.96369Z", null, "Mike", null, "2019-08-12T15:54:00.133477Z", "108.161.178.5", false, "US", "2019-08-12T15:54:37.319574Z", "2019-08-29T13:00:08.116721Z", "end_of_trial", "user", null, null, "$2y$13$wMuWUTi.g3P5skYUfo1S6e89hcnZ51a8ClFTqrVW.5ujr/z1piGjm", "2019-08-12T15:54:00Z", true, 62297, null, null, null, "s/wo37Yy1pspBeV12LJ9rUI7Q3phtpKiw0/tMgLYDopMWnlBtr1HZktvHq5Fo1VQ$0oKTcFa+HBCxO2vr3jeS0A==", null, null, false, null, null],
[44374, "h.knoedler@airtango.de", "2017-07-26T07:34:26.931144Z", null, "Harald Knödler", null, "2017-07-26T07:34:27.708608Z", "185.161.231.254", true, null, null, null, null, "user", null, null, "$2y$13$VDVUK0bWjZE8ZCYi/tbsT.q1a9Xy.ShZQqGT1FtzBKxRQ8GC107Yu", "2019-10-11T05:11:13Z", true, null, null, null, null, "nHWWYwIyV6AWlH9aUxE+LUBzoeVRML7Q2BKGW7Wq+6wa3inMIikitx6FvyRJIYD9$/+DnGttd+oI5J8BPyduWww==", null, null, false, null, null],
[46982, "FABIO@FABIOVIANNA.COM", "2017-11-15T01:48:45.966561Z", null, "Fabio Vianna", null, "2017-11-15T01:48:46.807471Z", "186.204.234.145", false, "BR", "2017-11-15T01:49:24.508889Z", "2017-11-15T03:34:56.832089Z", "clients_request", "user", null, null, "$2y$13$vVsPFl.HP1lsuhJYQSgGweKnCw0IcDvU6adl6fiQZyc0mF8LjSs1q", "2017-11-15T01:48:47Z", true, 46982, null, null, null, "MjQhQ65yC1c+p/dBkUO2qZikWS5NNOfwmdarF+FoU+OIbX8k+0dpSzPQ89YYbQom$YY9UWlE04AB+DNsq/14ghQ==", null, null, false, null, null],
JSON:
"rez": [
[{
"ip": "195.181.168.54",
"ip6": "",
"environment_id": null,
"environment_name": null,
"last_report": null,
"mac": "90:e2:ba:e7:b1:ad",
"realm_id": null,
"realm_name": null,
"sp_mac": "ac:1f:6b:2e:87:07",
"sp_ip": "10.110.36.70",
"sp_name": "",
"domain_id": 2,
"domain_name": "10gbps.io",
"architecture_id": 1,
"architecture_name": "x86_64",
"operatingsystem_id": 3,
"operatingsystem_name": "CentOS 7",
"subnet_id": 144,
"subnet_name": "NYC DP Shared",
"subnet6_id": null,
"subnet6_name": null,
"sp_subnet_id": null,
"ptable_id": 146,
"ptable_name": "old 10Gbps.io kickstart 2x RAID1",
"medium_id": 1,
"medium_name": "CentOS mirror [auto]",
"pxe_loader": "PXELinux BIOS",
"build": false,
"comment": "",
"disk": "",
"installed_at": "2018-08-29 02:20:08 -0700",
"model_id": 1,
"hostgroup_id": 1,
"owner_id": 3,
"owner_name": "Admin User",
"owner_type": "User",
"enabled": true,
"managed": true,
"use_image": null,
"image_file": "",
"uuid": null,
"compute_resource_id": null,
"compute_resource_name": null,
"compute_profile_id": null,
"compute_profile_name": null,
"capabilities": ["build"],
"provision_method": "build",
"certname": "1002.10gbps.io",
"image_id": null,
"image_name": null,
"created_at": "2017-09-14 07:37:42 -0700",
"updated_at": "2018-08-29 02:20:11 -0700",
"last_compile": null,
"global_status": 0,
"global_status_label": "OK",
"organization_id": 2,
"organization_name": "Default Organization",
"location_id": 1,
"location_name": "Default Location",
"puppet_status": 0,
"model_name": "Super Server",
"build_status": 0,
"build_status_label": "Installed",
"name": "1002.10gbps.io",
"id": 947,
"puppet_proxy_id": null,
"puppet_proxy_name": null,
"puppet_ca_proxy_id": null,
"puppet_ca_proxy_name": null,
"puppet_proxy": null,
"puppet_ca_proxy": null,
"hostgroup_name": "Default",
"hostgroup_title": "Default"
}, {
"ip": "185.59.223.85",
"ip6": "",
"environment_id": null,
"environment_name": null,
"last_report": null,
"mac": "90:e2:ba:e7:af:e9",
"realm_id": null,
"realm_name": null,
"sp_mac": "ac:1f:6b:2e:87:06",
"sp_ip": "10.110.36.71",
"sp_name": "",
"domain_id": 2,
"domain_name": "10gbps.io",
"architecture_id": 1,
"architecture_name": "x86_64",
"operatingsystem_id": 5,
"operatingsystem_name": "Ubuntu 16.04.2",
"subnet_id": 50,
"subnet_name": "NYC-10g-shared-2-vlan954",
"subnet6_id": null,
"subnet6_name": null,
"sp_subnet_id": null,
"ptable_id": 136,
"ptable_name": "10Gbps.io preseed 2x RAID1",
"medium_id": 7,
"medium_name": "Ubuntu mirror [CZ]",
"pxe_loader": "PXELinux BIOS",
"build": false,
"comment": "",
"disk": null,
"installed_at": "2017-09-14 11:30:42 -0700",
"model_id": 1,
"hostgroup_id": 1,
"owner_id": 3,
"owner_name": "Admin User",
"owner_type": "User",
"enabled": true,
"managed": true,
"use_image": null,
"image_file": "",
"uuid": null,
"compute_resource_id": null,
"compute_resource_name": null,
"compute_profile_id": null,
"compute_profile_name": null,
"capabilities": ["build"],
"provision_method": "build",
"certname": "1003.10gbps.io",
"image_id": null,
"image_name": null,
"created_at": "2017-09-14 10:51:16 -0700",
"updated_at": "2017-09-14 11:30:45 -0700",
"last_compile": null,
"global_status": 0,
"global_status_label": "OK",
"organization_id": 2,
"organization_name": "Default Organization",
"location_id": 1,
"location_name": "Default Location",
"puppet_status": 0,
"model_name": "Super Server",
"build_status": 0,
"build_status_label": "Installed",
"name": "1003.10gbps.io",
"id": 964,
"puppet_proxy_id": null,
"puppet_proxy_name": null,
"puppet_ca_proxy_id": null,
"puppet_ca_proxy_name": null,
"puppet_proxy": null,
"puppet_ca_proxy": null,
"hostgroup_name": "Default",
"hostgroup_title": "Default"
}, {
"ip": "185.59.223.59",
"ip6": "",
"environment_id": null,
"environment_name": null,
"last_report": null,
"mac": "90:e2:ba:e7:b0:0d",
"realm_id": null,
"realm_name": null,
"sp_mac": "ac:1f:6b:03:c4:f1",
"sp_ip": "10.110.36.72",
"sp_name": "",
"domain_id": 2,
"domain_name": "10gbps.io",
"architecture_id": 1,
"architecture_name": "x86_64",
"operatingsystem_id": 2,
"operatingsystem_name": "Ubuntu 14.04.6",
"subnet_id": 52,
"subnet_name": "NYC-10Gbps.io-shared 5",
"subnet6_id": null,
"subnet6_name": null,
"sp_subnet_id": null,
"ptable_id": 136,
{
Username: andy
Password: HUmR6CT6u4vbbUM8
Bash:
curl 'https://grafana.cdn77.eu/api/tsdb/query' -H 'User-Agent: localhost' -H 'Accept: application/json, text/plain, */*' -H 'Accept-Language: en-US,en;q=0.5' --compressed -H 'Referer: https://grafana.cdn77.eu/explore?orgId=1&left=%5B%22now-1h%22,%22now%22,%22cdn77%22,%7B%22datasource%22:%22cdn77%22,%22format%22:%22table%22,%22timeColumn%22:%22service_from%22,%22metricColumn%22:%22none%22,%22group%22:%5B%5D,%22where%22:%5B%7B%22type%22:%22macro%22,%22name%22:%22$__timeFilter%22,%22params%22:%5B%5D%7D%5D,%22select%22:%5B%5B%7B%22type%22:%22column%22,%22params%22:%5B%22max_traffic%22%5D%7D%5D%5D,%22rawQuery%22:true,%22rawSql%22:%22SELECT%20table_schema,table_name%5CnFROM%20information_schema.tables%5CnORDER%20BY%20table_schema,table_name;%22,%22table%22:%22service_streaming%22,%22timeColumnType%22:%22timestamp%22%7D,%7B%22mode%22:%22Metrics%22%7D,%7B%22ui%22:%5Btrue,true,true,%22none%22%5D%7D%5D' -H 'X-Grafana-Org-Id: 1' -H 'Content-Type: application/json;charset=utf-8' -H 'Connection: keep-alive' -H 'Cookie: grafana_session=*' --data '{"from":"","to":"","queries":[{"refId":"A","intervalMs":60000,"maxDataPoints":1500,"datasourceId":8,"rawSql":"SELECT * FROM api;","format":"table"}]}'