Mass Changing Camera Settings in Database

Issue:

Camera settings need to be changed on a global level.

Solution:

This can be done from each archive server.

1. Open SQL Management Studio on the server that the cameras are recording to. Press connect.

2. Expand Databases > ESM5_2 > Views

3. Right click on dbo.CameraDetail and choose "Edit top 200 rows". You will now get a spreadsheet-like image that appears on the right.

4. Navigate to the columns you wish to change. Once entering a new value, be sure to press the ENTER key for settings to commit.

For example, if you need to change the IP Addresses, the columns you will need to change are: CameraIP (live view IP) and CaptureIP (recording stream IP).

Please contact support if you experience any issues.