Condividi tramite


Get-AzSqlInstanceServerTrustCertificate

Restituisce informazioni sul certificato di attendibilità del server.

Sintassi

Get-AzSqlInstanceServerTrustCertificate
   [-ResourceGroupName] <String>
   [-InstanceName] <String>
   [[-Name] <String>]
   [-DefaultProfile <IAzureContextContainer>]
   [<CommonParameters>]
Get-AzSqlInstanceServerTrustCertificate
   [[-Name] <String>]
   [-InstanceObject] <AzureSqlManagedInstanceModel>
   [-DefaultProfile <IAzureContextContainer>]
   [<CommonParameters>]
Get-AzSqlInstanceServerTrustCertificate
   [[-Name] <String>]
   [-InstanceResourceId] <String>
   [-DefaultProfile <IAzureContextContainer>]
   [<CommonParameters>]
Get-AzSqlInstanceServerTrustCertificate
   [-ResourceId] <String>
   [-DefaultProfile <IAzureContextContainer>]
   [<CommonParameters>]

Descrizione

Il cmdlet Get-AzSqlInstanceServerTrustCertificate restituisce informazioni su una o più istanze del certificato di attendibilità del server in un Istanza gestita di SQL di Azure. Specificare il nome di un certificato per visualizzare le informazioni solo per il certificato.

Esempio

Esempio 1: Ottenere informazioni su tutti i certificati di attendibilità del server in Istanza gestita di SQL di Azure

Get-AzSqlInstanceServerTrustCertificate -ResourceGroupName "ResourceGroup01" -InstanceName "ManagedInstance01"

ResourceGroupName : ResourceGroup01
InstanceName      : ManagedInstance01
Id                : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/serverTrustCertificates/Certificate01
Type              : Microsoft.Sql/managedInstances/serverTrustCertificates
Name              : Certificate01
Thumbprint        : 0x7D989DF34BD0FD0D2F9F6B3B6A7096856F5AB004
PublicKey         : 0x1C8E3F85BCD8A2C1D082CE42D7A1E8112651A906B15F5F244134142C53B050FCBF2571965C522EBB86B4F1B790F3AD31E689950EE909B87C25A1BB51DA328BEEB1BB0FD44AB3CB774B8CC9F72B486476DEB8B1C95210B84C4A0F18310CD83F299CAF0D567EBCE2DD008581622D72499F8EC9A686BA526916E7F78DCA90BA0ADD8C2E5F601017D374E2FBD0818458BFC11C8268BC21383613323153163C0F33E09D03586A3BBFDA3628F0358FBADE41602BD05C4E47CDB67A9914F35B315B7844C2F2D1352034B56D6B155D38415B816247779E7A0EB3431765D9A48F4649E647CCD2EA8F38E8B5D415833BA8337BA00FED2F00D9066B9CAEF7BAA8C553F7B8787BCEF63AC98E05372981520BD5A598356590736B547F3B300F1D710EC3003D398AEB94589E196C42C5F6A1873D6138D9F666A2D6F24DAFB12FBD6B0124B2CFFAD51EF67032832900A9E113625BE4C4FB012923BB9886B52B733A5F8BFF04122A2474828F2EE5FC66154D9EBA92A21F0BFD6E8AAEE7DCC45BB3883A410E603C9D98A5BB913853D1B7543E694FF74F8CA9174BE152A96530803DD03C15BC258E77925877BCAF748CA85230ABBF90789F4856200166D110D369FB03B6593339CCE498CDA69016289056F4638E761B9904129DB36B6B4CD17D49567C27FF11059C0569ABF48C438CB6128F2B2F245BDB066B6BF1155BCA11E9D6B0BD8A1607F2F5BB42AF7498D1B8410AA1E5E3E23A3CA6FB933D3894C8D1A2162E735CFCB7BEDFB3318DAE32AE9E24900B9B0F472ABD563550C9E696836889123F0ED2E7A9A4B90C2C617C8ADCF088CE2A7EC8AB97A80C00F3296241C7B320118A1182E327919007930417004A301249EAACF139D611D9C30DAFDF8672F5347C488250F46D45E7D7E9BF3BE99ECD1C60A046FC80EB1DC473FD2E1A7672235F8A834338A4810E32CB24C9C24D09234995A3D038D70379B900E6C9217EF19062775B050CF7CA52D3D72E294E2315AA544247B436D46AD08D55957B9688C576E35760B527B7F7EB71E6209301C59B6643C921F2FB182D237E81DC6205BF6740C8EDC48C65DAB0546C1098C2DCBF0E3B31A47868A721942022E0B5DBFFFBBC4767699C7F0ABD6DEBE7D5FB91

