Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Report Manager's Subscriptions Page column/field view Expand / Collapse
Author
Message
Posted Thursday, July 22, 2010 7:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, December 6, 2013 5:47 AM
Points: 120, Visits: 243
Hi

Does anyone know if you can configure the Subscriptions page of a Report Manager report, to add additional fields to it, such as the email subject line.

The reason is I have a report with several dozen subscriptions set up by multiple users, and the standard view of Description (which for emails is just the email address it is being sent to), and then just the run time and status, is not enough for users to be able to identify the difference between their groups of subscriptions.

If it was configurable to be able to add in the email subject line, this would help.

Possible?

Thanks
David
Post #957162
Posted Friday, July 23, 2010 8:00 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:41 AM
Points: 2,818, Visits: 2,553
I don't think so, but I am not positive. However, I think you have a great idea.

I couldn't build this without a fair amount of research, but I am reasonably sure you could build a report based on the report server db that could have the columns you want.
Post #957978
Posted Friday, July 23, 2010 8:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, December 6, 2013 5:47 AM
Points: 120, Visits: 243
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

Post #957998
Posted Wednesday, July 28, 2010 1:27 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 20, 2012 8:52 AM
Points: 12, Visits: 26
Hi,

Did you find any solution about the email subject line?

Thanks
Post #960327
Posted Wednesday, July 28, 2010 2:51 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:41 AM
Points: 2,818, Visits: 2,553
The only suggesion I have regarding Report Manager is the My Subscriptions link at the upper right. I believe that will limit the subscriptions to the user, but it may be that they had to set up the subscription for themselves in the first place. I'm not sure.

Other than that it sounds more like some custom ASP.NET or a simple app front end. Either way you are looking at some custom work.
Post #960361
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse