use ReportServer
go

SELECT u.UserName, c.CreationDate, c.Name, c.[Path]
  FROM dbo.[Catalog] c
  left join dbo.Users u on u.UserID = c.CreatedByID
  

use ReportServer
go

SELECT u.UserName, c.CreationDate, c.Name, c.[Path]
  FROM dbo.[Catalog] c
  left join dbo.Users u on u.UserID = c.CreatedByID
where c.CreationDate >= CAST(CAST(DATEADD(DD, -1, GETDATE()) AS DATE) AS DATETIME)