ResourceGroupName : ResourceGroup01
InstanceName      : ManagedInstance01
Id                : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/serverTrustCertificates/Certificate02
Type              : Microsoft.Sql/managedInstances/serverTrustCertificates
Name              : Certificate02
Thumbprint        : 0x628B41E23E513EAF9C03F8E2C8A881E0D33D385B
PublicKey         : 0x5D014B47F6AF7D0469A853C84180445C146015D5098F09AC673A49281EDA9D3C560039BAFBD02617BF94DF30B505AA2CA891E3F80BD0056F39B21396F675EBAEA148A12C3EED8F7DE6753A2AAC722EEB1D3A71633A00909F720E74180CC9D7B51E84BEFDDC6A64C7015368FB041E59E836F3968739E7B84654FEDA396BD7E89C9AFCCF4086F8838A1FD5F833C1288EB619A14F68F15094D8BB4DD834F64333AF44A7C0CC5BF4406C408702993B14D04A20772EE23A0C7FED3D89B754EA66C23FDAE65AEAD53F55AE82ADEEDC8B730352D1A0933AD28745FCCA960FAD3AE12693175DA3A14CCF37B221AC35DEF986A9758EAB7DEFB334FF65BBAF8C5F4377F51224459B349CFDDC51A6D5DC9937477EF869CAE4B4165E8A4DC83B3E9D9B7A80E3C0C591DEE00A776E4C1915EDEF276D23BEEDEBF2E673F02857E909B0CEFD6C8D96C8B6E91E1753858974F24D37D0E85558D2A40C82E06B2BF6002CD57ABBEEF8C8C43EBEC5F2624E4E882E3094E62FC7624D2C52DD73DC0C618F1AB96D39316E2E16E301ABDE4FE267DE88425CBFCA9F3131D4FED6BDF7F296B5A7BAC4CB2F9E4A48F0C6BE822B611002A9785A60692F9B25A1EAA7F279FEF4BF5E2BDEA8BEC4E3417E9936E542A19F9D19880065B003537A514754F09ADFA9A08D067BF34D3BEBC56BF4D970526A20886CE25BEB1174496F2AB9BC884BEC3A885875FEF4DBA60F682F68354C40B3E7C3DF62666DA0D655B0BC9EB0A1E470EDF58538DD848ECB5700BD632175644D50C713BFC1ACDC94F6600331F7C14AE8A63C1396699662CF1D5BD668C1BCE1E9AA0A2B5DDDC62294841958A36C03E9D211AA4352FA2918962452F73831B843412725766728AE7BB18B863D1B267AAA5FAB9B735FE50E6B1DF43BD4FA33F5004AECBA0BFD9D704F22AE1F15FD7F7DDF839868F7A7FDDB03C167520CF1A61CA62D057CB89052695EBCA0248E2429457437044EDA2CF89AFF27C8BB4D779A177137D9C9FCA03B169004066A1D92B53A601ABC5EBF9603AEA1FE9798C001C3B058E0F8892AD592920955CBBE5403868B06F90D7011D9390793CA611883D774853559DA0CBBDE2C25FC5FED3197CFC1725137FFF221DC152F2C906972

Questo comando ottiene informazioni su tutti i certificati di attendibilità del server all'interno dell'istanza "ManagedInstance01".

Esempio 2: Ottenere informazioni su un certificato di attendibilità del server in Istanza gestita di SQL di Azure

Get-AzSqlInstanceServerTrustCertificate -ResourceGroupName "ResourceGroup01" -InstanceName "ManagedInstance01" -Name "Certificate01"

ResourceGroupName : ResourceGroup01
InstanceName      : ManagedInstance01
Id                : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/serverTrustCertificates/Certificate01
Type              : Microsoft.Sql/managedInstances/serverTrustCertificates
Name              : Certificate01
Thumbprint        : 0x7D989DF34BD0FD0D2F9F6B3B6A7096856F5AB004
PublicKey         : 0x1C8E3F85BCD8A2C1D082CE42D7A1E8112651A906B15F5F244134142C53B050FCBF2571965C522EBB86B4F1B790F3AD31E689950EE909B87C25A1BB51DA328BEEB1BB0FD44AB3CB774B8CC9F72B486476DEB8B1C95210B84C4A0F18310CD83F299CAF0D567EBCE2DD008581622D72499F8EC9A686BA526916E7F78DCA90BA0ADD8C2E5F601017D374E2FBD0818458BFC11C8268BC21383613323153163C0F33E09D03586A3BBFDA3628F0358FBADE41602BD05C4E47CDB67A9914F35B315B7844C2F2D1352034B56D6B155D38415B816247779E7A0EB3431765D9A48F4649E647CCD2EA8F38E8B5D415833BA8337BA00FED2F00D9066B9CAEF7BAA8C553F7B8787BCEF63AC98E05372981520BD5A598356590736B547F3B300F1D710EC3003D398AEB94589E196C42C5F6A1873D6138D9F666A2D6F24DAFB12FBD6B0124B2CFFAD51EF67032832900A9E113625BE4C4FB012923BB9886B52B733A5F8BFF04122A2474828F2EE5FC66154D9EBA92A21F0BFD6E8AAEE7DCC45BB3883A410E603C9D98A5BB913853D1B7543E694FF74F8CA9174BE152A96530803DD03C15BC258E77925877BCAF748CA85230ABBF90789F4856200166D110D369FB03B6593339CCE498CDA69016289056F4638E761B9904129DB36B6B4CD17D49567C27FF11059C0569ABF48C438CB6128F2B2F245BDB066B6BF1155BCA11E9D6B0BD8A1607F2F5BB42AF7498D1B8410AA1E5E3E23A3CA6FB933D3894C8D1A2162E735CFCB7BEDFB3318DAE32AE9E24900B9B0F472ABD563550C9E696836889123F0ED2E7A9A4B90C2C617C8ADCF088CE2A7EC8AB97A80C00F3296241C7B320118A1182E327919007930417004A301249EAACF139D611D9C30DAFDF8672F5347C488250F46D45E7D7E9BF3BE99ECD1C60A046FC80EB1DC473FD2E1A7672235F8A834338A4810E32CB24C9C24D09234995A3D038D70379B900E6C9217EF19062775B050CF7CA52D3D72E294E2315AA544247B436D46AD08D55957B9688C576E35760B527B7F7EB71E6209301C59B6643C921F2FB182D237E81DC6205BF6740C8EDC48C65DAB0546C1098C2DCBF0E3B31A47868A721942022E0B5DBFFFBBC4767699C7F0ABD6DEBE7D5FB91

