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.|
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.
Application Management Solution 6.1
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'
- 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
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
|Description||Logged in Littlebuggy (Altiris - Lindon, Plymouth) database|
Article URL http://www.symantec.com/docs/TECH34087