Delete SM default contact and operators from Database (219 Views)
Reply
Trusted Contributor
SanjeevDas
Posts: 385
Registered: ‎06-17-2013
Message 1 of 3 (219 Views)
Accepted Solution

Delete SM default contact and operators from Database

Hi Experts,

 

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.

 

Thanks and regards,

Sanjeev

Honored Contributor
Vadim Gorda
Posts: 5,781
Registered: ‎11-10-2008
Message 2 of 3 (205 Views)

Re: Delete SM default contact and operators from Database

Hello,

have you tryed with expert search? Write there exclusion for few contacts which you dont want to delete:

 

contact.name~="FALCON,JENIFER" and contact.name~= ...... and it will find for you all contacts except the listed one.

 

After that you can mass delete them.

 

There is option in menu which purges demo data from the system, but don't remember if it is deleting contacts.

 

 

Trusted Contributor
SanjeevDas
Posts: 385
Registered: ‎06-17-2013
Message 3 of 3 (175 Views)

Re: Delete SM default contact and operators from Database

Hi Vadim,

 

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.

 

Thanks and Best Regards,

Sanjeev

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.