@Saira You don't need automation for this, it can be more or less collected with a CQL search.
The query should be something like this:
creator in ("111", "222")
...where "111" and "222" are the IDs of the disabled user accounts. (Unfortunately, CQL cannot test for the "state" of the user account, so you need to collect the IDs for yourself.)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.