You upgrade Symantec Endpoint Protection Manager (SEPM) to 14.2 RU2. When you navigate to Monitor > Logs, click the View Log button for the Computer Status log, then click the Export button to export the log, a Query Failed error is shown instead of the expected CSV file save dialog box.

Reporting.log shows a failed query with a stack trace similar to the one below:

Stack trace:
#0 D:\SEPM\Php\Include\Common\ado.php(584): com->Execute(' select * from ...', -1)
#1 D:\SEPM\Php\Include\Common\ado.php(340): ado_doPreparedStatement(' select * from ...', Object(com))
#2 D:\SEPM\Php\Include\Common\connectdb.php(254): ado_query('select * from (...', Object(com), false)
#3 D:\SEPM\Inetpub\Reporting\Inventory\export_inventory.php(126): sav_query('select * from (...', Object(com))
#4 {MAIN.EN_US}Error message: <b>Source:</b> Microsoft OLE DB Provider for ODBC Drivers<br/><b>Description:</b> [Microsoft][SQL Server Native Client 11.0][SQL Server]All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.<br>Error code: -2147352567<br>File and line: D:\SEPM\Php\Include\Common\ado.php(584)<br>Trace: #0 D:\SEPM\Php\Include\Common\ado.php(584): com->Execute(' select * from ...', -1)
#1 D:\SEPM\Php\Include\Common\ado.php(340): ado_doPreparedStatement(' select * from ...', Object(com))
#2 D:\SEPM\Php\Include\Common\connectdb.php(254): ado_query('select * from (...', Object(com), false)
#3 D:\SEPM\Inetpub\Reporting\Inventory\export_inventory.php(126): sav_query('select * from (...', Object(com))

• SEPM 14.2 RU2

A missing INSTALL_TYPE column in the union query that is run when not only Windows, but also Linux clients are present in the environment.

This issue is fixed in Symantec Endpoint Protection 14.2 RU2 MP1. For information on how to obtain the latest build of Symantec Endpoint Protection, see Download the latest version of Symantec software here.

Workaround

 This issue can be resolved by renaming Symantec Endpoint Protection Manager\Php\Include\Inventory\InventoryQueries.php to InventoryQueries_backup.php and dropping in the replacement InventoryQueries.php file in attachment. The replacement file includes the corrected query.

Alternatively, open InventoryQueries.php in a text editor with line number display and, in-between lines 638 and 639, add the highlighted SA.INSTALL_TYPE, line shown below, then save the file.

 638:  SA.FIREWALL_ONOFF,
​ 639:  SA.INSTALL_TYPE,
 640:  case when SA.LAST_DOWNLOAD_TIME >= SA.CREATION_TIME then SA.LAST_DOWNLOAD_TIME else 0 end as LAST_DOWNLOAD_TIME,