Introduction to Database Views

This section describes how to use database views within SQL Server database queries to generate custom reports for Ivanti Security Controls.

When you install Ivanti Security Controls it creates a number of defined views in the SecurityControls SQL Server database. You can reference these views within custom queries that you write to extract exactly the information you want. By executing the custom queries and exporting the results to the format of your choice you effectively create your own customized reports for Ivanti Security Controls.

The benefits of writing your own database queries are:

  • You can mine the SecurityControls database for the exact information you want.

    • You can go beyond the predefined reports provided within Ivanti Security Controls. While the predefined reports are sufficient for many organizations, you may have the need to produce one or more custom reports that provide more specific information about the status of your machines.

  • You can export the query results and present the information in the format of your choosing.

You can, of course, opt to write custom queries without using the SecurityControls views. When you add the use of SecurityControls views to your custom queries, however, you gain a number of other benefits:

  • Nothing will be removed from view schemas in future versions of Ivanti Security Controls; only additive changes will be made.

    • Future versions of Ivanti Security Controls may modify the tables in the database. By referencing SecurityControls views in your queries rather than the tables, you will be guaranteed that your custom queries will not break when upgrading to future versions.

  • The queries are not as complex and are easier to write.

    • The views do some of the work for you. Your custom queries will not need to reference as many SecurityControls database tables. The views join multiple tables to gather relevant information and they pull different columns from multiple tables.

  • Ivanti will continue to build out the SecurityControls views in future versions, providing greater capabilities.
  • Custom queries can be shared by trusted members of the Ivanti community.

The process for creating a custom report is as follows:

  1. Familiarize yourself with the SQL Server database views that are provided with Ivanti Security Controls.
  2. Write a database query that references the Ivanti Security Controls views and that generates the information you want.
  3. Export the query results into the user-friendly format of your choosing.

Related Topics