dsccommunity / dsccommunity/SqlServerDsc
SqlLogin: Verbose messages is missing values
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 385
- Forks
- 224
- PR merge metrics
- No merged PRs in 30d
Description
Details of the scenario you tried and the problem that is occurring:
When creating a new login, the verbose messages are missing values for the properties PasswordExpirationEnabled and PasswordPolicyEnforced, should say 'is $false, but should be $true', but the resource does not handle $null values apparently, or wrong variable is used to build the string.
VERBOSE: [APPVYR-WIN]: [[SqlServerLogin]Integration_Test] 2018-01-06_04-24-15: The login 'DscUser4' on the instance 'APPVYR-WIN\DSCSQL2016' is Absent rather than Present
VERBOSE: [APPVYR-WIN]: [[SqlServerLogin]Integration_Test] 2018-01-06_04-24-15: The login 'DscUser4' on the instance 'APPVYR-WIN\DSCSQL2016' is a rather than SqlLogin
VERBOSE: [APPVYR-WIN]: [[SqlServerLogin]Integration_Test] 2018-01-06_04-24-15: The login 'DscUser4' on the instance 'APPVYR-WIN\DSCSQL2016' has PasswordExpirationEnabled set to rather than True
VERBOSE: [APPVYR-WIN]: [[SqlServerLogin]Integration_Test] 2018-01-06_04-24-15: The login 'DscUser4' on the instance 'APPVYR-WIN\DSCSQL2016' has PasswordPolicyEnforced set to rather than True
The DSC configuration that is using the resource (as detailed as possible):
Any SqlServerLogin configuration creating a new login.
Version of the Operating System, SQL Server and PowerShell the DSC Target Node is running:
n/a
What module (SqlServer or SQLPS) and which version of the module the DSC Target Node is running:
n/a
Version of the DSC module you're using, or 'dev' if you're using current dev branch:
Dev
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the SqlServerLogin resource and reproduce the verbose output using a configuration that creates a new login. Check how PasswordExpirationEnabled and PasswordPolicyEnforced values are assembled in the messages; done means the verbose output shows the actual values, including false versus true, instead of blanks.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- powershell, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100