Questo comando ottiene informazioni sul certificato di attendibilità del server "Certificate01" nell'istanza "ManagedInstance01" e nel gruppo di risorse "ResourceGroup01".

Esempio 3: Ottenere tutti i certificati di attendibilità del server in Istanza gestita di SQL di Azure usando l'oggetto Instance

$instance = Get-AzSqlInstance -Name "ManagedInstance01" -ResourceGroupName "ResourceGroup01"
Get-AzSqlInstanceServerTrustCertificate -InstanceObject $instance

ResourceGroupName : ResourceGroup01
InstanceName      : ManagedInstance01
Id                : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/serverTrustCertificates/Certificate01
Type              : Microsoft.Sql/managedInstances/serverTrustCertificates
Name              : Certificate01
Thumbprint        : 0x7D989DF34BD0FD0D2F9F6B3B6A7096856F5AB004
PublicKey         : 0x1C8E3F85BCD8A2C1D082CE42D7A1E8112651A906B15F5F244134142C53B050FCBF2571965C522EBB86B4F1B790F3AD31E689950EE909B87C25A1BB51DA328BEEB1BB0FD44AB3CB774B8CC9F72B486476DEB8B1C95210B84C4A0F18310CD83F299CAF0D567EBCE2DD008581622D72499F8EC9A686BA526916E7F78DCA90BA0ADD8C2E5F601017D374E2FBD0818458BFC11C8268BC21383613323153163C0F33E09D03586A3BBFDA3628F0358FBADE41602BD05C4E47CDB67A9914F35B315B7844C2F2D1352034B56D6B155D38415B816247779E7A0EB3431765D9A48F4649E647CCD2EA8F38E8B5D415833BA8337BA00FED2F00D9066B9CAEF7BAA8C553F7B8787BCEF63AC98E05372981520BD5A598356590736B547F3B300F1D710EC3003D398AEB94589E196C42C5F6A1873D6138D9F666A2D6F24DAFB12FBD6B0124B2CFFAD51EF67032832900A9E113625BE4C4FB012923BB9886B52B733A5F8BFF04122A2474828F2EE5FC66154D9EBA92A21F0BFD6E8AAEE7DCC45BB3883A410E603C9D98A5BB913853D1B7543E694FF74F8CA9174BE152A96530803DD03C15BC258E77925877BCAF748CA85230ABBF90789F4856200166D110D369FB03B6593339CCE498CDA69016289056F4638E761B9904129DB36B6B4CD17D49567C27FF11059C0569ABF48C438CB6128F2B2F245BDB066B6BF1155BCA11E9D6B0BD8A1607F2F5BB42AF7498D1B8410AA1E5E3E23A3CA6FB933D3894C8D1A2162E735CFCB7BEDFB3318DAE32AE9E24900B9B0F472ABD563550C9E696836889123F0ED2E7A9A4B90C2C617C8ADCF088CE2A7EC8AB97A80C00F3296241C7B320118A1182E327919007930417004A301249EAACF139D611D9C30DAFDF8672F5347C488250F46D45E7D7E9BF3BE99ECD1C60A046FC80EB1DC473FD2E1A7672235F8A834338A4810E32CB24C9C24D09234995A3D038D70379B900E6C9217EF19062775B050CF7CA52D3D72E294E2315AA544247B436D46AD08D55957B9688C576E35760B527B7F7EB71E6209301C59B6643C921F2FB182D237E81DC6205BF6740C8EDC48C65DAB0546C1098C2DCBF0E3B31A47868A721942022E0B5DBFFFBBC4767699C7F0ABD6DEBE7D5FB91

