1. I am trying to understand MoveClient.vbs (attached as MoveClient.txt) so I can customize it for our environment

2. I am referencing the SEP 11 RU7 MP1 database schema (https://www-secure.symantec.com/connect/downloads/database-schema-guide-sep-11-ru-7-mp1) to understand these SQL statements

3. I came across

sql="Select * from IDENTITY_MAP where type like 'SemClientGroup' and not name like '%\%';"

and I cannot find SemClientGroup referenced in the database schema, or any Symantec documentation.

Can anyone point me in the right direction?

Attachment(s)

MoveClient.txt   35 KB 1 version

Refer to the following links:

How to use the MoveClient Utility to switch multiple machines between computer and user mode.

@ Simpson Homer

Thank you for the links. However, it doesn't answer my original question. Where can I find more detailed information about the SEP 11 database schema because I cannot find where SemClientGroup is being referenced from.

In the future, I hope to create useful scripts to assist in administering SEP (beyond just moving clients), and I will definately post these scripts onto Symantec Connect

What she is requesting is the database schema that describes the possible attributes for TYPE in the table IDENTITY_MAP.

Other values in the TYPE field don't matter.

The name of the group is in the NAME field. More importantly is the ID in the IDENTITY_MAP table. That ID links back to the GROUP_ID in the SEM_CLIENT table. Thus every machine with SEP installed has an entry linking the GROUP_ID back to the name of the group as defined in the IDENTITY_MAP table.

As an example, there is no Group name defined in the SEM_CLIENT table. The best you can do is

SELECT computer_name, group_id from SEM_CLIENT

To get the name of the group that the machine belongs to you have to do a JOIN.

SELECT SEM_CLIENT.COMPUTER_NAME
       , IDENTITY_MAP.NAME
FROM   IDENTITY_MAP INNER JOIN
         SEM_CLIENT ON IDENTITY_MAP.ID = SEM_CLIENT.GROUP_ID





'SemClientGroup' is a value in the TYPE field of the IDENTITY_MAP table. You will not see that referenced in the schema doc as Symantec does not give you possible values for the fields.

Hope that clarifies things.

Yes, it answered the question perfectly. Thank you so much!

Hi. Please mark this thread as answered. It will help others and myself by letting us know how your question was resolved.

Regards.