PureConnect

 View Only
Discussion Thread View
  • 1.  Users' email address

    Posted 01-25-2021 17:09
    When creating a new user in IA, there is a 'Internet' tab on the 'Personal Info' tab with email addresses.  How can that data easily be retrieved?  I don't see that data in the backend DB anywhere. I have previously exported all the data from Interaction Administrator, but would prefer no to go that route. When working in the office it's a 5 to 10 minute process, but with telecommuting due to pandemic, it takes closer to 2 hours.

    Thanks for any help.​
    #ArchitectureandDesign

    ------------------------------
    Kenn Lambing
    OHIOHEALTH
    ------------------------------


  • 2.  RE: Users' email address

    Posted 01-25-2021 18:34
    That should be visible in directory services (handlers DS tools or dseditu directly from the server).  You can also pull this back from the user configuration api endpoint for ICWS.

    ------------------------------
    Aaron Lael
    State of Utah
    ------------------------------



  • 3.  RE: Users' email address

    Posted 01-26-2021 11:54
    If all you is need is Name and Email and have the [IAAttributeLog] turned on you can using this query

    SELECT DISTINCT
    [EnhancedIAChangeLogId]
    ,[AttributeName]
    ,[PreviousValue]
    ,[NewValue]
    FROM [dbo].[IAAttributeLog] IAAL

    WHERE [AttributeName] = 'emailAddress'
    OR AttributeName ='displayName'


    ORDER BY [EnhancedIAChangeLogId] ASC

    ------------------------------
    Brad Goff
    Palo Alto Networks, Inc.
    ------------------------------



Need Help finding something?

Check out the Genesys Knowledge Network - your all-in-one access point for Genesys resources