May 25, 2017 at 3:26 am
I would like to find the difference for any two past 30 days i.e if I select date1 as 5/24/2017 then date2 should current date - 30 days for all Servers. How do I do this ? Whatever I select current date(date1) to be date 2 should be selected as 30 days prior to it for all servers.
Ex: I select date1 as 12/24/2017 then date 2 should be autoselected as 11/24/2017 and the corresponding difference between Currentsize and previous should be calculated and result should be displayed under ServerSizeDifferenceinMB column.
Servername1 date1 date2 CurrentSize PreviousSize ServerSizeDifferenceinMB
ServerA 5/24/2017 5/23/2017 100000 90000 10000
ServerB 5/24/2017 5/23/2017 200000 100000 100000
ServerC 5/24/2017 5/23/2017 3000 2000 1000
May 25, 2017 at 9:12 am
create a table to store these statistics and create a job to run it daily.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply