How to get phase info for racks, rdus, UPSs via SXW Insight

DCIM_Support · ‎2020-07-02

I want to report in phase balancing and am looking for some raw data in DCO. I can see CONFIGURATION_ITEM_POWER_PATH and pp_average_power but I'm not sure exactly what it means.

Where else in DCO 7.5 ETL Export DB might I find the data?

Thanks

DCIM_Support · ‎2020-07-02

Hi Ed,

Remember, you won't find any historical data in the export db.

Otherwise you are looking at the right table (configuration_item_power_path), and both peak values (pp_peak_power) and average values (pp_average_power) are available for each phase.

You should have a value similar result than this one: #L1:756.0 #L2:432.0 #L3:456.0 which means 756Watts on phase 1, 432Watts on phase 2 and 456Watts on phase 3. You will need a little bit of scripting to extract the values from the string in your report engine. Note that "NaN" means we don't have measurement for the corresponding phase.

To my knowledge this data is not exposed today via web-services.

-Guillaume

See Answer In Context

DCIM_Support · ‎2020-07-02

Hi Ed Tarento, thank you for posting. Let's see who can be of assistance here. @community any ideas? Best, Stine

DCIM_Support · ‎2020-07-02

Hi Ed,

Remember, you won't find any historical data in the export db.

Otherwise you are looking at the right table (configuration_item_power_path), and both peak values (pp_peak_power) and average values (pp_average_power) are available for each phase.

You should have a value similar result than this one: #L1:756.0 #L2:432.0 #L3:456.0 which means 756Watts on phase 1, 432Watts on phase 2 and 456Watts on phase 3. You will need a little bit of scripting to extract the values from the string in your report engine. Note that "NaN" means we don't have measurement for the corresponding phase.

To my knowledge this data is not exposed today via web-services.

-Guillaume

DCIM_Support · ‎2020-07-02

Thanks Guillaume

A Javascript Event Handler in the BIRT report?

DCIM_Support · ‎2020-07-02

Hi Ed, You can script either the data set by adding a computed column or the data cell in your table. Here is an example that would work if you expect only single phase measurements (replace "peak_power" by the name of your column): var result=0; if(dataSetRow["peak_power"] != null){ var javaString = (new Packages.java.lang.String(dataSetRow["peak_power"])); var cleaned = javaString.replace('","', "").replace("{", "").replace("}", "").replace("NULL", "0").replace('"#L1:', "").replace("#L1:", "").replace(" #L2:", ",").replace(" #L3:", ",").replace('";', "").replace("NaN", "0").replace(',"', ""); var splitted=cleaned.split(","); for (var i=0; i

DCIM_Support · ‎2020-07-02

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.