Hi,
For replication report purpose, I found this select :
select node_name, fsname, start_time, end_time,comp_state,BKBYTES_REPLICATED,BKBYTES_TRANSFERRED from replicationview where start_time>=(current_date) order by node_name desc
it's works, but i would like to have value of "BKBYTES_REPLICATED,BKBYTES_TRANSFERRED" from bytes to GB,
i tried to used "" , but i found some difficult to integrate that on sql , sorry not really well understand how integrate correctly cast on sql command with many tables ?
thanks for helps,
For replication report purpose, I found this select :
select node_name, fsname, start_time, end_time,comp_state,BKBYTES_REPLICATED,BKBYTES_TRANSFERRED from replicationview where start_time>=(current_date) order by node_name desc
it's works, but i would like to have value of "BKBYTES_REPLICATED,BKBYTES_TRANSFERRED" from bytes to GB,
i tried to used "" , but i found some difficult to integrate that on sql , sorry not really well understand how integrate correctly cast on sql command with many tables ?
thanks for helps,