Get-AzSqlInstanceEndpointCertificate
Gibt Informationen zu Endpunktzertifikaten zurück.
Syntax
GetByNameParameterSet (Standard)
Get-AzSqlInstanceEndpointCertificate
[-ResourceGroupName] <String>
[-InstanceName] <String>
[[-Name] <String>]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
GetByParentObjectParameterSet
Get-AzSqlInstanceEndpointCertificate
[[-Name] <String>]
[-InstanceObject] <AzureSqlManagedInstanceModel>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
GetByInstanceResourceIdParameterSet
Get-AzSqlInstanceEndpointCertificate
[[-Name] <String>]
[-InstanceResourceId] <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
GetByResourceIdParameterSet
Get-AzSqlInstanceEndpointCertificate
[-ResourceId] <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Beschreibung
Get-AzSqlInstanceEndpointCertificate Cmdlet gibt Informationen zu einer oder mehreren Instanzen des Endpunktzertifikats für eine Azure SQL Managed Instance zurück. Geben Sie den Namen eines Zertifikats (oder Endpunkttyps) an, um nur Informationen für dieses Zertifikat anzuzeigen.
Beispiele
Beispiel 1: Abrufen von Informationen zu allen Endpunktzertifikaten auf Azure SQL Managed Instance
Get-AzSqlInstanceEndpointCertificate -ResourceGroupName "ResourceGroup01" -InstanceName "ManagedInstance01"
ResourceGroupName : ResourceGroup01
InstanceName : ManagedInstance01
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/endpointCertificates/DATABASE_MIRRORING
Type : Microsoft.Sql/managedInstances/endpointCertificates
Name : DATABASE_MIRRORING
PublicKey : 0x1C8E3F85BCD8A2C1D082CE42D7A1E8112651A906B15F5F244134142C53B050FCBF2571965C522EBB86B4F1B790F3AD31E689950EE909B87C25A1BB51DA328BEEB1BB0FD44AB3CB774B8CC9F72B486476DEB8B1C95210B84C4A0F18310CD83F299CAF0D567EBCE2DD008581622D72499F8EC9A686BA526916E7F78DCA90BA0ADD8C2E5F601017D374E2FBD0818458BFC11C8268BC21383613323153163C0F33E09D03586A3BBFDA3628F0358FBADE41602BD05C4E47CDB67A9914F35B315B7844C2F2D1352034B56D6B155D38415B816247779E7A0EB3431765D9A48F4649E647CCD2EA8F38E8B5D415833BA8337BA00FED2F00D9066B9CAEF7BAA8C553F7B8787BCEF63AC98E05372981520BD5A598356590736B547F3B300F1D710EC3003D398AEB94589E196C42C5F6A1873D6138D9F666A2D6F24DAFB12FBD6B0124B2CFFAD51EF67032832900A9E113625BE4C4FB012923BB9886B52B733A5F8BFF04122A2474828F2EE5FC66154D9EBA92A21F0BFD6E8AAEE7DCC45BB3883A410E603C9D98A5BB913853D1B7543E694FF74F8CA9174BE152A96530803DD03C15BC258E77925877BCAF748CA85230ABBF90789F4856200166D110D369FB03B6593339CCE498CDA69016289056F4638E761B9904129DB36B6B4CD17D49567C27FF11059C0569ABF48C438CB6128F2B2F245BDB066B6BF1155BCA11E9D6B0BD8A1607F2F5BB42AF7498D1B8410AA1E5E3E23A3CA6FB933D3894C8D1A2162E735CFCB7BEDFB3318DAE32AE9E24900B9B0F472ABD563550C9E696836889123F0ED2E7A9A4B90C2C617C8ADCF088CE2A7EC8AB97A80C00F3296241C7B320118A1182E327919007930417004A301249EAACF139D611D9C30DAFDF8672F5347C488250F46D45E7D7E9BF3BE99ECD1C60A046FC80EB1DC473FD2E1A7672235F8A834338A4810E32CB24C9C24D09234995A3D038D70379B900E6C9217EF19062775B050CF7CA52D3D72E294E2315AA544247B436D46AD08D55957B9688C576E35760B527B7F7EB71E6209301C59B6643C921F2FB182D237E81DC6205BF6740C8EDC48C65DAB0546C1098C2DCBF0E3B31A47868A721942022E0B5DBFFFBBC4767699C7F0ABD6DEBE7D5FB91
ResourceGroupName : ResourceGroup01
InstanceName : ManagedInstance01
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/endpointCertificates/SERVICE_BROKER
Type : Microsoft.Sql/managedInstances/endpointCertificates
Name : SERVICE_BROKER
PublicKey : 0x5D014B47F6AF7D0469A853C84180445C146015D5098F09AC673A49281EDA9D3C560039BAFBD02617BF94DF30B505AA2CA891E3F80BD0056F39B21396F675EBAEA148A12C3EED8F7DE6753A2AAC722EEB1D3A71633A00909F720E74180CC9D7B51E84BEFDDC6A64C7015368FB041E59E836F3968739E7B84654FEDA396BD7E89C9AFCCF4086F8838A1FD5F833C1288EB619A14F68F15094D8BB4DD834F64333AF44A7C0CC5BF4406C408702993B14D04A20772EE23A0C7FED3D89B754EA66C23FDAE65AEAD53F55AE82ADEEDC8B730352D1A0933AD28745FCCA960FAD3AE12693175DA3A14CCF37B221AC35DEF986A9758EAB7DEFB334FF65BBAF8C5F4377F51224459B349CFDDC51A6D5DC9937477EF869CAE4B4165E8A4DC83B3E9D9B7A80E3C0C591DEE00A776E4C1915EDEF276D23BEEDEBF2E673F02857E909B0CEFD6C8D96C8B6E91E1753858974F24D37D0E85558D2A40C82E06B2BF6002CD57ABBEEF8C8C43EBEC5F2624E4E882E3094E62FC7624D2C52DD73DC0C618F1AB96D39316E2E16E301ABDE4FE267DE88425CBFCA9F3131D4FED6BDF7F296B5A7BAC4CB2F9E4A48F0C6BE822B611002A9785A60692F9B25A1EAA7F279FEF4BF5E2BDEA8BEC4E3417E9936E542A19F9D19880065B003537A514754F09ADFA9A08D067BF34D3BEBC56BF4D970526A20886CE25BEB1174496F2AB9BC884BEC3A885875FEF4DBA60F682F68354C40B3E7C3DF62666DA0D655B0BC9EB0A1E470EDF58538DD848ECB5700BD632175644D50C713BFC1ACDC94F6600331F7C14AE8A63C1396699662CF1D5BD668C1BCE1E9AA0A2B5DDDC62294841958A36C03E9D211AA4352FA2918962452F73831B843412725766728AE7BB18B863D1B267AAA5FAB9B735FE50E6B1DF43BD4FA33F5004AECBA0BFD9D704F22AE1F15FD7F7DDF839868F7A7FDDB03C167520CF1A61CA62D057CB89052695EBCA0248E2429457437044EDA2CF89AFF27C8BB4D779A177137D9C9FCA03B169004066A1D92B53A601ABC5EBF9603AEA1FE9798C001C3B058E0F8892AD592920955CBBE5403868B06F90D7011D9390793CA611883D774853559DA0CBBDE2C25FC5FED3197CFC1725137FFF221DC152F2C906972
Dieser Befehl ruft Informationen zu allen Endpunktzertifikaten innerhalb der Instanz "ManagedInstance01" ab.
Beispiel 2: Abrufen von Informationen zu einem Zertifikat für einen bestimmten Endpunkttyp auf Azure SQL Managed Instance
Get-AzSqlInstanceEndpointCertificate -ResourceGroupName "ResourceGroup01" -InstanceName "ManagedInstance01" -EndpointType "DATABASE_MIRRORING"
ResourceGroupName : ResourceGroup01
InstanceName : ManagedInstance01
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/endpointCertificates/DATABASE_MIRRORING
Type : Microsoft.Sql/managedInstances/endpointCertificates
Name : DATABASE_MIRRORING
PublicKey : 0x1C8E3F85BCD8A2C1D082CE42D7A1E8112651A906B15F5F244134142C53B050FCBF2571965C522EBB86B4F1B790F3AD31E689950EE909B87C25A1BB51DA328BEEB1BB0FD44AB3CB774B8CC9F72B486476DEB8B1C95210B84C4A0F18310CD83F299CAF0D567EBCE2DD008581622D72499F8EC9A686BA526916E7F78DCA90BA0ADD8C2E5F601017D374E2FBD0818458BFC11C8268BC21383613323153163C0F33E09D03586A3BBFDA3628F0358FBADE41602BD05C4E47CDB67A9914F35B315B7844C2F2D1352034B56D6B155D38415B816247779E7A0EB3431765D9A48F4649E647CCD2EA8F38E8B5D415833BA8337BA00FED2F00D9066B9CAEF7BAA8C553F7B8787BCEF63AC98E05372981520BD5A598356590736B547F3B300F1D710EC3003D398AEB94589E196C42C5F6A1873D6138D9F666A2D6F24DAFB12FBD6B0124B2CFFAD51EF67032832900A9E113625BE4C4FB012923BB9886B52B733A5F8BFF04122A2474828F2EE5FC66154D9EBA92A21F0BFD6E8AAEE7DCC45BB3883A410E603C9D98A5BB913853D1B7543E694FF74F8CA9174BE152A96530803DD03C15BC258E77925877BCAF748CA85230ABBF90789F4856200166D110D369FB03B6593339CCE498CDA69016289056F4638E761B9904129DB36B6B4CD17D49567C27FF11059C0569ABF48C438CB6128F2B2F245BDB066B6BF1155BCA11E9D6B0BD8A1607F2F5BB42AF7498D1B8410AA1E5E3E23A3CA6FB933D3894C8D1A2162E735CFCB7BEDFB3318DAE32AE9E24900B9B0F472ABD563550C9E696836889123F0ED2E7A9A4B90C2C617C8ADCF088CE2A7EC8AB97A80C00F3296241C7B320118A1182E327919007930417004A301249EAACF139D611D9C30DAFDF8672F5347C488250F46D45E7D7E9BF3BE99ECD1C60A046FC80EB1DC473FD2E1A7672235F8A834338A4810E32CB24C9C24D09234995A3D038D70379B900E6C9217EF19062775B050CF7CA52D3D72E294E2315AA544247B436D46AD08D55957B9688C576E35760B527B7F7EB71E6209301C59B6643C921F2FB182D237E81DC6205BF6740C8EDC48C65DAB0546C1098C2DCBF0E3B31A47868A721942022E0B5DBFFFBBC4767699C7F0ABD6DEBE7D5FB91
Dieser Befehl ruft Informationen zum Endpunktzertifikat "DATABASE_MIRRORING" für die Instanz "ManagedInstance01" und die Ressourcengruppe "ResourceGroup01" ab.
Beispiel 3: Abrufen aller Endpunktzertifikate für Azure SQL Managed Instance mithilfe des Instance-Objekts
$instance = Get-AzSqlInstance -Name "ManagedInstance01" -ResourceGroupName "ResourceGroup01"
Get-AzSqlInstanceEndpointCertificate -InstanceObject $instance
ResourceGroupName : ResourceGroup01
InstanceName : ManagedInstance01
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/endpointCertificates/DATABASE_MIRRORING
Type : Microsoft.Sql/managedInstances/endpointCertificates
Name : DATABASE_MIRRORING
PublicKey : 0x1C8E3F85BCD8A2C1D082CE42D7A1E8112651A906B15F5F244134142C53B050FCBF2571965C522EBB86B4F1B790F3AD31E689950EE909B87C25A1BB51DA328BEEB1BB0FD44AB3CB774B8CC9F72B486476DEB8B1C95210B84C4A0F18310CD83F299CAF0D567EBCE2DD008581622D72499F8EC9A686BA526916E7F78DCA90BA0ADD8C2E5F601017D374E2FBD0818458BFC11C8268BC21383613323153163C0F33E09D03586A3BBFDA3628F0358FBADE41602BD05C4E47CDB67A9914F35B315B7844C2F2D1352034B56D6B155D38415B816247779E7A0EB3431765D9A48F4649E647CCD2EA8F38E8B5D415833BA8337BA00FED2F00D9066B9CAEF7BAA8C553F7B8787BCEF63AC98E05372981520BD5A598356590736B547F3B300F1D710EC3003D398AEB94589E196C42C5F6A1873D6138D9F666A2D6F24DAFB12FBD6B0124B2CFFAD51EF67032832900A9E113625BE4C4FB012923BB9886B52B733A5F8BFF04122A2474828F2EE5FC66154D9EBA92A21F0BFD6E8AAEE7DCC45BB3883A410E603C9D98A5BB913853D1B7543E694FF74F8CA9174BE152A96530803DD03C15BC258E77925877BCAF748CA85230ABBF90789F4856200166D110D369FB03B6593339CCE498CDA69016289056F4638E761B9904129DB36B6B4CD17D49567C27FF11059C0569ABF48C438CB6128F2B2F245BDB066B6BF1155BCA11E9D6B0BD8A1607F2F5BB42AF7498D1B8410AA1E5E3E23A3CA6FB933D3894C8D1A2162E735CFCB7BEDFB3318DAE32AE9E24900B9B0F472ABD563550C9E696836889123F0ED2E7A9A4B90C2C617C8ADCF088CE2A7EC8AB97A80C00F3296241C7B320118A1182E327919007930417004A301249EAACF139D611D9C30DAFDF8672F5347C488250F46D45E7D7E9BF3BE99ECD1C60A046FC80EB1DC473FD2E1A7672235F8A834338A4810E32CB24C9C24D09234995A3D038D70379B900E6C9217EF19062775B050CF7CA52D3D72E294E2315AA544247B436D46AD08D55957B9688C576E35760B527B7F7EB71E6209301C59B6643C921F2FB182D237E81DC6205BF6740C8EDC48C65DAB0546C1098C2DCBF0E3B31A47868A721942022E0B5DBFFFBBC4767699C7F0ABD6DEBE7D5FB91
ResourceGroupName : ResourceGroup01
InstanceName : ManagedInstance01
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/endpointCertificates/SERVICE_BROKER
Type : Microsoft.Sql/managedInstances/endpointCertificates
Name : SERVICE_BROKER
PublicKey : 0x5D014B47F6AF7D0469A853C84180445C146015D5098F09AC673A49281EDA9D3C560039BAFBD02617BF94DF30B505AA2CA891E3F80BD0056F39B21396F675EBAEA148A12C3EED8F7DE6753A2AAC722EEB1D3A71633A00909F720E74180CC9D7B51E84BEFDDC6A64C7015368FB041E59E836F3968739E7B84654FEDA396BD7E89C9AFCCF4086F8838A1FD5F833C1288EB619A14F68F15094D8BB4DD834F64333AF44A7C0CC5BF4406C408702993B14D04A20772EE23A0C7FED3D89B754EA66C23FDAE65AEAD53F55AE82ADEEDC8B730352D1A0933AD28745FCCA960FAD3AE12693175DA3A14CCF37B221AC35DEF986A9758EAB7DEFB334FF65BBAF8C5F4377F51224459B349CFDDC51A6D5DC9937477EF869CAE4B4165E8A4DC83B3E9D9B7A80E3C0C591DEE00A776E4C1915EDEF276D23BEEDEBF2E673F02857E909B0CEFD6C8D96C8B6E91E1753858974F24D37D0E85558D2A40C82E06B2BF6002CD57ABBEEF8C8C43EBEC5F2624E4E882E3094E62FC7624D2C52DD73DC0C618F1AB96D39316E2E16E301ABDE4FE267DE88425CBFCA9F3131D4FED6BDF7F296B5A7BAC4CB2F9E4A48F0C6BE822B611002A9785A60692F9B25A1EAA7F279FEF4BF5E2BDEA8BEC4E3417E9936E542A19F9D19880065B003537A514754F09ADFA9A08D067BF34D3BEBC56BF4D970526A20886CE25BEB1174496F2AB9BC884BEC3A885875FEF4DBA60F682F68354C40B3E7C3DF62666DA0D655B0BC9EB0A1E470EDF58538DD848ECB5700BD632175644D50C713BFC1ACDC94F6600331F7C14AE8A63C1396699662CF1D5BD668C1BCE1E9AA0A2B5DDDC62294841958A36C03E9D211AA4352FA2918962452F73831B843412725766728AE7BB18B863D1B267AAA5FAB9B735FE50E6B1DF43BD4FA33F5004AECBA0BFD9D704F22AE1F15FD7F7DDF839868F7A7FDDB03C167520CF1A61CA62D057CB89052695EBCA0248E2429457437044EDA2CF89AFF27C8BB4D779A177137D9C9FCA03B169004066A1D92B53A601ABC5EBF9603AEA1FE9798C001C3B058E0F8892AD592920955CBBE5403868B06F90D7011D9390793CA611883D774853559DA0CBBDE2C25FC5FED3197CFC1725137FFF221DC152F2C906972
Dieser Befehl ruft Informationen zu allen Endpunktzertifikaten innerhalb der Instanz "ManagedInstance01" ab.
Beispiel 4: Abrufen aller Endpunktzertifikate für Azure SQL Managed Instance mithilfe des Instanzressourcenbezeichners
Get-AzSqlInstanceEndpointCertificate -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/endpointCertificates/DATABASE_MIRRORING
Type : Microsoft.Sql/managedInstances/endpointCertificates
Name : DATABASE_MIRRORING
PublicKey : 0x1C8E3F85BCD8A2C1D082CE42D7A1E8112651A906B15F5F244134142C53B050FCBF2571965C522EBB86B4F1B790F3AD31E689950EE909B87C25A1BB51DA328BEEB1BB0FD44AB3CB774B8CC9F72B486476DEB8B1C95210B84C4A0F18310CD83F299CAF0D567EBCE2DD008581622D72499F8EC9A686BA526916E7F78DCA90BA0ADD8C2E5F601017D374E2FBD0818458BFC11C8268BC21383613323153163C0F33E09D03586A3BBFDA3628F0358FBADE41602BD05C4E47CDB67A9914F35B315B7844C2F2D1352034B56D6B155D38415B816247779E7A0EB3431765D9A48F4649E647CCD2EA8F38E8B5D415833BA8337BA00FED2F00D9066B9CAEF7BAA8C553F7B8787BCEF63AC98E05372981520BD5A598356590736B547F3B300F1D710EC3003D398AEB94589E196C42C5F6A1873D6138D9F666A2D6F24DAFB12FBD6B0124B2CFFAD51EF67032832900A9E113625BE4C4FB012923BB9886B52B733A5F8BFF04122A2474828F2EE5FC66154D9EBA92A21F0BFD6E8AAEE7DCC45BB3883A410E603C9D98A5BB913853D1B7543E694FF74F8CA9174BE152A96530803DD03C15BC258E77925877BCAF748CA85230ABBF90789F4856200166D110D369FB03B6593339CCE498CDA69016289056F4638E761B9904129DB36B6B4CD17D49567C27FF11059C0569ABF48C438CB6128F2B2F245BDB066B6BF1155BCA11E9D6B0BD8A1607F2F5BB42AF7498D1B8410AA1E5E3E23A3CA6FB933D3894C8D1A2162E735CFCB7BEDFB3318DAE32AE9E24900B9B0F472ABD563550C9E696836889123F0ED2E7A9A4B90C2C617C8ADCF088CE2A7EC8AB97A80C00F3296241C7B320118A1182E327919007930417004A301249EAACF139D611D9C30DAFDF8672F5347C488250F46D45E7D7E9BF3BE99ECD1C60A046FC80EB1DC473FD2E1A7672235F8A834338A4810E32CB24C9C24D09234995A3D038D70379B900E6C9217EF19062775B050CF7CA52D3D72E294E2315AA544247B436D46AD08D55957B9688C576E35760B527B7F7EB71E6209301C59B6643C921F2FB182D237E81DC6205BF6740C8EDC48C65DAB0546C1098C2DCBF0E3B31A47868A721942022E0B5DBFFFBBC4767699C7F0ABD6DEBE7D5FB91
ResourceGroupName : ResourceGroup01
InstanceName : ManagedInstance01
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/endpointCertificates/SERVICE_BROKER
Type : Microsoft.Sql/managedInstances/endpointCertificates
Name : SERVICE_BROKER
PublicKey : 0x5D014B47F6AF7D0469A853C84180445C146015D5098F09AC673A49281EDA9D3C560039BAFBD02617BF94DF30B505AA2CA891E3F80BD0056F39B21396F675EBAEA148A12C3EED8F7DE6753A2AAC722EEB1D3A71633A00909F720E74180CC9D7B51E84BEFDDC6A64C7015368FB041E59E836F3968739E7B84654FEDA396BD7E89C9AFCCF4086F8838A1FD5F833C1288EB619A14F68F15094D8BB4DD834F64333AF44A7C0CC5BF4406C408702993B14D04A20772EE23A0C7FED3D89B754EA66C23FDAE65AEAD53F55AE82ADEEDC8B730352D1A0933AD28745FCCA960FAD3AE12693175DA3A14CCF37B221AC35DEF986A9758EAB7DEFB334FF65BBAF8C5F4377F51224459B349CFDDC51A6D5DC9937477EF869CAE4B4165E8A4DC83B3E9D9B7A80E3C0C591DEE00A776E4C1915EDEF276D23BEEDEBF2E673F02857E909B0CEFD6C8D96C8B6E91E1753858974F24D37D0E85558D2A40C82E06B2BF6002CD57ABBEEF8C8C43EBEC5F2624E4E882E3094E62FC7624D2C52DD73DC0C618F1AB96D39316E2E16E301ABDE4FE267DE88425CBFCA9F3131D4FED6BDF7F296B5A7BAC4CB2F9E4A48F0C6BE822B611002A9785A60692F9B25A1EAA7F279FEF4BF5E2BDEA8BEC4E3417E9936E542A19F9D19880065B003537A514754F09ADFA9A08D067BF34D3BEBC56BF4D970526A20886CE25BEB1174496F2AB9BC884BEC3A885875FEF4DBA60F682F68354C40B3E7C3DF62666DA0D655B0BC9EB0A1E470EDF58538DD848ECB5700BD632175644D50C713BFC1ACDC94F6600331F7C14AE8A63C1396699662CF1D5BD668C1BCE1E9AA0A2B5DDDC62294841958A36C03E9D211AA4352FA2918962452F73831B843412725766728AE7BB18B863D1B267AAA5FAB9B735FE50E6B1DF43BD4FA33F5004AECBA0BFD9D704F22AE1F15FD7F7DDF839868F7A7FDDB03C167520CF1A61CA62D057CB89052695EBCA0248E2429457437044EDA2CF89AFF27C8BB4D779A177137D9C9FCA03B169004066A1D92B53A601ABC5EBF9603AEA1FE9798C001C3B058E0F8892AD592920955CBBE5403868B06F90D7011D9390793CA611883D774853559DA0CBBDE2C25FC5FED3197CFC1725137FFF221DC152F2C906972
Dieser Befehl ruft Informationen zu allen Endpunktzertifikaten innerhalb der Instanz "ManagedInstance01" ab.
Beispiel 5: Abrufen eines Endpunktzertifikats mithilfe des Ressourcenbezeichners
Get-AzSqlInstanceEndpointCertificate -ResourceId "/subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/endpointCertificates/DATABASE_MIRRORING"
ResourceGroupName : ResourceGroup01
InstanceName : ManagedInstance01
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/endpointCertificates/DATABASE_MIRRORING
Type : Microsoft.Sql/managedInstances/endpointCertificates
Name : DATABASE_MIRRORING
PublicKey : 0x1C8E3F85BCD8A2C1D082CE42D7A1E8112651A906B15F5F244134142C53B050FCBF2571965C522EBB86B4F1B790F3AD31E689950EE909B87C25A1BB51DA328BEEB1BB0FD44AB3CB774B8CC9F72B486476DEB8B1C95210B84C4A0F18310CD83F299CAF0D567EBCE2DD008581622D72499F8EC9A686BA526916E7F78DCA90BA0ADD8C2E5F601017D374E2FBD0818458BFC11C8268BC21383613323153163C0F33E09D03586A3BBFDA3628F0358FBADE41602BD05C4E47CDB67A9914F35B315B7844C2F2D1352034B56D6B155D38415B816247779E7A0EB3431765D9A48F4649E647CCD2EA8F38E8B5D415833BA8337BA00FED2F00D9066B9CAEF7BAA8C553F7B8787BCEF63AC98E05372981520BD5A598356590736B547F3B300F1D710EC3003D398AEB94589E196C42C5F6A1873D6138D9F666A2D6F24DAFB12FBD6B0124B2CFFAD51EF67032832900A9E113625BE4C4FB012923BB9886B52B733A5F8BFF04122A2474828F2EE5FC66154D9EBA92A21F0BFD6E8AAEE7DCC45BB3883A410E603C9D98A5BB913853D1B7543E694FF74F8CA9174BE152A96530803DD03C15BC258E77925877BCAF748CA85230ABBF90789F4856200166D110D369FB03B6593339CCE498CDA69016289056F4638E761B9904129DB36B6B4CD17D49567C27FF11059C0569ABF48C438CB6128F2B2F245BDB066B6BF1155BCA11E9D6B0BD8A1607F2F5BB42AF7498D1B8410AA1E5E3E23A3CA6FB933D3894C8D1A2162E735CFCB7BEDFB3318DAE32AE9E24900B9B0F472ABD563550C9E696836889123F0ED2E7A9A4B90C2C617C8ADCF088CE2A7EC8AB97A80C00F3296241C7B320118A1182E327919007930417004A301249EAACF139D611D9C30DAFDF8672F5347C488250F46D45E7D7E9BF3BE99ECD1C60A046FC80EB1DC473FD2E1A7672235F8A834338A4810E32CB24C9C24D09234995A3D038D70379B900E6C9217EF19062775B050CF7CA52D3D72E294E2315AA544247B436D46AD08D55957B9688C576E35760B527B7F7EB71E6209301C59B6643C921F2FB182D237E81DC6205BF6740C8EDC48C65DAB0546C1098C2DCBF0E3B31A47868A721942022E0B5DBFFFBBC4767699C7F0ABD6DEBE7D5FB91
Dieser Befehl ruft Informationen zum Endpunktzertifikat mit dem Namen "DATABASE_MIRRORING" ab.
Beispiel 6: Abrufen aller Endpunktzertifikate für eine verwaltete Instanz durch Das Anfügen eines Instanzobjekts
Get-AzSqlInstance -Name "ManagedInstance01" -ResourceGroupName "ResourceGroup01" | Get-AzSqlInstanceEndpointCertificate
ResourceGroupName : ResourceGroup01
InstanceName : ManagedInstance01
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/endpointCertificates/DATABASE_MIRRORING
Type : Microsoft.Sql/managedInstances/endpointCertificates
Name : DATABASE_MIRRORING
PublicKey : 0x1C8E3F85BCD8A2C1D082CE42D7A1E8112651A906B15F5F244134142C53B050FCBF2571965C522EBB86B4F1B790F3AD31E689950EE909B87C25A1BB51DA328BEEB1BB0FD44AB3CB774B8CC9F72B486476DEB8B1C95210B84C4A0F18310CD83F299CAF0D567EBCE2DD008581622D72499F8EC9A686BA526916E7F78DCA90BA0ADD8C2E5F601017D374E2FBD0818458BFC11C8268BC21383613323153163C0F33E09D03586A3BBFDA3628F0358FBADE41602BD05C4E47CDB67A9914F35B315B7844C2F2D1352034B56D6B155D38415B816247779E7A0EB3431765D9A48F4649E647CCD2EA8F38E8B5D415833BA8337BA00FED2F00D9066B9CAEF7BAA8C553F7B8787BCEF63AC98E05372981520BD5A598356590736B547F3B300F1D710EC3003D398AEB94589E196C42C5F6A1873D6138D9F666A2D6F24DAFB12FBD6B0124B2CFFAD51EF67032832900A9E113625BE4C4FB012923BB9886B52B733A5F8BFF04122A2474828F2EE5FC66154D9EBA92A21F0BFD6E8AAEE7DCC45BB3883A410E603C9D98A5BB913853D1B7543E694FF74F8CA9174BE152A96530803DD03C15BC258E77925877BCAF748CA85230ABBF90789F4856200166D110D369FB03B6593339CCE498CDA69016289056F4638E761B9904129DB36B6B4CD17D49567C27FF11059C0569ABF48C438CB6128F2B2F245BDB066B6BF1155BCA11E9D6B0BD8A1607F2F5BB42AF7498D1B8410AA1E5E3E23A3CA6FB933D3894C8D1A2162E735CFCB7BEDFB3318DAE32AE9E24900B9B0F472ABD563550C9E696836889123F0ED2E7A9A4B90C2C617C8ADCF088CE2A7EC8AB97A80C00F3296241C7B320118A1182E327919007930417004A301249EAACF139D611D9C30DAFDF8672F5347C488250F46D45E7D7E9BF3BE99ECD1C60A046FC80EB1DC473FD2E1A7672235F8A834338A4810E32CB24C9C24D09234995A3D038D70379B900E6C9217EF19062775B050CF7CA52D3D72E294E2315AA544247B436D46AD08D55957B9688C576E35760B527B7F7EB71E6209301C59B6643C921F2FB182D237E81DC6205BF6740C8EDC48C65DAB0546C1098C2DCBF0E3B31A47868A721942022E0B5DBFFFBBC4767699C7F0ABD6DEBE7D5FB91
ResourceGroupName : ResourceGroup01
InstanceName : ManagedInstance01
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/endpointCertificates/SERVICE_BROKER
Type : Microsoft.Sql/managedInstances/endpointCertificates
Name : SERVICE_BROKER
PublicKey : 0x5D014B47F6AF7D0469A853C84180445C146015D5098F09AC673A49281EDA9D3C560039BAFBD02617BF94DF30B505AA2CA891E3F80BD0056F39B21396F675EBAEA148A12C3EED8F7DE6753A2AAC722EEB1D3A71633A00909F720E74180CC9D7B51E84BEFDDC6A64C7015368FB041E59E836F3968739E7B84654FEDA396BD7E89C9AFCCF4086F8838A1FD5F833C1288EB619A14F68F15094D8BB4DD834F64333AF44A7C0CC5BF4406C408702993B14D04A20772EE23A0C7FED3D89B754EA66C23FDAE65AEAD53F55AE82ADEEDC8B730352D1A0933AD28745FCCA960FAD3AE12693175DA3A14CCF37B221AC35DEF986A9758EAB7DEFB334FF65BBAF8C5F4377F51224459B349CFDDC51A6D5DC9937477EF869CAE4B4165E8A4DC83B3E9D9B7A80E3C0C591DEE00A776E4C1915EDEF276D23BEEDEBF2E673F02857E909B0CEFD6C8D96C8B6E91E1753858974F24D37D0E85558D2A40C82E06B2BF6002CD57ABBEEF8C8C43EBEC5F2624E4E882E3094E62FC7624D2C52DD73DC0C618F1AB96D39316E2E16E301ABDE4FE267DE88425CBFCA9F3131D4FED6BDF7F296B5A7BAC4CB2F9E4A48F0C6BE822B611002A9785A60692F9B25A1EAA7F279FEF4BF5E2BDEA8BEC4E3417E9936E542A19F9D19880065B003537A514754F09ADFA9A08D067BF34D3BEBC56BF4D970526A20886CE25BEB1174496F2AB9BC884BEC3A885875FEF4DBA60F682F68354C40B3E7C3DF62666DA0D655B0BC9EB0A1E470EDF58538DD848ECB5700BD632175644D50C713BFC1ACDC94F6600331F7C14AE8A63C1396699662CF1D5BD668C1BCE1E9AA0A2B5DDDC62294841958A36C03E9D211AA4352FA2918962452F73831B843412725766728AE7BB18B863D1B267AAA5FAB9B735FE50E6B1DF43BD4FA33F5004AECBA0BFD9D704F22AE1F15FD7F7DDF839868F7A7FDDB03C167520CF1A61CA62D057CB89052695EBCA0248E2429457437044EDA2CF89AFF27C8BB4D779A177137D9C9FCA03B169004066A1D92B53A601ABC5EBF9603AEA1FE9798C001C3B058E0F8892AD592920955CBBE5403868B06F90D7011D9390793CA611883D774853559DA0CBBDE2C25FC5FED3197CFC1725137FFF221DC152F2C906972
Dieser Befehl ruft Informationen zu allen Endpunktzertifikaten innerhalb der Instanz "ManagedInstance01" ab.
Beispiel 7: Abrufen eines bestimmten Endpunktzertifikats für eine Instanz durch Anfügen eines Instanzobjekts und Angeben des Zertifikatnamens
Get-AzSqlInstance -Name "ManagedInstance01" -ResourceGroupName "ResourceGroup01" | Get-AzSqlInstanceEndpointCertificate -Name "SERVICE_BROKER"
ResourceGroupName : ResourceGroup01
InstanceName : ManagedInstance01
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/endpointCertificates/SERVICE_BROKER
Type : Microsoft.Sql/managedInstances/endpointCertificates
Name : SERVICE_BROKER
PublicKey : 0x1C8E3F85BCD8A2C1D082CE42D7A1E8112651A906B15F5F244134142C53B050FCBF2571965C522EBB86B4F1B790F3AD31E689950EE909B87C25A1BB51DA328BEEB1BB0FD44AB3CB774B8CC9F72B486476DEB8B1C95210B84C4A0F18310CD83F299CAF0D567EBCE2DD008581622D72499F8EC9A686BA526916E7F78DCA90BA0ADD8C2E5F601017D374E2FBD0818458BFC11C8268BC21383613323153163C0F33E09D03586A3BBFDA3628F0358FBADE41602BD05C4E47CDB67A9914F35B315B7844C2F2D1352034B56D6B155D38415B816247779E7A0EB3431765D9A48F4649E647CCD2EA8F38E8B5D415833BA8337BA00FED2F00D9066B9CAEF7BAA8C553F7B8787BCEF63AC98E05372981520BD5A598356590736B547F3B300F1D710EC3003D398AEB94589E196C42C5F6A1873D6138D9F666A2D6F24DAFB12FBD6B0124B2CFFAD51EF67032832900A9E113625BE4C4FB012923BB9886B52B733A5F8BFF04122A2474828F2EE5FC66154D9EBA92A21F0BFD6E8AAEE7DCC45BB3883A410E603C9D98A5BB913853D1B7543E694FF74F8CA9174BE152A96530803DD03C15BC258E77925877BCAF748CA85230ABBF90789F4856200166D110D369FB03B6593339CCE498CDA69016289056F4638E761B9904129DB36B6B4CD17D49567C27FF11059C0569ABF48C438CB6128F2B2F245BDB066B6BF1155BCA11E9D6B0BD8A1607F2F5BB42AF7498D1B8410AA1E5E3E23A3CA6FB933D3894C8D1A2162E735CFCB7BEDFB3318DAE32AE9E24900B9B0F472ABD563550C9E696836889123F0ED2E7A9A4B90C2C617C8ADCF088CE2A7EC8AB97A80C00F3296241C7B320118A1182E327919007930417004A301249EAACF139D611D9C30DAFDF8672F5347C488250F46D45E7D7E9BF3BE99ECD1C60A046FC80EB1DC473FD2E1A7672235F8A834338A4810E32CB24C9C24D09234995A3D038D70379B900E6C9217EF19062775B050CF7CA52D3D72E294E2315AA544247B436D46AD08D55957B9688C576E35760B527B7F7EB71E6209301C59B6643C921F2FB182D237E81DC6205BF6740C8EDC48C65DAB0546C1098C2DCBF0E3B31A47868A721942022E0B5DBFFFBBC4767699C7F0ABD6DEBE7D5FB91
Dieser Befehl ruft Informationen zum Endpunktzertifikat "SERVICE_BROKER" der Instanz "ManagedInstance01" und der Ressourcengruppe "ResourceGroup01" ab.
Beispiel 8: Abrufen von Informationen zu Endpunktzertifikaten mithilfe von Positionsparametern
Get-AzSqlInstanceEndpointCertificate "ResourceGroup01" "ManagedInstance01" "DATABASE_MIRRORING"
ResourceGroupName : ResourceGroup01
InstanceName : ManagedInstance01
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance01/endpointCertificates/DATABASE_MIRRORING
Type : Microsoft.Sql/managedInstances/endpointCertificates
Name : DATABASE_MIRRORING
PublicKey : 0x1C8E3F85BCD8A2C1D082CE42D7A1E8112651A906B15F5F244134142C53B050FCBF2571965C522EBB86B4F1B790F3AD31E689950EE909B87C25A1BB51DA328BEEB1BB0FD44AB3CB774B8CC9F72B486476DEB8B1C95210B84C4A0F18310CD83F299CAF0D567EBCE2DD008581622D72499F8EC9A686BA526916E7F78DCA90BA0ADD8C2E5F601017D374E2FBD0818458BFC11C8268BC21383613323153163C0F33E09D03586A3BBFDA3628F0358FBADE41602BD05C4E47CDB67A9914F35B315B7844C2F2D1352034B56D6B155D38415B816247779E7A0EB3431765D9A48F4649E647CCD2EA8F38E8B5D415833BA8337BA00FED2F00D9066B9CAEF7BAA8C553F7B8787BCEF63AC98E05372981520BD5A598356590736B547F3B300F1D710EC3003D398AEB94589E196C42C5F6A1873D6138D9F666A2D6F24DAFB12FBD6B0124B2CFFAD51EF67032832900A9E113625BE4C4FB012923BB9886B52B733A5F8BFF04122A2474828F2EE5FC66154D9EBA92A21F0BFD6E8AAEE7DCC45BB3883A410E603C9D98A5BB913853D1B7543E694FF74F8CA9174BE152A96530803DD03C15BC258E77925877BCAF748CA85230ABBF90789F4856200166D110D369FB03B6593339CCE498CDA69016289056F4638E761B9904129DB36B6B4CD17D49567C27FF11059C0569ABF48C438CB6128F2B2F245BDB066B6BF1155BCA11E9D6B0BD8A1607F2F5BB42AF7498D1B8410AA1E5E3E23A3CA6FB933D3894C8D1A2162E735CFCB7BEDFB3318DAE32AE9E24900B9B0F472ABD563550C9E696836889123F0ED2E7A9A4B90C2C617C8ADCF088CE2A7EC8AB97A80C00F3296241C7B320118A1182E327919007930417004A301249EAACF139D611D9C30DAFDF8672F5347C488250F46D45E7D7E9BF3BE99ECD1C60A046FC80EB1DC473FD2E1A7672235F8A834338A4810E32CB24C9C24D09234995A3D038D70379B900E6C9217EF19062775B050CF7CA52D3D72E294E2315AA544247B436D46AD08D55957B9688C576E35760B527B7F7EB71E6209301C59B6643C921F2FB182D237E81DC6205BF6740C8EDC48C65DAB0546C1098C2DCBF0E3B31A47868A721942022E0B5DBFFFBBC4767699C7F0ABD6DEBE7D5FB91
Dieser Befehl ruft Informationen zum Endpunktzertifikat "DATABASE_MIRRORING" der Instanz "ManagedInstance01" und der Ressourcengruppe "ResourceGroup01" ab.
Parameter
-DefaultProfile
Die Anmeldeinformationen, Konten, Mandanten und Abonnements, die für die Kommunikation mit Azure verwendet werden.
Parametereigenschaften
| Typ: | IAzureContextContainer |
| Standardwert: | None |
| Unterstützt Platzhalter: | False |
| Nicht anzeigen: | False |
| Aliase: | AzContext, AzureRmContext, AzureCredential |
Parametersätze
(All)
| Position: | Named |
| Obligatorisch: | False |
| Wert aus Pipeline: | False |
| Wert aus Pipeline nach dem Eigenschaftsnamen: | False |
| Wert aus verbleibenden Argumenten: | False |
-InstanceName
Name des Azure SQL Managed Instance.
Parametereigenschaften
| Typ: | String |
| Standardwert: | None |
| Unterstützt Platzhalter: | False |
| Nicht anzeigen: | False |
Parametersätze
GetByNameParameterSet
| Position: | 1 |
| Obligatorisch: | True |
| Wert aus Pipeline: | False |
| Wert aus Pipeline nach dem Eigenschaftsnamen: | False |
| Wert aus verbleibenden Argumenten: | False |
-InstanceObject
Instanzeingabeobjekt.
Parametereigenschaften
| Typ: | AzureSqlManagedInstanceModel |
| Standardwert: | None |
| Unterstützt Platzhalter: | False |
| Nicht anzeigen: | False |
Parametersätze
GetByParentObjectParameterSet
| Position: | 0 |
| Obligatorisch: | True |
| Wert aus Pipeline: | True |
| Wert aus Pipeline nach dem Eigenschaftsnamen: | False |
| Wert aus verbleibenden Argumenten: | False |
-InstanceResourceId
Ressourcen-ID der verwalteten Instanz.
Parametereigenschaften
| Typ: | String |
| Standardwert: | None |
| Unterstützt Platzhalter: | False |
| Nicht anzeigen: | False |
Parametersätze
GetByInstanceResourceIdParameterSet
| Position: | 0 |
| Obligatorisch: | True |
| Wert aus Pipeline: | False |
| Wert aus Pipeline nach dem Eigenschaftsnamen: | True |
| Wert aus verbleibenden Argumenten: | False |
-Name
Name des Zertifikats (Endpunkttyp).
Parametereigenschaften
| Typ: | String |
| Standardwert: | None |
| Unterstützt Platzhalter: | False |
| Nicht anzeigen: | False |
| Aliase: | Endpunkttyp |
Parametersätze
GetByNameParameterSet
| Position: | 2 |
| Obligatorisch: | False |
| Wert aus Pipeline: | False |
| Wert aus Pipeline nach dem Eigenschaftsnamen: | False |
| Wert aus verbleibenden Argumenten: | False |
GetByParentObjectParameterSet
| Position: | 2 |
| Obligatorisch: | False |
| Wert aus Pipeline: | False |
| Wert aus Pipeline nach dem Eigenschaftsnamen: | False |
| Wert aus verbleibenden Argumenten: | False |
GetByInstanceResourceIdParameterSet
| Position: | 2 |
| Obligatorisch: | False |
| Wert aus Pipeline: | False |
| Wert aus Pipeline nach dem Eigenschaftsnamen: | False |
| Wert aus verbleibenden Argumenten: | False |
-ResourceGroupName
Name der Ressourcengruppe
Parametereigenschaften
| Typ: | String |
| Standardwert: | None |
| Unterstützt Platzhalter: | False |
| Nicht anzeigen: | False |
Parametersätze
GetByNameParameterSet
| Position: | 0 |
| Obligatorisch: | True |
| Wert aus Pipeline: | False |
| Wert aus Pipeline nach dem Eigenschaftsnamen: | False |
| Wert aus verbleibenden Argumenten: | False |
-ResourceId
Zertifikatressourcen-ID.
Parametereigenschaften
| Typ: | String |
| Standardwert: | None |
| Unterstützt Platzhalter: | False |
| Nicht anzeigen: | False |
Parametersätze
GetByResourceIdParameterSet
| Position: | 0 |
| Obligatorisch: | True |
| Wert aus Pipeline: | False |
| Wert aus Pipeline nach dem Eigenschaftsnamen: | True |
| Wert aus verbleibenden Argumenten: | False |
CommonParameters
Dieses Cmdlet unterstützt die allgemeinen Parameter -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction und -WarningVariable. Weitere Informationen findest du unter about_CommonParameters.
