How to Create a complex queries?

Document ID : KB000027202
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

 How to build a query that filters more than 1 characteristic ?

 

Environment:                                          

CA Client Automation - All Versions

 

Answer:

 

The process below will show an example of a reasonably complex query which fulfill the following criteria:

Returns all Domain Managers (DM) and Scalability Servers (SS) but only if...

The DM and SS machines have an installation record for a particular piece of software but...

Do NOT have an installation record for another piece of software.

The process to achieve the above result is as follows:

  1. Open DSM Explorer, right-click on 'Computers and Users' and select 'New Group'

    Figure 1

  2. Provide an appropriate name and click the 'Query' tab.

    Figure 2

  3. Click the button with '...' on it to create a new query.

    Figure 3

  4. Double-click the icon called 'Computers'.

    Figure 4

  5. Click the '(' Boolean Operator to add to the query builder at right.

    Figure 5

  6. Select 'Software' -> 'Software Packages' and then 'SW Name'.

    Figure 6

  7. Select item for DSM Scalability Server package.

    Figure 7

  8. Click 'OK' and then select Boolean Operator 'OR'.

  9. Repeat 6 and 7 for the package named 'CA Unicenter DSM Manager'

  10. Add the Boolean Operator ')'.

  11. Add the Boolean Operator 'AND'

  12. Add the Boolean Operator '('

  13. Repeat 6-7 for the package named <Package name of your choice>

  14. Add the Boolean Operator 'AND'

  15. Add the Boolean Operator 'NOT'

  16. Repeat 6-7 for the package named <Package name of your choice>

    Figure 8

  17. Click 'OK'

  18. Provide a relevant query name and click 'OK' twice.