How much data is modified each day?

Hi Guys

I have a Windows 2008 Server, mainly used as file share. I currently run robocopy to backup to external hard drive, they want to backup to cloud so they don't have to rotate drives and take offsite.

I'm trying to find out how much data is modified each day so I know how much data transfer each night to cloud servers - tried using search by modified date period "modified:10/09/2013 .. 11/09/2013" but it shows entire folder
ErgsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Tony GiangrecoCommented:
Most cloud based backups offer a free 30 day trial. during that 30 day period, you should get a good idea of exactly what data is updated. I use two different cloud based backup vendors for different clients: Symantec and GFI. They both pull a full backup initially and then backup just the changed data.

Trying one of these services and reviewing the nightly backup report would probably answer your question most accurately.

Hope this helps!
0
arnoldCommented:
Enable logging on your robocopy task and the last lines reported will include the amount of data transferred/copied?
0
Kent DyerIT Security Analyst SeniorCommented:
Here is a PowerShell Script that I just cobbled together..

Should do the trick
$dir = "D:\users"
$files = Get-ChildItem -Path $dir -Recurse  | ? {(!($_.PSIsContainer))}
# verify if the list of source files is empty
#Checks to see if destination folders exist
foreach ($file in $files){
$lastWriteTime = (Get-Item $File).LastWriteTime
$d = [datetime](Get-ItemProperty -Path $file -Name LastWriteTime).lastwritetime
$today=get-date.Days
If ($d.days -eq $today) {
$total=$total+(Get-Item $File).Length
}
Write-host $total' Bytes modified'
}

Open in new window

HTH,

Kent
0
Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

ErgsAuthor Commented:
Thanks Kent, I have never used power shell.... what do I do with it?
0
arnoldCommented:
The short answer is the script looks through the denied directory d:\users looking for files that were written/modified today and then sum the size of these  files.
Add up the size of the files.
0
ErgsAuthor Commented:
Sorry I meant - how do I use it? do I copy all the lines in to a file and run it or do I have to use power shell?
0
Kent DyerIT Security Analyst SeniorCommented:
Sorry guys..
Unfortunately, I am running out of time to get to a meeting.  My previous PowerShell script has some issues..

Basically, you need to save to a text file and call it sizes.ps1 ..

fire up powershell
You may need to set powershell to allow scripts to be run
Navigate to where you saved sizes.ps1
type in sizes.ps1 <TAB>
PowerShell has built-in command-line completion..
just press <ENTER>

However, the scripts I provided need some tweaking.

ref..  http://technet.microsoft.com/en-us/library/ff730945.aspx

These are going to need some tweaking to work..
$dir = "D:\Users"
$colItems = (Get-ChildItem $dir -recurse | Measure-Object -property length -sum)  | ? { (!( $_.PSIsContainer )) } | where { $_.LastWriteTime.Date -eq (Get-Date).Date }
"{0:N2}" -f ($colItems.sum / 1MB) + " MB"

Open in new window


Or, you can try
$objFSO = New-Object -com  Scripting.FileSystemObject
"{0:N2}" -f (($objFSO.GetFolder("C:\Scripts").Size) / 1MB) + " MB"

Open in new window


HTH,

Kent
0
arnoldCommented:
Robocopy at the conclusion of the run reports the number f files and amount of data handled during copying process.
0
Kent DyerIT Security Analyst SeniorCommented:
I think arnold is right.  One of the keys of ROBOCOPY is to produce a report and not copy at all..  Sometime the simpler option is the best option.

From a command-line..
Robocopy /? shows..

/MAXAGE:n :: MAXimum file AGE - exclude files older than n days/date.
    /L :: List only - don't copy, timestamp or delete any files.
   /TS :: include source file Time Stamps in the output.
   /FP :: includEe Full Pathname of files in the output.
/BYTES :: Print sizes as bytes.
 /LOG:file :: output status to LOG file (overwrite existing log).
/LOG+:file :: output status to LOG file (append to existing log).

Just do this..
Robocopy D:\USERS D:\USERS1 /MAXAGE:1 /L /TS /FP /BYTES /LOG:D:\BACKUP_REPORT.TXT

HTH,

Kent
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ErgsAuthor Commented:
the robocopy with the /LOG worked nicely. Thanks.
0
Kent DyerIT Security Analyst SeniorCommented:
Have to ask..
First, you should have awarded the points to arnold..  It was his idea.
If this worked nicely - why did you grade this a "B"?

Thanks!

Kent
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Legacy OS

From novice to tech pro — start learning today.