Export Profile Manager database

1 vote

0 answers

625 views

macos server.app profile-manager postgresql

                          Good morning,
I have an old Apple server with macOS 10.12 and Server.app version 5.3

Now I need export the information about devices with DeviceName, SerialNumber and ICCID (for iPad)

I found some thread with command for read information with PostgreSQL, but no one with ICCID information.

Someone know the correct select command?
I found this:

1 - connect to the database

    sudo psql - U _devicemgr d devicemgr_v2m0 h/Library/Server/ProfileManager/Config/var/PostgreSQL

2 - If you want the names and serial numbers, use

    Select "DeviceName", "SerialNumber" of devices;

I try to use:

    Select * from devices;

And I see the title of the DB columns listed, but none traceable to ICCID...
Any help?

Thanks

Asked by fvadmin (21 rep)

Mar 31, 2021, 11:35 AM

Export Profile Manager database

Related Questions