Pipelined Functions for Report Query Building
  
Version 10.3.00P13
Pipelined Functions for Report Query Building
The product provides a set of published read-only database views of the underlying data within the database and related object model. The purpose of these views is to provide a read-only reporting or data extraction mechanism for advanced users of the product.
Typically, these views will be accessed via the SQL Template Designer, where SQL queries can be constructed to develop custom reports. Using these read-only views, you can write your own reports or stored procedure handlers to query the reporting database. These views provide a simple and fast mechanism to access a read-only view into the raw data maintained within the report database.
Pipelined functions can be used to query the database to further expand the capabilities of the custom report templates built with the SQL Template Designer.
The functions fall into the following categories:
General Functions
Functions
Policy Auditing Functions
Capacity Functions