Generate point list
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, 30
From time to time this is required when people request lists of measurements from installations.
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..
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.