microsoft / microsoft/sql-server-samples
invoke-sqlassessment returns warning - WMI
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 11.2k
- Forks
- 9.1k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 14
Description
Default instance. Execution policy is unrestricted.
$serverInstance = Get-SqlInstance -ServerInstance 'localhost'
Invoke-SqlAssessment $serverInstance
WARNING: Checks 'AgentSvcStoped', 'BrowserSvcStoped', 'DiskFragmentationAnalysis', and 7 more have been skipped because they need access to WMI
I get the Warning message.
Could you reply how to resolve above warnings?
With regards!
Contributor guide
No contributing guide indexed for this repository
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 by reproducing the warning with Get-SqlInstance and Invoke-SqlAssessment against the default localhost instance, then investigate the WMI access requirements for the skipped checks. Done should mean identifying the cause of the WMI skips and documenting a verified resolution or the exact missing prerequisites.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- powershell, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 20/100