This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 57.00000000000001%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH0%3C/text%3E%3C/svg%3E)
Hi,
I need assistance. I am using Azure Data Factory activity for data migration from source to destination. Next, we also need to log the user running these Azure Data Factory pipelines, such as the get portal.azure.com login from azure function, and pass output of azure function to the Azure Data Factory pipeline stored procedure activity and log in to the target database.
At the workflow activity level, I don't see the option to get the portal login username or email id. So I decided to use an Azure function to get the portal username, pass it to the Pipelines activity, and log it to the target log table. But below azure function code return nothing as output.
Can you please suggest if there is anything i am missing in below code to get user or is there any other way to get user information in pipelines activities?
Thanks
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Try any custom functionality, you are capturing the context of Azure function app , look for Log activity on ADF.
I don't see any log activity in Azure Data Factory pipeline. do you have any reference or not sure as new to ADF
Hi Please check this forum:
https://stackoverflow.com/questions/66678256/find-who-triggered-azure-data-factory-pipeline-adf
So there is no other way to get it in pipeline activity level and can only check in log activity?
Yeah, looks like there is no direct way to access the user's email or login name within the pipeline activity level. use log activity or use Azure Monitor logs for more details! We can request Microsoft for enabling this feature!!!!
By default, any activity on your ADF is already logged by Azure. Its the auditing feature of Azure - which will log any activity happening on your resource (in this case ADF). It will give you information such as the datetime stamp of activity, what was the activity & who initiated the activity. Why do you need to store it separately? What is the requirement? What are you trying to do?
Thanks for update!
I need to generate report on what data moved with status and who executed pipelines. so data and other information i am already extracting from database and sending email notification but not seeing anyway to log user details in database which is key identifier to escalate if something went wrong if pipelines.
0
You can use the Activity Logs REST API : Activity Logs – List to get the User ID details.
MSFT docs : https://learn.microsoft.com/en-us/rest/api/monitor/activity-logs/list?tabs=HTTP
You can use web activity to trigger the REST API
refer the below blog for additional details:
Thanks for detailed steps. will follow this direction.