Thanks again so much for your replies! One thing I noticed is that when I run the SQL marclant listed directly above, one of the results I get is NULL in the entity field. I am trying to figure out why there would be a NULL value in the entity (NODE) field. Here are three results from the above output:
NODE:
FILES: 114427
NODE: NODEF
FILES: 44312
NODE: NODEG
FILES: 81450
So I took a look at the summary table and did a select for entity, address and sure enough there are 19 entries where entity is null for multiple addresses. Because of sum(affected), the above select statement is summing items with entity=null, which would mean those items are not being listed properly with their respective hostnames.
Here is what I mean:
select ENTITY,ADDRESS from summary where activity='BACKUP' and ENTITY is NULL
ENTITY:
ADDRESS: nodea.blabla.com:1250
ENTITY:
ADDRESS:nodeb.blabla.com:3553
ENTITY:
ADDRESS: nodec.blabla.com:2350
So, the SQL works pretty well, but does not properly handle items with ENTITY=NULL.
What does ENTITY=NULL even mean and how does it get there? It doesn't seem to make any sense to me but I'd like to somehow get ENTITY=NULL entries accurately listed in the SQL too. Or maybe I can make a change to how the nodes are defined which would then populate the entity field as expected?