In SQL Server Reporting Services (SSRS), the information about the report author is typically stored in the ReportServer database. You can retrieve the report author by querying the relevant tables in the ReportServer database. Here's a simple SQL query to get the report author from SSRS:
```sql
USE ReportServer;
SELECT
C.Path AS ReportPath,
C.Name AS ReportName,
C.CreationDate AS ReportCreationDate,
U.UserName AS ReportAuthor
FROM
Catalog AS C
INNER JOIN Users AS U ON C.CreatedByID = U.UserID
WHERE
C.Type = 2; -- Type 2 corresponds to reports in SSRS
-- Optionally, you can add more conditions to filter the results based on your requirements.
```
.png)
