There are two parts to this that you should be aware of. The first is that that Adobe Analytics only allows for 500,000 unique dimension values per month in the UI. So you may find that storing your URL's without query strings will stop this problem in future - unless you really have over 500k active pages on your site!
Other than that your best bet (assuming you don't have a data lake) is to setup an data feed for a weeks worth of data containing only the essential fields and do the discovery in SQL. I believe you need: