We have developed a 3rd party app for Milestone and we need to get the source devices and linked devices for an alarm. We are currently being sent the events through a webhook but it does not include this information.
One option is to use the Alarm Definition API call but we would prefer to get this information directly from the sql database.
If we where to use the API it would mean a call for each alarm in the system to get the required information.
Using the configuration SQL Server database directly is not documented or supported. The database can be changed without notice by Milestone from one version to the next.
I do recommend to use the API instead, if it is changed it will be done with prior notice.
I am not sure if I understand or agree with the last remark. I assume the number of reads will be the same whether you read the database directly or uses the API.
You can probably figure out how it works if you want to use the database directly, but I am sorry there is a Milestone policy against me telling about using it directly, I hope you understand.