Anyone know how to pull out the Message that is the Description thats trapped from the Event log. I can see the message in the Alert console but want to know how to query for them in SQL?
The messages are written to the alarm DB, for you to easily retrieve them I recommend you enable the NIS bridge (search for 'bridge' in the NAS documentation).
From there the two tables you want to query are:
This table stores the actual alarm event as received and processed by the NAS. This is enabled by the ‘Log transaction details’ flag. Compression is done by removing suppressed updates. Housekeeping is done by removing the entire transaction.
One record per unique alarm is maintained and updated. Housekeeping is done by removing the alarm record.
Retrieving data ...