IBM Verify

IBM Verify

Join this online user group to communicate across Security product users and IBM experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
  • 1.  Massive Account Matching upload

    Posted 12/18/20 03:28 PM

    Dear Expert,

    do you know if there is a way to massively match account based on a spreadsheet? We probably have more than 200 accounts to be matched with different identities, and we would like to how that can be performed.

    Many thanks



    #Support
    #SupportMigration
    #Verify


  • 2.  RE: Massive Account Matching upload

    Posted 12/19/20 03:24 PM

    Take a look at the AGC->Tools Bulk Load "Insert User Account Attributes" and documented inthe KC:

    https://www.ibm.com/support/knowledgecenter/SSGHJR_5.2.4/com.ibm.igi.doc/CrossIdeas_Topics/AGC/AGCore_Insert_User_Account_Attributes_Record_Track.html

    You need the Account Configuration, IGI User (Master UID), the Account Name, and Default Account status. I believe, that this will match an unmatched account to a user. But test this out, on one or two accounts in a lower environment. I would normally try this out before posting, but my lab is down for a few days. So make sure this does not clobber any of the existing account attributes.



    #Support
    #SupportMigration
    #Verify


  • 3.  RE: Massive Account Matching upload

    Posted 12/21/20 08:18 AM

    Dear dkuehrmc,

    many thank from your answer. I tried your suggestion, but the system is showing me the following error message within the log:

    [ERROR] LINE: 1 - Cannot valorize account attributes for account configuration DOMINO_LN

    I tried several times but always same message, do you have any further suggestion?

    Many thanks again



    #Support
    #SupportMigration
    #Verify


  • 4.  RE: Massive Account Matching upload

    Posted 12/21/20 05:18 PM

    Can you post the header line and one line of data from the spreadsheet. Please anonymize any personally identifiable information from the record. I can take a look while i am on holiday.



    #Support
    #SupportMigration
    #Verify


  • 5.  RE: Massive Account Matching upload

    Posted 12/22/20 08:06 AM

    Yes sure, here the first 2 lines:


    ACCOUNT_CONFIGURATION_NAME MASTER_UID ACCOUNT_ID FIRST_NAME LAST_NAME PASSWORD IS_DEFAULT ACCOUNT_TYPE_NAME ACCOUNT_TYPE_DESCRIPTION EMAIL EXPIRATION_DATE DISPLAY_NAME DN LAST_LOGIN LAST_LOGIN_ERROR NUMBER_LOGIN_ERRORS LAST_PASSWORD_CHANGE
    DOMINO LN 139415 John.Smith


    I directly used the template file: Insert+User+Account+Attributes.xls


    Thanks again.




    #Support
    #SupportMigration
    #Verify