Help for Database Views
IT Analytics provides a set of published read-only database views into the reporting 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.
Database views provide a native SQL interface into the reporting database. IT Analytics publishes a collection of views that overlay the underlying database tables. 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 reporting database.
There are multiple types of database views:
. Provides read access to the properties for every inventory item that the product maintains.
. Provides read access to information about a given underlying IT Analytics licensed module.
. Provides read access to data specific to a third-party vendor, such as NetApp or HDS.
Use the Help specific to the database views to look up the valid tables and fields relevant to your environment. You can use the help as you build the query or you can download it as a PDF to use offline. Access column descriptions for Portal database views by selecting a view and then clicking the icon beside the Available views and fields drop down. You can also just click the icon to see the full listing of all the views.
Navigate through descriptions for Base Portal Views, Base Views for licensed modules, and third-party vendor-specific Views for your building your query.