Database Reference
In-Depth Information
P.PerformanceRuleInstanceRowId =
PRI.PerformanceRuleInstanceRowId
INNER JOIN vPerformanceRule PR ON
PRI.RuleRowId = PR.RuleRowId
INNER JOIN vRule R ON
PRI.RuleRowId = R.RuleRowId
Next, we need to grant permissions for the
OpsMgrReader
database role to the newly
created view. This can be done by executing the following query:
USE OperationsManagerDW
GO
GRANT SELECT ON v_Custom_r_PerformanceDataDaily TO
OpsMgrReader
GO
Tip
You need to make sure that the users who access the
OperationsManagerDW
database
from Microsoft Excel are members of the
OpsMgrReader
database role.
It is recommended that you create an Active Directory group and add this group as a login
to SQL Server. Add all users to whom you want to grant access to the data to this Active
Directory group. Then, add the login as a user to the
OperationsManagerDW
database
and assign it to the
OpsMgrReader
database role.
Perform the following steps:
1. Start Microsoft Excel and open a blank workbook.
2. On the
Data
ribbon, in the
Get External Data
area, click on
From Other
Sources
and then choose
From SQL Server
.
3. In the
Server name
field, enter the name of the SQL Server that hosts the
Oper-
ationsManagerDW
database, select
Use Windows Authentication
, and then
click on
Next
.
4. Select the
OperationsManagerDW
database, click on the
v_Custom_r_PerformanceDataDaily
view, and then click on
Finish
.
5. On the
Import Data
dialog, select
PivotChart
and then click on
OK
.