ResourceGroupName : ResourceGroup01
InstanceName      : ManagedInstance01
Id                : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/serverTrustCertificates/Certificate02
Type              : Microsoft.Sql/managedInstances/serverTrustCertificates
Name              : Certificate02
Thumbprint        : 0x628B41E23E513EAF9C03F8E2C8A881E0D33D385B
PublicKey         : 0x5D014B47F6AF7D0469A853C84180445C146015D5098F09AC673A49281EDA9D3C560039BAFBD02617BF94DF30B505AA2CA891E3F80BD0056F39B21396F675EBAEA148A12C3EED8F7DE6753A2AAC722EEB1D3A71633A00909F720E74180CC9D7B51E84BEFDDC6A64C7015368FB041E59E836F3968739E7B84654FEDA396BD7E89C9AFCCF4086F8838A1FD5F833C1288EB619A14F68F15094D8BB4DD834F64333AF44A7C0CC5BF4406C408702993B14D04A20772EE23A0C7FED3D89B754EA66C23FDAE65AEAD53F55AE82ADEEDC8B730352D1A0933AD28745FCCA960FAD3AE12693175DA3A14CCF37B221AC35DEF986A9758EAB7DEFB334FF65BBAF8C5F4377F51224459B349CFDDC51A6D5DC9937477EF869CAE4B4165E8A4DC83B3E9D9B7A80E3C0C591DEE00A776E4C1915EDEF276D23BEEDEBF2E673F02857E909B0CEFD6C8D96C8B6E91E1753858974F24D37D0E85558D2A40C82E06B2BF6002CD57ABBEEF8C8C43EBEC5F2624E4E882E3094E62FC7624D2C52DD73DC0C618F1AB96D39316E2E16E301ABDE4FE267DE88425CBFCA9F3131D4FED6BDF7F296B5A7BAC4CB2F9E4A48F0C6BE822B611002A9785A60692F9B25A1EAA7F279FEF4BF5E2BDEA8BEC4E3417E9936E542A19F9D19880065B003537A514754F09ADFA9A08D067BF34D3BEBC56BF4D970526A20886CE25BEB1174496F2AB9BC884BEC3A885875FEF4DBA60F682F68354C40B3E7C3DF62666DA0D655B0BC9EB0A1E470EDF58538DD848ECB5700BD632175644D50C713BFC1ACDC94F6600331F7C14AE8A63C1396699662CF1D5BD668C1BCE1E9AA0A2B5DDDC62294841958A36C03E9D211AA4352FA2918962452F73831B843412725766728AE7BB18B863D1B267AAA5FAB9B735FE50E6B1DF43BD4FA33F5004AECBA0BFD9D704F22AE1F15FD7F7DDF839868F7A7FDDB03C167520CF1A61CA62D057CB89052695EBCA0248E2429457437044EDA2CF89AFF27C8BB4D779A177137D9C9FCA03B169004066A1D92B53A601ABC5EBF9603AEA1FE9798C001C3B058E0F8892AD592920955CBBE5403868B06F90D7011D9390793CA611883D774853559DA0CBBDE2C25FC5FED3197CFC1725137FFF221DC152F2C906972

Questo comando ottiene informazioni su tutti i certificati di attendibilità del server all'interno dell'istanza "ManagedInstance01".

Esempio 4: Ottenere tutti i certificati di attendibilità del server in Istanza gestita di SQL di Azure usando l'identificatore di risorsa

Get-AzSqlInstanceServerTrustCertificate -InstanceResourceId "/subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01"

ResourceGroupName : ResourceGroup01
InstanceName      : ManagedInstance01
Id                : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/serverTrustCertificates/Certificate01
Type              : Microsoft.Sql/managedInstances/serverTrustCertificates
Name              : Certificate01
Thumbprint        : 0x7D989DF34BD0FD0D2F9F6B3B6A7096856F5AB004
PublicKey         : 0x1C8E3F85BCD8A2C1D082CE42D7A1E8112651A906B15F5F244134142C53B050FCBF2571965C522EBB86B4F1B790F3AD31E689950EE909B87C25A1BB51DA328BEEB1BB0FD44AB3CB774B8CC9F72B486476DEB8B1C95210B84C4A0F18310CD83F299CAF0D567EBCE2DD008581622D72499F8EC9A686BA526916E7F78DCA90BA0ADD8C2E5F601017D374E2FBD0818458BFC11C8268BC21383613323153163C0F33E09D03586A3BBFDA3628F0358FBADE41602BD05C4E47CDB67A9914F35B315B7844C2F2D1352034B56D6B155D38415B816247779E7A0EB3431765D9A48F4649E647CCD2EA8F38E8B5D415833BA8337BA00FED2F00D9066B9CAEF7BAA8C553F7B8787BCEF63AC98E05372981520BD5A598356590736B547F3B300F1D710EC3003D398AEB94589E196C42C5F6A1873D6138D9F666A2D6F24DAFB12FBD6B0124B2CFFAD51EF67032832900A9E113625BE4C4FB012923BB9886B52B733A5F8BFF04122A2474828F2EE5FC66154D9EBA92A21F0BFD6E8AAEE7DCC45BB3883A410E603C9D98A5BB913853D1B7543E694FF74F8CA9174BE152A96530803DD03C15BC258E77925877BCAF748CA85230ABBF90789F4856200166D110D369FB03B6593339CCE498CDA69016289056F4638E761B9904129DB36B6B4CD17D49567C27FF11059C0569ABF48C438CB6128F2B2F245BDB066B6BF1155BCA11E9D6B0BD8A1607F2F5BB42AF7498D1B8410AA1E5E3E23A3CA6FB933D3894C8D1A2162E735CFCB7BEDFB3318DAE32AE9E24900B9B0F472ABD563550C9E696836889123F0ED2E7A9A4B90C2C617C8ADCF088CE2A7EC8AB97A80C00F3296241C7B320118A1182E327919007930417004A301249EAACF139D611D9C30DAFDF8672F5347C488250F46D45E7D7E9BF3BE99ECD1C60A046FC80EB1DC473FD2E1A7672235F8A834338A4810E32CB24C9C24D09234995A3D038D70379B900E6C9217EF19062775B050CF7CA52D3D72E294E2315AA544247B436D46AD08D55957B9688C576E35760B527B7F7EB71E6209301C59B6643C921F2FB182D237E81DC6205BF6740C8EDC48C65DAB0546C1098C2DCBF0E3B31A47868A721942022E0B5DBFFFBBC4767699C7F0ABD6DEBE7D5FB91

