USE ReportServer

SELECT C.ItemID As IdElemento
	  ,C.[Name] As Nome
      ,C.[Path] As Percorso
      ,C.[Description] As Descrizione
      ,CASE C.Hidden
		WHEN 0 THEN 'No'
		WHEN 1 THEN 'Sė'
	   END As Nascosto
      ,UC.Username As 'Pubblicato da'
      ,C.CreationDate AS 'Data pubblicazione'
      ,UM.Username As 'Modificato da'
      ,C.ModifiedDate As 'Data Modifica'
      ,REPLACE(
		REPLACE(
			CAST(
				CAST(Parameter As xml).query('Parameters/Parameter/Name') 
					As nvarchar(1000))
		,'<Name>', '')
	   ,'</Name>', '; ') As Parametri

	  ,EL.TimeEnd As 'Ultima esecuzione'
	  ,DATEDIFF(second, EL.TimeStart, EL.TimeEnd) As 'Tempo esecuzione (secondi)'
	  ,EL.Status As Esito
	  ,EL.Username As Utente

FROM ReportServer.dbo.Catalog C
INNER JOIN dbo.Users UC
	ON UC.UserId = C.CreatedByID
INNER JOIN dbo.Users UM
	ON UM.UserId = C.ModifiedByID
LEFT JOIN dbo.ExecutionLog EL
	ON EL.ReportId = C.ItemId
	AND EL.TimeEnd = (SELECT MAX(TimeEnd) FROM dbo.ExecutionLog EL1 WHERE EL1.ReportId = EL.ReportId)

/* Visualizzo solo i reports */
WHERE Type = 2

ORDER BY Percorso, Nome