Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 1 subscriber
  • Views 7494 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.
  • 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
  • 0

    Hi Christian,

    I have multiple sites and domains. On one site I’’’’ve machines that are reporting, amongst others, 0000002e ‘‘‘‘Installation could not be started…’’’’. I want a report of those machines to give to my onsite support lads to investigate.

    I’’’’ve used the SQL statement: -

    SELECT [Name], [DomainName], [OperatingSystem], [IPAddressText], [InstallFailureReason], [InstallTime] ,[DNSName] ,[InsertedAt]

    FROM [ComputersAndDeletedComputers]

    WHERE [Managed]<> 1

    ORDER BY [Name]

    To list all the unmanaged machines with their failure reason. By filtering on [InstallFailureReason]=46, I can get all the 2e errors.

    Thanks for the pointer.

    :56444
Cookie Information Banner