ResourceGroupName : ResourceGroup01
InstanceName      : ManagedInstance01
Id                : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/serverTrustCertificates/Certificate02
Type              : Microsoft.Sql/managedInstances/serverTrustCertificates
Name              : Certificate02
Thumbprint        : 0x628B41E23E513EAF9C03F8E2C8A881E0D33D385B
PublicKey         : 0x5D014B47F6AF7D0469A853C84180445C146015D5098F09AC673A49281EDA9D3C560039BAFBD02617BF94DF30B505AA2CA891E3F80BD0056F39B21396F675EBAEA148A12C3EED8F7DE6753A2AAC722EEB1D3A71633A00909F720E74180CC9D7B51E84BEFDDC6A64C7015368FB041E59E836F3968739E7B84654FEDA396BD7E89C9AFCCF4086F8838A1FD5F833C1288EB619A14F68F15094D8BB4DD834F64333AF44A7C0CC5BF4406C408702993B14D04A20772EE23A0C7FED3D89B754EA66C23FDAE65AEAD53F55AE82ADEEDC8B730352D1A0933AD28745FCCA960FAD3AE12693175DA3A14CCF37B221AC35DEF986A9758EAB7DEFB334FF65BBAF8C5F4377F51224459B349CFDDC51A6D5DC9937477EF869CAE4B4165E8A4DC83B3E9D9B7A80E3C0C591DEE00A776E4C1915EDEF276D23BEEDEBF2E673F02857E909B0CEFD6C8D96C8B6E91E1753858974F24D37D0E85558D2A40C82E06B2BF6002CD57ABBEEF8C8C43EBEC5F2624E4E882E3094E62FC7624D2C52DD73DC0C618F1AB96D39316E2E16E301ABDE4FE267DE88425CBFCA9F3131D4FED6BDF7F296B5A7BAC4CB2F9E4A48F0C6BE822B611002A9785A60692F9B25A1EAA7F279FEF4BF5E2BDEA8BEC4E3417E9936E542A19F9D19880065B003537A514754F09ADFA9A08D067BF34D3BEBC56BF4D970526A20886CE25BEB1174496F2AB9BC884BEC3A885875FEF4DBA60F682F68354C40B3E7C3DF62666DA0D655B0BC9EB0A1E470EDF58538DD848ECB5700BD632175644D50C713BFC1ACDC94F6600331F7C14AE8A63C1396699662CF1D5BD668C1BCE1E9AA0A2B5DDDC62294841958A36C03E9D211AA4352FA2918962452F73831B843412725766728AE7BB18B863D1B267AAA5FAB9B735FE50E6B1DF43BD4FA33F5004AECBA0BFD9D704F22AE1F15FD7F7DDF839868F7A7FDDB03C167520CF1A61CA62D057CB89052695EBCA0248E2429457437044EDA2CF89AFF27C8BB4D779A177137D9C9FCA03B169004066A1D92B53A601ABC5EBF9603AEA1FE9798C001C3B058E0F8892AD592920955CBBE5403868B06F90D7011D9390793CA611883D774853559DA0CBBDE2C25FC5FED3197CFC1725137FFF221DC152F2C906972

Questo comando ottiene informazioni su tutti i certificati di attendibilità del server all'interno dell'istanza "ManagedInstance01".

Esempio 5: Ottenere un certificato di attendibilità server usando il relativo identificatore di risorsa

Get-AzSqlInstanceServerTrustCertificate -ResourceId "/subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/serverTrustCertificates/Certificate01"

ResourceGroupName : ResourceGroup01
InstanceName      : ManagedInstance01
Id                : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/serverTrustCertificates/Certificate01
Type              : Microsoft.Sql/managedInstances/serverTrustCertificates
Name              : Certificate01
Thumbprint        : 0x7D989DF34BD0FD0D2F9F6B3B6A7096856F5AB004
PublicKey         : 0x1C8E3F85BCD8A2C1D082CE42D7A1E8112651A906B15F5F244134142C53B050FCBF2571965C522EBB86B4F1B790F3AD31E689950EE909B87C25A1BB51DA328BEEB1BB0FD44AB3CB774B8CC9F72B486476DEB8B1C95210B84C4A0F18310CD83F299CAF0D567EBCE2DD008581622D72499F8EC9A686BA526916E7F78DCA90BA0ADD8C2E5F601017D374E2FBD0818458BFC11C8268BC21383613323153163C0F33E09D03586A3BBFDA3628F0358FBADE41602BD05C4E47CDB67A9914F35B315B7844C2F2D1352034B56D6B155D38415B816247779E7A0EB3431765D9A48F4649E647CCD2EA8F38E8B5D415833BA8337BA00FED2F00D9066B9CAEF7BAA8C553F7B8787BCEF63AC98E05372981520BD5A598356590736B547F3B300F1D710EC3003D398AEB94589E196C42C5F6A1873D6138D9F666A2D6F24DAFB12FBD6B0124B2CFFAD51EF67032832900A9E113625BE4C4FB012923BB9886B52B733A5F8BFF04122A2474828F2EE5FC66154D9EBA92A21F0BFD6E8AAEE7DCC45BB3883A410E603C9D98A5BB913853D1B7543E694FF74F8CA9174BE152A96530803DD03C15BC258E77925877BCAF748CA85230ABBF90789F4856200166D110D369FB03B6593339CCE498CDA69016289056F4638E761B9904129DB36B6B4CD17D49567C27FF11059C0569ABF48C438CB6128F2B2F245BDB066B6BF1155BCA11E9D6B0BD8A1607F2F5BB42AF7498D1B8410AA1E5E3E23A3CA6FB933D3894C8D1A2162E735CFCB7BEDFB3318DAE32AE9E24900B9B0F472ABD563550C9E696836889123F0ED2E7A9A4B90C2C617C8ADCF088CE2A7EC8AB97A80C00F3296241C7B320118A1182E327919007930417004A301249EAACF139D611D9C30DAFDF8672F5347C488250F46D45E7D7E9BF3BE99ECD1C60A046FC80EB1DC473FD2E1A7672235F8A834338A4810E32CB24C9C24D09234995A3D038D70379B900E6C9217EF19062775B050CF7CA52D3D72E294E2315AA544247B436D46AD08D55957B9688C576E35760B527B7F7EB71E6209301C59B6643C921F2FB182D237E81DC6205BF6740C8EDC48C65DAB0546C1098C2DCBF0E3B31A47868A721942022E0B5DBFFFBBC4767699C7F0ABD6DEBE7D5FB91

