IISRFBaseline-fileExtensions-IIS.psm1

function Get-RFLpQueryFileExtensionsIIS
{
    <#
        .SYNOPSIS
        Creates Logparser query for RF fileExtensions baseline using IIS logs.
        .EXAMPLE
        Get-RFLpQueryFileExtensionsIIS -Sitename W3SVC1 -LogDir D:\inetpub\Logs\ex*.log -OutputDir D:\WorkingFolder\ -MaxHttp 303
    #>


    [CmdletBinding()]
    param(
        [parameter(Mandatory=$true)]
        [System.String]
        # IIS Sitename of target website.
        $Sitename
        ,
        [parameter(Mandatory=$true)]
        [System.String]
        # IIS log directory.
        $LogDir
        ,
        [parameter(Mandatory=$true)]
        [System.String]
        # Outut directory for writing files.
        $OutputDir
        ,
        [parameter(Mandatory=$true)]
        [System.Int32]
        # Max HTTP Status Code
        $MaxHttp
    )

    $ResultFile = Join-Path -Path $OutputDir -ChildPath 'lp_results_fileExtensions_IIS.csv'

    return @"
--lp_query_fileExtensions_IIS.sql--
 
SELECT DISTINCT
    cs-uri-stem,
    EXTRACT_EXTENSION(cs-uri-stem) AS Extension,
    COUNT(*) AS Hits
 
INTO $ResultFile
 
FROM $LogDir
 
WHERE
    s-sitename LIKE `'$Sitename`'
    AND (sc-status<$MaxHttp AND sc-status>=200)
 
GROUP BY cs-uri-stem, Extension
 
ORDER BY Hits DESC
 
--lp_query_fileExtensions_IIS.sql--
"@


} # End function Get-RFLpQueryFileExtensionsIIS

function New-RFLpFileFileExtensionsIIS
{
    <#
        .SYNOPSIS
        Creates Logparser file for RF fileExtensions baseline using IIS logs.
        .EXAMPLE
        New-RFLpFileFileExtensionsIIS -Sitename W3SVC1 -LogDir D:\inetpub\Logs\ex*.log -OutputDir D:\WorkingFolder\ -MaxHttp 303
    #>


    [CmdletBinding()]
    param(
        [parameter(Mandatory=$true)]
        [System.String]
        # IIS Sitename of target website.
        $Sitename
        ,
        [parameter(Mandatory=$true)]
        [System.String]
        # IIS log directory.
        $LogDir
        ,
        [parameter(Mandatory=$true)]
        [System.String]
        # Outut directory for writing files.
        $OutputDir
        ,
        [parameter(Mandatory=$true)]
        [System.Int32]
        # Max HTTP Status Code
        $MaxHttp
    )

    $FileLocation = Join-Path -Path $OutputDir -ChildPath 'lp_query_fileExtensions_IIS.sql'

    Get-RFLpQueryFileExtensionsIIS -Sitename $Sitename -LogDir $LogDir -OutputDir $OutputDir -MaxHttp $MaxHttp | Out-File -LiteralPath $FileLocation -Force -Encoding ascii

    return $FileLocation

} # End function New-RFLpFileFileExtensionsIIS

Export-ModuleMember -Function 'Get-RFLpQueryFileExtensionsIIS','New-RFLpFileFileExtensionsIIS'