topic Re: How to get Temperature report from OneView using API script? in HPE OneView

How to get Temperature report from OneView using API script?

Vinodh_Kumar_V — Thu, 31 Aug 2023 02:19:41 GMT

Hello Team,

We have 40 servers in the OneView and need to download Temperature inventory for each server in Microsoft Excel.

Please share the different methods to download customized Report from OneView. Thanks!

Re: How to get Temperature report from OneView using API script?

MV3 — Tue, 29 Aug 2023 04:09:22 GMT

Server status is refreshed every 20 minutes when there is no event from the iLO. If you are looking for real-time temp monitoring or data collection,it is not possible.

You will have to collect the data from individual server and insert it in excel.

Cheers....

Re: How to get Temperature report from OneView using API script?

bradawk1 — Wed, 13 Sep 2023 10:33:52 GMT

You can use the OneView REST API to get authenticated to the OneView appliance. Then useing those credentials can get credentials to log into the iLO of each server. Once you have that, you can use the iLO Redfish API to get thermal data. There are lots of locations. Here is just an example:

i=1 TMP=$(mktemp) for SERVER in my-server-r{1..2}-n{1..12}.myorg.com; do echo "Getting thermal data from ${SERVER}" UUID=$(jq -r '.members[] | select(.serverName=="'${SERVER}'") | "\'(.uuid)"' ${HARDW} read iLOSSO iLOAuth <<< $(curl --insecure --silent --header "X-API-Version: ${currentVersion}" \ --header "auth: ${sessionID}" --request GET ${OneView}/rest/server-hardware/${UUID}/remoteConsoleUrl | \ jq -r '.remoteConsoleUrl' | sed -e 's|hplocons|https' -e 's|addr=||' -e 's|^$.*$&sessionkey=$.*$$|\1 \2') curl --insecure --silent --output thermal${i} --header "X-Auth-Token: ${iLOAuth}" --request GET ${iLOSSO}/redfish/v1/chassis/1/thermal jq '. + { "serverName": "'${SERVER}'" }' thermal${i} > ${TMP} cat ${TMP} > thermal${i} ((i++)) done # ((i--)) j=${i} THERMAL=thermal CMD="" for (( i=1; i<=${j}; i++ )); do CMD="${CMD} ${THERMAL}${i}" done cat $(echo "${CMD}") > ${THERMAL} /bin/rm ${THERMAL}? ${THERMAL}?? ${TMP} # jq -r '.serverName as $name | .Temperatures[] | { "serverName": $name,"Name":.name,"PhysicalContext":.PhysicalContext,"ReadingCelsius":.ReadingCelsius }' ${THERMAL}

Re: How to get Temperature report from OneView using API script?

bradawk1 — Thu, 14 Sep 2023 11:29:25 GMT

I'm sorry. Just realized I posted getting the UUID from a downloaded file of all of the OneView hardware. In order to query OneView directly for that, substitute the UUID= line above with these two lines:

ACTV=$(python3 -c "import urllib.parse, sys; print urllib.parse.quote(sys.argv[1])"'serverName' = '${SERVER}'\"") UUID=$(curl --insecure --header "X-API-Version: ${currentVersion}" --header "auth: ${sessionID}" --silent \ --request GET ${OneView}/rest/server-hardware?filter=${ACTV} | jq -r '.members[] | .uuid'})