search

microsoft / Code-Search

Code Search Admin scripts (SQL and PS) for managing a Code Search on-prem instance
53 stars 68 forks source link

Support for Azure DevOps 2020 #86

Open mosheytiko opened 3 years ago

mosheytiko commented 3 years ago

Hi team, are you planning to release 2020 version?

gprosch commented 1 year ago

It's been a few years and still nothing for the 2020 version. An update would be very much appreciated.

cvocvo commented 1 year ago

+1 for 2022 now

TMattes commented 1 year ago

We also would appreciate an update on this, although scripts of ADO 2019 are still usable on ADO 2022. But: why aren't these scripts digitally signed? We always have to work around this circumstance...

xfiles-92 commented 1 year ago

Is there any news on the ADO 2022 version of the scripts being released ???

bballpaul4work commented 9 months ago

How do you work around the fact that they're not digitally signed? I get the error "The certificate chain was issued by an authority that is not trusted" when trying to run Invoke-SqlCmd for ADO 2022

xfiles-92 commented 9 months ago

I have literally just added this switch -TrustServerCertificate to every Invoke-Sqlcmd in the scripts to get around the certificate issues.

$queryResults = Invoke-Sqlcmd -InputFile "$PWD\SqlScripts\CodeAccountFaultInResult.sql" -serverInstance $SQLServerInstance -database $ConfigurationDatabaseName -Verbose -Variable $Params -TrustServerCertificate

This has allowed me to run most of the PowerShell scripts against DevOps 2022

bballpaul4work commented 9 months ago

Ha brilliant! This has worked for me as well

kohithms commented 3 months ago

Hi @steved0x,

Any update on the scripts for 2020 server ?