Export (0) Print
Expand All

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

See Also

-----
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.
-----
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft