The -BackupFile parameter for the Backup-SqlDatabase cmdlet does not work properly with a drive created with the New-PSDrive cmdlet. It will first pull the default backup drive for the SQL Server then append the string for the file system. For example:

New-PSDrive -Name "fs" -PSProvider FileSystem -Root "\MyFileServer\Backups"
Backup-SqlDatabase -Database "MyDatabase" -ServerInstance "MySQLServer" -BackupFile "fs:\MyDatabase.bak"

Would error with "Cannot find the path 'C:\BackupPath\fs:\MyDatabase.bak'"

When is Powershell v6 due to be released Will it work with Windows 10?

The docs clearly say that Expand-Archive should return a System.IO.FileInfo or System.IO.DirectoryInfo but it has no output

In PS 3.0, it was known to have to do an Import-Module sqlps -DisableNameChecking command in order to get the SQL SMO CMDLETS for working with SQL Server. Is this still needed for PS 4.0? There doesn't seem to be any Documentation on this difference.

Typing "Import-Module -Na<tab>" does not autocomplete to "-Name", as if parameter switch "-Name" is no recognized.

Other switches "-g<tab" and so forth work ok

$PSVersionTable.PSVersion
Major Minor Build Revision

5 1 14393 953

@arisaastamoinen

OS : Windows Server 2016

The command prompt an error when I add authorization rule in PowerShell Web Acces. It's syntax error : "domain/user".

But, this is my commande :
Add-PswaAuthorizationRule -ComputerName SRVDC01 -UserName 'FRPSUG\Test' -ConfigurationName Microsoft.PowerShell

It's same issue with group, no quote, simple quote, double quote, local user...

Register-ArgumentCompleter does not appear to support module-qualified command names, such as:

Register-ArgumentCompleter -CommandName Microsoft.PowerShell.Management\Get-Process

Running this command does not return an error, but does not function either. Module-qualified command names are often considered a best practice so it would be helpful if this was supported. Thanks!

For the Get-Module cmdlet, there is a -ListAvailable parameter to show the modules that are available, but not loaded. Although Get-Module without any parameters does show which modules ARE loaded, it would be nice (i.e. intuitive - for those just learning PowerShell as well as enhance readability) if there was a corresponding -ListLoaded parameter as well.

New-EventLog allows specifying a CategoryResourceFile but not a 'CategoryCount'. This field then gets created in the registry as 0 and so I effectively have no categories.

If Join-Path handled a single base path and an array of child paths then you could easily process a list of relative paths.

I would pass in:

-Path "C:\MyTargetDirectory"
-ChildPath ".\Sub1",".\Sub2",".\Sub2\Sub2.1",".\Sub2\Sub2.1\Sub2.1.1"

and it would return the following:

C:\MyTargetDirectory\Sub1
C:\MyTargetDirectory\Sub2
C:\MyTargetDirectory\Sub2\Sub2.1
C:\MyTargetDirectory\Sub2\Sub2.1\Sub2.1.1

If it isn't possible to create parameter sets that can cope with both methods then you could always create Join-ChildPath to simplify things.

Bug in PowerShell Invoke-sqlcmd - Inserting duplicate rows if the second row of SQL insert statement table name is wrong.
Example:
create table TestDB..TestTable
(Id Int,
InsertedDate Datetime default (getdate()))

Run below script in PowerShell, which has table name wrong in second row.

$Query = "Use TestDB
Insert into TestTable (id) values ('1')
Insert into TestTable2 (id) values ('2')"
Invoke-sqlcmd -Query "$Query" -ServerInstance "SQLInstanceName"

SQLResult:
Id InsertedDate
1 2016-09-15 03:35:12.587
1 2016-09-15 03:35:12.590

I do test:

$a=Get-WinEvent -FilterHashtable @{LogName="Microsoft-Windows-PrintService/Operational";"Param5"=
"UserPrinterName"} -Verbose -ComputerName printserver

VERBOSE: Constructed structured query:
<QueryList><Query Id="0" Path="microsoft-windows-printservice/operational"><Select
Path="microsoft-windows-printservice/operational">[([EventData[Data[@Name='Param5']='UserPrinterName']] or
[UserData//Param5='UserPrinterName'])]</Select></Query></QueryList>.

Get-WinEvent : No events were found that match the specified selection criteria.

1. Really the log contain events under the filter!


2. If you copy-paste the Constructed structured query into Eventvwr.msc then you get error!


3. If I do the test with part of the generated query "[UserData//DocumentPrinted/Param5='UserPrinterName']" then you get the events in Powershell and in Eventvwr.msc

I am trying to execute the below command to enable credssp remotely but it is giving below error and blocking our execution in prod. Can some one suggest me how to enable it.

Invoke-Command -ComputerName Server1 -Credential domain\user1-ScriptBlock {

Enable-WSManCredSSP -Role Server -Force
Enable-WSManCredSSP -Role Client -DelegateComputer * -Force

}
Access is denied.

+ CategoryInfo          : InvalidOperation: (:) [Enable-WSManCredSSP], Inv 

alidOperationException

+ FullyQualifiedErrorId : WsManError,Microsoft.WSMan.Management.EnableWSMa 

nCredSSPCommand

+ PSComputerName        : civautowinclu02

Access is denied.

+ CategoryInfo          : InvalidOperation: (System.String[]:String[]) [En 

able-WSManCredSSP], InvalidOperationException

+ FullyQualifiedErrorId : WsManError,Microsoft.WSMan.Management.EnableWSMa 

nCredSSPCommand

+ PSComputerName        : Server1

It seems that the RemoteDesktop module for RDS isn't working correctly. When trying to configure constrained endpoints in powershell it seems nearly impossible to restrict the session to only use the RemoteDesktop-module. It appears as if the modules isn't loading in a constrained endpoint due do the use of aliases in the modules.

https://powershell.org/forums/topic/creating-jea-endpoint-for-remote-desktop-services/

MSSQL Tiger Team gave a great presentation today about new extended events and properties for troubleshooting AoAG. These improvements rely on AG Lease & X-events. It would be great to have a set of Cmdlets added to the AG modules to return information captured by AG-Lease a few examples:

Get-AGDiagnosticEvent
Get-AGLeaseExpired
Get-AGLeaseSystemComponent

ps 5.0 bug：some unicode display none

【Cause of the bug】
unknown

【bug with powershell version】
powershell 2.0: no this bug
powershell 3.0: no this bug
powershell 4.0: no this bug
powershell 5.0: have this bug
ise in win10 10586：no this bug

【test code】
write-host 'a♦♣♥♠b'

【how to fix】
unknown

【reporter】
By the chinese powershell study & research group. QQ group No. is 183173532

【date】
2016-06-04

As of PowerShell 5.1.14328.1000, the core Get-Command command is improperly IMPORTING modules when run with -ListImported, so that it ALWAYS finds the command.

For example, the following series of commands will always return the command and the module, when it should return neither:

Remove-Module Microsoft.PowerShell.Security
Get-Command Get-ACL -ListImported
Get-Module Microsoft.PowerShell.Security

the confirm impact on the Remove* cmdlets in the Microsoft.PowerShell.LocalAccounts module is not set to high.
I think removing a local group or user (especially when the pipeline is involved) should have Confirm impact set to high to prevent accidental mass deletion

In Powershell 5 the ability to create/delete links (SymbolicLink, HardLink or Junction) was introduced using new-item and remove-item. However remove-item does not work for remote to remote symbolic links.

Remote to remote symbolic links are typically not enabled by default. They can be enabled by doing:
fsutil behavior set SymlinkEvaluation R2R:1

Issue can be replicated by doing:
fsutil behavior set SymlinkEvaluation R2R:1
sl "\$servername\$servershare\$serverpath"
new-item Data -ItemType Directory
new-item DataPtr -ItemType SymbolicLink -Target Data
remove-item DataPtr -force -Recurse

This generates the error:
remove-item : Incorrect function

Workaround is to do: