Log Information During Delta Resource Membership Update: Incorrect number of columns returned from the query. 1 GUID column is expected

Products

• IT Management Suite

Issue/Introduction

When the Delta Resource Membership Update schedule runs one or more instances similar to the following informational log entry are seen:

Description: Invalid collection definition query found for collection 'Computers with Symantec Management Agent in Domain EPM'  New Filter (c6d5cd0c-e82a-4099-9200-0b337fb27dcd~) . Incorrect number of columns returned from the query. 1 GUID column is expected, but 5 is found. Collection membership update will ignore the other columns and continue with the operation.

Depending on the complexity of the inclusion query used by filter it may not be corrected until the Complete Resource Membership Update schedule is run.  Either way the condition works the resource update schedules causing them to take much longer than they normally would.

Environment

ITMS 8.x

Cause

The filter is composed of an embedded query which calls multiple columns in the "SELECT" statement.  Filters are not reports. They are only concerned with receiving the GUID of the computer(s) qualified by the SQL query.

For example the following query, if used in a filter, would cause the previous log entry to be thrown:

SELECT vc.Guid, vc.Name, Domain, vc.[IP Address], vc.IsManaged
FROM vComputer vc
join Inv_AeX_AC_Client_Agent ca on ca._ResourceGuid = vc.Guid
  and ca.[Agent Name] = 'Altiris Agent'
WHERE vc.Domain = 'EPM'

NOTE: That the "SELECT" statement calls five differnet columns:  vc.Guid, vc.Name, Domain, vc.[IP Address], vc.IsManaged

Resolution

Change the query to only pass in the GUID of the resource qualified by the rest of the SQL statement.

SELECT vc.Guid
FROM vComputer vc
join Inv_AeX_AC_Client_Agent ca on ca._ResourceGuid = vc.Guid
  and ca.[Agent Name] = 'Altiris Agent'
WHERE vc.Domain = 'EPM'