8000 Adding Agent v5 tests by ClaudioESSilva · Pull Request #1003 · dataplat/dbachecks · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

Adding Agent v5 tests #1003

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 28 commits into from
Aug 28, 2023
Merged

Adding Agent v5 tests #1003

Show file tree
Hide file tree
Changes from all commits
Commits
Show all changes
28 commits
Select commit Hold shift + click to select a range
c1d2983
add FailsafeOperator (but not working)
ClaudioESSilva Apr 13, 2023
9eb5111
add FailsafeOperator (but not working)
ClaudioESSilva Apr 13, 2023
db487be
failsafe Operators
ClaudioESSilva Jul 9, 2023
09bc3a6
Merge branch 'agentV5' of https://github.com/dataplat/dbachecks into …
ClaudioESSilva Jul 9, 2023
a8d4d3a
add filesafeoperator + small improves + configs
ClaudioESSilva Jul 12, 2023
00b4895
DatabaseMailProfile
ClaudioESSilva Jul 12, 2023
a30f969
added Agent Mail Profile
ClaudioESSilva Jul 13, 2023
7fee4ba
ValidJobOwner
ClaudioESSilva Aug 21, 2023
35c4152
InvalidJobOwner
ClaudioESSilva Aug 22, 2023
351fa70
Last Agent Job Run
ClaudioESSilva Aug 22, 2023
a2ac79a
Last Agent Job Run
ClaudioESSilva Aug 22, 2023
4a0d92b
Long Running Agent Jobs
ClaudioESSilva Aug 22, 2023
24401bb
SQL Agent Failed Jobs
ClaudioESSilva Aug 22, 2023
b558063
SQL Agent Failed Jobs "improve?"
ClaudioESSilva Aug 22, 2023
43e94b3
AgentAlert
ClaudioESSilva Aug 23, 2023
55f30ce
Job History Configuration
ClaudioESSilva Aug 23, 2023
e614b28
some cleaning
ClaudioESSilva Aug 23, 2023
2f25a0f
so that we might know which way round to do this
SQLDBAWithABeard Aug 23, 2023
069750e
so that #887 has some checks done
SQLDBAWithABeard Aug 23, 2023
2ad34b2
sdo that it formats adn that the configvalue is more performant #887
SQLDBAWithABeard Aug 23, 2023
2404994
using $__dbcconfig - we want PERFORMANNNNCE!!!
ClaudioESSilva Aug 23, 2023
ceef968
Merge branch 'main' into agentV5
SQLDBAWithABeard Aug 23, 2023
f8a93ec
Merge branch 'main' into agentV5
SQLDBAWithABeard Aug 26, 2023
d7f4434
update changelog
jpomfret Aug 27, 2023
143ec3b
Fix typo
ClaudioESSilva Aug 28, 2023
e498505
Removed entries from not converted tests
ClaudioESSilva Aug 28, 2023
6d39640
remove page verify
jpomfret Aug 28, 2023
e80b9b7
Merge branch 'main' into agentV5
jpomfret Aug 28, 2023
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
4 changes: 4 additions & 0 deletions CHANGELOG.md
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -5,6 +5,10 @@ and this project adheres to [Semantic Versioning](https://semver.org/spec/v2.0.0

## [Unreleased]

### Added

- Pester v5 support for agent checks.

## [3.0.1-preview0025] - 2023-08-28

### Added
Expand Down
63 changes: 35 additions & 28 deletions containers/JessAndBeard.psm1
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -2312,7 +2312,7 @@ Uh-Oh - The Tag filters between v4 and v5 are not the same somehow.
For v4 We returned
{0}
and
For v5 we returned
for v4 we returned
{1}
" -f ($v4code.TagFilter | Out-String), ($v5code.Configuration.Filter.Tag.Value | Out-String)
Write-PSFMessage -Message $Message -Level Warning
Expand All @@ -2325,47 +2325,54 @@ The Tags are the same"
$changedTags = @(
@{
Name = 'TraceFlagsExpected'
RunChange = 3 # + or - the number of tests run for v5
PassedChange = 3 # + or - the number of tests passed for v5
FailedChange = 0 # + or - the number of tests failed for v5
SkippedChange = 0 # + or - the number of tests skipped for v5
RunChange = 3 # + or - the number of tests run for v4
PassedChange = 3 # + or - the number of tests passed for v4
FailedChange = 0 # + or - the number of tests failed for v4
SkippedChange = 0 # + or - the number of tests skipped for v4

},
@{
Name = 'TraceFlagsNotExpected'
RunChange = 3 # + or - the number of tests for v5
PassedChange = 3 # + or - the number of tests passed for v5
FailedChange = 0 # + or - the number of tests failed for v5
SkippedChange = 0 # + or - the number of tests skipped for v5
RunChange = 3 # + or - the number of tests for v4
PassedChange = 3 # + or - the number of tests passed for v4
FailedChange = 0 # + or - the number of tests failed for v4
SkippedChange = 0 # + or - the number of tests skipped for v4
},
@{
Name = 'XESessionRunningAllowed'
RunChange = -12 # + or - the number of tests for v5
PassedChange = 0 # + or - the number of tests passed for v5
FailedChange = -12 # + or - the number of tests failed for v5
SkippedChange = 8000 0 # + or - the number of tests skipped for v5
RunChange = -12 # + or - the number of tests for v4
PassedChange = 0 # + or - the number of tests passed for v4
FailedChange = -12 # + or - the number of tests failed for v4
SkippedChange = 0 # + or - the number of tests skipped for v4
},
@{
Name = 'LinkedServerConnection'
RunChange = -3 # + or - the number of tests for v5
PassedChange = -3 # + or - the number of tests passed for v5
FailedChange = 0 # + or - the number of tests failed for v5
SkippedChange = 0 # + or - the number of tests skipped for v5
RunChange = -3 # + or - the number of tests for v4
PassedChange = -3 # + or - the number of tests passed for v4
FailedChange = 0 # + or - the number of tests failed for v4
SkippedChange = 0 # + or - the number of tests skipped for v4
},
@{
Name = 'SupportedBuild'
RunChange = -3 # + or - the number of tests run for v5
PassedChange = -3 # + or - the number of tests passed for v5
FailedChange = 0 # + or - the number of tests failed for v5
SkippedChange = 0 # + or - the number of tests skipped for v5
RunChange = -3 # + or - the number of tests run for v4
PassedChange = -3 # + or - the number of tests passed for v4
FailedChange = 0 # + or - the number of tests failed for v4
SkippedChange = 0 # + or - the number of tests skipped for v4
},
@{
Name = 'GuestUserConnect'
RunChange = 0 # + or - the number of tests run for v5
PassedChange = +2 # + or - the number of tests passed for v5
FailedChange = -2 # + or - the number of tests failed for v5
SkippedChange = 0 # + or - the number of tests skipped for v5
RunChange = 0 # + or - the number of tests run for v4
PassedChange = +2 # + or - the number of tests passed for v4
FailedChange = -2 # + or - the number of tests failed for v4
SkippedChange = 0 # + or - the number of tests skipped for v4
},
@{
Name = 'AgentServiceAccount'
RunChange = -3 # + or - the number of tests run for v4
PassedChange = -5 # + or - the number of tests passed for v4
FailedChange = -1 # + or - the number of tests failed for v4
SkippedChange = +3 # + or - the number of tests skipped for v4
},
@{
Name = 'SqlEngineServiceAccount'
RunChange = -3 # + or - the number of tests run for v5
Expand Down Expand Up @@ -2407,7 +2414,7 @@ Uh-Oh - The total tests run between v4 and v5 are not the same somehow.
For v4 We ran
{0} tests
and
For v5 we ran
for v4 we ran
{1} tests
The MOST COMMON REASON IS you have used Tags instead of Tag in your Describe block {2}
" -f $v4code.TotalCount, $v5run, $messageAppend
Expand All @@ -2427,7 +2434,7 @@ Uh-Oh - The total tests Passed between v4 and v5 are not the same somehow.
For v4 We Passed
{0} tests
and
For v5 we Passed
for v4 we Passed
{1} tests
{2}

Expand All @@ -2454,7 +2461,7 @@ Uh-Oh - The total tests Failed between v4 and v5 are not the same somehow.
For v4 We Failed
{0} tests
and
For v5 we Failed
for v4 we Failed
{1} tests

" -f $v4code.FailedCount, $v5Failed, $messageAppend
Expand Down
Loading
0