Deployment solution: Predefined computers created with static IP addresses no longer show up in the predefined computers filter

Products

• Deployment Solution

Issue/Introduction

​Computers entered with static IP addresses in the Symantec Management, 'Add Predefined Computer Settings' window, no longer show up under the pre-defined Computers filter. 

Eg: 

 

Cause

This was due to a change in the way the filter was constructed under RU1 to account for another condition. 

Environment

Affects 8.1 RU1, RU2

Resolution

Engineering is currently working to resolve this in 8.1 RU3.

WORKAROUND:

The pre-defined computer filter can be exported from the 8.1 version and imported into 8.1 RU1 or can be manually reverted by exporting and inserting the SQL below:

    SELECT  predefine.[_ResourceGuid]
        FROM    Inv_AeX_AC_Identification as predefine
        WHERE   predefine.[_ResourceGuid] NOT IN (SELECT  [_ResourceGuid] FROM
Inv_Client_Task_Resources )  AND [OS Name] = 'Unknown Windows'