Software Delivery uses queries in a number of places to automate the management of assets. Starting with Unicenter DSM release 11, a new query mechanism that is common to all the DSM components replaces the 4.0 query sub system. The new SQL-based query mechanism gives performance improvements over the code-based legacy evaluation mechanism. Also, starting with Unicenter DSM r11, a new basic hardware inventory mechanism that is common to all of DSM replaces the inventory module of Unicenter Software Delivery 4.0. The new basic hardware inventory module offers more accurate inventory. However, some of the Unicenter Software Delivery version 4.0 attributes are not collected by the Client Automation inventory module.
These changes have the following high-level impact on the query import:
When you import a 4.0 formatted query string into Client Automation, it is not possible to map all the query attributes to equivalent Client Automation attributes. Client Automation will import invalid queries with empty expressions marked as invalid for informational purposes. You must modify these queries before performing an import.
The Client Automation query subsystem recognizes computers and user profiles as individual target types for queries. This means that a query can return either a set of computers or a set of user profiles but not both. In version 4.0, computers and user profiles were represented by one target type allowing a query to return both computers and user profiles. When you import a version 4.0 formatted query string into Client Automation, the ability to return both computers and user profiles is maintained through the creation of a custom query. Custom queries are pure SQL statements that are not directly compatible with the query building functionality of the Query Designer. Therefore, you need to modify the custom queries using the Edit SQL feature of the Query Designer rather than using the Insert Argument feature.
Client Automation uses SQL wildcards; the LIKE operator replaces the MATCH operator in Unicenter Software Delivery 4.0 and all other wildcard characters are mapped to the SQL equivalents where possible. However, some of the wildcard characters such as '?', '+' and '|' have no equivalent in SQL; the 'set negation' [^ ….] is not supported and produces an invalid query.
Some attribute values have changed in Client Automation. In many cases, a simple mapping is possible to convert the version 4.0 values embedded in queries to the new values. In other cases, this is not possible because the number of values used in Client Automation and version 4.0 may not match; in some cases an '=' or '<>' operator can be replaced with LIKE and some wildcards added to the literal. In this case, operators other than '=' or '<>' produce an invalid query.
This limitation specifically applies to the Target attribute group with the attribute values such as Machine, Staging Server, Domain, and UserId. It also applies to the Name attribute of attribute groups SDAttr_OS2, SDAttr_WinNT, SDAttr_WinCE, SDAttr_unix, SDAttr_Win9X, SDAttr_Netware, and SDAttr_VMS.
In the case of the attribute Type (in the Target attribute group) with the values 'Machine' and 'Staging Server', queries behave differently in Unicenter Software Delivery version 4.0 and Client Automation. The reason for this is, in version 4.0 the agent on the Local Server was of the type 'Machine' whereas in Client Automation the agent on the domain manager is of type 'Staging Server'.
In Unicenter Software Delivery 4.0, a query "Target.Type='Machine'" returns all agents (no Staging Servers) including the Local Server's agent. When this query is imported to Client Automation, it returns only standalone agents (agents that have no scalability server or domain manager on the same machine).
In Unicenter Software Delivery 4.0, a query "Target.Type='Staging Server'" returns all Staging Servers. When this query is imported to Client Automation, it also returns the domain manager, as its agent is considered to be a Staging Server.
|
Copyright © 2014 CA Technologies.
All rights reserved.
|
|