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

[DCIM_Support]

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.

(CID:93194099)

[DCIM_Support]

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

(CID:93194157)

[DCIM_Support · Accepted solution]

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

(CID:93194183)

[DCIM_Support]

Hi Guillaume,

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

Malc

(CID:93194185)

[DCIM_Support]

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.

(CID:93194187)

[DCIM_Support]

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