Questo comando ottiene informazioni sul certificato di attendibilità del server denominato "Certificate01".

Esempio 6: Ottenere tutti i certificati di attendibilità del server per un Istanza gestita tramite pipe di un oggetto istanza

Get-AzSqlInstance -Name "ManagedInstance01" -ResourceGroupName "ResourceGroup01" | Get-AzSqlInstanceServerTrustCertificate

ResourceGroupName : ResourceGroup01
InstanceName      : ManagedInstance01
Id                : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/serverTrustCertificates/Certificate01
Type              : Microsoft.Sql/managedInstances/serverTrustCertificates
Name              : Certificate01
Thumbprint        : 0x7D989DF34BD0FD0D2F9F6B3B6A7096856F5AB004
PublicKey         : 0x1C8E3F85BCD8A2C1D082CE42D7A1E8112651A906B15F5F244134142C53B050FCBF2571965C522EBB86B4F1B790F3AD31E689950EE909B87C25A1BB51DA328BEEB1BB0FD44AB3CB774B8CC9F72B486476DEB8B1C95210B84C4A0F18310CD83F299CAF0D567EBCE2DD008581622D72499F8EC9A686BA526916E7F78DCA90BA0ADD8C2E5F601017D374E2FBD0818458BFC11C8268BC21383613323153163C0F33E09D03586A3BBFDA3628F0358FBADE41602BD05C4E47CDB67A9914F35B315B7844C2F2D1352034B56D6B155D38415B816247779E7A0EB3431765D9A48F4649E647CCD2EA8F38E8B5D415833BA8337BA00FED2F00D9066B9CAEF7BAA8C553F7B8787BCEF63AC98E05372981520BD5A598356590736B547F3B300F1D710EC3003D398AEB94589E196C42C5F6A1873D6138D9F666A2D6F24DAFB12FBD6B0124B2CFFAD51EF67032832900A9E113625BE4C4FB012923BB9886B52B733A5F8BFF04122A2474828F2EE5FC66154D9EBA92A21F0BFD6E8AAEE7DCC45BB3883A410E603C9D98A5BB913853D1B7543E694FF74F8CA9174BE152A96530803DD03C15BC258E77925877BCAF748CA85230ABBF90789F4856200166D110D369FB03B6593339CCE498CDA69016289056F4638E761B9904129DB36B6B4CD17D49567C27FF11059C0569ABF48C438CB6128F2B2F245BDB066B6BF1155BCA11E9D6B0BD8A1607F2F5BB42AF7498D1B8410AA1E5E3E23A3CA6FB933D3894C8D1A2162E735CFCB7BEDFB3318DAE32AE9E24900B9B0F472ABD563550C9E696836889123F0ED2E7A9A4B90C2C617C8ADCF088CE2A7EC8AB97A80C00F3296241C7B320118A1182E327919007930417004A301249EAACF139D611D9C30DAFDF8672F5347C488250F46D45E7D7E9BF3BE99ECD1C60A046FC80EB1DC473FD2E1A7672235F8A834338A4810E32CB24C9C24D09234995A3D038D70379B900E6C9217EF19062775B050CF7CA52D3D72E294E2315AA544247B436D46AD08D55957B9688C576E35760B527B7F7EB71E6209301C59B6643C921F2FB182D237E81DC6205BF6740C8EDC48C65DAB0546C1098C2DCBF0E3B31A47868A721942022E0B5DBFFFBBC4767699C7F0ABD6DEBE7D5FB91

