cctvQL — Scheduled Camera Report
Send a scheduled plain-English summary of camera activity as a notification — perfect for a nightly security digest or morning briefing. At a configured time, this blueprint asks cctvQL a natural-language question and delivers the answer to any notify target.
Works with Frigate, Hikvision, Synology Surveillance Station, Dahua, Milestone XProtect, ONVIF, and Scrypted.
Prerequisites: A running cctvQL server + the cctvQL HA integration (HACS). Source and setup: github dot com/arunrajiah/cctvql
Features
- Time-based trigger (any time of day)
- Fully customisable query — ask about all cameras or a specific one
- Configurable notification target and report title
Blueprint source
blueprint:
name: cctvQL — Scheduled Camera Report
domain: automation
author: arunrajiah
homeassistant:
min_version: "2024.1.0"
input:
schedule_time:
name: Report Time
selector:
time:
default: "07:00:00"
query:
name: Query
selector: {text: {}}
default: "Give me a summary of all camera activity overnight."
notify_target:
name: Notification Target
selector: {text: {}}
default: notify.notify
report_title:
name: Report Title
selector: {text: {}}
default: "Daily Camera Report"
variables:
query: !input query
notify_target: !input notify_target
report_title: !input report_title
trigger:
- platform: time
at: !input schedule_time
action:
- service: cctvql.query
data:
query: "{{ query }}"
session_id: "blueprint-scheduled-report"
response_variable: cctvql_response
- service: "{{ notify_target }}"
data:
title: "{{ report_title }}"
message: "{{ cctvql_response.answer | default('No activity summary available.') }}"
mode: single