Does deleting users require a SQL query?
Because we are unable to use the Active Directory sync functionality I am working on a routine to delete selected users from our asset database.
My original thought was to update the users department to Flagged for Deletion and then have a CMDB rule take care of the actual deletion on a scheduled basis.
It appears from the documentation that a deletion of this type would require a SQL query.
Can you help with -:
1-Deletion confirmation. Do I have to use SQL? I realize that I could manipulate the data via a import/export but I am looking for a long term solution.Does someone know a way to have the CMDB do this?
2-If I delete using SQL do I need to remove the user from all the tables or will a database clean up take care of removing the linked entries?