Rack weight per Rack/Cage using ETL

[DCIM_Support]

Hi,

We have been trying to gather if we can get the Rack weight per rack using the ETL. Anyone who has experience on this area?

(CID:132667423)

[DCIM_Support · Accepted solution]

Hi Vineet

Sorry for the delayed answer.

Yes that is possible. The data is available in the swo_kpi table.

The query below should get you started.

select ci_name, kpi_value, kpi_serie_type, ci_type from swo_kpi k, configuration_item ci where kpi_serie_type = 'TOTAL_WEIGHT' and k.ci_id = ci.ci_id;

Best,

Niels

(CID:133367416)

[DCIM_Support]

Thanks Niels , Let me work using this.

(CID:133367474)

[DCIM_Support]

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