SQL query to remove delete group from sepm
For one group only?
The recommended and preferred way is to go thru the SEPM so that you don't risk DB corruption.
I Agree Brian,It's will be Impact your Database.
If you want to SQL Query Check Landon Manning Comments on this thread.
https://www-secure.symantec.com/connect/forums/how-enumerate-deleted-groups-sql-database#comment-3550311
its better to do from SEPM console, as you need to make sure the clients are moved to other group.
Deleting group from SEPM does not get delted from SQL DB
it will not be deleted immediately .,It will be done when next DB cleanup occurs.
Yes, in the next database cleanup it should go away if it's been deleted from SQL DB.
Hello,
You may like to check these Threads with similar query:
https://www-secure.symantec.com/connect/forums/sql-querys-database
https://www-secure.symantec.com/connect/forums/sql-query-duplicate-computers-sepm
https://www-secure.symantec.com/connect/forums/duplicate-client-sepm-hardware-id-problem
https://www-secure.symantec.com/connect/forums/how-come-i-got-duplicated-sep-client-my-sepm-database
https://www-secure.symantec.com/connect/forums/what-sql-script-query-sem5-database-find-duplicate-sep-client
Hope that helps!!
Why the SEPM Console does not meet your needs?
HI,
You can do a manual cleanup to get it cleaned from either SEPM console or from the DB side.
Regards
Ajin
Hi
You can delete the entry from SEPM