#!/usr/bin/python

from optparse import OptionParser
cmdline = OptionParser()
cmdline.add_option( "-s", "--siteid", dest="siteID", default=0, type="int", help="site to examine" )
cmdline.add_option( "-w", "--warning", dest="warning", default=60, type="int", help="warning level" )
cmdline.add_option( "-c", "--critical", dest="critical", default=1440, type="int", help="critical level" )
(options, args) = cmdline.parse_args()

if options.siteID:
    siteID = options.siteID

if options.warning:
    warn = options.warning

if options.critical:
    crit = options.critical

if not siteID:
        print "SiteID Needed"
        exit (6)

import _mssql
conn = _mssql.connect(server='192.168.55.100', user='user', password='password', database='db')

res = conn.execute_scalar('nagios_GetMinutesSinceLastReading @siteid=%d', siteID)

if res < warn:
        print "OK: %d" % res
        exit (0)

if res > warn < crit:
        print "WARNING: %d" % res
        exit (1)

if res > crit:
        print "CRITICAL: %d" % res
        exit (2)

conn.close()