DX NetOps

Is there a way I can get a list of all of the Device Has Stopped Responding To Polls events (0x10d35) that occurred on a certain day (yesterday) within a particular time frame?  The "outage" lasted only about 2 minutes and I'm pretty sure all of the alarms have cleared.  All the events would be on the same landscape.  Trying to find them without having to query each possible device.

Steve,

You can run the following command from the $SPECROOT/mysql/bin directory (from a bash shell on Windows). It will give you the model handle of the model and the number of times the event was logged in the timeframe specified:

./mysql --defaults-file=../my-spectrum.cnf -uroot -proot ddmdb -e "SELECT hex(model_h), count(*) as count from ddmdb.event where utime > UNIX_TIMESTAMP('2017-10-06 00:00:00') and utime < UNIX_TIMESTAMP('2017-10-07 00:00:00')and type=68917 group by hex(model_h) order by count desc;"

68917 is the decimal for 10d35

You will need to change the start/end dates and times for your needs.

The output will look similar to the following:

+--------------+------------+
| hex(model_h) | count |
+--------------+------------+
| 2000065 |               1 |
+--------------+------------+

Joe