No, your company cannot get a list of these unmanaged Box accounts after your enterprise agreement has expired. Box considers these to be personal accounts, and due to data privacy policies, it cannot share that information. The email is a standard, automated notification designed to encourage you to re-engage and start a new enterprise agreement, which would allow you to regain administrative control and manage or migrate those accounts.
