Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Creating groups through SQL Server Managment Studio

Updated: 04 Aug 2010 | 13 comments
virusdefender's picture
+1 1 Vote
Login to vote

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...
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

discussion Filed Under:

Comments

virusdefender's picture
25
Aug
2009
1 Vote +1
Login to vote

I'll look around and fine

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

virusdefender's picture
26
Aug
2009
1 Vote +1
Login to vote

The database schema seems to

The database schema seems to have some information.

hemu's picture
26
Aug
2009
1 Vote +1
Login to vote

i can provied us the VBS

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

Things are EASY with File Sharing....... It makes easy for Viruses also...!!

Symantec SEP11 STS
Symantec SNAC 11 STS

virusdefender's picture
26
Aug
2009
1 Vote +1
Login to vote

script sounds good

sounds good, will do.

hemu's picture
26
Aug
2009
0 Votes 0
Login to vote

this script will move clients

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

Things are EASY with File Sharing....... It makes easy for Viruses also...!!

Symantec SEP11 STS
Symantec SNAC 11 STS

virusdefender's picture
27
Aug
2009
1 Vote +1
Login to vote

close but I need to create groups

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.

hemu's picture
27
Aug
2009
0 Votes 0
Login to vote

hii i have script to creat a

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

Things are EASY with File Sharing....... It makes easy for Viruses also...!!

Symantec SEP11 STS
Symantec SNAC 11 STS

hemu's picture
27
Aug
2009
1 Vote +1
Login to vote

that is realy safe i can

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

Things are EASY with File Sharing....... It makes easy for Viruses also...!!

Symantec SEP11 STS
Symantec SNAC 11 STS

hemu's picture
28
Aug
2009
0 Votes 0
Login to vote

hii how can i share script

hii

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

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

Things are EASY with File Sharing....... It makes easy for Viruses also...!!

Symantec SEP11 STS
Symantec SNAC 11 STS

MrKaye's picture
19
Nov
2009
0 Votes 0
Login to vote

 Hi! I am trying to script

 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 :-)

 

attila's picture
01
Feb
2010
0 Votes 0
Login to vote

 Hi,I am trying to write

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

zer0's picture
02
Feb
2010
0 Votes 0
Login to vote

Why do you guys need so many

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 :)

attila's picture
03
Feb
2010
0 Votes 0
Login to vote

I want to develop a internal

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