List of web sites patch manage need access for downloading patches .

Products

• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

What are the List of web sites Patch Manager need access for downloading patches ?

Environment

Client Automation - 14.3 and above

Resolution

Execute Below SQL query on Domain/Enterprise Manager SQL Management Studio ( On which Patch Manager Installed ) to get the list. 

SELECT SUBSTRING(download_url,1,CHARINDEX('/',download_url,CHARINDEX('//',download_url,1)+2)) 'Web Site',
COUNT(*) 'Number Files'
FROM ca_download_file
WHERE is_active=1
GROUP BY SUBSTRING(download_url,1,CHARINDEX('/',download_url,CHARINDEX('//',download_url,1)+2))
ORDER BY 2 DESC

Below list is as on June 2020

http://download.microsoft.com/ 881966
https://download.microsoft.com/ 88390
http://download.windowsupdate.com/ 26589
https://ftp.broadcom.com/user/downloads/ 11302
ftp://www7b.software.ibm.com/ 8989
https://update.esecurityonline.com/ 1583
ftp://www7b.boulder.ibm.com/ 705
https://ftp.mozilla.org/ 456
http://ardownload.adobe.com/ 285
https://fpdownload.macromedia.com/ 239
http://sunsolve.sun.com/ 203
ftp://anonymous:[email protected]/ 170
ftp://ftp.itrc.hp.com/ 154
http://ftp.mozilla.org/ 128
http://localhost/ 100
http://fpdownload.macromedia.com/ 90
http://releases.mozilla.org/ 86
http://download.macromedia.com/ 80
http://www.download.windowsupdate.com/ 61
http://fpdownload.adobe.com/ 55
http://download3.vmware.com/ 40
http://ftp.us.dell.com/ 38
http://patches.sun.com/ 28
https://javadl.oracle.com/ 14
http://appldnld.apple.com.edgesuite.net/ 14
http://javadl.oracle.com/ 12
http://download.oldversion.com/ 12
http://download.oldapps.com/ 11
http://www.oldapps.com/ 9
http://appldnld.apple.com/ 7
ftp://ftp.adobe.com/ 7
http://download.winzip.com/ 6
http://www.oldversion.com/ 6
https://download-installer.cdn.mozilla.net/ 5
http://download.adobe.com/ 4
 4
http://www.microsoft.com/ 4
http://mozilla.mirror.ac.za/ 3
http://pv-mirror02.mozilla.org/ 3
http://wsus.ds.download.windowsupdate.com/ 2
http://xpsp.dlservice.microsoft.com/ 2
https://dl.google.com/ 2
http://www.old-software.com/ 2
https://ardownload2.adobe.com/ 2
http://download.cdn.mozilla.net/ 2
http://mozilla.cs.utah.edu/ 1
http://mozilla-mirror.3347.voxcdn.com/ 1
http://software-dl.real.com/ 1
http://supportdownload.apple.com/ 1
https://secure-appldnld.apple.com/ 1
http://Download.Microsoft.com/ 1
Http://download.microsoft.com/ 1
http://mirror.metrocast.net/ 1
http://appldnld.m7z.net/ 1
http://classic.sunsolve.sun.com/ 1
http://dm-download02.mozilla.org/ 1
ftp://ftp.dell.com/ 1
ftp://ftp.microsoft.com/ 1
ftp://public.dhe.ibm.com/ 1
http://127.0.0.1/ 1