Using PowerShell To Record SQL Server Virtual Log File (VLF) Growth

Function Loop-Databases {
    Param(
        [ValidateScript({Test-Path $_})][string]$smolibrary
        , [ValidateLength(4,25)][string]$server
        , [ValidateLength(4,25)][string]$logging
    )
    Process
    {
        Add-Type -Path $smolibrary

        $srv = New-Object Microsoft.SqlServer.Management.SMO.Server($server)
		
		### Note that I don't apply a filter here using Where-Object, but could apply one to remove databases that I may not want to check
        foreach ($database in $srv.Databases)
        {
            Get-VLFCount -vlfserver $server -saveserver $logging -vlfdatabase $database.Name
        }
    }
}
	
Function Execute-Sql {
    Param(
        [ValidateLength(4,25)][string]$server
        , [ValidateLength(4,1000)][string]$command
    )
    Process
    {
        $scon = New-Object System.Data.SqlClient.SqlConnection
        $scon.ConnectionString = "Data Source=$server;Initial Catalog=master;Integrated Security=true;Connection Timeout=0;"
        
        $cmd = New-Object System.Data.SqlClient.SqlCommand
        $cmd.Connection = $scon
        $cmd.CommandTimeout = 0
        $cmd.CommandText = $command

        try
        {
            $scon.Open()
            $cmd.ExecuteNonQuery()
        }
        catch [Exception]
        {
            Write-Warning $_.Exception.Message
        }
        finally
        {
            $scon.Dispose()
            $cmd.Dispose()
        }
    }
}


Function Get-VLFCount {
    Param(
        [ValidateLength(4,25)][string]$vlfserver
        , [ValidateLength(4,25)][string]$saveserver
        , [ValidateLength(4,25)][string]$vlfdatabase
    )
    Process
    {
        $vlf_con = New-Object System.Data.SqlClient.SqlConnection
        $vlf_con.ConnectionString = "Data Source=$vlfserver;Initial Catalog=$vlfdatabase;Integrated Security=true;"
        
        $vlf_cmd = New-Object System.Data.SqlClient.SqlCommand
        $vlf_cmd.Connection = $vlf_con
        $vlf_cmd.CommandText = "DBCC LOGINFO"
        $vlf_cmd.CommandTimeout = 0

        [int]$vlfloop = 0
        
        try
        {
            $vlf_con.Open()
            $countvlfs = $vlf_cmd.ExecuteReader()
    
            while ($countvlfs.Read())
            {
                $vlfloop++
            }
        }
        catch [Exception]
        {
            Write-Warning "Get-VLFCount"
            Write-Warning $_.Exception.Message
        }
        finally
        {
            $vlf_cmd.Dispose()
            $vlf_con.Dispose()
        }

        $command = "INSERT INTO OurDatabase.dbo.tb_OurVLFTable VALUES ('$vlfserver','$vlfdatabase',$vlfloop,GETDATE())"

        Execute-Sql -server $saveserver -command $command
    }
}