Get-AzSqlInstanceServerTrustCertificate
Devuelve información sobre el certificado de confianza del servidor.
Syntax
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>] Description
El cmdlet Get-AzSqlInstanceServerTrustCertificate devuelve información sobre una o varias instancias de certificado de confianza de servidor en una Instancia administrada de Azure SQL. Especifique el nombre de un certificado para ver información solo para ese certificado.
Ejemplos
Ejemplo 1: Obtener información sobre todos los certificados de confianza de servidor en Azure SQL Instancia administrada
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 : 0x5D014B47F6AF7D0469A853C84180445C146015D5098F09AC673A49281EDA9D3C560039BAFBD02617BF94DF30B505AA2CA891E3F80BD0056F39B21396F675EBAEA148A12C3EED8F7DE6753A2AAC722EEB1D3A71633A00909F720E74180CC9D7B51E84BEFDDC6A64C7015368FB041E59E836F3968739E7B84654FEDA396BD7E89C9AFCCF4086F8838A1FD5F833C1288EB619A14F68F15094D8BB4DD834F64333AF44A7C0CC5BF4406C408702993B14D04A20772EE23A0C7FED3D89B754EA66C23FDAE65AEAD53F55AE82ADEEDC8B730352D1A0933AD28745FCCA960FAD3AE12693175DA3A14CCF37B221AC35DEF986A9758EAB7DEFB334FF65BBAF8C5F4377F51224459B349CFDDC51A6D5DC9937477EF869CAE4B4165E8A4DC83B3E9D9B7A80E3C0C591DEE00A776E4C1915EDEF276D23BEEDEBF2E673F02857E909B0CEFD6C8D96C8B6E91E1753858974F24D37D0E85558D2A40C82E06B2BF6002CD57ABBEEF8C8C43EBEC5F2624E4E882E3094E62FC7624D2C52DD73DC0C618F1AB96D39316E2E16E301ABDE4FE267DE88425CBFCA9F3131D4FED6BDF7F296B5A7BAC4CB2F9E4A48F0C6BE822B611002A9785A60692F9B25A1EAA7F279FEF4BF5E2BDEA8BEC4E3417E9936E542A19F9D19880065B003537A514754F09ADFA9A08D067BF34D3BEBC56BF4D970526A20886CE25BEB1174496F2AB9BC884BEC3A885875FEF4DBA60F682F68354C40B3E7C3DF62666DA0D655B0BC9EB0A1E470EDF58538DD848ECB5700BD632175644D50C713BFC1ACDC94F6600331F7C14AE8A63C1396699662CF1D5BD668C1BCE1E9AA0A2B5DDDC62294841958A36C03E9D211AA4352FA2918962452F73831B843412725766728AE7BB18B863D1B267AAA5FAB9B735FE50E6B1DF43BD4FA33F5004AECBA0BFD9D704F22AE1F15FD7F7DDF839868F7A7FDDB03C167520CF1A61CA62D057CB89052695EBCA0248E2429457437044EDA2CF89AFF27C8BB4D779A177137D9C9FCA03B169004066A1D92B53A601ABC5EBF9603AEA1FE9798C001C3B058E0F8892AD592920955CBBE5403868B06F90D7011D9390793CA611883D774853559DA0CBBDE2C25FC5FED3197CFC1725137FFF221DC152F2C906972Este comando obtiene información sobre todos los certificados de confianza del servidor dentro de la instancia "ManagedInstance01".
Ejemplo 2: Obtención de información sobre un certificado de confianza de servidor en Azure SQL Instancia administrada
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 : 0x1C8E3F85BCD8A2C1D082CE42D7A1E8112651A906B15F5F244134142C53B050FCBF2571965C522EBB86B4F1B790F3AD31E689950EE909B87C25A1BB51DA328BEEB1BB0FD44AB3CB774B8CC9F72B486476DEB8B1C95210B84C4A0F18310CD83F299CAF0D567EBCE2DD008581622D72499F8EC9A686BA526916E7F78DCA90BA0ADD8C2E5F601017D374E2FBD0818458BFC11C8268BC21383613323153163C0F33E09D03586A3BBFDA3628F0358FBADE41602BD05C4E47CDB67A9914F35B315B7844C2F2D1352034B56D6B155D38415B816247779E7A0EB3431765D9A48F4649E647CCD2EA8F38E8B5D415833BA8337BA00FED2F00D9066B9CAEF7BAA8C553F7B8787BCEF63AC98E05372981520BD5A598356590736B547F3B300F1D710EC3003D398AEB94589E196C42C5F6A1873D6138D9F666A2D6F24DAFB12FBD6B0124B2CFFAD51EF67032832900A9E113625BE4C4FB012923BB9886B52B733A5F8BFF04122A2474828F2EE5FC66154D9EBA92A21F0BFD6E8AAEE7DCC45BB3883A410E603C9D98A5BB913853D1B7543E694FF74F8CA9174BE152A96530803DD03C15BC258E77925877BCAF748CA85230ABBF90789F4856200166D110D369FB03B6593339CCE498CDA69016289056F4638E761B9904129DB36B6B4CD17D49567C27FF11059C0569ABF48C438CB6128F2B2F245BDB066B6BF1155BCA11E9D6B0BD8A1607F2F5BB42AF7498D1B8410AA1E5E3E23A3CA6FB933D3894C8D1A2162E735CFCB7BEDFB3318DAE32AE9E24900B9B0F472ABD563550C9E696836889123F0ED2E7A9A4B90C2C617C8ADCF088CE2A7EC8AB97A80C00F3296241C7B320118A1182E327919007930417004A301249EAACF139D611D9C30DAFDF8672F5347C488250F46D45E7D7E9BF3BE99ECD1C60A046FC80EB1DC473FD2E1A7672235F8A834338A4810E32CB24C9C24D09234995A3D038D70379B900E6C9217EF19062775B050CF7CA52D3D72E294E2315AA544247B436D46AD08D55957B9688C576E35760B527B7F7EB71E6209301C59B6643C921F2FB182D237E81DC6205BF6740C8EDC48C65DAB0546C1098C2DCBF0E3B31A47868A721942022E0B5DBFFFBBC4767699C7F0ABD6DEBE7D5FB91Este comando obtiene información sobre el certificado de confianza de servidor "Certificate01" en la instancia "ManagedInstance01" y el grupo de recursos "ResourceGroup01".
Ejemplo 3: Obtención de todos los certificados de confianza de servidor en Azure SQL Instancia administrada mediante el objeto 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 : 0x5D014B47F6AF7D0469A853C84180445C146015D5098F09AC673A49281EDA9D3C560039BAFBD02617BF94DF30B505AA2CA891E3F80BD0056F39B21396F675EBAEA148A12C3EED8F7DE6753A2AAC722EEB1D3A71633A00909F720E74180CC9D7B51E84BEFDDC6A64C7015368FB041E59E836F3968739E7B84654FEDA396BD7E89C9AFCCF4086F8838A1FD5F833C1288EB619A14F68F15094D8BB4DD834F64333AF44A7C0CC5BF4406C408702993B14D04A20772EE23A0C7FED3D89B754EA66C23FDAE65AEAD53F55AE82ADEEDC8B730352D1A0933AD28745FCCA960FAD3AE12693175DA3A14CCF37B221AC35DEF986A9758EAB7DEFB334FF65BBAF8C5F4377F51224459B349CFDDC51A6D5DC9937477EF869CAE4B4165E8A4DC83B3E9D9B7A80E3C0C591DEE00A776E4C1915EDEF276D23BEEDEBF2E673F02857E909B0CEFD6C8D96C8B6E91E1753858974F24D37D0E85558D2A40C82E06B2BF6002CD57ABBEEF8C8C43EBEC5F2624E4E882E3094E62FC7624D2C52DD73DC0C618F1AB96D39316E2E16E301ABDE4FE267DE88425CBFCA9F3131D4FED6BDF7F296B5A7BAC4CB2F9E4A48F0C6BE822B611002A9785A60692F9B25A1EAA7F279FEF4BF5E2BDEA8BEC4E3417E9936E542A19F9D19880065B003537A514754F09ADFA9A08D067BF34D3BEBC56BF4D970526A20886CE25BEB1174496F2AB9BC884BEC3A885875FEF4DBA60F682F68354C40B3E7C3DF62666DA0D655B0BC9EB0A1E470EDF58538DD848ECB5700BD632175644D50C713BFC1ACDC94F6600331F7C14AE8A63C1396699662CF1D5BD668C1BCE1E9AA0A2B5DDDC62294841958A36C03E9D211AA4352FA2918962452F73831B843412725766728AE7BB18B863D1B267AAA5FAB9B735FE50E6B1DF43BD4FA33F5004AECBA0BFD9D704F22AE1F15FD7F7DDF839868F7A7FDDB03C167520CF1A61CA62D057CB89052695EBCA0248E2429457437044EDA2CF89AFF27C8BB4D779A177137D9C9FCA03B169004066A1D92B53A601ABC5EBF9603AEA1FE9798C001C3B058E0F8892AD592920955CBBE5403868B06F90D7011D9390793CA611883D774853559DA0CBBDE2C25FC5FED3197CFC1725137FFF221DC152F2C906972Este comando obtiene información sobre todos los certificados de confianza del servidor dentro de la instancia "ManagedInstance01".
Ejemplo 4: Obtención de todos los certificados de confianza de servidor en Azure SQL Instancia administrada mediante el identificador de recursos
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 : 0x5D014B47F6AF7D0469A853C84180445C146015D5098F09AC673A49281EDA9D3C560039BAFBD02617BF94DF30B505AA2CA891E3F80BD0056F39B21396F675EBAEA148A12C3EED8F7DE6753A2AAC722EEB1D3A71633A00909F720E74180CC9D7B51E84BEFDDC6A64C7015368FB041E59E836F3968739E7B84654FEDA396BD7E89C9AFCCF4086F8838A1FD5F833C1288EB619A14F68F15094D8BB4DD834F64333AF44A7C0CC5BF4406C408702993B14D04A20772EE23A0C7FED3D89B754EA66C23FDAE65AEAD53F55AE82ADEEDC8B730352D1A0933AD28745FCCA960FAD3AE12693175DA3A14CCF37B221AC35DEF986A9758EAB7DEFB334FF65BBAF8C5F4377F51224459B349CFDDC51A6D5DC9937477EF869CAE4B4165E8A4DC83B3E9D9B7A80E3C0C591DEE00A776E4C1915EDEF276D23BEEDEBF2E673F02857E909B0CEFD6C8D96C8B6E91E1753858974F24D37D0E85558D2A40C82E06B2BF6002CD57ABBEEF8C8C43EBEC5F2624E4E882E3094E62FC7624D2C52DD73DC0C618F1AB96D39316E2E16E301ABDE4FE267DE88425CBFCA9F3131D4FED6BDF7F296B5A7BAC4CB2F9E4A48F0C6BE822B611002A9785A60692F9B25A1EAA7F279FEF4BF5E2BDEA8BEC4E3417E9936E542A19F9D19880065B003537A514754F09ADFA9A08D067BF34D3BEBC56BF4D970526A20886CE25BEB1174496F2AB9BC884BEC3A885875FEF4DBA60F682F68354C40B3E7C3DF62666DA0D655B0BC9EB0A1E470EDF58538DD848ECB5700BD632175644D50C713BFC1ACDC94F6600331F7C14AE8A63C1396699662CF1D5BD668C1BCE1E9AA0A2B5DDDC62294841958A36C03E9D211AA4352FA2918962452F73831B843412725766728AE7BB18B863D1B267AAA5FAB9B735FE50E6B1DF43BD4FA33F5004AECBA0BFD9D704F22AE1F15FD7F7DDF839868F7A7FDDB03C167520CF1A61CA62D057CB89052695EBCA0248E2429457437044EDA2CF89AFF27C8BB4D779A177137D9C9FCA03B169004066A1D92B53A601ABC5EBF9603AEA1FE9798C001C3B058E0F8892AD592920955CBBE5403868B06F90D7011D9390793CA611883D774853559DA0CBBDE2C25FC5FED3197CFC1725137FFF221DC152F2C906972Este comando obtiene información sobre todos los certificados de confianza del servidor dentro de la instancia "ManagedInstance01".
Ejemplo 5: Obtención de un certificado de confianza de servidor mediante su identificador de recurso
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 : 0x1C8E3F85BCD8A2C1D082CE42D7A1E8112651A906B15F5F244134142C53B050FCBF2571965C522EBB86B4F1B790F3AD31E689950EE909B87C25A1BB51DA328BEEB1BB0FD44AB3CB774B8CC9F72B486476DEB8B1C95210B84C4A0F18310CD83F299CAF0D567EBCE2DD008581622D72499F8EC9A686BA526916E7F78DCA90BA0ADD8C2E5F601017D374E2FBD0818458BFC11C8268BC21383613323153163C0F33E09D03586A3BBFDA3628F0358FBADE41602BD05C4E47CDB67A9914F35B315B7844C2F2D1352034B56D6B155D38415B816247779E7A0EB3431765D9A48F4649E647CCD2EA8F38E8B5D415833BA8337BA00FED2F00D9066B9CAEF7BAA8C553F7B8787BCEF63AC98E05372981520BD5A598356590736B547F3B300F1D710EC3003D398AEB94589E196C42C5F6A1873D6138D9F666A2D6F24DAFB12FBD6B0124B2CFFAD51EF67032832900A9E113625BE4C4FB012923BB9886B52B733A5F8BFF04122A2474828F2EE5FC66154D9EBA92A21F0BFD6E8AAEE7DCC45BB3883A410E603C9D98A5BB913853D1B7543E694FF74F8CA9174BE152A96530803DD03C15BC258E77925877BCAF748CA85230ABBF90789F4856200166D110D369FB03B6593339CCE498CDA69016289056F4638E761B9904129DB36B6B4CD17D49567C27FF11059C0569ABF48C438CB6128F2B2F245BDB066B6BF1155BCA11E9D6B0BD8A1607F2F5BB42AF7498D1B8410AA1E5E3E23A3CA6FB933D3894C8D1A2162E735CFCB7BEDFB3318DAE32AE9E24900B9B0F472ABD563550C9E696836889123F0ED2E7A9A4B90C2C617C8ADCF088CE2A7EC8AB97A80C00F3296241C7B320118A1182E327919007930417004A301249EAACF139D611D9C30DAFDF8672F5347C488250F46D45E7D7E9BF3BE99ECD1C60A046FC80EB1DC473FD2E1A7672235F8A834338A4810E32CB24C9C24D09234995A3D038D70379B900E6C9217EF19062775B050CF7CA52D3D72E294E2315AA544247B436D46AD08D55957B9688C576E35760B527B7F7EB71E6209301C59B6643C921F2FB182D237E81DC6205BF6740C8EDC48C65DAB0546C1098C2DCBF0E3B31A47868A721942022E0B5DBFFFBBC4767699C7F0ABD6DEBE7D5FB91Este comando obtiene información sobre el certificado de confianza del servidor denominado "Certificate01".
Ejemplo 6: Obtención de todos los certificados de confianza de servidor para un Instancia administrada canalizando un objeto de instancia
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 : 0x5D014B47F6AF7D0469A853C84180445C146015D5098F09AC673A49281EDA9D3C560039BAFBD02617BF94DF30B505AA2CA891E3F80BD0056F39B21396F675EBAEA148A12C3EED8F7DE6753A2AAC722EEB1D3A71633A00909F720E74180CC9D7B51E84BEFDDC6A64C7015368FB041E59E836F3968739E7B84654FEDA396BD7E89C9AFCCF4086F8838A1FD5F833C1288EB619A14F68F15094D8BB4DD834F64333AF44A7C0CC5BF4406C408702993B14D04A20772EE23A0C7FED3D89B754EA66C23FDAE65AEAD53F55AE82ADEEDC8B730352D1A0933AD28745FCCA960FAD3AE12693175DA3A14CCF37B221AC35DEF986A9758EAB7DEFB334FF65BBAF8C5F4377F51224459B349CFDDC51A6D5DC9937477EF869CAE4B4165E8A4DC83B3E9D9B7A80E3C0C591DEE00A776E4C1915EDEF276D23BEEDEBF2E673F02857E909B0CEFD6C8D96C8B6E91E1753858974F24D37D0E85558D2A40C82E06B2BF6002CD57ABBEEF8C8C43EBEC5F2624E4E882E3094E62FC7624D2C52DD73DC0C618F1AB96D39316E2E16E301ABDE4FE267DE88425CBFCA9F3131D4FED6BDF7F296B5A7BAC4CB2F9E4A48F0C6BE822B611002A9785A60692F9B25A1EAA7F279FEF4BF5E2BDEA8BEC4E3417E9936E542A19F9D19880065B003537A514754F09ADFA9A08D067BF34D3BEBC56BF4D970526A20886CE25BEB1174496F2AB9BC884BEC3A885875FEF4DBA60F682F68354C40B3E7C3DF62666DA0D655B0BC9EB0A1E470EDF58538DD848ECB5700BD632175644D50C713BFC1ACDC94F6600331F7C14AE8A63C1396699662CF1D5BD668C1BCE1E9AA0A2B5DDDC62294841958A36C03E9D211AA4352FA2918962452F73831B843412725766728AE7BB18B863D1B267AAA5FAB9B735FE50E6B1DF43BD4FA33F5004AECBA0BFD9D704F22AE1F15FD7F7DDF839868F7A7FDDB03C167520CF1A61CA62D057CB89052695EBCA0248E2429457437044EDA2CF89AFF27C8BB4D779A177137D9C9FCA03B169004066A1D92B53A601ABC5EBF9603AEA1FE9798C001C3B058E0F8892AD592920955CBBE5403868B06F90D7011D9390793CA611883D774853559DA0CBBDE2C25FC5FED3197CFC1725137FFF221DC152F2C906972Este comando obtiene información sobre todos los certificados de confianza del servidor dentro de la instancia "ManagedInstance01".
Ejemplo 7: Obtención de un certificado de confianza de servidor específico para una instancia mediante la canalización de un objeto de instancia y la especificación del nombre del certificado
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 : 0x1C8E3F85BCD8A2C1D082CE42D7A1E8112651A906B15F5F244134142C53B050FCBF2571965C522EBB86B4F1B790F3AD31E689950EE909B87C25A1BB51DA328BEEB1BB0FD44AB3CB774B8CC9F72B486476DEB8B1C95210B84C4A0F18310CD83F299CAF0D567EBCE2DD008581622D72499F8EC9A686BA526916E7F78DCA90BA0ADD8C2E5F601017D374E2FBD0818458BFC11C8268BC21383613323153163C0F33E09D03586A3BBFDA3628F0358FBADE41602BD05C4E47CDB67A9914F35B315B7844C2F2D1352034B56D6B155D38415B816247779E7A0EB3431765D9A48F4649E647CCD2EA8F38E8B5D415833BA8337BA00FED2F00D9066B9CAEF7BAA8C553F7B8787BCEF63AC98E05372981520BD5A598356590736B547F3B300F1D710EC3003D398AEB94589E196C42C5F6A1873D6138D9F666A2D6F24DAFB12FBD6B0124B2CFFAD51EF67032832900A9E113625BE4C4FB012923BB9886B52B733A5F8BFF04122A2474828F2EE5FC66154D9EBA92A21F0BFD6E8AAEE7DCC45BB3883A410E603C9D98A5BB913853D1B7543E694FF74F8CA9174BE152A96530803DD03C15BC258E77925877BCAF748CA85230ABBF90789F4856200166D110D369FB03B6593339CCE498CDA69016289056F4638E761B9904129DB36B6B4CD17D49567C27FF11059C0569ABF48C438CB6128F2B2F245BDB066B6BF1155BCA11E9D6B0BD8A1607F2F5BB42AF7498D1B8410AA1E5E3E23A3CA6FB933D3894C8D1A2162E735CFCB7BEDFB3318DAE32AE9E24900B9B0F472ABD563550C9E696836889123F0ED2E7A9A4B90C2C617C8ADCF088CE2A7EC8AB97A80C00F3296241C7B320118A1182E327919007930417004A301249EAACF139D611D9C30DAFDF8672F5347C488250F46D45E7D7E9BF3BE99ECD1C60A046FC80EB1DC473FD2E1A7672235F8A834338A4810E32CB24C9C24D09234995A3D038D70379B900E6C9217EF19062775B050CF7CA52D3D72E294E2315AA544247B436D46AD08D55957B9688C576E35760B527B7F7EB71E6209301C59B6643C921F2FB182D237E81DC6205BF6740C8EDC48C65DAB0546C1098C2DCBF0E3B31A47868A721942022E0B5DBFFFBBC4767699C7F0ABD6DEBE7D5FB91Este comando obtiene información sobre el certificado de confianza del servidor denominado "Certificate01" en la instancia "ManagedInstance01" y el grupo de recursos "ResourceGroup01".
Ejemplo 8: Obtener información sobre el certificado de confianza de servidor mediante parámetros posicionales
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 : 0x1C8E3F85BCD8A2C1D082CE42D7A1E8112651A906B15F5F244134142C53B050FCBF2571965C522EBB86B4F1B790F3AD31E689950EE909B87C25A1BB51DA328BEEB1BB0FD44AB3CB774B8CC9F72B486476DEB8B1C95210B84C4A0F18310CD83F299CAF0D567EBCE2DD008581622D72499F8EC9A686BA526916E7F78DCA90BA0ADD8C2E5F601017D374E2FBD0818458BFC11C8268BC21383613323153163C0F33E09D03586A3BBFDA3628F0358FBADE41602BD05C4E47CDB67A9914F35B315B7844C2F2D1352034B56D6B155D38415B816247779E7A0EB3431765D9A48F4649E647CCD2EA8F38E8B5D415833BA8337BA00FED2F00D9066B9CAEF7BAA8C553F7B8787BCEF63AC98E05372981520BD5A598356590736B547F3B300F1D710EC3003D398AEB94589E196C42C5F6A1873D6138D9F666A2D6F24DAFB12FBD6B0124B2CFFAD51EF67032832900A9E113625BE4C4FB012923BB9886B52B733A5F8BFF04122A2474828F2EE5FC66154D9EBA92A21F0BFD6E8AAEE7DCC45BB3883A410E603C9D98A5BB913853D1B7543E694FF74F8CA9174BE152A96530803DD03C15BC258E77925877BCAF748CA85230ABBF90789F4856200166D110D369FB03B6593339CCE498CDA69016289056F4638E761B9904129DB36B6B4CD17D49567C27FF11059C0569ABF48C438CB6128F2B2F245BDB066B6BF1155BCA11E9D6B0BD8A1607F2F5BB42AF7498D1B8410AA1E5E3E23A3CA6FB933D3894C8D1A2162E735CFCB7BEDFB3318DAE32AE9E24900B9B0F472ABD563550C9E696836889123F0ED2E7A9A4B90C2C617C8ADCF088CE2A7EC8AB97A80C00F3296241C7B320118A1182E327919007930417004A301249EAACF139D611D9C30DAFDF8672F5347C488250F46D45E7D7E9BF3BE99ECD1C60A046FC80EB1DC473FD2E1A7672235F8A834338A4810E32CB24C9C24D09234995A3D038D70379B900E6C9217EF19062775B050CF7CA52D3D72E294E2315AA544247B436D46AD08D55957B9688C576E35760B527B7F7EB71E6209301C59B6643C921F2FB182D237E81DC6205BF6740C8EDC48C65DAB0546C1098C2DCBF0E3B31A47868A721942022E0B5DBFFFBBC4767699C7F0ABD6DEBE7D5FB91Este comando obtiene información sobre el certificado de confianza de servidor "Certificate01" en la instancia "ManagedInstance01" y el grupo de recursos "ResourceGroup01".
Parámetros
-DefaultProfile
Credenciales, cuenta, inquilino y suscripción usados para la comunicación con Azure.
| Type: | IAzureContextContainer |
| Aliases: | AzContext, AzureRmContext, AzureCredential |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-InstanceName
Nombre del Instancia administrada de Azure SQL.
| Type: | String |
| Position: | 1 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-InstanceObject
Objeto de entrada de instancia.
| Type: | AzureSqlManagedInstanceModel |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-InstanceResourceId
Identificador de recurso de instancia administrada.
| Type: | String |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-Name
Nombre del certificado.
| Type: | String |
| Aliases: | CertificateName |
| Position: | 2 |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ResourceGroupName
Nombre del grupo de recursos.
| Type: | String |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ResourceId
Id. de recurso de certificado.
| Type: | String |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
Entradas
Salidas
AzureSqlInstanceServerTrustCertificateModel
Vínculos relacionados
Colaborar con nosotros en GitHub
El origen de este contenido se puede encontrar en GitHub, donde también puede crear y revisar problemas y solicitudes de incorporación de cambios. Para más información, consulte nuestra guía para colaboradores.
Comentarios
Próximamente: a lo largo de 2024, eliminaremos gradualmente los problemas de GitHub como mecanismo de comentarios para el contenido y lo reemplazaremos por un nuevo sistema de comentarios. Para obtener más información, consulte: https://aka.ms/ContentUserFeedback.
Enviar y ver comentarios de