How to Query Alarms/Events from Citadel with SQL

[nathanpongar]

Hi everyone,

We are interested in building an application for viewing both trended data and alarms/events from Lookout 5.  I have already wrote code for retrieving trended data from Citadel using the ODBCConnection object in .net, but I’m not sure if I can extract alarm/event data the same way.  I’ve read several articles on this subject but haven’t found a clear answer.  Can you query alarms/events from Citadel using SQL?  And if so, what are the table names you need to use?

[nathanpongar]

Nobody has any advice on this?

[Ryan.S]

It's possible to query alarms by SQL. Unzip and run the attached software. select the "Microsoft OLE DB Provider for SQL Server" provider, Next. Connect to MyComputer\Citadel with NT Integrated security, and select the name of the database you want to query from the list. Then, you can input and execute the SQL to query alarm/event database.

There are three tables, table_set, table_clear, and table_ack.

Execute  select * from table_set  to see all the column names.

But I don't know how to write the .net code to query. It is said to be very complicated.