HOW TO make the PCA filter 'Windows Computers with no pcAnywhere plug-in Installed' available again after you deleted the rule.

Article:TECH152290  |  Created: 2011-01-31  |  Updated: 2012-10-12  |  Article URL http://www.symantec.com/docs/TECH152290
Article Type
Technical Solution


Environment

Issue



When PCA Solution is added to SMP7 the PCA policies contain a special rule to filter all the clients that have no PCA agent installed. Should you delete this rule you cannot recreate it as the filter is not available for selection.


Environment



SMP7 + PCA Solution


Cause



The filter is set to hidden.


Solution



The filter is defined in the Database and you can set it to be visible.

1. Open the database

2. Go to Symantec_CMDB (or the name that you changed it to) and locate the Table DBO.Item

3a. You can run the following SQL statement to see what the current Attribute value is for this filter:

SELECT * FROM Item WHERE Name = 'Windows Computers with no pcAnywhere plug-in Installed' AND Description = 'This filter contains Windows computers that do not have the pcAnywhere plug-in installed.'

By default the setting is set to 23 (see table below for explanation of values)

3b. Run the following SQL statement to change the Attribute to 18 (Readonly - NoModify (2) + NoDelete (16)):

UPDATE Item
SET Attributes=18
WHERE Name = 'Windows Computers with no pcAnywhere plug-in Installed' AND Description = 'This filter contains Windows computers that do not have the pcAnywhere plug-in installed.'

If you run the statement from 3a again you should see that the Atrribute Value is now 18.

If you now open the SMP console and check your available filters you should be able to select the 'Windows Computers with no pcAnywhere plug-in Installed' filter.

Table for Attribute values:

0 = Normal
1 = Hidden
2 = NoModify
4 = NoReplication
16 = NoDelete
18 = Readonly - NoModify (2) + NoDelete (16)
32 = NoClone
128 = NoExport - This item can not be exported





Article URL http://www.symantec.com/docs/TECH152290


Terms of use for this information are found in Legal Notices