Standalone UPM Patch Availability

[Colin Wink]

HI,

I have installed ITCM Domain Manager with IIS, Web Console, Web Services and Patch Manager on a Windows 2008 R2 Server... due to Security Restrictions this is a standalone server not connected to our Live Environment and will only be used to download the required Patches from CA which will be moved (via USB) to a Live Patch Managed Server to allow them to be tested and deployed (as advised in the Solutions Guide) .

We have the Standalone server connected to the Internet but it is only showing the Patches required by the server (only Node showing in ITCM) is there any way of getting the full list of patches available to download regardless of what Nodes are showing in ITCM or a way to setup dummy Nodes in ITCM to show which current software deployed on our estate and then will allow Patch Manager to make the required Patches Available.

Any Help would be appropriated

Regards

[pucjo01]

You can run a query like the following to change the status of any one patch to 'pending user acceptance':

UPDATE ca_install_package SET status=3
WHERE sw_def_uuid IN (SELECT sw_def_uuid FROM ca_software_def
WHERE name='<PATCH_NAME>')

EX:
UPDATE ca_install_package SET status=3
WHERE sw_def_uuid IN (SELECT sw_def_uuid FROM ca_software_def
WHERE name='Office2003-KB957784-FullFile')

Optionally, you can change all patches currently showing as 'Not Applicable' to 'pending user acceptance' via the following which might be more relevant to you:

UPDATE ca_install_package SET status=3
WHERE status=2

Status 2 equals 'Not Applicable'...

[pucjo01]

Please note that while the above works, the change is not permanent. Every time the evaluation process runs these items will revert to 'Not Applicable'. Luckily the evaluation I refer to runs only once a day, at 12:30AM by default, so running this will allow any patch to be downloaded until the next day.

Also, any patch that gets accepted will stay accepted, packaging, testing, approved etc...

ONLY packages in the 'pending user acceptance' state can revert when the midnight process runs, so there should be no barrier to accepting as many patches as you need to when you're ready.