3 of 4 people found this helpful
It is not easy to delete records directly from the DB. You can directly delete "Non Support" users from CTM:People form. You need to set status of these profiles to "Deleted" and then have some workflow to delete those records using "Application-Delete-Entry".
In case of Support Staff users, It is bit tricky because there might be some tickets assigned to them so first you need to identify those tickets and assign them to some other users then convert them to "non support staff" , set status to "deleted" and then delete them. This is a recommended way.
Still if you want to perform delete operation through DB then here are some queries: Please note, It won't delete associated records from backend forms like (Peple Permissions, support group association etc etc)
Get the schemaid of the form
SELECT name, schemaid FROM aradmin.arschema WHERE name ='CTM:People'
SEARCH THE RECORDS/OR GET A COUNT (suppose schemaid is 928)
SELECT * FROM aradmin.t928 where 'your qualification'
SELECT * FROM aradmin.H928 where 'your qualification'
SELECT * FROM aradmin.B928 where 'your qualification'
Delete from aradmin.T928 where 'your qualification'
Delete from aradmin.H928 where 'your qualification'
Delete from aradmin.B928 where 'your qualification'
1 of 1 people found this helpful
The link still worked for me....here is an updated one for 19.11
Thanks LJ, the link didn't work for me. I got a "Forbidden" page reference to it when I clicked on it.
What I was looking for, information in 9.1.x + that depicted the processes that happen when a People Record is set to "Delete". That is what trickle down happen to all associations of the People record. Tickets (CHG, PBI, INC,ASSET, etc, Associations, User Record, Orphan Records etc.).
From that you probably can surmise what I'm after.