I looked into the VoIPEngines table, to see what there is to see, expecting to see 5 rows -- the same number of rows in Engines table.
SELECT * FROM [dbo].[Engines]
SELECT * FROM [dbo].[VoipEngines]
However, it seems that somehow there have been a lot of null engines added into the table every since July 31.
VoipEngineID KeepAlive BusinessLayerPort EngineID
1 2018-10-23 14:03:51.450 17777 1
3 2018-10-23 14:03:45.293 17777 3
6 2018-07-31 11:03:49.423 17777 NULL
7 2018-07-31 11:04:39.257 17777 NULL
8 2018-07-31 11:04:49.523 17777 NULL
...
44990 2018-10-23 13:50:17.450 17777 NULL
44991 2018-10-23 13:55:17.883 17777 NULL
44992 2018-10-23 14:00:17.307 17777 NULL
As of writing this question, there are 44987 too many engines in VoipEngineID, all with NULL EngineID. These do not show up in the [dbo].[Engines] table.
Does anyone know what causes this?
Also, can I just delete the NULL rows?
DELETE [ve]
FROM [dbo].[VoipEngineID][ve]
WHERE [EngineID] IS NULL
I suppose someone is going to say, "ask Tech Support". Sure, I can do that, I just thought that I maybe this would make a good question to post online.
