I would use Azure Resource Graph (ARG) for this for info about the Workspaces, there is a good built-in example query you can use or edit:
From the Azure Portal --> Log Analytics workspaces --> "Open Query" --> then press [Run Query]
You can select "All subscriptions" or the required ones
