Software Metering Console View – Part 6

Today is the last up date to this series of blog posts. First let summarize what we have done.

We created the basic software metering console query
http://smsug.ca/blogs/garth_jones/archive/2007/02/27/178.aspx

Then we updated the column headers
http://smsug.ca/blogs/garth_jones/archive/2007/02/28/179.aspx

Add a case statement
http://smsug.ca/blogs/garth_jones/archive/2007/03/01/180.aspx

Create a SQL function
http://smsug.ca/blogs/garth_jones/archive/2007/03/02/191.aspx

Create a SQL Table
http://smsug.ca/blogs/garth_jones/archive/2007/03/03/193.aspx

In order to use either the SQL function or the SQL table you need to set permissions on the object so that they will work within SMS Web reports.

First let talk about the SQL Function:
SMS Web reporting uses stored procedure (SP) for each web report that you create, in order to use these SP via the web console SMS set the appropriate permission on the SP to allow them to be executed. Since we are setup function outside of the SMS console we must setup the permission ourselves.

Manually apply permissions from the SQL console:
Right click the object | Properties | permissions
Select the webreport_approle and click the EXEC check box.

 

sw6

With in Query Analyzer:

GRANT EXECUTE ON LANG TO [webreport_approle]

sw6b

Now for the Table

Manually apply permissions from the SQL console:
Right click the object | Properties | permissions
Select the webreport_approle and click the SELECT check box.
Select the smsschm_users and click the SELECT check box.

 

sw6c

With in Query Analyzer:
GRANT Select ON Language TO [webreport_approle]
GRANT Select ON Language TO [smsschm_users]

 

sw6c

We have now covered off the basics of how to expand your SMS / SCOM web report environment. There is a lot more that you can do, once you become proficient at SQL queries and have a very good understanding of the data within the SMS database.

 

Leave a Reply

Your email address will not be published. Required fields are marked *