topic Re: Display the workflow names from Gallery with their latest uploaded/published (datetime in Alteryx Server Discussions

Display the workflow names from Gallery with their latest uploaded/published (datetime)

EN6924 — Tue, 04 Apr 2023 12:00:42 GMT

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?

As per Alteryx Gallery, Published date for a workflow named - "UAT server annualised audit report" is showing - Mar 07, 2023, 05:46 PM

But from Alteryx Designer, MongoDB tool, the date is same, but the time is showing different.

From Alteryx Server Usage report, it displays - Scheduled date, Started date & Completion date; but we don't see uploaded date, published date.

Please help.

Re: Display the workflow names from Gallery with their latest uploaded/published (datetime

fmvizcaino — Tue, 04 Apr 2023 14:11:09 GMT

Hey @EN6924 ,

Could it be a timezone conversion issue? The Upload Date column from AppInfo collection is in UTC format.

Best regards,

Fernando Vizcaino

Re: Display the workflow names from Gallery with their latest uploaded/published (datetime

EN6924 — Wed, 05 Apr 2023 07:51:41 GMT

Thanks.

I've checked it -

Now I'll have to apply a formula to convert UTC to IST.

Re: Display the workflow names from Gallery with their latest uploaded/published (datetime

EN6924 — Wed, 05 Apr 2023 07:55:16 GMT

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.

Re: Display the workflow names from Gallery with their latest uploaded/published (datetime

fmvizcaino — Wed, 05 Apr 2023 15:11:48 GMT

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