Returns every cloud subscription registered in the organization, optionally narrowed to one provider,
with provider identifiers, lifecycle state, and owning tenant.
Rows carry the subscription ID that per-subscription operations require, and describe registration rather than
contents: no host pools, no resources, and no live credential health.