Sample Inventory report with filters

This example demonstrates how to create an Inventory report that lists all servers violating the password policy applicable in your organization.

To create an Inventory report with filters

1. Launch Query Studio from the BMC Decision Support for Server Automation portal.
2. Select a package (for example, BladeLogic) from the list of available packages.
3. Click the Run Report link.
4. Click the Preview with No Data link.
5. Click the Insert Data link.
6. Open the Inventory folder and drag the following query items to the right pane:
   • Server/Server Name
   • Snapshot Template/Template Name
   • Windows/Security Settings/Policy Category
   • Windows/Security Settings/Policy Full Name
   • Windows/Security Settings/Local Policy Setting
   • Windows/Security Settings/Effective Policy Setting
7. On the Policy Category column, add a filter as follows:
   1. Select the column and click Filter on the toolbar.
   2. On the Prompt page, select the required option, and click OK.
   3. Select the column and click Filter on the toolbar.
   4. Select the Password Policy check box, and click OK.
8. On the Policy Full Name column, add a filter and specify Security Settings\Account Policies\Password Policy\Passwords must meet complexity requirements as the filter value.
9. When you are prompted to combine the filter conditions, click OK.
10. On the Local Policy Setting column, add a filter and specify Disabled as the filter value.
11. When you are prompted to combine the filter conditions, click OK.
12. Click the Run Report link.
13. Click the Run with All Data link.
14. On the Prompt page, select the required option. (For information about options, see Running an Inventory report.)
15. Save the report.
    The following figure shows a sample Inventory report created by using this procedure:
    

Related topics

Sample reports demonstrating Query Studio features
Creating reports with Report Studio