Indigo Domotics

Hi All,

I switched to PostgreSQL some time back and in truth don't ever go near it. I have a need to find a particular device history for a period of about 6 hrs back in August. Just to add some background to the request, the local police decided to inform me today that they arrested a drunk driver on my property back then and NOW want me to give them written permission for being on my property. Strange, very strange. I still haven't invested in cameras, which will be rectified very soon. However I have a beam sensor on my driveway entrance, I now want to query that device for a set period. I have next to no knowledge of SQL but would love some help.

TIA - Colly

You can use indigo utilities to query the dB

You have to know the name of the device rest should be self explaining.



Sent from my iPhone using Tapatalk

I use pgAdmin4 to query it. Simple to pull the whole table and dump to excel, or restrict the SQL to the date range you want.


Sent from my iPhone using Tapatalk

Thanks to both of you for your replies.