tsmguy
Active Newcomer
- Joined
- Sep 29, 2010
- Messages
- 6
- Reaction score
- 1
- Points
- 0
Hi,
Could someone assist me in adjusting this select to pull for TB instead of MB?
SELECT n.platform_name, DATE(s.START_TIME) AS Date, (CAST(FLOAT(SUM(s.bytes))/1024/1024 AS DECIMAL(12,2))) AS DAILY_MB from summary s inner join nodes n on s.entity = n.node_name where activity='BACKUP' or activity='ARCHIVE' GROUP BY n.platform_name, DATE(S.START_TIME) order by 1,2
Also would there be a way to specify how many days to go back with this type of select statement?
TIA!
Could someone assist me in adjusting this select to pull for TB instead of MB?
SELECT n.platform_name, DATE(s.START_TIME) AS Date, (CAST(FLOAT(SUM(s.bytes))/1024/1024 AS DECIMAL(12,2))) AS DAILY_MB from summary s inner join nodes n on s.entity = n.node_name where activity='BACKUP' or activity='ARCHIVE' GROUP BY n.platform_name, DATE(S.START_TIME) order by 1,2
Also would there be a way to specify how many days to go back with this type of select statement?
TIA!