Dela via

Get-AzSqlInstanceEndpointCertificate

  • Referens
Modul:
Az.Sql

Returnerar information om slutpunktscertifikat.

Syntax

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

Description

Get-AzSqlInstanceEndpointCertificate cmdlet returnerar information om en eller flera instanser av slutpunktscertifikat på en Azure SQL Managed Instance. Ange namnet på ett certifikat (eller en slutpunktstyp) för att endast visa information om certifikatet.

Exempel

Exempel 1: Hämta information om alla slutpunktscertifikat på 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

Det här kommandot hämtar information om alla slutpunktscertifikat i instansen "ManagedInstance01".

Exempel 2: Hämta information om ett certifikat för en viss slutpunktstyp på 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

Det här kommandot hämtar information om slutpunktscertifikatet "DATABASE_MIRRORING" på instansen "ManagedInstance01" och resursgruppen "ResourceGroup01".

Exempel 3: Hämta alla slutpunktscertifikat på Azure SQL Managed Instance med hjälp av instansobjekt

$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

Det här kommandot hämtar information om alla slutpunktscertifikat i instansen "ManagedInstance01".

Exempel 4: Hämta alla slutpunktscertifikat på Azure SQL Managed Instance med hjälp av instansresursidentifierare

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

Det här kommandot hämtar information om alla slutpunktscertifikat i instansen "ManagedInstance01".

Exempel 5: Hämta ett slutpunktscertifikat med hjälp av dess resursidentifierare

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

Det här kommandot hämtar information om slutpunktscertifikatet med namnet "DATABASE_MIRRORING".

Exempel 6: Hämta alla slutpunktscertifikat för en hanterad instans genom att skicka ett instansobjekt

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

Det här kommandot hämtar information om alla slutpunktscertifikat i instansen "ManagedInstance01".

Exempel 7: Hämta ett specifikt slutpunktscertifikat för en instans genom att skicka ett instansobjekt och ange certifikatnamnet

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

Det här kommandot hämtar information om slutpunktscertifikatet "SERVICE_BROKER" på instansen "ManagedInstance01" och resursgruppen "ResourceGroup01".

Exempel 8: Hämta information om slutpunktscertifikat med hjälp av positionsparametrar

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

Det här kommandot hämtar information om slutpunktscertifikatet "DATABASE_MIRRORING" på instansen "ManagedInstance01" och resursgruppen "ResourceGroup01".

Parametrar

-DefaultProfile

Autentiseringsuppgifter, konto, klientorganisation och prenumeration som används för kommunikation med Azure.

Typ:IAzureContextContainer
Alias:AzContext, AzureRmContext, AzureCredential
Position:Named
Standardvärde:None
Obligatorisk:False
Godkänn pipeline-indata:False
Godkänn jokertecken:False

-InstanceName

Namnet på Azure SQL Managed Instance.

Typ:String
Position:1
Standardvärde:None
Obligatorisk:True
Godkänn pipeline-indata:False
Godkänn jokertecken:False

-InstanceObject

Instansindataobjekt.

Typ:AzureSqlManagedInstanceModel
Position:0
Standardvärde:None
Obligatorisk:True
Godkänn pipeline-indata:True
Godkänn jokertecken:False

-InstanceResourceId

Resurs-ID för hanterad instans.

Typ:String
Position:0
Standardvärde:None
Obligatorisk:True
Godkänn pipeline-indata:True
Godkänn jokertecken:False

-Name

Namnet på certifikatet (slutpunktstyp).

Typ:String
Alias:EndpointType
Position:2
Standardvärde:None
Obligatorisk:False
Godkänn pipeline-indata:False
Godkänn jokertecken:False

-ResourceGroupName

Namnet på resursgruppen.

Typ:String
Position:0
Standardvärde:None
Obligatorisk:True
Godkänn pipeline-indata:False
Godkänn jokertecken:False

-ResourceId

Certifikatresurs-ID.

Typ:String
Position:0
Standardvärde:None
Obligatorisk:True
Godkänn pipeline-indata:True
Godkänn jokertecken:False

Indata

AzureSqlManagedInstanceModel

String

Utdata

AzureSqlInstanceEndpointCertificateModel