-
Notifications
You must be signed in to change notification settings - Fork 0
/
IISRFBaseline-maxUrl-FS.psm1
87 lines (68 loc) · 2.24 KB
/
IISRFBaseline-maxUrl-FS.psm1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
function Get-RFLpQueryMaxUrlFS
{
<#
.SYNOPSIS
Creates Logparser query for RF maxUrl baseline using website content directory.
.EXAMPLE
Get-RFLpQueryMaxUrlFS -ContentDir \\server.domain.com\website -OutputDir D:\WorkingFolder\
#>
[CmdletBinding()]
param(
[parameter(Mandatory=$true)]
[System.String]
# Website content directory.
$ContentDir
,
[parameter(Mandatory=$true)]
[System.String]
# Outut directory for writing files.
$OutputDir
)
$ResultFile = Join-Path -Path $OutputDir -ChildPath 'lp_results_maxUrl_FS.csv'
$BaseDir = [System.IO.Path]::GetDirectoryName($ContentDir)
return @"
--lp_query_maxUrl_FS.sql--
SELECT
Path AS FilePath,
REPLACE_CHR(file-cs-uri-stem,'\\','/') AS PROPOSED-cs-uri-stem,
STRLEN(PROPOSED-cs-uri-stem) AS maxUrl
USING
REPLACE_STR(Path, `'$BaseDir`', '') as file-cs-uri-stem
INTO $ResultFile
FROM $ContentDir
WHERE
Path NOT LIKE '%\\aspnet_client%' AND
Path NOT LIKE '%.config' AND
Path NOT LIKE '%.dll' AND
Path NOT LIKE '%.cs' AND
Path NOT LIKE '%\\..' AND
Path NOT LIKE '%\\.'
ORDER BY maxUrl DESC
--lp_query_maxUrl_FS.sql--
"@
} # End function Get-RFLpQueryMaxUrlFS
function New-RFLpFileMaxUrlFS
{
<#
.SYNOPSIS
Creates Logparser file for RF verbs baseline using website content directory.
.EXAMPLE
New-RFLpFileMaxUrlFS -ContentDir \\server.domain.com\website -OutputDir D:\WorkingFolder\
#>
[CmdletBinding()]
param(
[parameter(Mandatory=$true)]
[System.String]
# Website content directory.
$ContentDir
,
[parameter(Mandatory=$true)]
[System.String]
# Outut directory for writing files.
$OutputDir
)
$FileLocation = Join-Path -Path $OutputDir -ChildPath 'lp_query_maxUrl_FS.sql'
Get-RFLpQueryMaxUrlFS -ContentDir $ContentDir -OutputDir $OutputDir | Out-File -LiteralPath $FileLocation -Force -Encoding ascii
return $FileLocation
} # End function New-RFLpFileMaxUrlFS
Export-ModuleMember -Function 'Get-RFLpQueryMaxUrlFS','New-RFLpFileMaxUrlFS'