HC3 Reference list / inventory list

[FBerges 52]

Hello

I'm looking for a way to create a reference list and / or inventory list!

I want to edit this later in Excel.

I read a lot but found nothing with which to create or create something like this.

Commands for file processing on an FTP / server / computer seem to be missing ?!

Did I not read it correctly again or is there no possibility?

Greetings Frank

 

[FBerges 52]

Well you're right there!
I hadn't seen it like that before and my knowledge is already too old.

The safety of the HC3 should be a high priority and not undermined.

I didn't know that Samba is such a sieve and that I so stubbornly true that I have to say SORRY!

 

Now that it is clearly clear what I want, is there a simple way to get such a logging done?
I would like to deal with it, but what is the best way to get there?
I would like to do without a subsystem like an RPi because all of this in combination is too difficult to handle and again becomes too complex.
With the one-sidedness from the HC3 to another system, I would also like to stay out of precisely security thinking.

 

If it is only possible via an SQL system, I will not pursue it any further because it is too complex for what I want to do.
Shooting at sparrows with a cannon is not effective!

 

If something like that does not work yet and should be implemented in the HC3 later, it would be great if the less experienced programmers would not forget that SQL is not for occasional programmers.
I would also like to count myself among them.

Greetings Frank

 

[petergebruers 1,268]

On 8/27/2020 at 8:55 PM, Martin_N said:

I once published an opinion here, the possibilities of using the SYSLOG logging system.

I would not say that I am qualified to talk about all the possible kinds of "logging" but I've done system maintenance of server systems so I do know a few things about logging...

 

The problematic part is... "What is logging"? Is that "every change on your Home Center"? Then how are you going to analyze it?

 

I would argue that the simplest solution is "Leave The Data Where It Is" - Your HC already has a memory (but it might be short).

 

The trouble is, at least with the HC2, that it limits "events" to about 14 days  on a 100 node network due to cleanup of the database.

 

An Idea for Home Center 4: add 128 GB of nvme storage so we can keep 5 years of data

 

I would argue that InfluxDB and similar products where built exactly to "ingest" large amounts of heterogeneous data.

 

Eg support floating point "temperature" but also support log style data... From their website

 

Please login or register to see this link.

 

InfluxDB supports Syslog network monitoring via the Telegraf Syslog Input Plugin, which allows Telegraf to ingest logs using the Syslog protocol. Telegraf converts the Syslog messages to line protocol to be written to InfluxDB, from which data can be queried in real-time for alerts using Kapacitor and visualized using Chronograf, Grafana, or other visualization tools.

 

But then why would HC log to syslog, have "telegraf" import that syslog into InfluxDB, when the line protocol of InfluxDB can directly accept messages from HC?

 

On 8/27/2020 at 8:55 PM, Martin_N said:

The safety of HC3 should not be compromised, it is a one-way data transfer.

No, but the security of the system running SYSLOG service would be compromised

 

On 8/27/2020 at 9:36 PM, 10der said:

my IMHO right way write all event from zwave and ZigBee in MQTT server 

Like "syslog" and "influxdb line protocol" that is mostly about transporting data from A to B and does not help query and analyse the data.

 

If you get your data into a (special) database like InfluxDB you have to think about on "how to structure" but then you can query your data and make nice graphs.

 

BTW I am tempted to check out a competing product:

 

Please login or register to see this link.

 

That is a layer on top of an existing database (PostgreSQL) which offers the benefits of (a) being real SQL and support stuff like "renames" which are not possible without trickery right now on InfluxDB 1.X (b) you probably have some other open source thingy that would like to have a SQL data store.

 

Edited September 1, 2020 by petergebruers