General IT Goto Guy

Zack

<div>
Hi Jose, 
 
Okay if want to set the parameter value in the form of the pre-set variable can I use something like this? : 
 

<pre><code class="code-10 nolinks" id="code-20-42840391-1">$ComputerName = &quot;DC1PRDSQLFCI1&quot;
 $SQLBackupPath = '\\DC1PRDSQLFCI1\Z$\MSSQL13.SQL2016APPS01\MSSQL\Backup\DC1PRDSQLFCI1$SQL2016APPS\PeopleEnt\FULL'

 [Parameter(Mandatory=$true,
				 ValueFromPipeline=$True,
				 ValueFromPipelineByPropertyName=$true,
				 HelpMessage=&quot;Select PeoplePoint environment&quot;)]
		[ValidateNotNullOrEmpty()]
		[ValidateSet(&quot;Development&quot;, &quot;Test&quot;, &quot;Training&quot;)]
		[String]$Environment,

 [Parameter(Mandatory)]
 [ValidateNotNullOrEmpty()]
 [string]$ComputerName,

 [Parameter(Mandatory)]
 [ValidateNotNullOrEmpty()]
 [string]$SQLBackupPath
 
</code></pre>
 
Thank you.
</div>

<div>
Sorry &nbsp;Zack I didn't understand. 
 
if you want to set a parameter value the way is: 
Remove the Mandatory parameter (from $true), so that makes it mandatory=$false... 
 

<pre><code class="code-1 nolinks" id="code-20-42840394-1">[Parameter(Mandatory=$false,Position=0)] 
$ComputerName = &quot;DC1PRDSQLFCI1&quot;
</code></pre>
</div>

<div>
Hi Jose, 
 
That's fine thank you very much for your assistance: I am stuck with this issue now; 
 
Command: PS C:\&gt; ./Invoke-Edited.ps1 -Environment Test -ScriptBlock {param($p1, $p2)} -ArgumentList $Comput 
erName, $SQLBackupPath 
 
A parameter cannot be found that matches parameter name 'ScriptBlock'. 
 
What I'm trying to do is parse execute $ComputerName and SQLBackupPathName remotely on the target box. 
 
If don't parse these variables to execute remotely, I get this error. Cannot bind argument to parameter 'Path' because it is null. 
 
My apologies if my query is opaque. 
 
Thank you.
</div>

<div>
You'd need to defined the scriptblock: 
 
like this: 

<pre><code class="code-1 nolinks" id="code-20-42840409-1">$sb = { 
param(
[Parameter(mandatory=$true,position=0)]$A,
[Parameter(mandatory=$true,position=1)]$B
)
 Write-Host &quot;C: $($A+$B)&quot;
}

Invoke-Command -ScriptBlock $sb -ArgumentList 1,3
</code></pre>
 
Your ScriptBlock only receives 2 parameters ($p1,$p2) and DOES NOTHING :) hahaha
</div>

<div>
Hi Jose, 
 
Okay, but how can nest $sb inside the existing code structure: 
 
&nbsp;
<pre><code class="code-10 nolinks" id="code-20-42840417-1">param
	(
 

 [Parameter(Mandatory=$true,
				 ValueFromPipeline=$True,
				 ValueFromPipelineByPropertyName=$true,
				 HelpMessage=&quot;Select PeoplePoint environment&quot;)]
		[ValidateNotNullOrEmpty()]
		[ValidateSet(&quot;Development&quot;, &quot;Test&quot;, &quot;Training&quot;)]
		[String]$Environment,

 #[Parameter(Mandatory=$false,Position=0)] 
 #$ComputerName = (&quot;DC1PRDSQLFCI1&quot;),

 # [Parameter(Mandatory=$false,Position=1)] 
 # $SQLBackupPath = ('\\DC1PRDSQLFCI1\Z$\MSSQL13.SQL2016APPS\MSSQL\Backup\DC1PRDSQLFCI02$SQL2016APPS\PeopleEntProd\FULL')


 $ComputerName = (&quot;DC1PRDSQLFCI1&quot;),
 $SQLBackupPath = ('\\DC1PRDSQLFCI1\Z$\MSSQL13.SQL2016APPS\MSSQL\Backup\DC1PRDSQLFCI02$SQL2016APPS\PeopleEntProd\FULL')
 $sb = { 
 param(
 [Parameter(mandatory=$true,position=0)]$ComputerName
 ,
 [Parameter(mandatory=$true,position=1)]$SQLBackupPath
 )
 Write-Host &quot;C: $($ComputerName+$SQLBackupPath)&quot;
 }
 )
