Hi All,
I'm a gallery admin and I want to export a list of workflows that are saved within the gallery with their published date, is this possible?
From Alteryx Server Usage report, it displays - Scheduled date, Started date & Completion date; but we don't see uploaded date, published date.
Please help.
Solved! Go to Solution.
Hey @EN6924 ,
Could it be a timezone conversion issue? The Upload Date column from AppInfo collection is in UTC format.
Best regards,
Fernando Vizcaino
Thanks.
I've checked it -
Now I'll have to apply a formula to convert UTC to IST.
Hi,
Please help in another thing if you know -
The 'CreatedBy' column shows the subscription ID of the user who published the workflow to the Gallery. How can I fetch the Firstname & LastName of the user associated to the IDs and which dataset I'll have to import in case of joining required.
Hey @EN6924 ,
The CreatedBy column from the AppInfos collection shows the AuthorID/Owner of the workflow. To merge with the users info, you should use the column _id from the Users collection.
I highly suggest adapting the Usage Report rather than creating all the connections between the collections.
Best regards,
Fernando Vizcaino