Export (0) Print
Expand All

Modify Opalis Policies that Contain Special Characters

 

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft