For Ex: 1-59/10 * * * * root /usr/bin/nice -n20 /root/interfase-tester/renew_wan0.sh 5-59/10 * * * * root /usr/bin/nice -n20 /root/interfase-tester/renew_wan1.sh 7-59/10 * * * * root /usr/bin/nice -n20 /root/interfase-tester/renew_wan2.sh Line 1: 01/11/21/31/41/51 Line 2: 05/15/25/35/45/55 Line 3: 07/17/27/37/47/57
After a lot of work, trying to figure this out, the problem is related with the “rotation” column on the “campaign_leads” table. When you manually remove a contact from the campaign manually (meaning through the web interface), then the change is reflected on the “campaign_leads” table specifically on the “manually_removed” column. Then, when […]
Based on Row Size SELECT TABLE_SCHEMA, table_name, table_rows FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ‘**Table NAME**’ ORDER BY table_rows DESC; Based on Table Size (MB) SELECT table_schema as `Database`, table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC
URL Format: http://192.168.5.229:32400/web/ Create Shared Folder with NAS # Mounting Network Directory for Plex //192.168.5.201/volume1/Plex /var/plex/media cifs uid=999,gid=999,credentials=/var/lib/plexmediaserver/.mountaccess,iocharset=utf8 0 0 sudo mount 192.168.1.214:/volume1/Downloads /media/NAS/Downloads $sudo mount -t nfs 192.168.1.254:/volume1/system76 /mnt/system76 \ sudo mount -t nfs 192.168.5.201:/volume1/Plex /var/plex/media
Go to Window Tab & Field on the System Role search for your desired document (in my case Purchase Order) and on the {{Sql WHERE}} field add your condition. In my case: C_Order.IsSOTrx=’N’ AND C_Order.em_mg_procurement=’Y’