Delete SM default contact and operators from Database
I want to delete SM's default contact and operators from database. I can't use mass delete option from SM because there are users (like system.admin, ldapoperator, falcon and few more) which I dont want to delete. And deleting the users one by one from SM would be a time consuming effort. I can run a delete query in the database by not including those users.
Can you guys please recommend me what would be the better option to delete the defualt operators and contacts without deleting a few.
Re: Delete SM default contact and operators from Database
Thanks for your response. I have around 50+ users that donot required deletion. So I didnt use expert search.
The default contacts in the SM Contact table has IDs starting with "advantage".
So deleted the contacts from the database by using the userid condition. Worked.
There's another table CONTCTSA1, Somehow I dont know how to delete the records. Cos it has only 3 columns, and two of it contains the same value for all the contacts. Would it affect the CONTCTSM1 table if I delete all the contacts from CONTCTSA1 table. Whats the use of CONTCTSA1 table?
I never knew about the expert search. Thanks for making me know about it. May come handy in future.