Topics | How To
The SRM Views provide a way to query information on the SRM components directly from the SQL database. These views are provided in addition to the SRM Reports.
You can use these default views, or you can create or customize the existing views to reflect the data in your organization. The views are created by querying the database. These query are by default displayed in SQL Enterprise Manager. You can also use products such as Crystal Reports, Microsoft Reporting Services and/or Microsoft Excel to format your query output.
If you modify a view or create a new view, you must reapply them after each new release.
The following views are available in the SRM:
The CommCellSRMEnterpriseFileSystemUsageDistribution view provides information about File System Usage Distribution.
The following image displays a sample CommCellSRMEnterpriseFileSystemUsageDistribution view:
| Column | Description |
| categoryName | The File System utilized under certain percentage value. |
| numberOfComputers | The number of computers used by the File Systems. |
| numberOfFileSystems | The number of File Systems in use. |
| percentageOfFileSystems | The percentage of the File Systems in use. |
| totalCapacityMB | The total amount of Capacity available in the media. |
| availableSpaceMB | The amount of space available in the media. |
| usedSpaceMB | The amount of space in use. |
| percentageSpaceUsed | The percentage of the space used. |
| percentageSpaceAvailable | The percentage of the space available. |
The CommCellSRMEnterpriseFileSystemUtilization view provides information about File System Utilization.
The following image displays a sample CommCellSRMEnterpriseFileSystemUtilization view:
| Column | Description |
| totalNumberOfComputer | The total number of Computer in use for File System Utilization. |
| totalNumberOfFileSystems | The total number of File System in use. |
| totalCapacityMB | The total amount of capacity. |
| usedSpaceMB | The amount of space in use. |
| availableSpaceMB | The amount of space available. |
| percentageSpaceUsed | The percentage of the space used. |
| percentageSpaceAvailable | The percentage of the space available. |
| avgTotalCapacityPerComputerMB | The average amount of capacity for each computer. |
| avgUsedSpacePerComputerMB | The average amount of space used by each computer. |
| avgAvailableSpacePerComputerMB | The average amount of space available for each computer |
The CommCellSRMEnterpriseFileSystemUsageDistribution view provides information about the File Type Distribution across the Entire SRM Server.
The following image displays a sample CommCellSRMEnterpriseFileTypeDistribution view:
| Column | Description |
| categoryName | The name of file type. |
| categoryFileCount | The count of number of file type. |
| categoryUsedSpaceMB | The amount of space used by the file type. |
| percentageFileCount | The percentage of total count of files used by all categories by each category file count. |
| percentageUsedSpace | The percentage of total amount of space used by all categories by amount of space used by each category. |
The CommCellSRMEnterpriseInactiveDataByAccessTimeDistribution view provides information about Inactive data by Last Access Time Distribution.
The following image displays a sample CommCellSRMEnterpriseInactiveDataByAccessTimeDistribution view:
| Column | Description |
| categoryName | The access time distribution category. |
| categoryFileCount | The count of the number of files accessed. |
| categoryUsedSpaceMB | The space used by each time category. |
| percentageFileCount | The percentage of total count of files used by all categories by each category file count. |
| percentageUsedSpace | The percentage of total amount of space used by all categories by amount of space used by each category. |
The CommCellSRMEnterpriseInactiveDataByModificationTimeDistribution view provides information about Inactive data by Last Modification Time Distribution.
The following image displays a sample CommCellSRMEnterpriseInactiveDataByModificationTimeDistribution view:
| Column | Description |
| categoryName | The modification time limit. |
| categoryFileCount | The count of the number of files modified |
| categoryUsedSpaceMB | The amount of space used by each time category. |
| percentageFileCount | The percentage of total count of files used by all categories by each category file count. |
| percentageUsedSpace | The percentage of total amount of space used by all categories by amount of space used by each category. |
The CommCellSRMEnterpriseUserUsageReport view provides information about Storage Utilization File Type Distribution for Multimedia, Document or Other file types.
The following image displays a sample CommCellSRMEnterpriseTotalFileSystemUserUsage view:
| Column | Description |
| totalFSUserUsageClientID | The CommCell Client Id. If this is not applicable then it displays -1. |
| totalFSUserUsageClientName | The CommCell Client Name or Server Name. If this is not applicable then it is empty. |
| totalFSUserUsageFileSystemID | The SRM File System Id. If this is not applicable then it displays -1. |
| totalFSUserUsageFileSystemName | The SRM File System Name - Windows Drive mapping. If this is not applicable then it is empty. |
| totalFSUserUsageUserId | The SRM User Id. |
| totalFSUserUsageUserName | The SRM User Name - Windows form of [Domain | Computer] \ Account Name. |
| totalFSUserUsageFileCount | Total number of files owned by a user. It is a summation at the appropriate level based on type column. |
| totalFSUserUsageTotalFileBytes | Total space used by a user. It is a summation at the appropriate level based on type column. |
| totalFSUserUsageAverageFileBytes | The average file size owned by a user. It is an average value at the appropriate level based on type column. |
| totalFSUserUsageMaxFileBytes | The largest file based on size owned by a user. It is the maximum value at the appropriate level based on type column. |
The CommCellSRMEnterpriseUserUsageReport view provides information about the File System Usage by User across the Entire SRM Server.
The following image displays a sample CommCellSRMEnterpriseUserUsageReport view:
| Column | Description |
| Titletype | Level of detail: Enterprise(1), Server(2), FileSystem(3) |
| Titlename | Title associated to type for a readable description |
| totalFSUserUsageClientId | The CommCell Client Id. If this is not applicable then it displays -1. |
| totalFSUserUsageClientName | The CommCell Client Name or Server Name. If this is not applicable then it is empty. |
| totalFSUserUsageFileSystemId | The SRM File System Id. If this is not applicable then it displays -1. |
| totalFSUserUsageFileSystemName | The SRM File System Name - Windows Drive mapping. If this is not applicable then it is empty. |
| totalFSUserUsageUserId | The SRM User Id. |
| totalFSUserUsageUserName | The SRM User Name - Windows form of [Domain | Computer] \ Account Name. |
| totalFSUserUsageFileCount | Total number of files owned by a user. It is a summation at the appropriate level based on type column. |
| totalFSUserUsageTotalFileBytes | Total space used by a user. It is a summation at the appropriate level based on type column. |
| totalFSUserUsageTotalAverageFileBytes | The average file size owned by a user. It is an average value at the appropriate level based on type column. |
| totalFSUserUsageTotalMaxFileBytes | The largest file based on size owned by a user. It is the maximum value at the appropriate level based on type column. |