Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- DATABASE=devicemgr_v2m0
- USERNAME=_devicemgr
- HOSTNAME=/Library/Server/ProfileManager/Config/var/PostgreSQL
- psql -h $HOSTNAME -U $USERNAME -d $DATABASE -c "COPY devices TO STDOUT WITH CSV HEADER " > /Volumes/Adsoft/student_db_export/profilemanager/devices.csv
- psql -h $HOSTNAME -U $USERNAME -d $DATABASE -c "COPY device_groups TO STDOUT WITH CSV HEADER " > /Volumes/Adsoft/student_db_export/profilemanager/device_groups.csv
- psql -h $HOSTNAME -U $USERNAME -d $DATABASE -c "COPY device_group_memberships TO STDOUT WITH CSV HEADER " > /Volumes/Adsoft/student_db_export/profilemanager/device_group_memberships.csv
- psql -h $HOSTNAME -U $USERNAME -d $DATABASE -c "COPY device_groups_devices TO STDOUT WITH CSV HEADER " > /Volumes/Adsoft/student_db_export/profilemanager/device_groups_devices.csv
- psql -h $HOSTNAME -U $USERNAME -d $DATABASE -c "COPY users TO STDOUT WITH CSV HEADER " > /Volumes/Adsoft/student_db_export/profilemanager/users.csv
- psql -h $HOSTNAME -U $USERNAME -d $DATABASE -c "COPY user_groups TO STDOUT WITH CSV HEADER " > /Volumes/Adsoft/student_db_export/profilemanager/user_groups.csv
- psql -h $HOSTNAME -U $USERNAME -d $DATABASE -c "COPY device_group_memberships TO STDOUT WITH CSV HEADER " > /Volumes/Adsoft/student_db_export/profilemanager/user_group_memberships.csv
- psql -h $HOSTNAME -U $USERNAME -d $DATABASE -c "COPY device_group_memberships TO STDOUT WITH CSV HEADER " > /Volumes/Adsoft/student_db_export/profilemanager/user_groups_users.csv
- psql -h $HOSTNAME -U $USERNAME -d $DATABASE -c "COPY installed_ios_applications TO STDOUT WITH CSV HEADER " > /Volumes/Adsoft/student_db_export/profilemanager/installed_ios_applications.csv
- psql -h $HOSTNAME -U $USERNAME -d $DATABASE -c "COPY edu_classes TO STDOUT WITH CSV HEADER " > /Volumes/Adsoft/student_db_export/profilemanager/edu_classes.csv
- psql -h $HOSTNAME -U $USERNAME -d $DATABASE -c "COPY edu_classes_library_items TO STDOUT WITH CSV HEADER " > /Volumes/Adsoft/student_db_export/profilemanager/edu_classes_library_items.csv
- psql -h $HOSTNAME -U $USERNAME -d $DATABASE -c "COPY edu_devices_users TO STDOUT WITH CSV HEADER " > /Volumes/Adsoft/student_db_export/profilemanager/edu_devices_users.csv
Advertisement
Add Comment
Please, Sign In to add comment
