Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

New database - Encryption

Created: 20 Sep 2013 | 6 comments
LukasM's picture

Hi everyone!

I need to create a new database for my Encryption Console, and I need to know how to do it if it possible. 

Thx to all!

Operating Systems:

Comments 6 CommentsJump to latest comment

SMLatCST's picture

Hi LukasM

Can you elaborate on what you want to do?  Is this the precreation of a custom DB in preperation of the SEE installation?

IIRC, there's no article describing how to do this.  That said, the files and filegroups of the SEEMSDb just use the default/basic structure.  Don't forget to make sure you size it correctly though:
http://www.symantec.com/docs/TECH148192

If, however, you're just moving the DB, then the below article should help:

http://www.symantec.com/docs/HOWTO83927

LukasM's picture

Hi SMLatCST 

My objective is to clean up my database, there are to many machines that do not supposed to be in there. I thought in create a new DB for my actual encryption console.

Hope this help :)

SMLatCST's picture

Short of restoring to an earlier backup of your SEEMSDb, or reinstalling outright, I don't think there's another supported method of going back to a clean DB (as I mentioned, there aren't any articles for precreating teh DB).

It's entirely possible to bulk delete clients from the SEE Manager Console.  Is this not working for you?

LukasM's picture

We have machines on the report list that does not reported to the console since 2011. Something is wrong, and for this we need to start over.

Do you have any suggestion? 

SMLatCST's picture

It's possible to sort by "Last check-in", are you in a position to just bulk delete those that have not checked in recently?

It's worth notiing this only works for machines being managed natively by SEE (i.e. those not part of the domain).  To delete domain-managed SEE clients, please follow the below article:

http://www.symantec.com/docs/TECH92374

rrt1966's picture

We had a similar need so I wrote this script (actually modified on something that Symantec Engineerng originally sent me).  

Rename the attached script from .TXT extension back to .SQL.  Please advise if it works for you.   

It will do 2 things: purge any records already marked for deletion in the database and delete any records older than 90 days (our lockout policy is set to 45 days so anything older than 90 days would be safe to delete).

Regards,

Roland

AttachmentSize
seemsdb-cleanup.txt 4.33 KB