Which Internet sites UPM should have access to, in order to download patches?

Document ID : KB000024737
Last Modified Date : 26/10/2018
Show Technical Document Details
Introduction:

UPM needs Internet access to contentupdate.ca.com (Via port 443 OR 5250) to receive patch information and maintains an up-to-date repository of available patches. Also, Unicenter Patch Management uses its internet connection to download accepted patches from their third-party website sources. Typically, this connection is made via an internet proxy although this is not required. NOTE: Security Rollups also require the download of 1 file via FTP (Port 21) for any rollup or delta patch download to complete successfully.

What websites might UPM typically need to connect to?

 

Instructions:

Following is a common list of third-party websites from which UPM typically downloads patches (There could be other sites as well and this list can change any time as the third-party chooses).

 Third-Party Websites                         Nb files referenced
------------------------------------------------------------------------
http://download.microsoft.com/                      881935
https://download.microsoft.com/                      61480
http://download.windowsupdate.com/                   11325
ftp://ftp.ca.com/                                    10560
ftp://www7b.software.ibm.com/                         8989
https://update.esecurityonline.com/                   1583
ftp://www7b.boulder.ibm.com/                           705
https://ftp.mozilla.org/                               252
http://ardownload.adobe.com/                           249
http://sunsolve.sun.com/                               203
https://fpdownload.macromedia.com/                     177
ftp://anonymous:anonymous@ftp.itrc.hp.com/             170
ftp://ftp.itrc.hp.com/                                 154
http://ftp.mozilla.org/                                 94
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
http://appldnld.apple.com.edgesuite.net/                14
http://download.oldversion.com/                         12
http://javadl.oracle.com/                               12
http://download.oldapps.com/                            11
http://www.oldapps.com/                                  8
ftp://ftp.adobe.com/                                     7
http://appldnld.apple.com/                               7
http://download.winzip.com/                              6
http://www.oldversion.com/                               6
https://download-installer.cdn.mozilla.net/              5
http://download.adobe.com/                               4
http://www.microsoft.com/                                4
http://mozilla.mirror.ac.za/                             3
https://dl.google.com/                                   3
http://pv-mirror02.mozilla.org/                          3
http://xpsp.dlservice.microsoft.com/                     2
http://www.old-software.com/                             2
http://download.cdn.mozilla.net/                         2
ftp://ftp.dell.com/                                      1
http://Download.Microsoft.com/                           1
Http://download.microsoft.com/                           1
http://classic.sunsolve.sun.com/                         1
http://mozilla-mirror.3347.voxcdn.com/                   1
ftp://public.dhe.ibm.com/                                1
http://appldnld.m7z.net/                                 1
http://mozilla.cs.utah.edu/                              1
http://mirror.metrocast.net/                             1
ftp://ftp.microsoft.com/                                 1
http://dm-download02.mozilla.org/                        1
http://supportdownload.apple.com/                        1
http://software-dl.real.com/                             1
https://secure-appldnld.apple.com/                       1

Note: This above list was collated in October 2018 and some new Websites may now be listed.

The following SQL statement may give an up-to-date 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