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

Document ID : KB000024737
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

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?

Solution

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/                     885242
https://download.microsoft.com/ 19931
ftp://ftp.ca.com/ 9802
ftp://www7b.software.ibm.com/ 8989
https://update.esecurityonline.com/ 1583
http://download.windowsupdate.com/ 1077
ftp://www7b.boulder.ibm.com/ 705
http://ardownload.adobe.com/ 219
http://localhost/ 218
http://sunsolve.sun.com/ 203
https://fpdownload.macromedia.com/ 188
ftp://anonymous:anonymous@ftp.itrc.hp.com/ 170
ftp://ftp.itrc.hp.com/ 154
http://ftp.mozilla.org/ 90
http://releases.mozilla.org/ 86
http://download.macromedia.com/ 80
http://www.download.windowsupdate.com/ 60
http://fpdownload.adobe.com/ 55
https://ftp.mozilla.org/ 43
http://download3.vmware.com/ 40
http://ftp.us.dell.com/ 38
http://javadl.sun.com/ 28
http://patches.sun.com/ 28
http://appldnld.apple.com.edgesuite.net/ 14
http://download.oldversion.com/ 12
http://download.oldapps.com/ 11
http://127.0.0.1/ 10
http://www.oldapps.com/ 8
http://javadl.oracle.com/ 8
http://appldnld.apple.com/ 7
ftp://ftp.adobe.com/ 7
http://download.winzip.com/ 6
http://www.oldversion.com/ 6
http://download.adobe.com/ 4
http://www.microsoft.com/ 4
http://pv-mirror02.mozilla.org/ 3
http://mozilla.mirror.ac.za/ 3
http://download.cdn.mozilla.net/ 2
http://www.old-software.com/ 2
https://dl.google.com/ 2
http://xpsp.dlservice.microsoft.com/ 2
http://mozilla-mirror.3347.voxcdn.com/ 1
http://supportdownload.apple.com/ 1
http://software-dl.real.com/ 1
https://secure-appldnld.apple.com/ 1
ftp://ftp.microsoft.com/ 1
http://appldnld.m7z.net/ 1
http://mozilla.cs.utah.edu/ 1
http://mirror.metrocast.net/ 1
ftp://public.dhe.ibm.com/ 1
ftp://ftp.dell.com/ 1
http://dm-download02.mozilla.org/ 1
http://Download.Microsoft.com/ 1
Http://download.microsoft.com/ 1
http://fpdownload.macromedia.com/ 1
http://classic.sunsolve.sun.com/ 1

Note: This above list was collated in November 2016 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