We have thousands of LPs that need to be decommissioned, can anyone suggest what is the best way to decommission them in a automated way?
By decommission, you mean unapprove or do you want those to be redirected to some other link?
I was also trying to do something similar recently. The only way i found is to use the API. Let me know what exactly you are trying to achieve here, will try to help you out.
If you are trying to unapprove them you can now perform bulk actions in Marketo Sky: Local Assets: Mass Actions – Marketo Help Center
Second this! We just went through and unapproved a bunch of pages in Sky.