Asset Management Suite

 View Only
  • 1.  Does deleting users require a SQL query?

    Posted Aug 10, 2012 07:56 AM

    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



  • 2.  RE: Does deleting users require a SQL query?

    Posted Aug 10, 2012 10:29 AM

    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. 

    1. User flagged as Terminated.
    2. Store custom data ( if required )
    3. Assets identified
    4. Confirm asset collection.
    5. Disabled AD account
    6. Either flag in Altiris or delete resource.

    Really it boils down to what your company decides.

     

    Basic Steps to remove users

    1. Create a spreadsheet of all the Users you want to remain in in Altiris.
    2. Under connectors create a new data source that links to the spreadsheet.
    3. Create a new import rule that will review the users in the spreadsheet and remove the missing items.

     

     Please test the rule before running it.