Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Export Vendors and Software List?

Created: 24 May 2013 • Updated: 06 Jun 2013 | 2 comments
HighTower's picture
This issue has been solved. See solution.

Has anyone figured out a way to export the list of the Vendors and Software that are available for patching vs what's enabled?  I'd much rather hand someone a spreadsheet instead of giving them console access just to look at the task.

Capture.PNG

You can kind of copy and paste from the web page but it doesn't retain the bolding and certainly doesn't include the checkboxes but it does expand the vendors. 
 

Surely I'm missing something here.

 

Operating Systems:

Comments 2 CommentsJump to latest comment

SK's picture

I have just created an article containing this information (pending approval); however, the query you are looking for is:

 

--/ Software that is selected in the "Vendors and Software" PMImport section

declare @hdoc int

declare @doc varchar(max)

select @doc = convert(varchar(max), State) from vItem

where ClassGuid = '730ce470-aa29-442f-a37b-965a1fd0cf7d'

exec sp_xml_preparedocument @hdoc output, @doc

select v.Name Vendor, sw.Name Product from RM_ResourceCompany v

inner join ResourceAssociation ra on v.Guid=ra.ChildResourceGuid

inner join RM_ResourceSoftware_Release sw on ra.ParentResourceGuid = sw.guid

left outer join

(select release.guid,release.[Name] from openxml(@hdoc, '/item/PatchManagementSolutionPolicy/CoreConfig/SWReleasesToExcludeFromSWUpdatesImport/sRelease') with (guid uniqueidentifier) stateXml

inner join vItem release on release.Guid = stateXml.guid

inner join ResourceAssociation ra on ra.ParentResourceGuid = release.Guid

where ra.ResourceAssociationTypeGuid = '292dbd81-1526-423a-ae6d-f44eb46c5b16') as ex on sw.Guid = ex.Guid

where ex.guid is null and sw.ProductGuid='B1338338-5575-4A27-9808-23BEC40D79FA' and sw.Attributes=0

order by v.Name,sw.Name

exec sp_xml_removedocument @hdoc

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.

SK's picture

Hello HT,

Here is my article:  https://www-secure.symantec.com/connect/articles/patch-management-solution-712-software-and-vendor-page-queries

SK

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.

SOLUTION