You'll need to use NPM's Universal Device Poller (UnDP) along with the correct OID to poll the device for when it fails.
HP provides the MIB files w OIDs for MSA2000 as a download:
Also, see the "Monitoring MIBS with Universal Device Pollers" section (physical page 235) of the Solarwinds Orion Network Administrator Guide for information on creating a UnDP.
Finally, check out this Moniroting HP Storage Works MSA 2012i for more information.
Hope you don't mind if I go in reverse order. Unfortunately I have already tried profiler, only to go to support and find that msa 2000's aren't supported by profiler, which was quite disappointing.
What I did was just to set up a rule for the traps so that when the msa sends out a trap it will alert send out a mail. As far as I know dothill (who hp bought to get the MSA 2000 family) never released an oid to monitor disk status, but if it works on traps then it is all good!