mydate=`date +"%m/%d/%Y -%H:%M:%S"` current_time=$(date "+%Y.%m.%d-%H.%M.%S") mytime=`date +%T` USER=anirban PW=Bose9711 filename="/var/lib/mysql-files/VFS_Ticket_data.csv" rm -rf "/var/lib/mysql-files/VFS_Ticket_data.csv" reportname="/tmp/VFS_Ticket_data_$current_time.csv" mysql -u$USER -p$PW -e"call onedirect.get_export_to_excel_summary(8112,current_timestamp - interval 2 hour,current_timestamp)">/var/lib/mysql-files/VFS_Ticket_data.csv mv /var/lib/mysql-files/VFS_Ticket_data.csv $reportname echo " ****TRANSFER START**** " echo $reportname azcopy cp "$reportname" "https://prjdwuatadls.dfs.core.windows.net/vfsbiproject?sp=rwle&st=2022-08-05T05:47:28Z&se=2022-09-05T13:47:28Z&spr=https&sv=2021-06-08&sr=c&sig=GuyhDRcueFwQUdtL7%2FQ%2Bq5IdRFnd3QKpud1dusF%2Bu0E%3D" echo " ****TRANSFER END**** "
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter