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 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

Languages

Show all

Problem

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

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).
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

Attachments

Updated - Computers with State Management Agent.xml (4 kBytes)

Supplemental Materials

Source	DEFECT
Value	LB 64055
Description	Logged in Littlebuggy (Altiris - Lindon, Plymouth) database

Legacy ID

37793