Article Content
Article Number | 000031541 |
Applies To | RSA Product Set: ECAT RSA Version/Condition: 4.x |
Tasks | The purpose of this article is to assign a machine group based on a SQL Query. The following steps could potentially be placed in an automated task to assign new machines daily. |
Resolution | Step 1: Create the desired groups in ECAT UI. Step 2: Build a query to retrieve a group number. This can only be done one group at the time. Example with a group named Workstations: SELECT TOP (1) @fk_machinegroup = PK_MachineGroups Step 3: Build a query to retrieve only the machines which you wish to change. Example with MachineOU: SELECT TOP 10 * Example with IP: SELECT TOP 10 * Step 4: Modify and run the attached script. BEGIN TRANSACTION If you are unsure of any of the steps above or experience any issues, contact RSA Support and quote this article number for further assistance. |