HOW TO make the PCA filter 'Macintosh Computers with no pcAnywhere plug-in Installed' available again after you deleted the rule.
|Article:TECH198307|||||Created: 2012-10-12|||||Updated: 2012-10-12|||||Article URL http://www.symantec.com/docs/TECH198307|
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.
SMP7 + PCA Solution
The filter is set to hidden.
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 = 'Macintosh Computers with no pcAnywhere plug-in Installed' AND Description = 'This filter contains Macintosh 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)):
WHERE Name = 'Macintosh Computers with no pcAnywhere plug-in Installed' AND Description = 'This filter contains Macintosh 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 Macintosh 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/TECH198307