MARKET: |
ALL |
PROBLEM OR NEED TO SOLVE: |
Currently, it is not possible to pull alarm/event history into a report. Alarm and Event reports are needed at times such as when investigating incidents. Currently, I can run SQL queries against the appropriate historian views/tables and insert the results into an Excel spreadsheet for users. However, there needs to be a way for a typical user to do this just as they can with other historized data, such as analog or discrete. |
EXPECTED FUNCTIONALITY: |
A typical user should be able to use Historian Client Excel add-in to retrieve alarm and/or event logger history just as they can other types of data. I envision a new button/function where, once selected, a screen pops up letting the user select what historian they want to access, if they want alarm history, event, or a combination of both of them, and they can enter a date range. Once done, they can select which columns they want or select all of them if they like. This function pulls in the information from Historian and inserts it into the spreadsheet just like any other data it can currently handle. This would make it possible for a typical user to just point and click to get a report instead of having to sling SQL code around. |
RATING |
In a scale of 1 to 10, how would you rate this enhancement?
E.g. Ranking of importance to the customer:
10: Cannot do the project without this feature and there are no workarounds.
1: Cosmetic . Can live with it but would like it to be enhanced.
8 – Users need these kinds of reports often. They typically come to me and wait for me to create SQL code which I then use to generate the report which I then forward to them. This works but can be slow and cumbersome depending on how busy we are all. One thing to keep in mind is these reports are sometimes used in incident reports. Someone could be in serious trouble and management may not want anyone outside the investigation, such as me, aware there is an investigation. This will help keep things private.
|
BUSINESS CASE |
Provide information on the associated business case.
See information in rating above.
|
REQUESTOR(S) |
Customer or customers requesting this feature.
Users, management
|
RELATED ENHANCEMENT REQUESTS |
If known, mentioned related existing enhancement requests.
Unknown
|
I see two requests here: the ability to get event rows into excel, similar to how users do that with VTQ today.
The other is to represent the entire alarm lifecycle on a single row, i.e. go from multiple rows with a timestamp in each, to a single row with multiple timestamps.
Are they both equally important? Would everyone want to group-by and pivot the event rows in the same way?
Initiated by Case # 960375144