How to move Alerts in the 'Alert Management Settings' with a SQL query

Article:HOWTO80661  |  Created: 2012-10-09  |  Updated: 2012-10-24  |  Article URL http://www.symantec.com/docs/HOWTO80661
Article Type
How To



In some cases Alerts cannot be moved if the target Category is not in the window.  This query will allow you to move alerts manually in SQL.

You can also use the following query (with desired edits) to move multiple alerts since it is the current behavior of alert managment that you can only move one alert at a time.

Start by getting the target Category's GUID
     select [Guid] from Item where Name like '<targetCategory>'
--Where '<targetCategory>' is the name of the category you want the alert to go to, ie. 'Physical Disk'
--The result will be used below in '<targetCategoryGUID>', ie 'a240b9c6-8879-4113-bd0a-8d9de4fc0907'

Then run the following updates with the GUID from above:

Update ItemFolder
Set ParentFolderGuid = '<targetCategoryGUID>'
WHERE (ItemGuid IN (
SELECT [Guid] 
FROM PPA_AlertDefinition
WHERE Name like
'<AlertName>'))
--Where '<AlertName>' is the name of the alert you want to move, ie 'rtPhysicalDriveStateHotspare'
-----

Update PPA_AlertDefinition 
Set CategoryGuid = '<targetCategoryGUID>' 
WHERE Name like
'<AlertName>'
--Where '<AlertName>' is the name of the alert you want to move, ie 'rtPhysicalDriveStateHotspare'

 



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


Terms of use for this information are found in Legal Notices