Get-AzSqlInstanceDatabaseSensitivityClassification
Mendapatkan jenis informasi saat ini dan label sensitivitas kolom di database Azure SQL Managed Instance.
Sintaks
Get-AzSqlInstanceDatabaseSensitivityClassification
-DatabaseObject <AzureSqlManagedDatabaseModel>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Get-AzSqlInstanceDatabaseSensitivityClassification
[-ResourceGroupName] <String>
[-InstanceName] <String>
[-DatabaseName] <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Get-AzSqlInstanceDatabaseSensitivityClassification
[-ResourceGroupName] <String>
[-InstanceName] <String>
[-DatabaseName] <String>
-SchemaName <String>
-TableName <String>
-ColumnName <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Get-AzSqlInstanceDatabaseSensitivityClassification
-DatabaseObject <AzureSqlManagedDatabaseModel>
-SchemaName <String>
-TableName <String>
-ColumnName <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Deskripsi
Cmdlet Get-AzSqlInstanceDatabaseSensitivityClassification mengembalikan jenis informasi saat ini dan label sensitivitas kolom dalam database Azure SQL Managed Instance.
Contoh
Contoh 1: Dapatkan jenis informasi saat ini dan label sensitivitas database Azure SQL Managed Instance.
Get-AzSqlInstanceDatabaseSensitivityClassification -ResourceGroupName resourceGroup -InstanceName managedInstance -DatabaseName database
ResourceGroupName : resourceGroup
InstanceName : managedInstance
DatabaseName : database
SensitivityLabels : {{
SchemaName: dbo,
TableName: Report,
ColumnName: ReportEmailBody,
InformationType: Contact Info
}, {
SchemaName: dbo,
TableName: Report,
ColumnName: ReportEmailSubject,
SensitivityLabel: Confidential,
Rank: Medium
}, {
SchemaName: dbo,
TableName: EMailLog,
ColumnName: BounceEmailSubject,
SensitivityLabel: Confidential,
InformationType: Contact Info,
Rank: Medium
}}
Contoh 2: Dapatkan jenis informasi saat ini dan label sensitivitas database Azure SQL Managed Instance dengan Piping.
Get-AzSqlInstanceDatabase -ResourceGroupName resourceGroup -InstanceName managedInstance -Name database | Get-AzSqlInstanceDatabaseSensitivityClassification
ResourceGroupName : resourceGroup
InstanceName : managedInstance
DatabaseName : database
SensitivityLabels : {{
SchemaName: dbo,
TableName: Report,
ColumnName: ReportEmailBody,
InformationType: Contact Info
}, {
SchemaName: dbo,
TableName: Report,
ColumnName: ReportEmailSubject,
SensitivityLabel: Confidential,
Rank: Medium
}, {
SchemaName: dbo,
TableName: EMailLog,
ColumnName: BounceEmailSubject,
SensitivityLabel: Confidential,
InformationType: Contact Info,
Rank: Medium
}}
Contoh 3: Dapatkan jenis informasi saat ini dan label sensitivitas kolom tertentu dari database Azure SQL Managed Instance.
Get-AzSqlInstanceDatabaseSensitivityClassification -ResourceGroupName resourceGroup -InstanceName managedInstance -DatabaseName database -SchemaName dbo -TableName EMailLog -ColumnName BounceEmailSubject
ResourceGroupName : resourceGroup
InstanceName : managedInstance
DatabaseName : database
SensitivityLabels : {{
SchemaName: dbo,
TableName: EMailLog,
ColumnName: BounceEmailSubject,
SensitivityLabel: Confidential,
InformationType: Contact Info,
Rank: Medium
}}
Contoh 4: Dapatkan jenis informasi saat ini dan label sensitivitas kolom tertentu dari database Azure SQL Managed Instance menggunakan Piping.
Get-AzSqlInstanceDatabase -ResourceGroupName resourceGroup -InstanceName managedInstance -Name database | Get-AzSqlInstanceDatabaseSensitivityClassification -SchemaName dbo -TableName EMailLog -ColumnName BounceEmailSubject
ResourceGroupName : resourceGroup
InstanceName : managedInstance
DatabaseName : database
SensitivityLabels : {{
SchemaName: dbo,
TableName: EMailLog,
ColumnName: BounceEmailSubject,
SensitivityLabel: Confidential,
InformationType: Contact Info,
Rank: Medium
}}
Parameter
-AsJob
Jalankan cmdlet di latar belakang
Jenis: | SwitchParameter |
Position: | Named |
Nilai default: | None |
Diperlukan: | False |
Terima input alur: | False |
Terima karakter wildcard: | False |
-ColumnName
Nama kolom.
Jenis: | String |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-DatabaseName
Nama database Azure SQL Managed Instance.
Jenis: | String |
Position: | 2 |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-DatabaseObject
Objek database Azure SQL Managed Instance.
Jenis: | AzureSqlManagedDatabaseModel |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-DefaultProfile
Kredensial, akun, penyewa, dan langganan yang digunakan untuk komunikasi dengan Azure.
Jenis: | IAzureContextContainer |
Alias: | AzContext, AzureRmContext, AzureCredential |
Position: | Named |
Nilai default: | None |
Diperlukan: | False |
Terima input alur: | False |
Terima karakter wildcard: | False |
-InstanceName
Nama Azure SQL Managed Instance.
Jenis: | String |
Position: | 1 |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-ResourceGroupName
Nama grup sumber daya.
Jenis: | String |
Position: | 0 |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-SchemaName
Nama skema.
Jenis: | String |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-TableName
Nama tabel.
Jenis: | String |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
Input
Output
ManagedDatabaseSensitivityClassificationModel