Dell PowerVault DP600 - Manual (Page 146)

146
Attribute Value
rangeUpper 260
isSingleValued TRUE
showInAdvancedViewOnly TRUE
adminDisplayName ms-ProductionSrv-Share
adminDescription Identifies a computer with shared resources.
oMSyntax 64
IDAPDisplayName ms-productionSrvShare
objectCategory CN=Attribute-Schema,
Appendix C: Custom Report Views
Data Protection Manager 2007 includes several SQL views to help you create custom reports.
SQL views simplify your queries by populating columns with data collected from multiple tables in
the database. These views offer several advantages over querying the tables directly:
• You do not need in-depth knowledge of the entire database or the relationship between
tables and keys.
• If the database structure changes in future versions of the product, the views can be updated
so that they behave the same.
For DPM installations that use a separate, dedicated computer for the SQL Server database, the
views are queried on the database computer, not the computer running DPM. This results in less
competition for resources when large numbers of views are queried over a short period of time.
The potential disadvantages of the SQL views include the following:
• Because the view runs each time it is queried, server performance may be degraded if the
view is used too frequently.
• The available supported views might not include all of the columns you need.
This appendix lists the views available in DPM 2007.
Vw_DPM_Agents: Contains the list of computers on which a DPM protection agent from this
DPM server has been installed.
Field Data type Description
ServerName String The name of the computer
Version String The version of the DPM agent