How to Query the VAIM DB for template or policy information

Document ID : KB000071663
Last Modified Date : 22/02/2018
Show Technical Document Details
Issue:
We need some information on how to extract VAIM template information from VAIM database.

We need the following information:
  1. Which templates are applied to each server?
  2. What monitors are defined within the templates?
Resolution:
CA has not published the VAIM SQL Database schema.   The VAIM database is a mixture of SQL DB, SQL Lite DB and flat files so there is no singular point where all the data is stored.

You can run two reports within VAIM and output as CSV (Excel) to get the information required.

1. Reporting > Policy Configuration Reports > Agent List by Distribution Server.

This report will show you what Distribution Server is managing the host, the Agent Version, Platform, and which Policies and Templates are applied to each system.

2. Reporting > Policy Configuration Reports > Policy and Policy Template Details.

This report will show you which monitors are configured within a given base Policy or Template.