This is my output, Please help me. I want  to get copy and restore also

I want to copy and restore output, please modify script and help me...   Thanks in advance

 This is output, I want add secondary server output also

Here two scenarios,  I want to check daily size of log backup's in log shipping and i want to monitor hourly log backup size

above script for daily, you mention -1 (for hourly)

select subquery.DATABASE_NAME,
SUM(bkSize_KB) as SumBkSize_KB,
SUM(bkSize_MB) as SumBkSize_MB,
SUM(bkSize_GB) as SumBkSize_GB
from
(
SELECT 
A.[Server],
A.DATABASE_NAME, 
A.last_db_backup_date, 
B.backup_start_date, 
B.expiration_date, 
CAST(b.backup_size / 1000 AS INT) AS bkSize_KB,
CAST(b.backup_size / 1000000 AS...

I want log backup size in hourly/daily (sum of size)  in log shipping. Historically last 10 days.

I want this pattern output in primary server log shipping.

Above script showing only hourly, I want calendar date and hourly and day wise

select subquery.DATABASE_NAME,
   SUM(bkSize_KB) as SumBkSize_KB,
   SUM(bkSize_MB) as SumBkSize_MB,
   SUM(bkSize_GB) as SumBkSize_GB
from
(
   SELECT
    A.[Server],
    A.DATABASE_NAME, 
    ...