How to Use an Automation Policy to Move Computer(s) in a Filter to an Organization Group on your Symantec Management Platform Server

Products

• Client Management Suite
• IT Management Suite

Issue/Introduction

The article can help you with the following scenario:

You have a bunch of computers that are part of a filter, and you want to move those computers into an organizational group.  In the following example, I have a computer in the filter, Derek's Computer Filter OU Test.  I want to move the computers listed in this filter to an organizational group called Derek's Organizational Group.

You have an organizational view created with an organizational group inside it.  

You would like an automation policy to move the computers on a set schedule.

Environment

Release: 8.6

Resolution

Start off by creating a new task.  In the create new task dialogue box, search for assign.  Choose Assign to Organizational Group.  Give the task a unique name and configure the Choose the Organizational Group that the resource(s) will be assigned to match your organizational group.

Once the task is created, you can move on to creating the automation policy.

For data source, you would use the RAW SQL Query option:

The SQL you use should only return a GUID for the filter you wish to move the computers in.  For example, the following SQL query will return a GUID for the filter containing the name Derek. 

select vc.Guid
from vcomputer vc
join CollectionMembership cm on cm.ResourceGuid = vc.Guid
join vCollection vcol on vcol.Guid = cm.CollectionGuid
where vcol.Name like '%derek%'

For Run job/task, choose the task you created earlier.

Click on Edit Input Parameters.

The Organizational Group will be the value of whatever you named your organizational group.

Resources, this is to be set to GUID.  This is important because the SQL query is returning a GUID.

That should be all you need to configure.