Under the Agent Health display expected version is lower than actual after upgrading ITMS to 8.6 RU2

Products

• Client Management Suite
• IT Management Suite
• Server Management Suite

Issue/Introduction

 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.

Environment

ITMS 8.6.x

Resolution

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

Additional Information

KB 164972 "Altiris Console Shows "Not up-to-date" Alert for Computers"

KB 175750 "Incorrect version of Software Update Plug-in Windows"