KNOWN ISSUE: Uninstall collection for Computers with State Management Agent has invalid members

Article:TECH34087  |  Created: 2007-08-30  |  Updated: 2008-01-08  |  Article URL http://www.symantec.com/docs/TECH34087
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 State Management Agent collection may display computers which do not have the State Management Agent installed. Each of these computers correlates to a computer that is "mobile". Each mobile computer may also appear in the "Windows Mobile Collection".  

For reference, the Notification Server considers a computer "mobile" if its agent contacts the Notification Server over a low-speed connection more frequently than a LAN speed connection.


Environment



Application Management Solution 6.1

Cause



Invalid SQL in the collection (highlighted in red)

select Guid from vResource where
                Guid in (
                 [Trimmed for brevity]

                                                WHERE   r.IsManaged = 1
                                                                and a.[System Type] = 'Win32'
                                                                and  (  con.Lan < con.Wan
                                                                        OR
i.[Agent Name] like 'Altiris AppMgmtAgent'


Solution



  1. Import the attached collection .xml file (Updated - Computers with State Management Agent.xml) into the same parent folder (Configuration tab > Solution Settings > Software Management > Application Management > Windows > State Management Agent).
  2. Update any policies (State Management Agent Uninstall) that were pointing to the broken collection to instead use this one.

For reference, here is the updated SQL in the collection

SELECT vcr.[Guid]
FROM vComputerResource vcr
JOIN Inv_AeX_AC_Identification aci
    ON aci.[_ResourceGuid] = vcr.[Guid]
        AND aci.[System Type] = 'Win32'
JOIN Inv_AeX_AC_Client_Agent ca
    ON ca.[_ResourceGuid] = vcr.[Guid]
        AND ca.[Agent Name] = 'Altiris AppMgmtAgent'
WHERE vcr.[IsManaged] = 1


Supplemental Materials

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

Legacy ID



37793


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


Terms of use for this information are found in Legal Notices