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?
