Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 1 subscriber
  • Views 7480 views
  • Users 0 members are here
Options
Suggested
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

Create custom Install error report

PopsZ1

Is it possible and what would the SQL statement be to create a report of computers with failed installs in a group.

I can connect to the Sophos DB with SQL management studio and extract simple reports. But I can’’’’t see which tables and fields will give installation errors in a similar way to the ‘‘‘‘Alert and Error Details’’’’ tab of the Enterprise console.

Thanks

:56339


This thread was automatically locked due to age.
Parents
  • 0

    Hello PopsZ1,

    installation errors

    which ones would these be and what is the purpose of these reports (i.e. in which way does Computers with errors in the console fall short)?

    I'm not mocking you. SEC still has the Install errors column in the Alerts and Error Details tab and Computers with installation errors in the View: drop-down but these are empty. Anyway, the information is in the dbo.Errors table (ComputerID refers to ID in ComputersAndDeletedComputers) where Source='ALC' and Outstanding=1 (note you'll get the download errors as well).

    Christian

    :56352
Reply
  • 0

    Hello PopsZ1,

    installation errors

    which ones would these be and what is the purpose of these reports (i.e. in which way does Computers with errors in the console fall short)?

    I'm not mocking you. SEC still has the Install errors column in the Alerts and Error Details tab and Computers with installation errors in the View: drop-down but these are empty. Anyway, the information is in the dbo.Errors table (ComputerID refers to ID in ComputersAndDeletedComputers) where Source='ALC' and Outstanding=1 (note you'll get the download errors as well).

    Christian

    :56352
Children
No Data