Modify Opalis Policies that Contain Special Characters
Updated: May 13, 2016
Applies To: System Center 2012 - Orchestrator, System Center 2012 R2 Orchestrator
Occasionally Opalis Policies contain special characters. These characters are in objects and links between objects in Opalis Policies. You must remove these characters from Opalis Policies before they are migrated to Orchestrator. The following Microsoft SQL Server query runs against the Opalis database to locate Policies that contain special characters. The results provide information about the objects and links where special characters appear.
When a Name or Description field is located that contains these special characters, select the field and use CTRL+A to select its entire contents. Delete the field contents, and then replace the contents with supported characters.
SELECT Policies.Name, Objects.Name, Objects.Description FROM Objects join Policies on Objects.ParentID=Policies.UniqueID where ASCII(Objects.Name) < 32 or ASCII(CAST(Objects.Description as nvarchar(max))) < 32 and Policies.Deleted is NULL