API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
169
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 57.20 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "__inputs": [
  3. {
  4. "name": "DS_MYSQL",
  5. "label": "MySQL",
  6. "description": "",
  7. "type": "datasource",
  8. "pluginId": "mysql",
  9. "pluginName": "MySQL"
  10. },
  11. {
  12. "name": "DS_INFLUXDB-UNIFI",
  13. "label": "InfluxDB-unifi",
  14. "description": "",
  15. "type": "datasource",
  16. "pluginId": "influxdb",
  17. "pluginName": "InfluxDB"
  18. }
  19. ],
  20. "__requires": [
  21. {
  22. "type": "grafana",
  23. "id": "grafana",
  24. "name": "Grafana",
  25. "version": "6.2.2"
  26. },
  27. {
  28. "type": "panel",
  29. "id": "grafana-piechart-panel",
  30. "name": "Pie Chart",
  31. "version": "1.3.6"
  32. },
  33. {
  34. "type": "panel",
  35. "id": "graph",
  36. "name": "Graph",
  37. "version": ""
  38. },
  39. {
  40. "type": "datasource",
  41. "id": "influxdb",
  42. "name": "InfluxDB",
  43. "version": "1.0.0"
  44. },
  45. {
  46. "type": "datasource",
  47. "id": "mysql",
  48. "name": "MySQL",
  49. "version": "1.0.0"
  50. },
  51. {
  52. "type": "panel",
  53. "id": "singlestat",
  54. "name": "Singlestat",
  55. "version": ""
  56. }
  57. ],
  58. "annotations": {
  59. "list": [
  60. {
  61. "builtIn": 1,
  62. "datasource": "-- Grafana --",
  63. "enable": true,
  64. "hide": true,
  65. "iconColor": "rgba(0, 211, 255, 1)",
  66. "name": "Annotations & Alerts",
  67. "type": "dashboard"
  68. }
  69. ]
  70. },
  71. "editable": true,
  72. "gnetId": null,
  73. "graphTooltip": 1,
  74. "id": null,
  75. "links": [],
  76. "panels": [
  77. {
  78. "cacheTimeout": null,
  79. "colorBackground": false,
  80. "colorValue": false,
  81. "colors": [
  82. "#299c46",
  83. "rgba(237, 129, 40, 0.89)",
  84. "#d44a3a"
  85. ],
  86. "datasource": "${DS_MYSQL}",
  87. "format": "none",
  88. "gauge": {
  89. "maxValue": 100,
  90. "minValue": 0,
  91. "show": false,
  92. "thresholdLabels": false,
  93. "thresholdMarkers": true
  94. },
  95. "gridPos": {
  96. "h": 7,
  97. "w": 5,
  98. "x": 1,
  99. "y": 0
  100. },
  101. "id": 45,
  102. "interval": null,
  103. "links": [],
  104. "mappingType": 1,
  105. "mappingTypes": [
  106. {
  107. "name": "value to text",
  108. "value": 1
  109. },
  110. {
  111. "name": "range to text",
  112. "value": 2
  113. }
  114. ],
  115. "maxDataPoints": 100,
  116. "nullPointMode": "connected",
  117. "nullText": null,
  118. "options": {},
  119. "postfix": "",
  120. "postfixFontSize": "50%",
  121. "prefix": "",
  122. "prefixFontSize": "50%",
  123. "rangeMaps": [
  124. {
  125. "from": "null",
  126. "text": "N/A",
  127. "to": "null"
  128. }
  129. ],
  130. "sparkline": {
  131. "fillColor": "rgba(31, 118, 189, 0.18)",
  132. "full": false,
  133. "lineColor": "rgb(31, 120, 193)",
  134. "show": false
  135. },
  136. "tableColumn": "sum(peoplecount)",
  137. "targets": [
  138. {
  139. "format": "table",
  140. "group": [],
  141. "metricColumn": "none",
  142. "rawQuery": true,
  143. "rawSql": "select sum(peoplecount) from speakers",
  144. "refId": "A",
  145. "select": [
  146. [
  147. {
  148. "params": [
  149. "Talktotal"
  150. ],
  151. "type": "column"
  152. }
  153. ]
  154. ],
  155. "table": "speakers",
  156. "timeColumn": "TalkID",
  157. "timeColumnType": "int",
  158. "where": []
  159. }
  160. ],
  161. "thresholds": "",
  162. "timeFrom": null,
  163. "timeShift": null,
  164. "title": "Total peoplecount",
  165. "type": "singlestat",
  166. "valueFontSize": "80%",
  167. "valueMaps": [
  168. {
  169. "op": "=",
  170. "text": "N/A",
  171. "value": "null"
  172. }
  173. ],
  174. "valueName": "avg"
  175. },
  176. {
  177. "aliasColors": {},
  178. "breakPoint": "25%",
  179. "cacheTimeout": null,
  180. "combine": {
  181. "label": "Others",
  182. "threshold": 0
  183. },
  184. "datasource": "${DS_INFLUXDB-UNIFI}",
  185. "decimals": 0,
  186. "description": "",
  187. "fontSize": "70%",
  188. "format": "short",
  189. "gridPos": {
  190. "h": 9,
  191. "w": 6,
  192. "x": 6,
  193. "y": 0
  194. },
  195. "hideTimeOverride": true,
  196. "id": 11,
  197. "interval": null,
  198. "legend": {
  199. "header": "",
  200. "percentage": true,
  201. "show": true,
  202. "values": false
  203. },
  204. "legendType": "Right side",
  205. "links": [],
  206. "maxDataPoints": 3,
  207. "nullPointMode": "connected",
  208. "options": {},
  209. "pieType": "pie",
  210. "strokeWidth": "3",
  211. "targets": [
  212. {
  213. "alias": "$tag_radio_proto",
  214. "groupBy": [
  215. {
  216. "params": [
  217. "channel"
  218. ],
  219. "type": "tag"
  220. }
  221. ],
  222. "hide": false,
  223. "measurement": "clients",
  224. "orderByTime": "ASC",
  225. "policy": "default",
  226. "query": "select count(distinct(hostname)) FROM \"clients\" WHERE (time > now() - 10m and is_wired = 'false') group by radio_proto",
  227. "rawQuery": true,
  228. "refId": "A",
  229. "resultFormat": "time_series",
  230. "select": [
  231. [
  232. {
  233. "params": [
  234. "hostname"
  235. ],
  236. "type": "field"
  237. },
  238. {
  239. "params": [],
  240. "type": "distinct"
  241. }
  242. ]
  243. ],
  244. "tags": [
  245. {
  246. "key": "is_wired",
  247. "operator": "=",
  248. "value": "false"
  249. }
  250. ]
  251. }
  252. ],
  253. "timeFrom": "1h",
  254. "title": "5ghz vs 2.4ghz",
  255. "transparent": true,
  256. "type": "grafana-piechart-panel",
  257. "valueName": "current"
  258. },
  259. {
  260. "aliasColors": {},
  261. "breakPoint": "50%",
  262. "cacheTimeout": null,
  263. "combine": {
  264. "label": "Others",
  265. "threshold": 0
  266. },
  267. "datasource": "${DS_INFLUXDB-UNIFI}",
  268. "decimals": 0,
  269. "description": "",
  270. "fontSize": "70%",
  271. "format": "short",
  272. "gridPos": {
  273. "h": 9,
  274. "w": 6,
  275. "x": 12,
  276. "y": 0
  277. },
  278. "hideTimeOverride": true,
  279. "id": 9,
  280. "interval": null,
  281. "legend": {
  282. "header": "",
  283. "show": true,
  284. "sort": "current",
  285. "sortDesc": true,
  286. "values": true
  287. },
  288. "legendType": "Right side",
  289. "links": [],
  290. "maxDataPoints": 3,
  291. "nullPointMode": "connected",
  292. "options": {},
  293. "pieType": "pie",
  294. "strokeWidth": 1,
  295. "targets": [
  296. {
  297. "alias": "Channel $tag_channel",
  298. "groupBy": [
  299. {
  300. "params": [
  301. "$__interval"
  302. ],
  303. "type": "time"
  304. },
  305. {
  306. "params": [
  307. "null"
  308. ],
  309. "type": "fill"
  310. }
  311. ],
  312. "orderByTime": "ASC",
  313. "policy": "default",
  314. "query": "select count(distinct(hostname)) FROM \"clients\" WHERE time > now() - 10m AND is_wired = 'false' group by channel",
  315. "rawQuery": true,
  316. "refId": "B",
  317. "resultFormat": "time_series",
  318. "select": [
  319. [
  320. {
  321. "params": [
  322. "value"
  323. ],
  324. "type": "field"
  325. },
  326. {
  327. "params": [],
  328. "type": "mean"
  329. }
  330. ]
  331. ],
  332. "tags": []
  333. }
  334. ],
  335. "timeFrom": "1h",
  336. "title": "Client per Wifi Channels",
  337. "transparent": true,
  338. "type": "grafana-piechart-panel",
  339. "valueName": "current"
  340. },
  341. {
  342. "aliasColors": {},
  343. "breakPoint": "50%",
  344. "cacheTimeout": null,
  345. "combine": {
  346. "label": "Others",
  347. "threshold": 0
  348. },
  349. "datasource": "${DS_INFLUXDB-UNIFI}",
  350. "decimals": 0,
  351. "description": "",
  352. "fontSize": "70%",
  353. "format": "short",
  354. "gridPos": {
  355. "h": 9,
  356. "w": 6,
  357. "x": 18,
  358. "y": 0
  359. },
  360. "hideTimeOverride": true,
  361. "id": 12,
  362. "interval": null,
  363. "legend": {
  364. "header": "",
  365. "show": true,
  366. "sort": "current",
  367. "sortDesc": true,
  368. "values": true
  369. },
  370. "legendType": "Right side",
  371. "links": [],
  372. "maxDataPoints": 3,
  373. "nullPointMode": "connected",
  374. "options": {},
  375. "pieType": "pie",
  376. "strokeWidth": 1,
  377. "targets": [
  378. {
  379. "alias": "$tag_oui",
  380. "groupBy": [
  381. {
  382. "params": [
  383. "channel"
  384. ],
  385. "type": "tag"
  386. }
  387. ],
  388. "measurement": "clients",
  389. "orderByTime": "ASC",
  390. "policy": "default",
  391. "query": "select count(distinct(hostname)) FROM \"clients\" WHERE (time > now() - 60m) AND (\"is_wired\" = 'false') group by oui",
  392. "rawQuery": true,
  393. "refId": "A",
  394. "resultFormat": "time_series",
  395. "select": [
  396. [
  397. {
  398. "params": [
  399. "hostname"
  400. ],
  401. "type": "field"
  402. },
  403. {
  404. "params": [],
  405. "type": "distinct"
  406. }
  407. ]
  408. ],
  409. "tags": [
  410. {
  411. "key": "is_wired",
  412. "operator": "=",
  413. "value": "false"
  414. }
  415. ]
  416. }
  417. ],
  418. "timeFrom": "1h",
  419. "title": "Client MAC OUI Breakdown",
  420. "transparent": true,
  421. "type": "grafana-piechart-panel",
  422. "valueName": "current"
  423. },
  424. {
  425. "aliasColors": {},
  426. "bars": false,
  427. "dashLength": 10,
  428. "dashes": false,
  429. "datasource": "${DS_INFLUXDB-UNIFI}",
  430. "editable": true,
  431. "error": false,
  432. "fill": 1,
  433. "gridPos": {
  434. "h": 8,
  435. "w": 12,
  436. "x": 0,
  437. "y": 9
  438. },
  439. "id": 34,
  440. "isNew": true,
  441. "legend": {
  442. "alignAsTable": true,
  443. "avg": false,
  444. "current": true,
  445. "hideEmpty": false,
  446. "hideZero": true,
  447. "max": true,
  448. "min": false,
  449. "rightSide": true,
  450. "show": true,
  451. "sort": "current",
  452. "sortDesc": true,
  453. "total": false,
  454. "values": true
  455. },
  456. "lines": true,
  457. "linewidth": 1,
  458. "links": [],
  459. "nullPointMode": "connected",
  460. "options": {},
  461. "percentage": false,
  462. "pointradius": 5,
  463. "points": false,
  464. "renderer": "flot",
  465. "seriesOverrides": [
  466. {
  467. "alias": "/:Rx$/",
  468. "transform": "negative-Y"
  469. }
  470. ],
  471. "spaceLength": 10,
  472. "stack": false,
  473. "steppedLine": false,
  474. "targets": [
  475. {
  476. "alias": "$tag_device_name:$col",
  477. "dsType": "influxdb",
  478. "groupBy": [
  479. {
  480. "params": [
  481. "2m"
  482. ],
  483. "type": "time"
  484. },
  485. {
  486. "params": [
  487. "device_name"
  488. ],
  489. "type": "tag"
  490. },
  491. {
  492. "params": [
  493. "null"
  494. ],
  495. "type": "fill"
  496. }
  497. ],
  498. "measurement": "uap_radios",
  499. "orderByTime": "ASC",
  500. "policy": "default",
  501. "refId": "A",
  502. "resultFormat": "time_series",
  503. "select": [
  504. [
  505. {
  506. "params": [
  507. "tx_bytes"
  508. ],
  509. "type": "field"
  510. },
  511. {
  512. "params": [],
  513. "type": "last"
  514. },
  515. {
  516. "params": [
  517. "1s"
  518. ],
  519. "type": "derivative"
  520. },
  521. {
  522. "params": [
  523. "*8"
  524. ],
  525. "type": "math"
  526. },
  527. {
  528. "params": [
  529. "Tx"
  530. ],
  531. "type": "alias"
  532. }
  533. ]
  534. ],
  535. "tags": [
  536. {
  537. "key": "radio",
  538. "operator": "=",
  539. "value": "na"
  540. }
  541. ]
  542. }
  543. ],
  544. "thresholds": [],
  545. "timeFrom": null,
  546. "timeRegions": [],
  547. "timeShift": null,
  548. "title": "5 GHz Traffic downlink",
  549. "tooltip": {
  550. "msResolution": false,
  551. "shared": true,
  552. "sort": 2,
  553. "value_type": "cumulative"
  554. },
  555. "type": "graph",
  556. "xaxis": {
  557. "buckets": null,
  558. "mode": "time",
  559. "name": null,
  560. "show": true,
  561. "values": []
  562. },
  563. "yaxes": [
  564. {
  565. "format": "bps",
  566. "label": null,
  567. "logBase": 1,
  568. "max": null,
  569. "min": null,
  570. "show": true
  571. },
  572. {
  573. "format": "pps",
  574. "label": null,
  575. "logBase": 1,
  576. "max": null,
  577. "min": null,
  578. "show": false
  579. }
  580. ],
  581. "yaxis": {
  582. "align": false,
  583. "alignLevel": null
  584. }
  585. },
  586. {
  587. "aliasColors": {},
  588. "bars": false,
  589. "dashLength": 10,
  590. "dashes": false,
  591. "datasource": "${DS_INFLUXDB-UNIFI}",
  592. "decimals": 0,
  593. "editable": true,
  594. "error": false,
  595. "fill": 0,
  596. "gridPos": {
  597. "h": 8,
  598. "w": 12,
  599. "x": 12,
  600. "y": 9
  601. },
  602. "id": 42,
  603. "isNew": true,
  604. "legend": {
  605. "alignAsTable": true,
  606. "avg": false,
  607. "current": true,
  608. "hideEmpty": true,
  609. "hideZero": true,
  610. "max": true,
  611. "min": true,
  612. "rightSide": true,
  613. "show": true,
  614. "sort": "current",
  615. "sortDesc": true,
  616. "total": false,
  617. "values": true
  618. },
  619. "lines": true,
  620. "linewidth": 2,
  621. "links": [],
  622. "nullPointMode": "connected",
  623. "options": {},
  624. "percentage": false,
  625. "pointradius": 5,
  626. "points": false,
  627. "renderer": "flot",
  628. "seriesOverrides": [],
  629. "spaceLength": 10,
  630. "stack": true,
  631. "steppedLine": false,
  632. "targets": [
  633. {
  634. "alias": "$tag_device_name total",
  635. "dsType": "influxdb",
  636. "groupBy": [
  637. {
  638. "params": [
  639. "$__interval"
  640. ],
  641. "type": "time"
  642. },
  643. {
  644. "params": [
  645. "device_name"
  646. ],
  647. "type": "tag"
  648. }
  649. ],
  650. "measurement": "uap_radios",
  651. "orderByTime": "ASC",
  652. "policy": "default",
  653. "query": "SELECT last(\"num_sta\") FROM \"uap_radios\" WHERE (\"device_name\" =~ /^$host$/ AND \"radio\" = 'na') AND $timeFilter GROUP BY time($__interval), \"device_name\"",
  654. "rawQuery": false,
  655. "refId": "A",
  656. "resultFormat": "time_series",
  657. "select": [
  658. [
  659. {
  660. "params": [
  661. "num_sta"
  662. ],
  663. "type": "field"
  664. },
  665. {
  666. "params": [],
  667. "type": "last"
  668. }
  669. ]
  670. ],
  671. "tags": []
  672. }
  673. ],
  674. "thresholds": [],
  675. "timeFrom": null,
  676. "timeRegions": [],
  677. "timeShift": null,
  678. "title": "Clients per AP",
  679. "tooltip": {
  680. "msResolution": false,
  681. "shared": true,
  682. "sort": 2,
  683. "value_type": "individual"
  684. },
  685. "type": "graph",
  686. "xaxis": {
  687. "buckets": null,
  688. "mode": "time",
  689. "name": null,
  690. "show": true,
  691. "values": []
  692. },
  693. "yaxes": [
  694. {
  695. "format": "none",
  696. "label": "",
  697. "logBase": 1,
  698. "max": null,
  699. "min": null,
  700. "show": true
  701. },
  702. {
  703. "format": "short",
  704. "label": null,
  705. "logBase": 1,
  706. "max": null,
  707. "min": null,
  708. "show": false
  709. }
  710. ],
  711. "yaxis": {
  712. "align": false,
  713. "alignLevel": null
  714. }
  715. },
  716. {
  717. "aliasColors": {},
  718. "bars": false,
  719. "dashLength": 10,
  720. "dashes": false,
  721. "datasource": "${DS_INFLUXDB-UNIFI}",
  722. "editable": true,
  723. "error": false,
  724. "fill": 1,
  725. "gridPos": {
  726. "h": 8,
  727. "w": 12,
  728. "x": 0,
  729. "y": 17
  730. },
  731. "id": 36,
  732. "isNew": true,
  733. "legend": {
  734. "alignAsTable": true,
  735. "avg": false,
  736. "current": true,
  737. "hideZero": true,
  738. "max": true,
  739. "min": false,
  740. "rightSide": true,
  741. "show": true,
  742. "sort": "current",
  743. "sortDesc": true,
  744. "total": false,
  745. "values": true
  746. },
  747. "lines": true,
  748. "linewidth": 1,
  749. "links": [],
  750. "nullPointMode": "connected",
  751. "options": {},
  752. "percentage": false,
  753. "pointradius": 5,
  754. "points": false,
  755. "renderer": "flot",
  756. "seriesOverrides": [
  757. {
  758. "alias": "/:Rx$/",
  759. "transform": "negative-Y"
  760. }
  761. ],
  762. "spaceLength": 10,
  763. "stack": false,
  764. "steppedLine": false,
  765. "targets": [
  766. {
  767. "alias": "$tag_device_name",
  768. "dsType": "influxdb",
  769. "groupBy": [
  770. {
  771. "params": [
  772. "2m"
  773. ],
  774. "type": "time"
  775. },
  776. {
  777. "params": [
  778. "device_name"
  779. ],
  780. "type": "tag"
  781. },
  782. {
  783. "params": [
  784. "null"
  785. ],
  786. "type": "fill"
  787. }
  788. ],
  789. "measurement": "uap_radios",
  790. "orderByTime": "ASC",
  791. "policy": "default",
  792. "refId": "A",
  793. "resultFormat": "time_series",
  794. "select": [
  795. [
  796. {
  797. "params": [
  798. "tx_bytes"
  799. ],
  800. "type": "field"
  801. },
  802. {
  803. "params": [],
  804. "type": "last"
  805. },
  806. {
  807. "params": [
  808. "1s"
  809. ],
  810. "type": "derivative"
  811. },
  812. {
  813. "params": [
  814. "*8"
  815. ],
  816. "type": "math"
  817. },
  818. {
  819. "params": [
  820. "Tx"
  821. ],
  822. "type": "alias"
  823. }
  824. ]
  825. ],
  826. "tags": [
  827. {
  828. "key": "radio",
  829. "operator": "=",
  830. "value": "ng"
  831. }
  832. ]
  833. }
  834. ],
  835. "thresholds": [],
  836. "timeFrom": null,
  837. "timeRegions": [],
  838. "timeShift": null,
  839. "title": "2.4GHz Traffic Down link",
  840. "tooltip": {
  841. "msResolution": false,
  842. "shared": true,
  843. "sort": 2,
  844. "value_type": "cumulative"
  845. },
  846. "type": "graph",
  847. "xaxis": {
  848. "buckets": null,
  849. "mode": "time",
  850. "name": null,
  851. "show": true,
  852. "values": []
  853. },
  854. "yaxes": [
  855. {
  856. "format": "bps",
  857. "label": null,
  858. "logBase": 1,
  859. "max": null,
  860. "min": null,
  861. "show": true
  862. },
  863. {
  864. "format": "pps",
  865. "label": null,
  866. "logBase": 1,
  867. "max": null,
  868. "min": null,
  869. "show": false
  870. }
  871. ],
  872. "yaxis": {
  873. "align": false,
  874. "alignLevel": null
  875. }
  876. },
  877. {
  878. "aliasColors": {},
  879. "bars": false,
  880. "dashLength": 10,
  881. "dashes": false,
  882. "datasource": "${DS_INFLUXDB-UNIFI}",
  883. "editable": true,
  884. "error": false,
  885. "fill": 1,
  886. "gridPos": {
  887. "h": 7,
  888. "w": 12,
  889. "x": 12,
  890. "y": 17
  891. },
  892. "id": 40,
  893. "isNew": true,
  894. "legend": {
  895. "alignAsTable": true,
  896. "avg": false,
  897. "current": true,
  898. "hideZero": true,
  899. "max": true,
  900. "min": false,
  901. "rightSide": true,
  902. "show": true,
  903. "sort": "current",
  904. "sortDesc": true,
  905. "total": false,
  906. "values": true
  907. },
  908. "lines": true,
  909. "linewidth": 1,
  910. "links": [],
  911. "nullPointMode": "connected",
  912. "options": {},
  913. "percentage": false,
  914. "pointradius": 5,
  915. "points": false,
  916. "renderer": "flot",
  917. "seriesOverrides": [],
  918. "spaceLength": 10,
  919. "stack": false,
  920. "steppedLine": false,
  921. "targets": [
  922. {
  923. "alias": "$tag_device_name:$col",
  924. "dsType": "influxdb",
  925. "groupBy": [
  926. {
  927. "params": [
  928. "2m"
  929. ],
  930. "type": "time"
  931. },
  932. {
  933. "params": [
  934. "device_name"
  935. ],
  936. "type": "tag"
  937. },
  938. {
  939. "params": [
  940. "null"
  941. ],
  942. "type": "fill"
  943. }
  944. ],
  945. "measurement": "uap_radios",
  946. "orderByTime": "ASC",
  947. "policy": "default",
  948. "refId": "A",
  949. "resultFormat": "time_series",
  950. "select": [
  951. [
  952. {
  953. "params": [
  954. "rx_bytes"
  955. ],
  956. "type": "field"
  957. },
  958. {
  959. "params": [],
  960. "type": "last"
  961. },
  962. {
  963. "params": [
  964. "1s"
  965. ],
  966. "type": "derivative"
  967. },
  968. {
  969. "params": [
  970. "*8"
  971. ],
  972. "type": "math"
  973. },
  974. {
  975. "params": [
  976. "Rx"
  977. ],
  978. "type": "alias"
  979. }
  980. ]
  981. ],
  982. "tags": [
  983. {
  984. "key": "radio",
  985. "operator": "=",
  986. "value": "na"
  987. }
  988. ]
  989. }
  990. ],
  991. "thresholds": [],
  992. "timeFrom": null,
  993. "timeRegions": [],
  994. "timeShift": null,
  995. "title": "5 GHz Traffic uplink",
  996. "tooltip": {
  997. "msResolution": false,
  998. "shared": true,
  999. "sort": 2,
  1000. "value_type": "cumulative"
  1001. },
  1002. "type": "graph",
  1003. "xaxis": {
  1004. "buckets": null,
  1005. "mode": "time",
  1006. "name": null,
  1007. "show": true,
  1008. "values": []
  1009. },
  1010. "yaxes": [
  1011. {
  1012. "format": "bps",
  1013. "label": null,
  1014. "logBase": 1,
  1015. "max": null,
  1016. "min": null,
  1017. "show": true
  1018. },
  1019. {
  1020. "format": "pps",
  1021. "label": null,
  1022. "logBase": 1,
  1023. "max": null,
  1024. "min": null,
  1025. "show": false
  1026. }
  1027. ],
  1028. "yaxis": {
  1029. "align": false,
  1030. "alignLevel": null
  1031. }
  1032. },
  1033. {
  1034. "aliasColors": {},
  1035. "bars": false,
  1036. "dashLength": 10,
  1037. "dashes": false,
  1038. "datasource": "${DS_INFLUXDB-UNIFI}",
  1039. "editable": true,
  1040. "error": false,
  1041. "fill": 1,
  1042. "gridPos": {
  1043. "h": 8,
  1044. "w": 12,
  1045. "x": 12,
  1046. "y": 24
  1047. },
  1048. "id": 39,
  1049. "isNew": true,
  1050. "legend": {
  1051. "alignAsTable": true,
  1052. "avg": false,
  1053. "current": true,
  1054. "hideZero": true,
  1055. "max": true,
  1056. "min": false,
  1057. "rightSide": true,
  1058. "show": true,
  1059. "sort": "current",
  1060. "sortDesc": true,
  1061. "total": false,
  1062. "values": true
  1063. },
  1064. "lines": true,
  1065. "linewidth": 1,
  1066. "links": [],
  1067. "nullPointMode": "connected",
  1068. "options": {},
  1069. "percentage": false,
  1070. "pointradius": 5,
  1071. "points": false,
  1072. "renderer": "flot",
  1073. "seriesOverrides": [
  1074. {
  1075. "alias": "/:Rx$/",
  1076. "transform": "negative-Y"
  1077. }
  1078. ],
  1079. "spaceLength": 10,
  1080. "stack": false,
  1081. "steppedLine": false,
  1082. "targets": [
  1083. {
  1084. "alias": "$tag_device_name",
  1085. "dsType": "influxdb",
  1086. "groupBy": [
  1087. {
  1088. "params": [
  1089. "2m"
  1090. ],
  1091. "type": "time"
  1092. },
  1093. {
  1094. "params": [
  1095. "device_name"
  1096. ],
  1097. "type": "tag"
  1098. },
  1099. {
  1100. "params": [
  1101. "null"
  1102. ],
  1103. "type": "fill"
  1104. }
  1105. ],
  1106. "measurement": "uap_radios",
  1107. "orderByTime": "ASC",
  1108. "policy": "default",
  1109. "refId": "A",
  1110. "resultFormat": "time_series",
  1111. "select": [
  1112. [
  1113. {
  1114. "params": [
  1115. "rx_bytes"
  1116. ],
  1117. "type": "field"
  1118. },
  1119. {
  1120. "params": [],
  1121. "type": "last"
  1122. },
  1123. {
  1124. "params": [
  1125. "1s"
  1126. ],
  1127. "type": "derivative"
  1128. },
  1129. {
  1130. "params": [
  1131. "*8"
  1132. ],
  1133. "type": "math"
  1134. },
  1135. {
  1136. "params": [
  1137. "Rx"
  1138. ],
  1139. "type": "alias"
  1140. }
  1141. ]
  1142. ],
  1143. "tags": [
  1144. {
  1145. "key": "radio",
  1146. "operator": "=",
  1147. "value": "ng"
  1148. }
  1149. ]
  1150. }
  1151. ],
  1152. "thresholds": [],
  1153. "timeFrom": null,
  1154. "timeRegions": [],
  1155. "timeShift": null,
  1156. "title": "2.4GHz Traffic uplink",
  1157. "tooltip": {
  1158. "msResolution": false,
  1159. "shared": true,
  1160. "sort": 2,
  1161. "value_type": "cumulative"
  1162. },
  1163. "type": "graph",
  1164. "xaxis": {
  1165. "buckets": null,
  1166. "mode": "time",
  1167. "name": null,
  1168. "show": true,
  1169. "values": []
  1170. },
  1171. "yaxes": [
  1172. {
  1173. "format": "bps",
  1174. "label": null,
  1175. "logBase": 1,
  1176. "max": null,
  1177. "min": null,
  1178. "show": true
  1179. },
  1180. {
  1181. "format": "pps",
  1182. "label": null,
  1183. "logBase": 1,
  1184. "max": null,
  1185. "min": null,
  1186. "show": false
  1187. }
  1188. ],
  1189. "yaxis": {
  1190. "align": false,
  1191. "alignLevel": null
  1192. }
  1193. },
  1194. {
  1195. "aliasColors": {},
  1196. "bars": false,
  1197. "dashLength": 10,
  1198. "dashes": false,
  1199. "datasource": "${DS_INFLUXDB-UNIFI}",
  1200. "editable": true,
  1201. "error": false,
  1202. "fill": 0,
  1203. "gridPos": {
  1204. "h": 7,
  1205. "w": 12,
  1206. "x": 0,
  1207. "y": 25
  1208. },
  1209. "id": 32,
  1210. "isNew": true,
  1211. "legend": {
  1212. "alignAsTable": true,
  1213. "avg": false,
  1214. "current": true,
  1215. "hideZero": false,
  1216. "max": true,
  1217. "min": false,
  1218. "rightSide": true,
  1219. "show": true,
  1220. "total": false,
  1221. "values": true
  1222. },
  1223. "lines": true,
  1224. "linewidth": 3,
  1225. "links": [],
  1226. "nullPointMode": "connected",
  1227. "options": {},
  1228. "percentage": false,
  1229. "pointradius": 5,
  1230. "points": false,
  1231. "renderer": "flot",
  1232. "seriesOverrides": [],
  1233. "spaceLength": 10,
  1234. "stack": false,
  1235. "steppedLine": false,
  1236. "targets": [
  1237. {
  1238. "alias": "$tag_device_name:$col",
  1239. "dsType": "influxdb",
  1240. "groupBy": [
  1241. {
  1242. "params": [
  1243. "1m"
  1244. ],
  1245. "type": "time"
  1246. },
  1247. {
  1248. "params": [
  1249. "device_name"
  1250. ],
  1251. "type": "tag"
  1252. },
  1253. {
  1254. "params": [
  1255. "null"
  1256. ],
  1257. "type": "fill"
  1258. }
  1259. ],
  1260. "measurement": "uap_radios",
  1261. "orderByTime": "ASC",
  1262. "policy": "default",
  1263. "refId": "A",
  1264. "resultFormat": "time_series",
  1265. "select": [
  1266. [
  1267. {
  1268. "params": [
  1269. "cu_total"
  1270. ],
  1271. "type": "field"
  1272. },
  1273. {
  1274. "params": [],
  1275. "type": "last"
  1276. },
  1277. {
  1278. "params": [
  1279. "Total"
  1280. ],
  1281. "type": "alias"
  1282. }
  1283. ]
  1284. ],
  1285. "tags": [
  1286. {
  1287. "key": "radio",
  1288. "operator": "=",
  1289. "value": "ng"
  1290. }
  1291. ]
  1292. }
  1293. ],
  1294. "thresholds": [],
  1295. "timeFrom": null,
  1296. "timeRegions": [],
  1297. "timeShift": null,
  1298. "title": "2.4GHz Channel Utilization",
  1299. "tooltip": {
  1300. "msResolution": false,
  1301. "shared": true,
  1302. "sort": 2,
  1303. "value_type": "cumulative"
  1304. },
  1305. "type": "graph",
  1306. "xaxis": {
  1307. "buckets": null,
  1308. "mode": "time",
  1309. "name": null,
  1310. "show": true,
  1311. "values": []
  1312. },
  1313. "yaxes": [
  1314. {
  1315. "format": "percent",
  1316. "label": null,
  1317. "logBase": 1,
  1318. "max": null,
  1319. "min": null,
  1320. "show": true
  1321. },
  1322. {
  1323. "format": "short",
  1324. "label": null,
  1325. "logBase": 1,
  1326. "max": null,
  1327. "min": null,
  1328. "show": false
  1329. }
  1330. ],
  1331. "yaxis": {
  1332. "align": false,
  1333. "alignLevel": null
  1334. }
  1335. },
  1336. {
  1337. "aliasColors": {},
  1338. "bars": false,
  1339. "dashLength": 10,
  1340. "dashes": false,
  1341. "datasource": "${DS_INFLUXDB-UNIFI}",
  1342. "description": " Devices TX / RX bytes per second (calculated in 30 second buckets) using OUI.",
  1343. "fill": 1,
  1344. "gridPos": {
  1345. "h": 7,
  1346. "w": 12,
  1347. "x": 0,
  1348. "y": 32
  1349. },
  1350. "id": 41,
  1351. "legend": {
  1352. "alignAsTable": true,
  1353. "avg": true,
  1354. "current": true,
  1355. "max": true,
  1356. "min": false,
  1357. "rightSide": true,
  1358. "show": true,
  1359. "sort": "current",
  1360. "sortDesc": true,
  1361. "total": false,
  1362. "values": true
  1363. },
  1364. "lines": true,
  1365. "linewidth": 1,
  1366. "links": [],
  1367. "nullPointMode": "connected",
  1368. "options": {},
  1369. "percentage": false,
  1370. "pointradius": 5,
  1371. "points": false,
  1372. "renderer": "flot",
  1373. "seriesOverrides": [],
  1374. "spaceLength": 10,
  1375. "stack": false,
  1376. "steppedLine": false,
  1377. "targets": [
  1378. {
  1379. "alias": "$tag_oui $col",
  1380. "groupBy": [
  1381. {
  1382. "params": [
  1383. "2m"
  1384. ],
  1385. "type": "time"
  1386. },
  1387. {
  1388. "params": [
  1389. "oui"
  1390. ],
  1391. "type": "tag"
  1392. },
  1393. {
  1394. "params": [
  1395. "none"
  1396. ],
  1397. "type": "fill"
  1398. }
  1399. ],
  1400. "hide": false,
  1401. "measurement": "clients",
  1402. "orderByTime": "ASC",
  1403. "policy": "default",
  1404. "query": "SELECT derivative(sum(\"rx_bytes\"), 1s) AS \"Rx\", derivative(sum(\"rx_bytes\"), 1s) AS \"Rx\" FROM \"clients\" WHERE (\"oui\" = 'Htc' AND \"is_wired\" = 'false') AND $timeFilter GROUP BY time(30s), \"oui\" fill(none)",
  1405. "rawQuery": false,
  1406. "refId": "A",
  1407. "resultFormat": "time_series",
  1408. "select": [
  1409. [
  1410. {
  1411. "params": [
  1412. "tx_bytes"
  1413. ],
  1414. "type": "field"
  1415. },
  1416. {
  1417. "params": [],
  1418. "type": "last"
  1419. },
  1420. {
  1421. "params": [
  1422. "1s"
  1423. ],
  1424. "type": "derivative"
  1425. },
  1426. {
  1427. "params": [
  1428. "*8"
  1429. ],
  1430. "type": "math"
  1431. },
  1432. {
  1433. "params": [
  1434. "Tx"
  1435. ],
  1436. "type": "alias"
  1437. }
  1438. ]
  1439. ],
  1440. "tags": [
  1441. {
  1442. "key": "oui",
  1443. "operator": "=",
  1444. "value": "Htc"
  1445. },
  1446. {
  1447. "condition": "AND",
  1448. "key": "is_wired",
  1449. "operator": "=",
  1450. "value": "false"
  1451. }
  1452. ]
  1453. },
  1454. {
  1455. "alias": "$tag_oui $col",
  1456. "groupBy": [
  1457. {
  1458. "params": [
  1459. "2m"
  1460. ],
  1461. "type": "time"
  1462. },
  1463. {
  1464. "params": [
  1465. "oui"
  1466. ],
  1467. "type": "tag"
  1468. },
  1469. {
  1470. "params": [
  1471. "none"
  1472. ],
  1473. "type": "fill"
  1474. }
  1475. ],
  1476. "hide": false,
  1477. "measurement": "clients",
  1478. "orderByTime": "ASC",
  1479. "policy": "default",
  1480. "query": "SELECT derivative(sum(\"rx_bytes\"), 1s) AS \"Rx\", derivative(sum(\"rx_bytes\"), 1s) AS \"Rx\" FROM \"clients\" WHERE (\"oui\" = 'Htc' AND \"is_wired\" = 'false') AND $timeFilter GROUP BY time(30s), \"oui\" fill(none)",
  1481. "rawQuery": false,
  1482. "refId": "B",
  1483. "resultFormat": "time_series",
  1484. "select": [
  1485. [
  1486. {
  1487. "params": [
  1488. "tx_bytes"
  1489. ],
  1490. "type": "field"
  1491. },
  1492. {
  1493. "params": [],
  1494. "type": "last"
  1495. },
  1496. {
  1497. "params": [
  1498. "1s"
  1499. ],
  1500. "type": "derivative"
  1501. },
  1502. {
  1503. "params": [
  1504. "*8"
  1505. ],
  1506. "type": "math"
  1507. },
  1508. {
  1509. "params": [
  1510. "Tx"
  1511. ],
  1512. "type": "alias"
  1513. }
  1514. ]
  1515. ],
  1516. "tags": [
  1517. {
  1518. "key": "oui",
  1519. "operator": "=",
  1520. "value": "IntelCor"
  1521. },
  1522. {
  1523. "condition": "AND",
  1524. "key": "is_wired",
  1525. "operator": "=",
  1526. "value": "false"
  1527. }
  1528. ]
  1529. },
  1530. {
  1531. "alias": "$tag_oui $col",
  1532. "groupBy": [
  1533. {
  1534. "params": [
  1535. "2m"
  1536. ],
  1537. "type": "time"
  1538. },
  1539. {
  1540. "params": [
  1541. "oui"
  1542. ],
  1543. "type": "tag"
  1544. },
  1545. {
  1546. "params": [
  1547. "none"
  1548. ],
  1549. "type": "fill"
  1550. }
  1551. ],
  1552. "hide": false,
  1553. "measurement": "clients",
  1554. "orderByTime": "ASC",
  1555. "policy": "default",
  1556. "query": "SELECT derivative(sum(\"rx_bytes\"), 1s) AS \"Rx\", derivative(sum(\"rx_bytes\"), 1s) AS \"Rx\" FROM \"clients\" WHERE (\"oui\" = 'Htc' AND \"is_wired\" = 'false') AND $timeFilter GROUP BY time(30s), \"oui\" fill(none)",
  1557. "rawQuery": false,
  1558. "refId": "C",
  1559. "resultFormat": "time_series",
  1560. "select": [
  1561. [
  1562. {
  1563. "params": [
  1564. "tx_bytes"
  1565. ],
  1566. "type": "field"
  1567. },
  1568. {
  1569. "params": [],
  1570. "type": "last"
  1571. },
  1572. {
  1573. "params": [
  1574. "1s"
  1575. ],
  1576. "type": "derivative"
  1577. },
  1578. {
  1579. "params": [
  1580. "*8"
  1581. ],
  1582. "type": "math"
  1583. },
  1584. {
  1585. "params": [
  1586. "Tx"
  1587. ],
  1588. "type": "alias"
  1589. }
  1590. ]
  1591. ],
  1592. "tags": [
  1593. {
  1594. "key": "oui",
  1595. "operator": "=",
  1596. "value": "HonHaiPr"
  1597. },
  1598. {
  1599. "condition": "AND",
  1600. "key": "is_wired",
  1601. "operator": "=",
  1602. "value": "false"
  1603. }
  1604. ]
  1605. }
  1606. ],
  1607. "thresholds": [],
  1608. "timeFrom": null,
  1609. "timeRegions": [],
  1610. "timeShift": null,
  1611. "title": "WIFI traffic per vendor downlink",
  1612. "tooltip": {
  1613. "shared": true,
  1614. "sort": 2,
  1615. "value_type": "individual"
  1616. },
  1617. "transparent": true,
  1618. "type": "graph",
  1619. "xaxis": {
  1620. "buckets": null,
  1621. "mode": "time",
  1622. "name": null,
  1623. "show": true,
  1624. "values": []
  1625. },
  1626. "yaxes": [
  1627. {
  1628. "format": "bps",
  1629. "label": null,
  1630. "logBase": 1,
  1631. "max": null,
  1632. "min": null,
  1633. "show": true
  1634. },
  1635. {
  1636. "format": "short",
  1637. "label": null,
  1638. "logBase": 1,
  1639. "max": null,
  1640. "min": null,
  1641. "show": false
  1642. }
  1643. ],
  1644. "yaxis": {
  1645. "align": false,
  1646. "alignLevel": null
  1647. }
  1648. },
  1649. {
  1650. "aliasColors": {},
  1651. "bars": false,
  1652. "dashLength": 10,
  1653. "dashes": false,
  1654. "datasource": "${DS_INFLUXDB-UNIFI}",
  1655. "editable": true,
  1656. "error": false,
  1657. "fill": 0,
  1658. "gridPos": {
  1659. "h": 7,
  1660. "w": 12,
  1661. "x": 12,
  1662. "y": 32
  1663. },
  1664. "id": 30,
  1665. "isNew": true,
  1666. "legend": {
  1667. "alignAsTable": true,
  1668. "avg": false,
  1669. "current": true,
  1670. "max": true,
  1671. "min": false,
  1672. "rightSide": true,
  1673. "show": true,
  1674. "total": false,
  1675. "values": true
  1676. },
  1677. "lines": true,
  1678. "linewidth": 3,
  1679. "links": [],
  1680. "nullPointMode": "connected",
  1681. "options": {},
  1682. "percentage": false,
  1683. "pointradius": 5,
  1684. "points": false,
  1685. "renderer": "flot",
  1686. "seriesOverrides": [],
  1687. "spaceLength": 10,
  1688. "stack": false,
  1689. "steppedLine": false,
  1690. "targets": [
  1691. {
  1692. "alias": "$tag_device_name:$col",
  1693. "dsType": "influxdb",
  1694. "groupBy": [
  1695. {
  1696. "params": [
  1697. "$interval"
  1698. ],
  1699. "type": "time"
  1700. },
  1701. {
  1702. "params": [
  1703. "device_name"
  1704. ],
  1705. "type": "tag"
  1706. },
  1707. {
  1708. "params": [
  1709. "null"
  1710. ],
  1711. "type": "fill"
  1712. }
  1713. ],
  1714. "measurement": "uap_radios",
  1715. "orderByTime": "ASC",
  1716. "policy": "default",
  1717. "refId": "A",
  1718. "resultFormat": "time_series",
  1719. "select": [
  1720. [
  1721. {
  1722. "params": [
  1723. "cu_total"
  1724. ],
  1725. "type": "field"
  1726. },
  1727. {
  1728. "params": [],
  1729. "type": "last"
  1730. },
  1731. {
  1732. "params": [
  1733. "Total"
  1734. ],
  1735. "type": "alias"
  1736. }
  1737. ]
  1738. ],
  1739. "tags": [
  1740. {
  1741. "key": "radio",
  1742. "operator": "=",
  1743. "value": "na"
  1744. }
  1745. ]
  1746. }
  1747. ],
  1748. "thresholds": [],
  1749. "timeFrom": null,
  1750. "timeRegions": [],
  1751. "timeShift": null,
  1752. "title": "5 GHz Channel Utilization",
  1753. "tooltip": {
  1754. "msResolution": false,
  1755. "shared": true,
  1756. "sort": 0,
  1757. "value_type": "cumulative"
  1758. },
  1759. "type": "graph",
  1760. "xaxis": {
  1761. "buckets": null,
  1762. "mode": "time",
  1763. "name": null,
  1764. "show": true,
  1765. "values": []
  1766. },
  1767. "yaxes": [
  1768. {
  1769. "decimals": 1,
  1770. "format": "percent",
  1771. "label": null,
  1772. "logBase": 1,
  1773. "max": null,
  1774. "min": "0",
  1775. "show": true
  1776. },
  1777. {
  1778. "format": "short",
  1779. "label": null,
  1780. "logBase": 1,
  1781. "max": null,
  1782. "min": null,
  1783. "show": false
  1784. }
  1785. ],
  1786. "yaxis": {
  1787. "align": false,
  1788. "alignLevel": null
  1789. }
  1790. },
  1791. {
  1792. "aliasColors": {},
  1793. "bars": false,
  1794. "dashLength": 10,
  1795. "dashes": false,
  1796. "datasource": "${DS_INFLUXDB-UNIFI}",
  1797. "description": " Devices TX / RX bytes per second (calculated in 30 second buckets) using OUI.",
  1798. "fill": 1,
  1799. "gridPos": {
  1800. "h": 7,
  1801. "w": 12,
  1802. "x": 0,
  1803. "y": 39
  1804. },
  1805. "id": 23,
  1806. "legend": {
  1807. "alignAsTable": true,
  1808. "avg": true,
  1809. "current": true,
  1810. "max": true,
  1811. "min": false,
  1812. "rightSide": true,
  1813. "show": true,
  1814. "sort": "current",
  1815. "sortDesc": true,
  1816. "total": false,
  1817. "values": true
  1818. },
  1819. "lines": true,
  1820. "linewidth": 1,
  1821. "links": [],
  1822. "nullPointMode": "connected",
  1823. "options": {},
  1824. "percentage": false,
  1825. "pointradius": 5,
  1826. "points": false,
  1827. "renderer": "flot",
  1828. "seriesOverrides": [],
  1829. "spaceLength": 10,
  1830. "stack": false,
  1831. "steppedLine": false,
  1832. "targets": [
  1833. {
  1834. "alias": "$tag_oui $col",
  1835. "groupBy": [
  1836. {
  1837. "params": [
  1838. "2m"
  1839. ],
  1840. "type": "time"
  1841. },
  1842. {
  1843. "params": [
  1844. "oui"
  1845. ],
  1846. "type": "tag"
  1847. },
  1848. {
  1849. "params": [
  1850. "none"
  1851. ],
  1852. "type": "fill"
  1853. }
  1854. ],
  1855. "hide": false,
  1856. "measurement": "clients",
  1857. "orderByTime": "ASC",
  1858. "policy": "default",
  1859. "query": "SELECT derivative(sum(\"rx_bytes\"), 1s) AS \"Rx\", derivative(sum(\"rx_bytes\"), 1s) AS \"Rx\" FROM \"clients\" WHERE (\"oui\" = 'Htc' AND \"is_wired\" = 'false') AND $timeFilter GROUP BY time(30s), \"oui\" fill(none)",
  1860. "rawQuery": false,
  1861. "refId": "A",
  1862. "resultFormat": "time_series",
  1863. "select": [
  1864. [
  1865. {
  1866. "params": [
  1867. "rx_bytes"
  1868. ],
  1869. "type": "field"
  1870. },
  1871. {
  1872. "params": [],
  1873. "type": "last"
  1874. },
  1875. {
  1876. "params": [
  1877. "1s"
  1878. ],
  1879. "type": "derivative"
  1880. },
  1881. {
  1882. "params": [
  1883. " *8"
  1884. ],
  1885. "type": "math"
  1886. },
  1887. {
  1888. "params": [
  1889. "Rx"
  1890. ],
  1891. "type": "alias"
  1892. }
  1893. ]
  1894. ],
  1895. "tags": [
  1896. {
  1897. "key": "oui",
  1898. "operator": "=",
  1899. "value": "Htc"
  1900. },
  1901. {
  1902. "condition": "AND",
  1903. "key": "is_wired",
  1904. "operator": "=",
  1905. "value": "false"
  1906. }
  1907. ]
  1908. },
  1909. {
  1910. "alias": "$tag_oui $col",
  1911. "groupBy": [
  1912. {
  1913. "params": [
  1914. "2m"
  1915. ],
  1916. "type": "time"
  1917. },
  1918. {
  1919. "params": [
  1920. "oui"
  1921. ],
  1922. "type": "tag"
  1923. },
  1924. {
  1925. "params": [
  1926. "none"
  1927. ],
  1928. "type": "fill"
  1929. }
  1930. ],
  1931. "hide": false,
  1932. "measurement": "clients",
  1933. "orderByTime": "ASC",
  1934. "policy": "default",
  1935. "query": "SELECT derivative(sum(\"rx_bytes\"), 1s) AS \"Rx\", derivative(sum(\"rx_bytes\"), 1s) AS \"Rx\" FROM \"clients\" WHERE (\"oui\" = 'Htc' AND \"is_wired\" = 'false') AND $timeFilter GROUP BY time(30s), \"oui\" fill(none)",
  1936. "rawQuery": false,
  1937. "refId": "B",
  1938. "resultFormat": "time_series",
  1939. "select": [
  1940. [
  1941. {
  1942. "params": [
  1943. "rx_bytes"
  1944. ],
  1945. "type": "field"
  1946. },
  1947. {
  1948. "params": [],
  1949. "type": "last"
  1950. },
  1951. {
  1952. "params": [
  1953. "1s"
  1954. ],
  1955. "type": "derivative"
  1956. },
  1957. {
  1958. "params": [
  1959. "*8"
  1960. ],
  1961. "type": "math"
  1962. },
  1963. {
  1964. "params": [
  1965. "Rx"
  1966. ],
  1967. "type": "alias"
  1968. }
  1969. ]
  1970. ],
  1971. "tags": [
  1972. {
  1973. "key": "oui",
  1974. "operator": "=",
  1975. "value": "IntelCor"
  1976. },
  1977. {
  1978. "condition": "AND",
  1979. "key": "is_wired",
  1980. "operator": "=",
  1981. "value": "false"
  1982. }
  1983. ]
  1984. },
  1985. {
  1986. "alias": "$tag_oui $col",
  1987. "groupBy": [
  1988. {
  1989. "params": [
  1990. "2m"
  1991. ],
  1992. "type": "time"
  1993. },
  1994. {
  1995. "params": [
  1996. "oui"
  1997. ],
  1998. "type": "tag"
  1999. },
  2000. {
  2001. "params": [
  2002. "none"
  2003. ],
  2004. "type": "fill"
  2005. }
  2006. ],
  2007. "hide": false,
  2008. "measurement": "clients",
  2009. "orderByTime": "ASC",
  2010. "policy": "default",
  2011. "query": "SELECT derivative(sum(\"rx_bytes\"), 1s) AS \"Rx\", derivative(sum(\"rx_bytes\"), 1s) AS \"Rx\" FROM \"clients\" WHERE (\"oui\" = 'Htc' AND \"is_wired\" = 'false') AND $timeFilter GROUP BY time(30s), \"oui\" fill(none)",
  2012. "rawQuery": false,
  2013. "refId": "C",
  2014. "resultFormat": "time_series",
  2015. "select": [
  2016. [
  2017. {
  2018. "params": [
  2019. "rx_bytes"
  2020. ],
  2021. "type": "field"
  2022. },
  2023. {
  2024. "params": [],
  2025. "type": "last"
  2026. },
  2027. {
  2028. "params": [
  2029. "1s"
  2030. ],
  2031. "type": "derivative"
  2032. },
  2033. {
  2034. "params": [
  2035. "*8"
  2036. ],
  2037. "type": "math"
  2038. },
  2039. {
  2040. "params": [
  2041. "Rx"
  2042. ],
  2043. "type": "alias"
  2044. }
  2045. ]
  2046. ],
  2047. "tags": [
  2048. {
  2049. "key": "oui",
  2050. "operator": "=",
  2051. "value": "HonHaiPr"
  2052. },
  2053. {
  2054. "condition": "AND",
  2055. "key": "is_wired",
  2056. "operator": "=",
  2057. "value": "false"
  2058. }
  2059. ]
  2060. }
  2061. ],
  2062. "thresholds": [],
  2063. "timeFrom": null,
  2064. "timeRegions": [],
  2065. "timeShift": null,
  2066. "title": "WIFI traffic per vendor uplink",
  2067. "tooltip": {
  2068. "shared": true,
  2069. "sort": 2,
  2070. "value_type": "individual"
  2071. },
  2072. "transparent": true,
  2073. "type": "graph",
  2074. "xaxis": {
  2075. "buckets": null,
  2076. "mode": "time",
  2077. "name": null,
  2078. "show": true,
  2079. "values": []
  2080. },
  2081. "yaxes": [
  2082. {
  2083. "format": "bps",
  2084. "label": null,
  2085. "logBase": 1,
  2086. "max": null,
  2087. "min": null,
  2088. "show": true
  2089. },
  2090. {
  2091. "format": "short",
  2092. "label": null,
  2093. "logBase": 1,
  2094. "max": null,
  2095. "min": null,
  2096. "show": false
  2097. }
  2098. ],
  2099. "yaxis": {
  2100. "align": false,
  2101. "alignLevel": null
  2102. }
  2103. },
  2104. {
  2105. "aliasColors": {},
  2106. "bars": false,
  2107. "dashLength": 10,
  2108. "dashes": false,
  2109. "datasource": "${DS_INFLUXDB-UNIFI}",
  2110. "decimals": 0,
  2111. "editable": true,
  2112. "error": false,
  2113. "fill": 0,
  2114. "gridPos": {
  2115. "h": 8,
  2116. "w": 12,
  2117. "x": 12,
  2118. "y": 39
  2119. },
  2120. "id": 28,
  2121. "isNew": true,
  2122. "legend": {
  2123. "alignAsTable": true,
  2124. "avg": false,
  2125. "current": true,
  2126. "hideEmpty": true,
  2127. "hideZero": true,
  2128. "max": true,
  2129. "min": true,
  2130. "rightSide": true,
  2131. "show": true,
  2132. "total": false,
  2133. "values": true
  2134. },
  2135. "lines": true,
  2136. "linewidth": 2,
  2137. "links": [],
  2138. "nullPointMode": "connected",
  2139. "options": {},
  2140. "percentage": false,
  2141. "pointradius": 5,
  2142. "points": false,
  2143. "renderer": "flot",
  2144. "seriesOverrides": [],
  2145. "spaceLength": 10,
  2146. "stack": true,
  2147. "steppedLine": false,
  2148. "targets": [
  2149. {
  2150. "alias": "$tag_device_name 5GHz",
  2151. "dsType": "influxdb",
  2152. "groupBy": [
  2153. {
  2154. "params": [
  2155. "$__interval"
  2156. ],
  2157. "type": "time"
  2158. },
  2159. {
  2160. "params": [
  2161. "device_name"
  2162. ],
  2163. "type": "tag"
  2164. }
  2165. ],
  2166. "measurement": "uap_radios",
  2167. "orderByTime": "ASC",
  2168. "policy": "default",
  2169. "query": "SELECT last(\"num_sta\") FROM \"uap_radios\" WHERE (\"device_name\" =~ /^$host$/ AND \"radio\" = 'na') AND $timeFilter GROUP BY time($__interval), \"device_name\"",
  2170. "rawQuery": false,
  2171. "refId": "A",
  2172. "resultFormat": "time_series",
  2173. "select": [
  2174. [
  2175. {
  2176. "params": [
  2177. "num_sta"
  2178. ],
  2179. "type": "field"
  2180. },
  2181. {
  2182. "params": [],
  2183. "type": "last"
  2184. }
  2185. ]
  2186. ],
  2187. "tags": [
  2188. {
  2189. "key": "radio",
  2190. "operator": "=",
  2191. "value": "na"
  2192. }
  2193. ]
  2194. },
  2195. {
  2196. "alias": "$tag_device_name 2.4GHz",
  2197. "dsType": "influxdb",
  2198. "groupBy": [
  2199. {
  2200. "params": [
  2201. "$__interval"
  2202. ],
  2203. "type": "time"
  2204. },
  2205. {
  2206. "params": [
  2207. "device_name"
  2208. ],
  2209. "type": "tag"
  2210. }
  2211. ],
  2212. "measurement": "uap_radios",
  2213. "orderByTime": "ASC",
  2214. "policy": "default",
  2215. "query": "SELECT last(\"num_sta\") FROM \"uap_radios\" WHERE (\"device_name\" =~ /^$host$/ AND \"radio\" = 'ng') AND $timeFilter GROUP BY time($__interval), \"device_name\"",
  2216. "rawQuery": false,
  2217. "refId": "B",
  2218. "resultFormat": "time_series",
  2219. "select": [
  2220. [
  2221. {
  2222. "params": [
  2223. "num_sta"
  2224. ],
  2225. "type": "field"
  2226. },
  2227. {
  2228. "params": [],
  2229. "type": "last"
  2230. }
  2231. ]
  2232. ],
  2233. "tags": [
  2234. {
  2235. "key": "radio",
  2236. "operator": "=",
  2237. "value": "ng"
  2238. }
  2239. ]
  2240. }
  2241. ],
  2242. "thresholds": [],
  2243. "timeFrom": null,
  2244. "timeRegions": [],
  2245. "timeShift": null,
  2246. "title": "Clients per AP per band",
  2247. "tooltip": {
  2248. "msResolution": false,
  2249. "shared": true,
  2250. "sort": 2,
  2251. "value_type": "individual"
  2252. },
  2253. "type": "graph",
  2254. "xaxis": {
  2255. "buckets": null,
  2256. "mode": "time",
  2257. "name": null,
  2258. "show": true,
  2259. "values": []
  2260. },
  2261. "yaxes": [
  2262. {
  2263. "format": "none",
  2264. "label": "",
  2265. "logBase": 1,
  2266. "max": null,
  2267. "min": null,
  2268. "show": true
  2269. },
  2270. {
  2271. "format": "short",
  2272. "label": null,
  2273. "logBase": 1,
  2274. "max": null,
  2275. "min": null,
  2276. "show": false
  2277. }
  2278. ],
  2279. "yaxis": {
  2280. "align": false,
  2281. "alignLevel": null
  2282. }
  2283. },
  2284. {
  2285. "aliasColors": {},
  2286. "bars": false,
  2287. "dashLength": 10,
  2288. "dashes": false,
  2289. "datasource": "${DS_INFLUXDB-UNIFI}",
  2290. "fill": 0,
  2291. "gridPos": {
  2292. "h": 9,
  2293. "w": 12,
  2294. "x": 4,
  2295. "y": 47
  2296. },
  2297. "id": 10,
  2298. "legend": {
  2299. "alignAsTable": true,
  2300. "avg": false,
  2301. "current": true,
  2302. "hideEmpty": false,
  2303. "hideZero": false,
  2304. "max": true,
  2305. "min": true,
  2306. "rightSide": true,
  2307. "show": true,
  2308. "sort": "current",
  2309. "sortDesc": true,
  2310. "total": false,
  2311. "values": true
  2312. },
  2313. "lines": true,
  2314. "linewidth": 1,
  2315. "links": [],
  2316. "nullPointMode": "connected",
  2317. "options": {},
  2318. "percentage": false,
  2319. "pointradius": 5,
  2320. "points": false,
  2321. "renderer": "flot",
  2322. "seriesOverrides": [],
  2323. "spaceLength": 10,
  2324. "stack": false,
  2325. "steppedLine": false,
  2326. "targets": [
  2327. {
  2328. "alias": "$tag_ap_mac",
  2329. "groupBy": [
  2330. {
  2331. "params": [
  2332. "2m"
  2333. ],
  2334. "type": "time"
  2335. },
  2336. {
  2337. "params": [
  2338. "ap_mac"
  2339. ],
  2340. "type": "tag"
  2341. }
  2342. ],
  2343. "measurement": "clients",
  2344. "orderByTime": "ASC",
  2345. "policy": "default",
  2346. "query": "SELECT derivative(first(\"wired-rx_bytes\"), 1s) FROM \"clients\" WHERE (\"hostname\" = 'dns-rtn') AND $timeFilter GROUP BY time(10s) fill(none)",
  2347. "rawQuery": false,
  2348. "refId": "A",
  2349. "resultFormat": "time_series",
  2350. "select": [
  2351. [
  2352. {
  2353. "params": [
  2354. "rssi"
  2355. ],
  2356. "type": "field"
  2357. },
  2358. {
  2359. "params": [],
  2360. "type": "last"
  2361. }
  2362. ]
  2363. ],
  2364. "tags": [
  2365. {
  2366. "key": "is_wired",
  2367. "operator": "=",
  2368. "value": "false"
  2369. }
  2370. ]
  2371. }
  2372. ],
  2373. "thresholds": [],
  2374. "timeFrom": null,
  2375. "timeRegions": [],
  2376. "timeShift": null,
  2377. "title": "Rssi",
  2378. "tooltip": {
  2379. "shared": true,
  2380. "sort": 2,
  2381. "value_type": "individual"
  2382. },
  2383. "transparent": true,
  2384. "type": "graph",
  2385. "xaxis": {
  2386. "buckets": null,
  2387. "mode": "time",
  2388. "name": null,
  2389. "show": true,
  2390. "values": []
  2391. },
  2392. "yaxes": [
  2393. {
  2394. "format": "dBm",
  2395. "label": "Rssi",
  2396. "logBase": 1,
  2397. "max": null,
  2398. "min": null,
  2399. "show": true
  2400. },
  2401. {
  2402. "format": "short",
  2403. "label": null,
  2404. "logBase": 1,
  2405. "max": null,
  2406. "min": null,
  2407. "show": false
  2408. }
  2409. ],
  2410. "yaxis": {
  2411. "align": false,
  2412. "alignLevel": null
  2413. }
  2414. }
  2415. ],
  2416. "refresh": "30s",
  2417. "schemaVersion": 18,
  2418. "style": "dark",
  2419. "tags": [],
  2420. "templating": {
  2421. "list": []
  2422. },
  2423. "time": {
  2424. "from": "now-3h",
  2425. "to": "now"
  2426. },
  2427. "timepicker": {
  2428. "refresh_intervals": [
  2429. "5s",
  2430. "10s",
  2431. "30s",
  2432. "1m",
  2433. "5m",
  2434. "15m",
  2435. "30m",
  2436. "1h",
  2437. "2h",
  2438. "1d"
  2439. ],
  2440. "time_options": [
  2441. "5m",
  2442. "15m",
  2443. "1h",
  2444. "6h",
  2445. "12h",
  2446. "24h",
  2447. "2d",
  2448. "7d",
  2449. "30d"
  2450. ]
  2451. },
  2452. "timezone": "",
  2453. "title": "NOC",
  2454. "uid": "YVR23BZiz",
  2455. "version": 53
  2456. }
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!