# Alarm status表中Active and UnAsk的计数与Mysql中的记录不一致 **URL:** \ **Category:** Ignition\ **Tags:** database, ignition80, perspective\ **Created:** [August 30, 2022, 2:42pm UTC](https://forum.inductiveautomation.com/t/alarm-status-active-and-unask-mysql/63605 "2022-08-30T14:42:23Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![471421143](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/471421143/32/38211_2.png) [@471421143](https://forum.inductiveautomation.com/u/471421143)\ **Post date:** [August 30, 2022, 2:42pm UTC](https://forum.inductiveautomation.com/t/alarm-status-active-and-unask-mysql/63605/1 "2022-08-30T14:42:23Z")
在MySql中，我使用Sql 语句查询Active and UnAsk的报警记录：SELECT \* FROM (SELECT \* FROM alarm\_events group by eventid, eventid having count(\*)=1) as A where A.eventtype=0 and A.eventflags=0 得到6条记录， 但是在Alarm Status table中只显示有两条激活未确认的记录。这是什么原因呢？ ![mysql](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/f/df6d2fbf81eee46b8136cda9989c879fe8c4cfab.png) ![alarm2](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/1/d18622785f86a4fc7a1c335de568b3745043a4ab.png) ![alarm](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/2/626214e0bc3fae01e9a2c95fb8c65e5249c4a9a4.png) ---
**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Post date:** [August 30, 2022, 3:21pm UTC](https://forum.inductiveautomation.com/t/alarm-status-active-and-unask-mysql/63605/2 "2022-08-30T15:21:31Z")
Yes. ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [August 30, 2022, 6:54pm UTC](https://forum.inductiveautomation.com/t/alarm-status-active-and-unask-mysql/63605/3 "2022-08-30T18:54:31Z")
The journal holds each event. The ack would be a separate event. If you need what is in the status table (instead of the journal), consider using [system.alarm.queryStatus()](https://docs.inductiveautomation.com/display/DOC81/system.alarm.queryStatus). ---
**Author:** ![471421143](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/471421143/32/38211_2.png) [@471421143](https://forum.inductiveautomation.com/u/471421143)\ **Post date:** [August 30, 2022, 8:16pm UTC](https://forum.inductiveautomation.com/t/alarm-status-active-and-unask-mysql/63605/4 "2022-08-30T20:16:39Z")
谢谢您的回复. 我使用[system.alarm.queryStatus()] 获得的结果和alarm status table中的一致，也是只有两条激活未确认的记录. 但是这无法满足我的需要. 报表统计中我需要统计一段时间不同报警类型的数量, 在手机端进行报警信息的反馈内容录入. 这些都需要与mysql中的记录交互. 我想知道数据不一致的原因是什么？ 是我的sql语句不对吗.或者alarm status table从数据库检索Active and UnAsk记录的sql语句是什么. ---
**Author:** ![ggross](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ggross/32/12668_2.png) [@ggross](https://forum.inductiveautomation.com/u/ggross)\ **Post date:** [August 31, 2022, 4:03pm UTC](https://forum.inductiveautomation.com/t/alarm-status-active-and-unask-mysql/63605/5 "2022-08-31T16:03:30Z")
One thing that might be incorrect in your query is `A.eventtype=0` will only return `Clear Unacknowledged` records. If you want all `Unacknowledged` you would need to be searching for `A.eventtype in (0, 2)` which would get you `Clear Unacknowledged` and `Active Unacknowledged`. You may also want to play around or remove `A.eventflags` as that is a binary representation of different events on the alarm: ```auto Bit 0: System event Bit 1: Shelved event Bit 2: System Ack Bit 3: Is Acknowledged Bit 4: Is Clear Bit 5: From Enabled State Change ``` Garth