So in ontap 7 I could query the global status amongst other things using this OID.
# snmpwalk -v1 -c public 196.168.0.2 .1.3.6.1.4.1.789.1.2.2.4.0
SNMPv2-SMI::enterprises.789.1.2.2.4.0 = INTEGER: 3
# snmpwalk -v1 -c public 196.168.0.2 .1.3.6.1.4.1.789.1.2.2.25.0
SNMPv2-SMI::enterprises.789.1.2.2.25.0 = STRING: "The system's global status is normal. "
Other things are available too
# snmpwalk -v1 -c public 192.168.0.2 .1.3.6.1.4.1.789.1.2.4
SNMPv2-SMI::enterprises.789.1.2.4.1.0 = INTEGER: 1
SNMPv2-SMI::enterprises.789.1.2.4.2.0 = INTEGER: 0
SNMPv2-SMI::enterprises.789.1.2.4.3.0 = STRING: "There are no failed fans."
SNMPv2-SMI::enterprises.789.1.2.4.4.0 = INTEGER: 0
SNMPv2-SMI::enterprises.789.1.2.4.5.0 = STRING: "There are no failed power supplies."
With ontap 9 nothing is returned
# snmpwalk -v1 -c public 192.168.0.3 .1.3.6.1.4.1.789.1.2.2.4.0
# snmpwalk -v1 -c public 192.168.0.3 .1.3.6.1.4.1.789.1.2.4
Where can I get this information from?