Example of a Table SQL Template: Host Group Membership List
The following example reports on host group membership, in display name order.
In the SQL Template Designer, check only .
In the Query window, enter the following select statement and click :
SELECT g.group_name, s.server_id, s.display_name client, s.hostname, s.ip_address FROM apt_v_group_member m, apt_v_group g, apt_v_server s WHERE g.group_id = m.group_id AND m.child_type = 2 --Server (excludes children that are host groups) AND m.child_id = s.server_id AND s.server_id IN (${hosts}) ORDER BY s.display_name, g.group_nameIn the Formatting window, select the fields to be displayed. For this example, it makes sense to select all and display the report as a .
Click , enter a report name and select a Menu Group. Then, click .
When you run this report, you can modify the scope to generate the report for a specific host group. The output will look something like this:
Note that the column header "client" was substituted for the field name, as specified in the query. You can specify similar substitutions using the Formatting window in the SQL Template Designer.
Since this query is ordered by display name and then group name, it may be more reasonable to display the output in a similar fashion. Use the Formatting tab to re-arrange the table columns (Move Up, Move Down).