반응형
Synology Video Station User Logs
cd /volume2/XTRM_DSM/_VideoStation/
mkdir `date +%Y%m%d`
echo 사용자번호_사용자명 >> /volume2/XTRM_DSM/_VideoStation/`date +%Y%m%d`/사용자명_`date +%Y%m%d`.txt;
psql -U postgres -d video_metadata -c "select (select path from video_file where id =video_file_id) from watch_status where uid = 사용자번호" >> /volume2/XTRM_DSM/_VideoStation/`date +%Y%m%d`/사용자명_`date +%Y%m%d`.txt;
--------------------------
관리자 권한 : sudo -i
사용자 목록 : cat /etc/passwd
DB접근 : su postgres
DB선택 : psql video_metadata
명령어 : select (select path from video_file where id =video_file_id) from watch_status where uid = 1234;
반응형
'시놀로지ㆍNAS > 데이터베이스' 카테고리의 다른 글
시놀로지 다운로드스테이션 RSS 백업 복원 (Synology Download Station RSS) (0) | 2021.04.25 |
---|---|
RSS Backup (Download Station RSS Backup script) (0) | 2021.04.23 |
Download Station Auto Delete - content (0) | 2021.04.23 |
Download Station Auto Delete (0) | 2021.04.23 |
댓글