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.
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
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
Applies To Application Management Solution 6.1
ID: LB 64055
Logged in Littlebuggy (Altiris - Lindon, Plymouth) database