The error messages are stored in the tblErrors.ErrorText and the error type is stored in the tsysasseterrortypes.ErrorMsg table.
A hint for the future, you can edit existing built-in reports to see how they are made. If you view 'Assets: Scanning errors in last 7 days' you will also see the two tables I mentioned above.