Powershell

• Topics

  Started by

  Posts

  Last post

• Need to extract a query result to CSV from a list of servers

  I have been trying the following PowerShell script to extract a query result from a list of SQL ins…

  TrailRunner

  3 replies

  3 days, 13 hours ago

  By: TrailRunner

• skip function if completed successfully

  I have a function where I’m executing in succession a list of sql queries\updates. The functi…

  Bruin

  9 replies

  1 week, 2 days ago

  By: garry.lovesey

• Convert VbScript Com object to PS to load sql2005 DTS pkg

  Trying to Convert VBScript Com Object to PS.  VbScript:Set objPkg = CreateObject(“DTS.Pa…

  Bruin

  6 replies

  2 weeks, 2 days ago

  By: Bruin

• Get Max Number of error log files

  Creating Audit script to validate newly built sql server- as it’s popular now- in PS. Do not …

  Yuri55

  2 replies

  1 month, 1 week ago

  By: Yuri55

• Help with List Variable

  Hi,  Please could anyone help me with following requirement. I have output like below – …

  Renuka__

  2 replies

  1 month, 1 week ago

  By: frederico_fonseca

• List edition and version of all SQL Server machines over the Network …

  In our organization, we have more than 100 SQL Server machines on different regions over the Networ…

  shamshad.ali

  6 replies

  1 month, 3 weeks ago

  By: Lowell

• date formats

  ((Get-Date).AddMonths(1)) gives meSaturday, August 25, 2018 3:06:26 AM (Get-Date -format ‘Y&#…

  mtz676

  8 replies

  1 month, 3 weeks ago

  By: David Burrows

• Services

  I need to go through a list of SQL Servers from a SQL table;hit the respective server and collect t…

  mtz676

  1 replies

  1 month, 4 weeks ago

  By: blakemcneill

• Run New PowerShell Process As A Different User

  Hello,I’m trying to create a PowerShell script that will run a new PowerShell Process&nb…

  Coozie

  9 replies

  3 months ago

  By: Coozie

• WMI connection error using Invoke-Sqlcmd

  Hi all, I’m brand new to powershell and am trying to convert an old batch script that run som…

  smw147

  6 replies

  3 months, 3 weeks ago

  By: Jeff Moden

• parse string and check for valid date

  I have a flat file with a bar(|) delimiter. It has no headers, but I want to check columns(11,12,13…

  Bruin

  14 replies

  4 months, 2 weeks ago

  By: Bruin

• Application Intent with Invoke-SQLcmd

  Are you able to specify read-only routing in invoke-SQLcmd? $dataTable = Invoke-Sqlcmd -Query $Que…

  gwellbrock

  2 replies

  5 months, 4 weeks ago

  By: dale53

• SQL Agent job not failing when Powershell script errors

  First time using Powershell. And I’m trying to execute via SQL Agent job. So I don’t kn…

  Sqlraider

  7 replies

  6 months ago

  By: mihaipetcu84 44501

• List all ADGroups and all their Users

  ForEach ($Group in (Get-Content c:\text.txt)) { Get-ADGroupMember $Group | Select @{Label=”G…

  mtz676

  1 replies

  6 months, 1 week ago

  By: Sue_H

• How to output everything to a log file in Invoke-SqlCmd

  I have powershell script to run database scripts below, but I can’t get it to output to my l…

  rnunez

  3 replies

  6 months, 3 weeks ago

  By: Ronen Ariely