How to find the Data Catalog (PMImport) Version

book

Article ID: 181066

calendar_today

Updated On:

Products

Patch Management Solution for Windows

Issue/Introduction

 

Resolution

You can find the Data Catalog version, aka PMImport version, on your SMP console by going to the following location:  Home > Patch Management.  Click on Compliance Dashboard and wait for the webpart to load on the right hand side.  The information you are looking for is located under the Windows Patch Configuration Summary section.

You may have a need to get this information outside of the console using a SQL query.  You can use the following query to accomplish this:

--Show the current Data Catalog version
select top 1 edi.Version as 'Data Catalog Version'
             from Evt_Download_Item_Task_State_Version edi
inner join dbo.Evt_Task_Instances eti on edi.ItemTaskStateGuid = eti.TaskInstanceGuid
and edi._ResourceGuid = eti._ResourceGuid
inner join ItemVersions iv
on iv.VersionGuid =  eti.TaskVersionGuid
join Item ti 
on ti.Guid = iv.ItemGuid
where ti.Guid = 'c27dbb50-6ddf-4125-87c1-d8f5b588491d'
 
--Show the current Data Catalog version and the time it was imported at
select top 1 edi.Version as 'Data Catalog Version', edi._eventTime as 'Time'
             from Evt_Download_Item_Task_State_Version edi
inner join dbo.Evt_Task_Instances eti on edi.ItemTaskStateGuid = eti.TaskInstanceGuid
and edi._ResourceGuid = eti._ResourceGuid
inner join ItemVersions iv
on iv.VersionGuid =  eti.TaskVersionGuid
join Item ti 
on ti.Guid = iv.ItemGuid
where ti.Guid = 'c27dbb50-6ddf-4125-87c1-d8f5b588491d'
 
If you would like the last 5 or maybe 10 instances of the data catalog, simply change the select top 1 to select top 5 or top 10.