</code></pre>
 
I am not so sure that PowerShell allows for this can you clarify? 
 
Thank you.
</div>

<div>
Hi Jose, 
 
To clarify in the -Environment variable needs to be entered in manually by the user but the $ComputerName + $SQLBackupPath are to be fixed specified in the ps1 script and to be executed remotely. 
 
Thank you.
</div>

<div>
Hi Jose, 
 
Fair point and thank you for your assistance I will begin to pay around with this script and see if I can get it working.
</div>

<div>
<div class="content wysiwyg-content">
Hi EE, 
 
I am running the following script (the script function is essentially to refresh databases from prod to UAT environments) see attached with the following command: 
 
./Invoke-Edited.ps1 -Environment Test -ScriptBlock {param($p1, $p2)} -ArgumentList $ComputerName, $SQLBackupPath 
 
I am running the scripts remotely and I am getting the following error 
 
Cannot find an overload for &quot;.ctor&quot; and the argument count: &quot;1&quot;. 
At C:\Invoke-Edited.ps1:54 char:9 
+ &nbsp; &nbsp; &nbsp; &nbsp; [ValidateNotNullOrEmpty('DC1PRDSQLFCI02')] 
 
Any assistance is appreciated. 
 
Thank you. 
<a href="https://filedb.experts-exchange.com/incoming/2019/04_w15/1417518/Edited.ps1" target="_blank" class="file-inline" title="script (11 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Edited.ps1</a>
</div>
</div>

Edited.ps1

Hi EE,

I am running the following script (the script function is essentially to refresh databases from prod to UAT environments) see attached with the following command:

./Invoke-Edited.ps1 -Environment Test -ScriptBlock {param($p1, $p2)} -ArgumentList $ComputerName, $SQLBackupPath

I am running the scripts remotely and I am getting the following error

Cannot find an overload for ".ctor" and the argument count: "1".
At C:\Invoke-Edited.ps1:54 char:9
+         [ValidateNotNullOrEmpty('DC1PRDSQLFCI02')]

Any assistance is appreciated.

Thank you.

Powershell - Cannot find an overload for &quot;.ctor&quot; and the argument count: &quot;1&quot;.

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Windows Server 2016 is the successor to Windows Server 2012 R2. Built upon the same core code as Windows 10, Windows Server 2016 brings enhancements in security, servicing, and connectivity. A particular focus on this release was hybrid-cloud scenarios, and has close ties to Azure and other Microsoft cloud initiatives. This does not detract from the many improvements that are available for on-premises-only deployments

Windows Server 2016 comes in Datacenter, Standard, and Essentials editions, and for servicing, has adopted windows 10's cumulative model. The new nano-server install is designed to be remotely managed and is designed to be kept current through continuous feature updates. The full GUI install operates similarly to windows 10's "Long Term Servicing Branch" (LTSB) model with cumulative security updates.

Windows Server 2016 has also shifted from a per-processor-and-CAL licensing model to a per-core-and CAL licensing model. This brings Windows Server's licensing more in line with Microsoft's other products and makes hybrid-cloud license planning easier as well.

Windows Server 2016

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Powershell - Cannot find an overload for &quot;.ctor&quot; and the argument count: &quot;1&quot;.

Powershell - Cannot find an overload for ".ctor" and the argument count: "1".