query

  1. P

    Inquiry on querying network traffic

    Hi! I've been collecting proxmox data to create visualizations and just wondering what the difference is between non_negative_derivative(mean("netout"), 10s) and mean("netout") is when querying the data such as this: SELECT non_negative_derivative(mean("netout"), 10s) FROM "system" and is...
  2. S

    Created a BASH script to convert json to csv

    I have created a bash script that will strip the special characters from the .json file and organize via comma delimited CSV file. Original JSON file provided by the pvesh get <resource> --output-format json You will have duplicate headers but it's still useful for SQL import commands. Read...