nice article

i've been doing something similar for 2 years and might check this out to see if it's faster than mine. in my case i run the VB from each server and dump to a central SQL server. i have a staging table for each server and there is a job that runs every hour to delete old data from the main tables and copy data from the staging tables and then truncate them. and i wrote a bunch of reports over the last year to track locked out accounts, AD Group changes, etc. each report has a SSRS subscription to email it to the right people

i've wanted to change over to powershell, but haven't found anything where it says how to dump the data directly to SQL

to make sure data is being imported i have a report that i check once a week that shows me the server name and the latest app/security log dates in the database for each server