Identify which viewports use a particular scale

[HFB]

I'm trying to work out which viewports are using an annotative scale and can't find any answers on the web.

We have a bunch of scales that are effectively the same, but they are separated by sheet so you can hide stuff on one sheet and show it on another at the same scale.

I'm wondering if there is a way to quickly identify which viewports (or at least the layout tab) the scales are used on, so that I can make sure I haven't doubled up on stuff. I've tried looking in the purge options, but can't see drawing scales as an item type, so I suspect there is no diesel code for them, and I know viewports are just given a random object name as they're created.

Rather than go from sheet to sheet (78 sheets), I'd like to be able to make a list or table that pulls the information from ALL viewports, including the name of the layout tab on which they appear. I've been getting into fields and diesel expressions and lisps (as much as LT25 can handle them), so I can probably get my head around one of those if it exists somewhere, but I'm not skilled enough to create something myself.

 

I am aware that how we set our scales and sheets etc up is not ideal, but I'm not after feedback on that. TIA