How to retrieve Image snapshot in Alarm Manager from MSSQL database

Hi,

We are working on extracting multiple alarm at once from Alarm Manager for reporting. May I know how to retrieve the Alarm snapshot image from the SQL database?

Thanks.

Regards,

Lee

The SQL Server Configuration database is not documented and using it directly is not supported. It means the Milestone policy is that I will not help. It also means that Milestone might change the database without notice in a future version. What I must recommend is that you use the Milestone APIs, these will be maintained even if Milestone would decide to change database layout or similar.

The Alarm and Event Viewer sample shows how to extract alarms, with some small modification you can extract the SnapshotList and the images within…

https://doc.developer.milestonesys.com/html/index.html?base=samples/componentsamples/alarmeventviewer/readme.html&tree=tree_2.html

Thanks for the suggestion!

Hi Bo,

We tried to run the alarmeventviewer sample but received the following error.

The command "cd “[C:\Program](file:C:/Program) Files\Milestone\MIPSDK\Bin”

CopyExportFiles.bat “[C:\Users\Administrator\Desktop\AlarmEventPictures\bin\Debug\](file:C:/Users/Administrator/Desktop/AlarmEventPictures/bin/Debug/)”" exited with code 9009.

Can help us on this?

Thanks.

Regards,

Lee

Please use a newer version of the sample, the error indicate you are using something very old.

https://github.com/milestonesys

PS.

I have an idea you might use https://download.milestonesys.com/mipsdk/samples/AlarmEventPictures.zip which is very old.

If this is the case you have two options.

  1. Change AlarmEventPictures.zip to use the NuGets. https://www.nuget.org/profiles/milestonesys
  2. Use instead the new sample from GitHub and then modify the code by using the extra code from AlarmEventPictures.zip.

If my suspicion was correct please use https://download.milestonesys.com/mipsdk/samples/AlarmEventPictures2025.zip instead, the old sample had issues besides being built on an old SDK and I chose to do an update…