Event & Device Activity Log - does a plugin exist?

I know it can be done with Vera Alerts but…
I have no need for it on my phone
I want to see/use it on a pc which allows me to use excel to sort/graph/report as desired in a millisecond
I also don’t want to touch every item to make sure it is logged… and then every item I ever add/change. This is tedious.

I guess I’ll just pull the full vera logs and clean them with excel. I just figured that since there were a few apps that did something similar it would be easy for the developer to add this functionality. There is an app that displays the full vera log in a web page… that would be great to mod, but I just don’t have time to learn the code since I’m starting a totally new job that I also have to learn.

Sent from my SGH-I747 using Tapatalk 2

[quote=“Aaron, post:14, topic:175433”]Every Device & Automation Event… as I provided in the examples above.

This is the ONLY way to see a true ‘activity log’ and assist with troubleshooting Automation events.

Vera already logs everything, yes? What is really needed is a human readable version of it with all the ‘garbage’ removed.[/quote]

When you say “every” device, can we interpret this to mean “a single variable from one specified service in each device” ?

That is, for example:

[ul][li]category 3, “urn:upnp-org:serviceId:SwitchPower1”, “Status”[/li]
[li]category 4, “urn:micasaverde-com:serviceId:SecuritySensor1”, “Tripped”[/li]
[li]category 16, “urn:micasaverde-com:serviceId:HumiditySensor1”, “CurrentLevel”[/li]
[li]category 17, “urn:upnp-org:serviceId:TemperatureSensor1”, “CurrentTemperature”[/li]
[li]category 18, “urn:micasaverde-com:serviceId:LightSensor1”, “CurrentLevel”[/li]
[li]etc…[/li][/ul]

this should provide an adequate window onto the functioning and interaction of most devices.

The problem being that, otherwise, there are a LOT of devices, a LOT of services, and a LOT of variables, most of which are really not relevant at all. Unless you are wanting to debug something particularly bizarre, this should cover most needs. I’m adding the functionality to do this to the EventServer code, which runs locally to Vera.

@Aaron

I think we’re after similar things, and you may have seen a thread I’ve been running → http://forum.micasaverde.com/index.php/topic,16713.0.html

My approach was to work with the existing Alternative Event Server and to benefit from using a relational database, however (and someone correct me if I’m wrong), by using luup.variable_watch you could theoretically set it up to write what you want, where you want it.

Another example I have is that I recently install CIFS support on my Vera and have bee n playing with opening a text file up on an external NAS and writing ‘human’ information to it.

Not sure how much of all that helps you, but thought I’d share :wink:

I use this to monitor, real-time, when needed…
http:///port_3480/data_request?id=lr_al_log&app=localApp

… If we could find an easy way to save the output to a CSV file we could clean it up using Excel. Ideally, there would be a page just like this, already cleaned, that we could both monitor in real time and save to CSV.

[quote=“Aaron, post:24, topic:175433”]I use this to monitor, real-time, when needed…
http:///port_3480/data_request?id=lr_al_log&app=localApp

… If we could find an easy way to save the output to a CSV file we could clean it up using Excel. Ideally, there would be a page just like this, already cleaned, that we could both monitor in real time and save to CSV.[/quote]

Changing the formatting is the easy bit, it’s the data collection that’s a bit tougher.

I currently have this sort of output:

02-10-13 22:36:37 : [253]Studio Window, Tripped = 0
02-10-13 22:36:37 : [259]Garage Door, Tripped = 0
02-10-13 22:36:37 : [262]Shed Door, Tripped = 0
02-10-13 22:36:37 : [282]Studio 4-in-1 (motion), Tripped = 0
02-10-13 22:36:53 : [284]Studio 4-in-1 (temp), CurrentTemperature = 16
02-10-13 22:36:53 : [283]Studio 4-in-1 (light), CurrentLevel = 4
02-10-13 22:37:00 : [324]Garage - Temperature, CurrentTemperature = 16.5
02-10-13 22:37:15 : [207]Front Door, Tripped = 0
02-10-13 22:37:15 : [235]Barn Door, Tripped = 0
02-10-13 22:37:15 : [277]Hall 4-in-1 (motion), Tripped = 1
02-10-13 22:37:15 : [294]Barn 4-in-1 (motion), Tripped = 0
02-10-13 22:39:51 : [181]Study Ceiling, Status = 0
02-10-13 22:39:51 : [297]Barn 4-in-1 (humidity), CurrentLevel = 67

