Under the Agent Health display expected version is lower than actual after upgrading to ITMS 8.6 RU2 from 8.5 RU3 ( 8.5 RU3 >>8.5 RU4>>8.6 RU2)
Client machine the it's showing the correct version details.
ITMS 8.6.x
After upgrading SMP to 8.6 RU2 few plugin version not updated in the Database.
In this case we noticed the the issue with "Inventory Rule Agent " and " Software Management Framework Agent "
We ran the below query against the CMDB database ( Altiris Database) and found that above plug-in's details are not updated and they are still on Older version.
select vi.Name, sv.* from SmpVersions sv
join vItem vi on vi.Guid= sv.PluginGuid
where vi.name = 'Software Management Plug-in'
select vi.Name, sv.* from SmpVersions sv
join vItem vi on vi.Guid= sv.PluginGuid
where vi.name = 'Inventory Rule Management Plug-in'
To fix the issue run the below query against the CMDB database ( Altiris Database) and update correct version as per your current SMP version.
In this case SMP server is on 8.6 RU2 (8.6.3286) .
1. For : Inventory Rule Management Plug-in
UPDATE [dbo].[SmpVersions]
SET
[Version] = '8.6.3268',
[Major] = 8,
[Minor] = 6,
[Build] = 3268
Where [PluginGuid] = '66CC94BE-1C0F-4895-9293-8B9658D570C1'
2. For : Software Management Plug-in or Software Management Framework Agent
UPDATE [dbo].[SmpVersions]
SET
[Version] = '8.6.3268',
[Major] = 8,
[Minor] = 6,
[Build] = 3268
Where [PluginGuid] = '73887285-562F-4720-A41B-B9987B2C2BD8'
Note: Please note we always recommend to take the latest working full backup of the database .
You can find the "Plugin guid" by running the below SQL query for any other plug-ins which is impacted apart from the above plug-ins and then use the Update query and place the correct value .
select vi.Name, sv.* from SmpVersions sv
join vItem vi on vi.Guid= sv.PluginGuid