Publishing and Subscribing to Service Manager Reports

re: Publishing and Subscribing to Service Manager Reports

Travis Wright MSFT — Sat, 23 Apr 2011 12:22:29 GMT

@Vish -

When you run a report in the Service Manager console you can set a *relative* date/time. In this case you would want to choose the last week. Then save that configuration as a linked report and then schedule that linked report.

re: Publishing and Subscribing to Service Manager Reports

Vish — Sat, 23 Apr 2011 08:07:37 GMT

Hi,

I would like to created a scheduled report for Incidents Management which shows the number of incidents logged weekly. The problem I am having is how to set the date values within new subsriptions as this will change depending on the week it will run. I wouldlike this report to run weekly and therefore the date value to reflect this.

Please can you advise,

Thanks,

Vish

re: Publishing and Subscribing to Service Manager Reports

refurbished computers cheap — Mon, 18 Apr 2011 11:31:27 GMT

Indeed a very good read! Very informative post with pretty good insight on all aspects of the topic! Will keep visiting in future too!

re: Publishing and Subscribing to Service Manager Reports

refurbish used computer — Thu, 17 Feb 2011 07:14:52 GMT

The blog provides helpful information regarding the topic and it also gives a vast knowledge as well which helps us in our studies and in practical life.

re: Publishing and Subscribing to Service Manager Reports

Travis Wright MSFT — Thu, 03 Feb 2011 18:37:31 GMT

@Clusterpuppy

Re #1 - In the SCSM console... click the Data Warehouse workspace button. Navigate to the User Roles view. Open the Report User user role and add the users or user groups in there.

Re #2 - see SQL RS documentation on security:

msdn.microsoft.com/.../aa274428(SQL.80).aspx

re: Publishing and Subscribing to Service Manager Reports

Hi Travis — Thu, 03 Feb 2011 18:32:40 GMT

I guess I am too dense to understand...

I look on the DWDB and cannot determine how to add users to the report users role, nor can I figure out how to "grant access to reports via SQL Reporting Services security model to be able to access reports either through the browser (pointed at the SQL Reporting Services web UI) or the SCSM console."

The only way I have been able to grant access is by adding a user to the the SCSM Admins security group.

If you can clarify I would appreciate it.

Clusterpuppy

[REG:210110378822157001]

re: Publishing and Subscribing to Service Manager Reports

Travis Wright MSFT — Thu, 03 Feb 2011 15:09:50 GMT

@Clusterpuppy -

A couple of things:

1) If you want users to be able to access reports they need to (a) be a member of the Report Users user role which you can find in the Data Warehouse User Roles view and (b) need to have permissions according to #2 below.

2) Users must be granted access to reports via SQL Reporting Services security model to be able to acces reports either through the browser (pointed at the SQL Reporting Services web UI) or the SCSM console.

re: Publishing and Subscribing to Service Manager Reports

Clusterpuppy — Thu, 03 Feb 2011 13:49:38 GMT

How do you set permissions for the users? Especially in Multi-domain environment.