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.
Parents
  • 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
Reply
  • 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
Children
No Data
Cookie Information Banner