I want to do some SQL reporting on success and errors for updates to the clients managed by the console as seen here:
Note there is a Code which here varies between 0x00000000 and 0x0000006d. In decimal that's 0 and 109. You can find those code values in the Errors table. But I couldn't find anywhere in the database which translates them to the Description on the right column so you could use them in a report. The closest Sophos webpage is here:
https://community.sophos.com/kb/en-us/120449
But this link is missing codes 0 and 109. Where can we go to find every value of the Code so we could decode it? Here is the DB Query so far. But it's unable to decode these cryptic codes yet so it doesn't work very well so far:
SELECT
e.*,
c.Name, c.DomainName, DNSName, IPAddress, IPAddressText, LastLoggedOnUser
FROM
Errors e
LEFT JOIN
ComputersAndDeletedComputers c ON e.ComputerID = c.ID
ORDER BY
e.id ASC;
This thread was automatically locked due to age.
