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.
------------------------------
Original Message:
Sent: 01-25-2021 17:08
From: Kenn Lambing
Subject: Users' email address
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
------------------------------