Alarm on MonitorId, ZoneId

Forum for questions and support relating to the 1.27.x releases only.
Locked
liderbug
Posts: 125
Joined: Wed Dec 19, 2007 4:46 pm

Alarm on MonitorId, ZoneId

Post by liderbug »

It's probably out there - but something about the trees for the forest...

When the UPS truck shows up, I'd like my X10 doorbell to ring.

Monitor: Driveway
Zones: 4
Subzone: UPS[id 16] - where the UPS (et-al) truck parks

FilterName: UpsIsHere
Monitor Hame: = Driveway
+ here's where I'm stuck - how do I select Zone=16
Execute command: ... send X10 turn D1 on (doorbell) to another computer (works)

Thanks
Last edited by liderbug on Tue Oct 28, 2014 6:47 pm, edited 1 time in total.
liderbug
Posts: 125
Joined: Wed Dec 19, 2007 4:46 pm

Re: Alarm on MonitorId, ZoneId

Post by liderbug »

I've kinda of answered my own question by going throught zmfilter.pl.
my $sql = "select M.Id, cou... only looks at MonitorId >> where MonitorId = ?
No Zone at all.and the DB, Event table, has MonitorId no ZoneId. So it looks like
not a 5 minute fix - at least for me - speak SQL, C - not perl although...

Request for enhancement.

Tnanks
Chuck
liderbug
Posts: 125
Joined: Wed Dec 19, 2007 4:46 pm

Re: Alarm on MonitorId, ZoneId

Post by liderbug »

Took a while, but reading code and doing select ... from... I have my answer

Create a zone with name 'UPS' covering the area where UPS/FedEx/RuthAnn parks.
Create filter:
[UpsIsHere]
[Alarm Frames] [greater than] [10]
[and] [Notes] [equal to] [Motion: UPS]
[Sort by [date/Time] [Desc]
[Limit to first] [ 1 ] only
[Execute..] [x] [drivealarm.sh]
Save, name, set background.

drivealarm.sh sends an command to my ARM box running Heyu, turn d4 on. Ding-dong, ding-dong. (which causes 'Woof! Woof! Bark! Woof! Bark!.....)
Locked