How to list ALL subscription with spaces at subscription name

[AntonyS]

Question: We are trying to extract subscriptions which has spaces at Subscription name or Customer Subscription name fields. We are trying to giving the condition % followed by space but it could not get the results.

[AntonyS · Accepted solution]

Answer:

• Verify the tenant
• Select Reporting-->Data Source-->Subscription->filter-->>Subscription.Name(text)-->>Apply conditions.
• Click and save

The exact condition is operator as ‘’like ‘’and the value as ’’ % %’’.

The above condition is used to extract subscription which has spaces at subscription name fields.