Query failed error when exporting computer status logs

Products

• Endpoint Protection

Issue/Introduction

Upon upgrade SEPM to 14.3 RU4 and above, you are unable to export the computer status log. 

The Query Failed error is returned immediately after clicking export.

 

Environment

Symantec Endpoint Protection Manager 14.3 RU4 and above

Cause

getExportInventoryQueryNoLinuxClients() in RU4 was changed from: WHEN (SA.OS_TYPE_TEXT = 'MAC') THEN to WHEN (SA.OS_TYPE_TEXT <> 'MAC') THEN

InventoryQueries.php may not update during the Upgrade causing the issue

Resolution

1. Stop the SEPM services
2. Backup <SEPM>\Php\Include\Inventory\InventoryQueries.php
3. Download 14.3 RU4 InventoryQueries.php from this article
4. Replace <SEPM>\Php\Include\Inventory\InventoryQueries.php with updated InventoryQueries.php
5. Start the SEPM services
   
   
   
   

 

Additional Information

CRE-9289