In the 7.4 Schema can you confirm which table the measured load is for creating my own report.

DCIM_Support · ‎2020-07-02

i am creating a new report in Insight i have measured load in DC down to the rack level and this is also being shown at the cage level. In the 7.4 schema which table is this held as i have tried configuration_item.ci_power_draw as utilized_power, but no luck.

any help appreciated.

DCIM_Support · ‎2020-07-02

Hi Malcolm,

If you are looking for measurements that have been manually entered into DCO, then you will find this in the table "configuration_item_power_path". The column is named "pp_peak_power" and you will use the corresponding power receptacle ci_id to retrieve the line.

This field is in the following format: #L1:290.98 #L2:301.3768 #L3:NaN (unit=kW). I have written the following script to transform that text field into a sum of the 3 phases, you can just reuse it in your report by changing ["peak_power"] with your column binding name:

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

result += (Math.round(splitted[i])/1000);

}

result=Math.round(result*100)/100;

}

Regards,

Guillaume

See Answer In Context

DCIM_Support · ‎2020-07-02

Hi Malcolm, we will look into it, thanks for sharing.

DCIM_Support · ‎2020-07-02

Hi Malcolm,

If you are looking for measurements that have been manually entered into DCO, then you will find this in the table "configuration_item_power_path". The column is named "pp_peak_power" and you will use the corresponding power receptacle ci_id to retrieve the line.

This field is in the following format: #L1:290.98 #L2:301.3768 #L3:NaN (unit=kW). I have written the following script to transform that text field into a sum of the 3 phases, you can just reuse it in your report by changing ["peak_power"] with your column binding name:

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

result += (Math.round(splitted[i])/1000);

}

result=Math.round(result*100)/100;

}

Regards,

Guillaume

DCIM_Support · ‎2020-07-02

Hi Guillaume,

Thanks you for your help i will give it a go.

Malc

DCIM_Support · ‎2020-07-02

Hi Guillaume,

when i update my query with the following line (configuration_item_power_path.pp_peak_power as utilized_power,)

I recieve the following error.

ERROR: missing FROM-clause entry for table "configuration_item_power_path"
LINE 10: configuration_item_power_path.pp_peak_power as utilized_pow...
^
********** Error **********

ERROR: missing FROM-clause entry for table "configuration_item_power_path"
SQL state: 42P01
Character: 411)

Any suggestions.

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.