Database Reference
In-Depth Information
Click on
Close
after completing all three view selections, as shown in this screen-
shot:
5. In the middle pane of MSSMS, ensure that you can see the three views (you may
have to drag the objects and resize the windows). Click and hold the
ServerName
column from the
vw_DPM_Agents(dbo)
view, and drag it onto the
Produc-
tionServerName
column in the
vw_DPM_ProtectedDataSource
view.
6. Click and hold the
ProtectedGroupId
column from the
vw_DPM_ProtectedDataSource
view, and drag it onto the
ProtectedGroupId
column in the
vw_DPM_ProtectedGroup
view, as shown in the following
screenshot:
7. Check the column names from the three views, as follows:
◦
VW_DPM_Agent(dbo)
:
ServerName
and
Version
◦
vw_DPM_ProtectedDataSource (dbo)
:
UsedSize
,
AllocatedSize
, and
StorageNode
◦
vw_DPM_ProtectedGroup (dbo)
:
ProtectedGroupName
8. In the middle pane, in the
Alias
column, type
Assigned_DPMServer
next to
the
StorageNode
column, as shown in this screenshot: