Hi,
I have multple reports on the report server. For some of the reports, we have schedules to automatically send mails with the reports. However, for some of the reports, I'm not able to see the schedule, even though I know it's there.
I went to the database and executed this query:
SELECT dbo.catalog.[Path],
dbo.catalog.Name,
s.Description,
u.UserName,
s.DeliveryExtension
FROM catalog with (nolock)
JOIN dbo.Subscriptions s with (nolock)
ON s.Report_OID = dbo.Catalog.ItemID
JOIN dbo.Users u WITH (nolock)
ON u.UserID = s.OwnerID
ORDER BY dbo.catalog.[Path],s.Description
With this query, I am able to see the reports I'm looking for. Within the results I also see the schedules that I can see on the report server. All subscriptions have the same owner (u.username).
Why can't I see a lot of the subscriptions on the report server site?