Ok Banister there are two ways to run a query, the Studio way and the Dashboard way.

To run a database query, go to Studio > Accounts > Manage 

In the first text box you will see "All Statuses," click that and select "Unconfirmed" and then in the middle text box select "All."  There are two export buttons to use, one says "Export All," and the another one on the bottom button's menu, that says "Export."  I am thinking one of those export functions will only be the Unconfirmed accounts, so download both.

You can also select the names with the checkboxes, on the left and click "Resend Confirmation."  This might be easier than sifting through the exported files, but you might want to look at the export files structure.

And so, the other way is to use the "Dashboard," in your top level profile menu using the Protean theme or the sidebar menu using the Artificer theme.  And then select "Accounts," (Dashboard > Accounts) which gives you the same thing as the Studio Accounts Module.

Let us know how this works, I have never done it, but appreciate running it down, because I will need to use it sometime myself.