Obtain both active and inactive stocks on an exchange using Datastream

Hello,

I'm trying to obtain both active and inactive/delisted stocks on a few exchanges, let's say the NYSE and Deutsche Börse. The period doesn't matter, I'll take everything and deal with that later.

I'm aware that this isn't possible on Eikon, both thanks to this thread and also from using the Screener in the Eikon application, as explained in this thread (and I've tried this myself now just to make sure).

I then tried with Datastream, and found that I can obtain the companies I need manually, via a Static Request, clicking around to filter equities, inactive, etc. build a list in Excel, and keep doing this manually until I build up the list of companies that I want. This is quite time consuming though, and I'm trying to find an equivalent way to do this using the Python API connecting to DatastreamWS.

Is this possible? Can you please explain how, using an example? I've tried looking this up in the API documentation but unfortunately cannot find how to do this.

Thank you very much in advance