The DL_PhoenixObject view is used to provide a unified way to access both library objects and collaboration objects in one query. This view outputs the properties that are common to both object types as shown:

• objectID
• title
• abstract
• tableName
• id
• isDeleted

This view provides a unified view of any object that is associated with a physical file on the server in an attempt to sum up the number of bytes that exist in file storage. This view includes the workspaceID that the file is in, as well as the user ID (createdBy) of the user that created it.

Figure:Calculating file sizes

The following example illustrates how to find the number of bytes uploaded in a particular workspace.

CopySQL

SELECT      SUM(dbo.WS_FileSizes.fileSizes) as bytesUploaded

FROM        dbo.WS_FileSizes
INNER JOIN  dbo.WS_Workspace ON dbo.WS_FileSizes.workspaceID = dbo.WS_Workspace.workspaceID
WHERE      (dbo.WS_FileSizes.workspaceID = @workspaceID)