Hi All,
I was using this query which is bit successful in my case, i was trying to modify it in my way to get the desired result but failing.
Original query-
select entity as "Node", CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS "Backup_Size(MB)", start_time, end_time, Affected, Failed, Successful FROM summary WHERE activity='BACKUP' AND start_time>=current_timestamp - 24 hours AND END_TIME>=current_timestamp - 24 hours group by entity, start_time, END_TIME, Affected, Failed, Successful
It is working for me but I need to get the result in different way one rather than end can we get elapse time and another one is how we can define specific dates rather then giving 24 hours or day.
like if i need to get the result from 2018-11-12, 18:00:00 to 2018-11-13, 17:59:00
Modify Query-
select entity as "Node", CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS "Backup_Size(MB)", start_time, end_time, Affected, Failed, Successful FROM summary WHERE activity='BACKUP' AND start_time >{'2018-11-12 18:00:00'} AND start_time <{'2018-11-13 17:59:00'}
------------------------------
Prem Singh
------------------------------
Original Message:
Sent: 11-14-2018 07:18 AM
From: Prem Singh
Subject: Unable to get the end time in Summary report
Hi Lynn,
Thanks it worked for me, All of you thank you so much for contributing ! Cheers
--
Original Message------
select entity as "Node", CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS "Backup_Size(MB)", start_time, end_time, Affected, Failed, Successful FROM summary WHERE activity='BACKUP' AND start_time>=current_timestamp - 24 hours AND END_TIME>=current_timestamp - 24 hours group by entity, start_time, END_TIME, Affected, Failed, Successful
End_time has to be in the Group by clause.
And, you can't get a start time >= current_timestamp. So you need to have a minimum of "- 1 hours" though -24 gives you at least anything that started and ended in the last 24 hours.
Lynn Hall
Infrastructure Services Division
Hosting Services Team
Office of the Chief Information Officer
State of Iowa
Mobile: 515-669-4325
lynn.hall@iowa.gov
No employee or agent of the department or the State of Iowa is authorized to enter into a contractual agreement on behalf of the department or the State of Iowa with another party by email without the express written consent of the director of the department. This electronic communication (including any attachments) is covered by the Electronic Communication Privacy Act, 18 U.S.C. @@ 2510 - 2521, is confidential and is intended solely for the use of the individuals or entities to whom the email is addressed. If you receive this email in error, any review, use, dissemination, distribution, copying, or storing of the email or its attachments is prohibited. Notify me immediately of the error by return email, and delete this message from your system. Any views or opinions in this email are the author's and do not necessarily represent the views or opinions of the department or the State of Iowa.
#Storage
#StorageManagementandReporting
#PrimaryStorage