Incorrect version of Software Update Plug-in Windows

Products

• Patch Management Solution for Windows

Issue/Introduction

For ITMS the version of Software Update Plug-in Windows was showing the expected version as 12346 instead of 12345 for example on the SMP Console.

Is there a way to find the plugin GUID and replace the correct version if required into the DB directly?

Environment

ITMS 8.X

Resolution

1) Use the following query to find the plugin GUID of the affected plugin/plugins:

select distinct vi.name, svs.pluginguid, svs.version,svs.build from smpversions svs 
join vitem vi on vi.guid = svs.pluginguid 

Note: '37D25576-7845-42A5-991C-D08D55D44414' is the usual GUID for Software Update Plug-in 

2) Execute the below query to update the correct version as mentioned in the following articles related to the version that you have installed:

UPDATE [dbo].[SmpVersions] 
SET [Version] = '1.2.346',
[Major] = 1,
[Minor] = 2,
[Build] = 346 
Where [PluginGuid] = '37D25576-7845-42A5-991C-D08D55D44414'

Additional Information

260127 "What are the released ITMS 8.7 Agent or Plug-in versions and build numbers?"
208803 "What are the released ITMS 8.6 Agent or Plug-in versions and build numbers?"
150933 "What are the released ITMS 8.5 Agent or Plug-in versions and build numbers?"