This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Unable to execute SQL query command


Hi All,

Below is the current customer deployment, We encounter issues with missing data control information for certain date 11th until 16th December 2020.
We have logged a case with Support and provided with SQL query to extract information. However, we encounter weird query report whereby instead of 2019 the error was trying to convert nvarchar value 2014.

Anyone encounter same issue or can help solve the solution?. Thanks

Sophos Environment:-


Sophos SEC (Windows 2012).
Sophos SQL Database (Windows 2012).

SQL Query & Error:-


SELECT * FROM [SOPHOS550].[Sophos Reporting Interface].[vEventsDataControlData] where EventTime >=2019-12-12



This thread was automatically locked due to age.
Parents Reply Children
No Data