How to find the List of users to know who Upload the package with version details?
Issue: Need to Validate the List of users Upload the package with the version details to Query.
Query:
SELECT pf.Name ,
T.Name ,
PM.Identifier As PackageName,
DU.Name as Username,
DU.Surname ,
PD.Version
FROM [dbo].[PackageMetadata] PM ,
[dbo].[PackageDefinitions] PD ,
[dbo].[Users] DU,
[dbo].[PackageFeeds] pf,
[dbo].[Tenants] T
where pd.Identifier = PM.Identifier
and PD.CreatorUserId = DU.ID
AND PD.CreatorUserId = pM.CreatorUserId
AND pm.FeedId = PF.Id
and t.Id = pf.TenantId
and pf.TenantId = pm.TenantId
and PM.IsDeleted = 0
Query Result:
Note: Query is version specific and may need change for next version updates.