Endpoint Protection

Hey Gang,

My manager has instructed me to use Visual Studio to add a bunch of new Groups in SEP.

I've read the following thread:
https://www-secure.symantec.com/connect/forums/sep-client-switch-computer-mode-user-mode-automatically-and-moving-other-group
and I'm getting some background on the process.

I understand that I need to modify the identity_map table in the database, setting the NAME according to it's location in the strucutre, the TYPE to SemClientGroup.  My belief is the Domain_ID will work as the same domain_id as the rest of the groups.  From there the big puzzle piece is the ID, which appears to be the primary key for the table. 

How should I generate an ID for each record?

Are there any other tables that I need to modify?

Edited to add:
I'm using SQL Server 2005
Windows Server 2003
SQL Server Mgmt Studio

I'll look around and fine more tables, if they exist.

The database schema seems to have some information.

i can provied us the VBS script which can creat group in DB .......PM me........

sounds good, will do.

this script will move clients from defult group to there respective group only..........

Thanks hemu, but what I'm actually trying to do is to create new groups.

I've done a little digging and it appears that the identity_map table has  most of what I need.  I need to figure out how to properly generate an identiy_map ID, which appears to be a unique, randomly generated number.

hii i have script to creat a group to......

that is realy safe i can share this script  if admin of forum dont mind

hii

how can i share script with u..........?

Should i upload that on downloads.........?

 Hi!

I am trying to script creation of groups. 
Could you help me with providing me with the script, or pointing me in direction of what tables i have to update.

Thanx :-)

 

 Hi,I am trying to write scripts to creating groups too,can you send me the scripts?Thank you!!

Why do you guys need so many groups?
You can manage thousands of SEP clients with very minimal group usage.

I try to keep them to an absolute minimum otherwise it creates administration headaches later on!!
The same holds true for locations although sometimes it is unavoidable :)

I want to develop a internal manager system  with SEP integration.