Migrating User & Menu Security from Pilot to Production

We’re on 10.2.300. I would like to migrate user security from Pilot to Production systems. I was able to get a good start utilizing the user template in DMT. For Menu Security, where can I export that data from Pilot?

You can do this with a BAQ.

[Security].[Company] as [Security_Company],
[Security].[SecCode] as [Security_SecCode],
[Security].[EntryList] as [Security_EntryList],
[Security].[SecurityMgr] as [Security_SecurityMgr]
from Ice.Security as Security

I would have these columns are my starting point, then any others required for your environment.