Hi Tim yes powershell is great for these type of tasks , I use it all the time on SCCM, Servers and workstations etc and I am learning to use it on SQL , but it can be a bit slow on network connections, get-childitem is good for local disk, but there is something much better "LogParser" from Microsoft, a nifty little tool for - as the name suggest parsing log files. I have made a link in my $profile so I can use it from the powershell console. check this out - getting the sccm-client logs across the network.
logparser -o:datagrid -i:TEXTLINE "select * from \\xxx-xxx-xxx\c$\windows\system32\ccm\logs\*.log where text like '%oracle%'".
there's a few references of it in the powershell blogs.