Active Directory Import is not populating "System Type"

Products

• IT Management Suite

Issue/Introduction

Active Directory Import is not pulling in "System Type" into the Inv_AeX_AC_Identification. Therefore none of the imported computers will ever fall into the "All Windows Computers with no Altiris Agent installed" filter. This is the filter used by the Altiris Agent installation scheduled task to push the Altiris Agent to computers in a target that uses this filter.

Environment

ITMS 8.x

Cause

Because AD Import is unable to determine whether a computer is a Win32 or Win64 bit computer this data is not populated.

Resolution

The Active Directory import process is working as designed.  The import can’t determine whether the system is a 32-bit or 64-bit from active directory. The break is in the target being used by the Altiris Agent Installation scheduled task.

  

1. Cloned the “Windows Computers with no Altiris Agent installed” (under Manage > Filters > Software Filters > Agent & Plug-ins > Windows Computers with no Altiris Agent installed"). Give it a new name.

2. Edit the query and remove the filter for "System Type" from the query. It’s not needed by the install since we don’t care whether it’s a 32-bit or 64-bit. Remove those lines in RED.

 AND
    (
  vc.[System Type] = 'Win32' OR vc.[System Type] = 'Win64' OR vc.[System Type] = 'win32' OR vc.[System Type] = 'win64'
    )

 

3. On the Altiris Agent Install page, edit target to point to the cloned version of the "Windows Computers with no Altiris Agent installed” filter.

 

Original Query

SELECT vc.[Guid] FROM vComputer vc
    WHERE
    vc.[Guid] NOT IN
    (
    SELECT agent.[_ResourceGuid] FROM Inv_AeX_AC_Client_Agent agent
    WHERE agent.[Agent Name]='Altiris eXpress NS Client'
    )
    AND
    (
    vc.[OS Name] LIKE 'Microsoft Windows 2000%'
    OR vc.[OS Name] LIKE 'Microsoft Windows XP%'
    OR vc.[OS Name] LIKE 'Microsoft Server 2003%'
OR vc.[OS Name] LIKE '%2008%'
    OR vc.[OS Name] LIKE '%Vista%'
OR LOWER( vc.[OS Name] ) = 'unknown windows'
    )
    AND
    (
  vc.[System Type] = 'Win32' OR vc.[System Type] = 'Win64' OR vc.[System Type] = 'win32' OR vc.[System Type] = 'win64'
    )
    AND vc.[IsLocal] = 1

Modified Query

SELECT vc.[Guid] FROM vComputer vc
    WHERE
    vc.[Guid] NOT IN
    (
    SELECT agent.[_ResourceGuid] FROM Inv_AeX_AC_Client_Agent agent
    WHERE agent.[Agent Name]='Altiris eXpress NS Client'
    )
    AND
    (
    vc.[OS Name] LIKE 'Microsoft Windows 2000%'
    OR vc.[OS Name] LIKE 'Microsoft Windows XP%'
    OR vc.[OS Name] LIKE 'Microsoft Server 2003%'
OR vc.[OS Name] LIKE '%2008%'
    OR vc.[OS Name] LIKE '%Vista%'
OR LOWER( vc.[OS Name] ) = 'unknown windows'
)
  AND vc.[IsLocal] = 1