Hi, Thanks for your reply.

I'm sure you're right that a report could be built to show the subscription details of a report or all reports, but could this be tied into the administration side of the subscriptions? ie allow users to identify their different subscriptions easily, so they can then chose the ones they want to administer?

Could the said report be used in place of the existing subscriptions page, but still allowing drill through(!), or could the standard report allow a hyperlink or drill through to the subscription editing details (again “!”).

Do you see the point, it's less about viewing the subscription list and more about identifying which subscription you want to edit if you have multiples with the same email name and run dates.

Any additional thoughts?

Thanks again.

David

ps. the below code shows the location for the subscription data.

Lifted from a posted script, apologies to the original poster, I cannot remember the source:

use reportserver

go

select

cat.Name,

u.username 'Report Author',

replace(S.[DeliveryExtension],'report server ','') 'Type',

S.[ExtensionSettings],

Parameters,

Modified.[UserName] 'Subscription Modifier/Creator',

S.[ModifiedDate],

replace(S.[Description],'send e-mail to ','') 'Distribution List',

S.[LastStatus],

CAT.[Path],

S.[LastRunTime]

from

[Subscriptions] S

inner join [Catalog] CAT on S.[Report_OID] = CAT.[ItemID]

inner join [Users] Owner on S.OwnerID = Owner.UserID

inner join [Users] Modified on S.ModifiedByID = Modified.UserID

inner join users u on cat.createdbyid = u.userid

left outer join [SecData] SD on CAT.PolicyID = SD.PolicyID AND SD.AuthType = 1

left outer join [ActiveSubscriptions] A with (NOLOCK) on S.[SubscriptionID] = A.[SubscriptionID]

where S.[LastStatus] not LIKE '%was written%' and S.[LastStatus] not LIKE '%mail sent%' and S.[LastStatus] not LIKE '%New Subscription%' and S.[LastStatus] not LIKE '%been saved%'

Order by s.lastruntime desc