Modify Opalis Policies that Contain Special Characters
Updated: November 1, 2013
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
Other ResourcesMigrate Opalis Policies to Orchestrator
For additional resources, see Information and Support for System Center 2012.
Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.