ResourceGroupName : ResourceGroup01
InstanceName      : ManagedInstance01
Id                : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/serverTrustCertificates/Certificate02
Type              : Microsoft.Sql/managedInstances/serverTrustCertificates
Name              : Certificate02
Thumbprint        : 0x628B41E23E513EAF9C03F8E2C8A881E0D33D385B
PublicKey         : 0x5D014B47F6AF7D0469A853C84180445C146015D5098F09AC673A49281EDA9D3C560039BAFBD02617BF94DF30B505AA2CA891E3F80BD0056F39B21396F675EBAEA148A12C3EED8F7DE6753A2AAC722EEB1D3A71633A00909F720E74180CC9D7B51E84BEFDDC6A64C7015368FB041E59E836F3968739E7B84654FEDA396BD7E89C9AFCCF4086F8838A1FD5F833C1288EB619A14F68F15094D8BB4DD834F64333AF44A7C0CC5BF4406C408702993B14D04A20772EE23A0C7FED3D89B754EA66C23FDAE65AEAD53F55AE82ADEEDC8B730352D1A0933AD28745FCCA960FAD3AE12693175DA3A14CCF37B221AC35DEF986A9758EAB7DEFB334FF65BBAF8C5F4377F51224459B349CFDDC51A6D5DC9937477EF869CAE4B4165E8A4DC83B3E9D9B7A80E3C0C591DEE00A776E4C1915EDEF276D23BEEDEBF2E673F02857E909B0CEFD6C8D96C8B6E91E1753858974F24D37D0E85558D2A40C82E06B2BF6002CD57ABBEEF8C8C43EBEC5F2624E4E882E3094E62FC7624D2C52DD73DC0C618F1AB96D39316E2E16E301ABDE4FE267DE88425CBFCA9F3131D4FED6BDF7F296B5A7BAC4CB2F9E4A48F0C6BE822B611002A9785A60692F9B25A1EAA7F279FEF4BF5E2BDEA8BEC4E3417E9936E542A19F9D19880065B003537A514754F09ADFA9A08D067BF34D3BEBC56BF4D970526A20886CE25BEB1174496F2AB9BC884BEC3A885875FEF4DBA60F682F68354C40B3E7C3DF62666DA0D655B0BC9EB0A1E470EDF58538DD848ECB5700BD632175644D50C713BFC1ACDC94F6600331F7C14AE8A63C1396699662CF1D5BD668C1BCE1E9AA0A2B5DDDC62294841958A36C03E9D211AA4352FA2918962452F73831B843412725766728AE7BB18B863D1B267AAA5FAB9B735FE50E6B1DF43BD4FA33F5004AECBA0BFD9D704F22AE1F15FD7F7DDF839868F7A7FDDB03C167520CF1A61CA62D057CB89052695EBCA0248E2429457437044EDA2CF89AFF27C8BB4D779A177137D9C9FCA03B169004066A1D92B53A601ABC5EBF9603AEA1FE9798C001C3B058E0F8892AD592920955CBBE5403868B06F90D7011D9390793CA611883D774853559DA0CBBDE2C25FC5FED3197CFC1725137FFF221DC152F2C906972

Questo comando ottiene informazioni su tutti i certificati di attendibilità del server all'interno dell'istanza "ManagedInstance01".

Esempio 7: Ottenere un certificato di attendibilità del server specifico per un'istanza eseguendo il piping di un oggetto istanza e specificando il nome del certificato

Get-AzSqlInstance -Name "ManagedInstance01" -ResourceGroupName "ResourceGroup01" | Get-AzSqlInstanceServerTrustCertificate -Name "Certificate01"

ResourceGroupName : ResourceGroup01
InstanceName      : ManagedInstance01
Id                : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/serverTrustCertificates/Certificate01
Type              : Microsoft.Sql/managedInstances/serverTrustCertificates
Name              : Certificate01
Thumbprint        : 0x7D989DF34BD0FD0D2F9F6B3B6A7096856F5AB004
PublicKey         : 0x1C8E3F85BCD8A2C1D082CE42D7A1E8112651A906B15F5F244134142C53B050FCBF2571965C522EBB86B4F1B790F3AD31E689950EE909B87C25A1BB51DA328BEEB1BB0FD44AB3CB774B8CC9F72B486476DEB8B1C95210B84C4A0F18310CD83F299CAF0D567EBCE2DD008581622D72499F8EC9A686BA526916E7F78DCA90BA0ADD8C2E5F601017D374E2FBD0818458BFC11C8268BC21383613323153163C0F33E09D03586A3BBFDA3628F0358FBADE41602BD05C4E47CDB67A9914F35B315B7844C2F2D1352034B56D6B155D38415B816247779E7A0EB3431765D9A48F4649E647CCD2EA8F38E8B5D415833BA8337BA00FED2F00D9066B9CAEF7BAA8C553F7B8787BCEF63AC98E05372981520BD5A598356590736B547F3B300F1D710EC3003D398AEB94589E196C42C5F6A1873D6138D9F666A2D6F24DAFB12FBD6B0124B2CFFAD51EF67032832900A9E113625BE4C4FB012923BB9886B52B733A5F8BFF04122A2474828F2EE5FC66154D9EBA92A21F0BFD6E8AAEE7DCC45BB3883A410E603C9D98A5BB913853D1B7543E694FF74F8CA9174BE152A96530803DD03C15BC258E77925877BCAF748CA85230ABBF90789F4856200166D110D369FB03B6593339CCE498CDA69016289056F4638E761B9904129DB36B6B4CD17D49567C27FF11059C0569ABF48C438CB6128F2B2F245BDB066B6BF1155BCA11E9D6B0BD8A1607F2F5BB42AF7498D1B8410AA1E5E3E23A3CA6FB933D3894C8D1A2162E735CFCB7BEDFB3318DAE32AE9E24900B9B0F472ABD563550C9E696836889123F0ED2E7A9A4B90C2C617C8ADCF088CE2A7EC8AB97A80C00F3296241C7B320118A1182E327919007930417004A301249EAACF139D611D9C30DAFDF8672F5347C488250F46D45E7D7E9BF3BE99ECD1C60A046FC80EB1DC473FD2E1A7672235F8A834338A4810E32CB24C9C24D09234995A3D038D70379B900E6C9217EF19062775B050CF7CA52D3D72E294E2315AA544247B436D46AD08D55957B9688C576E35760B527B7F7EB71E6209301C59B6643C921F2FB182D237E81DC6205BF6740C8EDC48C65DAB0546C1098C2DCBF0E3B31A47868A721942022E0B5DBFFFBBC4767699C7F0ABD6DEBE7D5FB91

