Trying to make custom gallery usage report, am I hitting the right tables?

csh8428 — Thu, 17 Feb 2022 13:52:37 GMT

I'm trying to make a basic report on our gallery usage. The only info I need is workflow name, the owner, the original date of upload, the deletion date.

In a nutshell I want to measure

Be able to create a SQL Server history table so I can measure it over time(this is why I need the upload and deletion date)
How many workflows are there currently?
How many workflows each user uploaded in total
How many workflows each user currently has

I connected to Alteryx Gallery.appinfos to get the workflow info.

I connected to Alteryx Gallery.users to get the owner info and join users.Revisions.0.AuthorId to users.User_ID

That all seemed to work.

Here are my questions

In order to get an understanding for the data structure I saved a workflow to the gallery, but when I queried AppInfos a couple minutes later, the workflow wasn't in the dataset. Why would it be missing?
If a workflow is deleted, am I correct in assuming the AppInfos.Revisions.0.DateCreated field for that row where AppInfos.IsDeleted = True is the date the workflow was deleted?

topic Re: Trying to make custom gallery usage report, am I hitting the right tables? in Alteryx Server Discussions

Trying to make custom gallery usage report, am I hitting the right tables?

Re: Trying to make custom gallery usage report, am I hitting the right tables?