adding device log indicators to aggregate tables