Questo comando ottiene informazioni sul certificato di attendibilità del server denominato "Certificate01" nell'istanza "ManagedInstance01" e nel gruppo di risorse "ResourceGroup01".

Esempio 8: Ottenere informazioni sul certificato di attendibilità server usando i parametri posizionali

Get-AzSqlInstanceServerTrustCertificate "ResourceGroup01" "ManagedInstance01" "Certificate01"

ResourceGroupName : ResourceGroup01
InstanceName      : ManagedInstance01
Id                : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/serverTrustCertificates/Certificate01
Type              : Microsoft.Sql/managedInstances/serverTrustCertificates
Name              : Certificate01
Thumbprint        : 0x7D989DF34BD0FD0D2F9F6B3B6A7096856F5AB004
PublicKey         : 0x1C8E3F85BCD8A2C1D082CE42D7A1E8112651A906B15F5F244134142C53B050FCBF2571965C522EBB86B4F1B790F3AD31E689950EE909B87C25A1BB51DA328BEEB1BB0FD44AB3CB774B8CC9F72B486476DEB8B1C95210B84C4A0F18310CD83F299CAF0D567EBCE2DD008581622D72499F8EC9A686BA526916E7F78DCA90BA0ADD8C2E5F601017D374E2FBD0818458BFC11C8268BC21383613323153163C0F33E09D03586A3BBFDA3628F0358FBADE41602BD05C4E47CDB67A9914F35B315B7844C2F2D1352034B56D6B155D38415B816247779E7A0EB3431765D9A48F4649E647CCD2EA8F38E8B5D415833BA8337BA00FED2F00D9066B9CAEF7BAA8C553F7B8787BCEF63AC98E05372981520BD5A598356590736B547F3B300F1D710EC3003D398AEB94589E196C42C5F6A1873D6138D9F666A2D6F24DAFB12FBD6B0124B2CFFAD51EF67032832900A9E113625BE4C4FB012923BB9886B52B733A5F8BFF04122A2474828F2EE5FC66154D9EBA92A21F0BFD6E8AAEE7DCC45BB3883A410E603C9D98A5BB913853D1B7543E694FF74F8CA9174BE152A96530803DD03C15BC258E77925877BCAF748CA85230ABBF90789F4856200166D110D369FB03B6593339CCE498CDA69016289056F4638E761B9904129DB36B6B4CD17D49567C27FF11059C0569ABF48C438CB6128F2B2F245BDB066B6BF1155BCA11E9D6B0BD8A1607F2F5BB42AF7498D1B8410AA1E5E3E23A3CA6FB933D3894C8D1A2162E735CFCB7BEDFB3318DAE32AE9E24900B9B0F472ABD563550C9E696836889123F0ED2E7A9A4B90C2C617C8ADCF088CE2A7EC8AB97A80C00F3296241C7B320118A1182E327919007930417004A301249EAACF139D611D9C30DAFDF8672F5347C488250F46D45E7D7E9BF3BE99ECD1C60A046FC80EB1DC473FD2E1A7672235F8A834338A4810E32CB24C9C24D09234995A3D038D70379B900E6C9217EF19062775B050CF7CA52D3D72E294E2315AA544247B436D46AD08D55957B9688C576E35760B527B7F7EB71E6209301C59B6643C921F2FB182D237E81DC6205BF6740C8EDC48C65DAB0546C1098C2DCBF0E3B31A47868A721942022E0B5DBFFFBBC4767699C7F0ABD6DEBE7D5FB91

Questo comando ottiene informazioni sul certificato di attendibilità del server "Certificate01" nell'istanza "ManagedInstance01" e nel gruppo di risorse "ResourceGroup01".

Parametri

-DefaultProfile

Le credenziali, l’account, il tenant e la sottoscrizione usati per comunicare con Azure.

Tipo:IAzureContextContainer
Alias:AzContext, AzureRmContext, AzureCredential
Posizione:Named
Valore predefinito:None
Necessario:False
Accettare l'input della pipeline:False
Accettare caratteri jolly:False

-InstanceName

Nome del Istanza gestita di SQL di Azure.

Tipo:String
Posizione:1
Valore predefinito:None
Necessario:True
Accettare l'input della pipeline:False
Accettare caratteri jolly:False

-InstanceObject

Oggetto di input dell'istanza.

Tipo:AzureSqlManagedInstanceModel
Posizione:0
Valore predefinito:None
Necessario:True
Accettare l'input della pipeline:True
Accettare caratteri jolly:False

-InstanceResourceId

ID risorsa dell'istanza gestita.

Tipo:String
Posizione:0
Valore predefinito:None
Necessario:True
Accettare l'input della pipeline:True
Accettare caratteri jolly:False

-Name

Nome del certificato.

Tipo:String
Alias:CertificateName
Posizione:2
Valore predefinito:None
Necessario:False
Accettare l'input della pipeline:False
Accettare caratteri jolly:False

-ResourceGroupName

Nome del gruppo di risorse.

Tipo:String
Posizione:0
Valore predefinito:None
Necessario:True
Accettare l'input della pipeline:False
Accettare caratteri jolly:False

-ResourceId

ID risorsa certificato.

Tipo:String
Posizione:0
Valore predefinito:None
Necessario:True
Accettare l'input della pipeline:True
Accettare caratteri jolly:False

Input

AzureSqlManagedInstanceModel

String

Output

AzureSqlInstanceServerTrustCertificateModel