KNOWN ISSUE: Clients requiring Application Metering collection are not accurate

Article:TECH17562  |  Created: 2006-08-28  |  Updated: 2008-07-03  |  Article URL http://www.symantec.com/docs/TECH17562
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Issue



The query for the "Clients Requiring Application Metering Agent Install/Upgrade" collection is not accurate. The query uses the OS name to determine the OS type. The collection is supposed to exclude all Windows Server computers (the information icon for this collection states this). However, the query includes Windows 2000 Server computers since OS name is Windows 2000, but the OS type is server. Windows 2000 server computers are deployed the Application Metering agent when they should not.

Location of Collection: Configuration > Solution Settings > Application Metering > Application Metering Agent Rollout > Clients Requiring Application Metering Agent Install/Upgrade.

Environment



Application Metering Solution 6.x

Cause



 


Solution



You can edit the SQL query used by default collection to take into account Windows 2000 Server and Windows 2000 Advance Server

To edit the "Clients Requiring Application Metering Agent Install/Upgrade" collection follow these steps below:

  1. Browse to Configuration > Solution Settings > Software Management > Application Metering > Application Metering Agent Rollout.
  2. Right-click Clients Requiring Application Metering Agent Install/Upgrade.
  3. Select Clone.
  4. Change the name of the cloned collection if you chose to, otherwise click OK.
  5. The newly created collection will now appear in the navigation pane on the left.
  6. Click the pencil icon in the middle toolbar.
  7. Paste in the following SQL query in the query box:

     select Guid from vResource where  
       Guid in 
      ( 
       SELECT distinct r.Guid 
       FROM vComputer r
       WHERE r.Guid IN
        -- Resources with AM Agent older then the current build, but also with a new 6.0 version of the Altiris Agent installed 
        (SELECT CA1.[_ResourceGuid] FROM Inv_AeX_AC_Client_Agent CA1
        WHERE (CA1.[Agent Name] = 'Application Metering' AND (CA1.[Product Version] != '6.1.31' OR CA1.[Build Number] != '31'))
        OR (CA1.[Agent Name] = 'Altiris Agent')
        GROUP BY CA1.[_ResourceGuid]
        HAVING COUNT(DISTINCT CA1.[Agent Name]) > 1)
       OR
          r.Guid IN 
          -- Resources without AM Agent installed, with 6.0 Altiris Agent and not a server machine
         (SELECT distinct c.[_ResourceGuid] FROM Inv_AeX_AC_Client_Agent c 
            inner join Inv_AeX_AC_Identification a
     on c._resourceguid = a._resourceguid
     where c.[_ResourceGuid] not in
              (SELECT CA2.[_ResourceGuid] FROM Inv_AeX_AC_Client_Agent CA2 WHERE CA2.[Agent Name] = 'Application Metering')
          AND [Agent Name] = 'Altiris Agent'
          AND isnull(r.[OS Name],'Professional') not like '%Edition%'
          AND isnull(r.[OS Name],'Professional') not like '%Server%'
    and isnull(a.[OS Type],'Professional') not like '%Server%'
      and isnull(a.[OS Type],'Professional') not like '%Enterprise%')
       AND r.IsManaged=1
       AND LOWER(r.[System Type]) like lower('%win32%')
      )

  8. Click Apply.
Next, set the new collection for the Application Metering Agent installation task.
  1. Browse to Configuration > Solution Settings > Software Management > Application Metering > Application Metering Agent Rollout > Win32 Application Metering Agent Install/Upgrade.
  2. Select Enable.
  3. In the Applies to collections section, click the pencil icon.
  4. The Collection Selector window will appear. Under the System folder, mark the check box next to collection created in step 4 above.
  5. Click Apply.

Now the Application Metering Agent will install to clients are not of OS Type "Server" or have OS Name "Server." This query has been modified to work with Application Metering 6.1 SP2.


Supplemental Materials

SourceDEFECT
ValueLB 40498
DescriptionLogged in Littlebuggy (Altiris - Lindon, Plymouth) database

Legacy ID



26297


Article URL http://www.symantec.com/docs/TECH17562


Terms of use for this information are found in Legal Notices