Options to edit historical data in Citadel database (Lookout 6.0)

[alan g.]

We are running a new installation of Lookout 6.0

I am looking for ways to edit the historical data that is found in the Citadel database. For example, if an alarm clears before I can enter comments, I would like to go to the database after the fact and enter comments regarding the alarm.

We are running this on XP pro operating system.

Thanks,

Alan

[Khalid]

Hi Alan,

I am afraid this will be difficult, if at all possible.  Citadel data, by design, can be written to (and edited?) only by the product using it, i.e., Lookout, LabVIEW-DSC, etc.  Outside of these products we can only retrieve the data -- not edit or add to it.  As you are probably aware, some of the options for writing user data (as opposed to IO/system data) from within these products is to use the Logger Object in Lookout and the VI-Server approach in DSC. 

So, I guess one option is to "annotate" / write additional data separately using the Logger Object, referencing the Alarms somehow.

Having said that, I believe Lookout 6.x (Citadel5) uses MSDE for storing Alarm data (other data is still stored in the native Citadel database).  You could explore this -- try opening the MSDE database from Query Analyzer, from instance, and see if it can be edited.  I haven't tried this. 

Hope this gives you some ideas. 

-Khalid

[Mike@DTSI]

This isnt very good seeing as how CFR 21 Part 11 is becoming more necessary....