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  
  

Migrate Opalis Policies to Orchestrator