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?
Linda
Comments 1 Comment • Jump to latest comment
Although you can use Altiris without SQL knowledge I would highly recommend learning SQL. In the example below I define how to use a spreadsheet. You can use the same concept using a SQL statement querying all the users excluding the ones you flagged for deletion.
Today, how are your users being populated into Altiris? If they are coming from another database depending on how the results are defined we could automate the process.
Another thought, is if you have Symantec workflow we could change the entire game. This could handle the entire HR employee termination process.
Really it boils down to what your company decides.
Basic Steps to remove users
Please test the rule before running it.
Would you like to reply?
Login or Register to post your comment.