Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
Generate point list
-
Hi,
Is there an easy way (SQL statement etc.) to generate a list/table that can spit out something like the following for every data point in a system:
Point data source, point name, point unit, point update frequency (seconds)I am trying to output a list like this that I can then paste into Excel or even just a text editor without any further manipulation required:
Generator, Energy, kWh, 30 Panel Meter, Load, kW, 10 Weather Station, Wind Speed, m/s, 30From time to time this is required when people request lists of measurements from installations.
Thanks
Jeremy -
We have a guy here who is proficient in SQL, he just needs to know where to get the data source update interval from, which is not apparent when looking through the tables..
-
Hey Jeremy,
The update rate is stored in the serialized data so it's not going to be available in an SQL statement. The only thing I can think of without writing any Java code would be to grab it out of the JSON from the export page or the API.
