Extract all nodes monitoring data

Hi, is there a way to find all metrics that are related to a node (like avg cpu load, availability etc.)?

I need to extract all available nodes monitoring data, as I understood the best way of doing that is to use SolarWinds/InformationService/v3/Json/Query endpoint. But I wasn't able to find out where to find what metrics are available for a node to write an SWQL query.

Also, I'd like to know if a new table is created for every metric to save historical data? Or those values are kept in some common storage?