Export Maven feed metadata from ProGet

ExportMavenFeed.sql

DECLARE @Feed_Id INT = <FEED ID>

SELECT [@Group] = M.[GroupId_Text],
       [@Id] = M.[ArtifactId_Text],
       [@Name] = M.[Name_Text],
       [@Description] = M.[Description_Text],
       [@Release] = M.[ReleaseVersion_Text],
       [@Latest] = [LatestVersion_Text],
	     (SELECT [@Version] = F.[Version_Text],
               [@Type] = F.[File_Type],
               [@SHA1] = F.[File_SHA1_Bytes],
               [@MD5] = F.[File_MD5_Bytes],
               [@Size] = F.[File_Size],
               [@Updated] = F.[Updated_Date],
               [@Cached] = F.[Cached_Indicator],
               [@Downloads] = F.[Download_Count],
               [@Downloaded] = F.[LastDownloaded_Date],
               [@FileName] = F.[FileName_Text]
          FROM [MavenArtifactFiles] F
         WHERE F.[MavenArtifact_Id] = M.[MavenArtifact_Id]
           FOR XML PATH('Version'), TYPE)
  FROM [MavenArtifacts] M
 WHERE [Feed_Id] = @Feed_Id
 FOR XML PATH('Package')