QUERY THE SRHOOK CLUSTER ATTRIBUTE:
https://documentation.suse.com/sbp/sap/html/SLES4SAP-hana-scaleout-multitarget-perfopt-15/index.html#id-1.11.8.2.3
The query should actually query for the multi-target attr:
# crm_attribute -G -n hana_<sid>_site_srHook_<site>
And the output would be:
scope=crm_config name=hana_<sid>_site_srHook_<site> value=SFAIL