Creating a drill-down computer report
You can create a custom drill-down report and add it as a right-click menu action to the audit report that you created.
The following is an example of how to create a drill-down report that shows the list of computers that have the software installed. You can create any other report according to your needs.
To create a drill-down computer report
In the Symantec Management Platform, on the Reports menu, click .
In the left pane, under Reports, expand Discovery and Inventory > Inventory > Cross-platform > Software /Applications, right-click , and then click .
On the New Computer Report page, click the report name and type a new name.
For example, type Drilldown: Installed.
On the Query tab, under Base Query, click , and then, in the left pane, under Actions, click .
In the Joins dialog box, create a table join as follows:
In the drop-down list, click .
In the middle drop-down list, click .
In the bottom drop-down lists, click the following:
On = .
Click .
On the Fields tab, on the toolbar, click the symbol, and then add the fields that are shown below.
Configure the fields as shown.
On the Report Parameters tab, on the toolbar, click and then, in the Editing Parameter dialog box, configure the parameter as follows:
In the box, type SWguid.
In the box, type Software Guid.
In the drop-down list, click .
Check .
Under Value Provider, in the drop-down list, click .
In the box, type Software Resource Guid.
Click .
On the Data Source tab, click the Query Parameters tab, and then, on the toolbar, click .
On the Filter Expressions tab, in the left pane, click .
In the right pane, do the following:
In the top drop-down list, click .
When a dialog box opens, click .
Under Filter Expression Operands, for the first filter operand, in the drop-down list, click and then, in the right drop-down list, click .
For the second filter operand, in the drop-down list, click , and then, in the right drop-down list, click .
Click .
To create a right-click drill-down menu
Open the report that you created with Query Builder.
Add a new [Inv_AddRemoveProgram].[_SoftwareComponentGuid] field to the report, and make it invisible.
On the Drilldowns tab, click to remove the default ShowContextMenu drilldown.
Click .
In the box, type Show Installed.
In the drop-down list, click .
Under Action Configuration, click , and then search for and select the drill-down report that you created.
Under Passing Parameter, click the symbol.
In the Pass Drilldown Parameter dialog box, configure the fields as follows:
Click .
Click .
Create a new drill-down as follows:
Click .
The right-click action that you created is not available in the right-click menu by default. You must edit the source of the report manually, as follows:
To enable the custom right-click menu
In the left pane, right-click the Adobe audit (Query Builder) report, click , and then save the file.
Open the saved XML file in a text editor.
In the XML file, under <viewingControl>, in the <link> element with the name="ContextMenu" attribute, locate the following string:
<action id="ContextMenu" />
Replace this string with the following text:
<action id="ContextMenu">
<arguments>
<argument name="MenuFactories" list="true">
<value>LinkMenu</value>
</argument>
</arguments>
</action>
Also, add the visible="false" attribute to the link element.
Save and close the file.
In the Symantec Management Console, right-click the folder in which your report is located (in this example, Software), click , then and import the report back into the CMDB.
The right-click menu is now available. Test the report. To go back to the parent report, use the breadcrumb bar above of the right pane.
(Optional) To hide the drill-down report from the left pane, in the XML, replace <itemAttributes>Normal</itemAttributes> with <itemAttributes>Hidden</itemAttributes>.
Thanks for your feedback. Let us know if you have additional comments below. (requires login)