Changeset 17529 for trunk/DataCheck/Monitoring

Timestamp:

01/21/14 01:35:09 (11 years ago)

Author:

Daniela Dorner

Message:

minor changes in db query

File:

• trunk/DataCheck/Monitoring/CheckNTPDate.sh (modified) (1 diff)

trunk/DataCheck/Monitoring/CheckNTPDate.sh

@@ -6 +6 @@
 
 offset=`/usr/sbin/ntpdate -d ptbtime1.ptb.de 2>/dev/null | grep '^offset*' | cut -d' ' -f2`
-query="INSERT NTPDate set fOffset="$offset", fMachineKEY=(SELECT fMachineKEY from Machine WHERE fMachineName='"$HOSTNAME"'), fTime=Now()"
+query="INSERT NTPDate SET fOffset="$offset", fMachineKEY=(SELECT fMachineKEY FROM Machine WHERE fMachineName='"$HOSTNAME"'), fTime=Now()"
 # host needs full address to work also on fact01
-/usr/bin/mysql -u systemstatus --host=fact01.fact.local SystemStatus -e "$query"
+/usr/bin/mysql -u systemstatus --host=fact01.fact.local systemstatus -e "$query"
 
 if [ $(echo " $offset > 1  ||  $offset < -1 " | bc) -eq 1 ]