Is the subset of information I outlined on the previous post sufficient for your needs?
…being able to watch the major variable for every device in each device category?

[quote=“Aaron, post:24, topic:175433”]I use this to monitor, real-time, when needed…
http:///port_3480/data_request?id=lr_al_log&app=localApp[/quote]

If I try that I receive

No handler

I’m so happy to see that there are other people that want this feature.

As I come from homeseer I was quite surprised that this is not included in Vera by default. The Log page is the one thing I miss the most from Homeseer.
The other thing I miss is a list of devices that show the current status and the timestamp of the last change like in the attachment.

Those 2 pages are basicly what I used mostly during my years of homeseer since I want things to work automaticaly and the need to interact with the controller is basicly when you need to modify an “event” (as they are called in homeseer) now I call them PLEGs :smiley: When you modify something you need to know what is hapening and when.

[quote=“parkerc, post:26, topic:175433”]If I try that I receive

No handler

I think this is actioned by the LogViewer app, so you have to have that installed?

[quote=“korttoma, post:27, topic:175433”]As I come from homeseer I was quite surprised that this is not included in Vera by default. The Log page is the one thing I miss the most from Homeseer.
The other thing I miss is a list of devices that show the current status and the timestamp of the last change like in the attachment.[/quote]

Fully agree. One of the first things I wrote when I got Vera was some utility code which runs every 5 minutes (because that seemed often enough) and produces reports of device by category in two forms…

Current status:

03-Oct-2013 09:14:09

Light sensors: 
  57Lx Barn 4-in-1 (light)
  48Lx Hall 4-in-1 (light)
 107Lx Studio 4-in-1 (light)

Temperature sensors: 
  18'C Barn 4-in-1 (temp)
  16'C Garage - Temperature
  15'C Garage Temperature
  17'C Greenhouse Temperature
  20'C Guest - Temperature
  23'C Hall 4-in-1 (temp)
  20'C High Temperature
  20'C Indoor - Temperature
  15'C Low Temperature
  17'C Max/Min Temp (greenhouse)
  16'C Outdoor - Temperature
  15'C Shed Temperature
  17'C Studio - Temperature
  17'C Studio 4-in-1 (temp)
  17'C Studio Temperature
  15'C Temperature
  15'C Temperature Statistics

Humidity sensors: 
  68%  Barn 4-in-1 (humidity)
  83%  Garage - Humidity
  90%  Garage Humidity
  87%  Greenhouse Humidity
  62%  Guest - Humidity
  45%  Hall 4-in-1 (humidity)
  99%  Humidity
  74%  Indoor - Humidity
  96%  Outdoor - Humidity
  90%  Shed Humidity
  77%  Studio - Humidity
  64%  Studio 4-in-1 (humidity)
  74%  Studio Humidity

Time of last change:

03-Oct-2013 09:14:09

Thursday, Oct 03: 
  09:14:03 Front Door
  09:13:27 Barn 4-in-1 (motion)

Wednesday, Oct 02: 
  19:00:55 Studio 4-in-1 (motion)
  18:57:03 Studio Door
  18:56:25 Studio Window

Monday, Sep 30: 
  18:34:02 Shed Door
  13:09:42 Garage Door

Tuesday, Aug 13: 
  07:21:07 Hall 4-in-1 (motion)

Thursday, May 16: 
  11:59:01 Barn Door

These all get written to a subdirectory of /www/ so can be viewed from within my firewall by any web browser.
I’m about to migrate these scripts into the EventServer device.

[quote=“akbooer, post:28, topic:175433”][quote=“parkerc, post:26, topic:175433”]If I try that I receive

No handler

I think this is actioned by the LogViewer app, so you have to have that installed?[/quote]

I already have the info viewer app installed (which I think is the same), but considering what you have shared @akbooer I do like what you are showing

Side note - I wrote a post to @gengen earlier about the info viewer app to see where that might go… (http://forum.micasaverde.com/index.php/topic,13477.msg129624.html#msg129624) And now with this in mind too - which is great stuff - it would be great for users to have all these types of reports/views accessible via one web dashboard…