How to bulk update KB article valid to dates to specific dates

[Khalnayak]

HI there,

I have been tasked to update the valid to date of over 1000 KBs.

I have a spreadsheet containing the columns of current valid to date and new valid to date.

What script do I need to run to update each KB with it's unique new valid to date.

As each KB will have different valid to date,  I can't simply set the same date for all of them.

Please help.

[Khalnayak]

Thanks Ankur, I was hoping for a simpler solution.

Just to confirm, we can't do this via a fix script?

[Ankur Bawiskar]

Hi Usmaan,

One time schedule job or fix script should be fine.

It's just that you should know for which KB Numbers the script should run and if all the KBs should have same Valid to date then it makes sense running script rather than Data Source and transform map approach.

If every KB has different Valid to date then better to go with Data source approach.

Regards
Ankur