i am trying to get daily consumption from smartmeter table for each week from aws timestream but its returning all the data thats the smartmeter has used SELECT
date_trunc(‘week’, CURRENT_DATE),
meter_id,
MAX(CASE WHEN measure_name = ‘ActEnPosT1’ THEN measure_value::varchar END) AS value_actenpost1_10m
FROM
“mykrogrid”.”smart_meter1.0″
WHERE
time BETWEEN ago(24h) AND NOW()
AND measure_name = ‘ActEnPosT1’
GROUP BY
date_trunc(‘day’, time),
meter_id`;

Configuring Postfix to Send Email via Simple Email Service (SES) 1. Install and Configure Postfix Ensure that Postfix is installed on your server. If not, you can install it using your package manager. On Ubuntu, you can install Postfix with: sudo apt-get update sudo apt-get install postfix During installation, you may be prompted to choose […]

We are monitoring the server health through a custom monitoring agent, would like to know if server responds to agent ping to know the status. TO monitor the status checks is it required to enable a CloudWatch metrics, or will the server respond to the agent ping?

Going through AWS documentation, it has following to say on dedicated host:

After completing the test via apic on my laptop, I put it up as a docker container on awsec2 Ubuntu server, but it doesn’t connect.

I have configured my load balancer, target group and created an entry in Route 53.
The certificate is not expired, I received it today.
In the security group I opened ports 80 and 443 for everyone.