Exporting of alarms and events
Many times I have been through this situation. My counterparts from operations, often ask me about event/alarm history of a particular object, like motor etc, of a particular date & time. And they need it in an XL format. Is there anyway to configure such resquest?
1. Alarm lists and event lists permit copying of their content. Use CTRL-A (mark all rows), then CTRL-C (copy) and then finally CTRL-V (paste) in the destination program, e.g. Excel or Notepad. A maximum of 500 rows can be displayed by A/E lists; to copy more, click the "Page Down" button and repeat the CTRL-A/C/V.
2. Excel DataDirect has a function called ABBAERetrieval() that you can use to automate the process. The output can be run manually in Excel on request, or fully automated (from the Scheduler Service). You fill find more information in the IM Data Access and Reports User's Guide, 3BUF001094-510 (Note: no IM server is required for DataDirect; its included in the 800xA Base System)