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

[EN6924]

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.

[fmvizcaino · Accepted 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

[EN6924]

Thanks.

I've checked it -

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

[EN6924]

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.

[fmvizcaino · Accepted solution]

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