#!/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
Comments