-
Notifications
You must be signed in to change notification settings - Fork 0
Get UdeDbJit
Gets UDE database JIT access information for a specified environment.
Get-UdeDbJit [-EnvironmentId] <String> [[-WhitelistIp] <String>] [[-Role] <String>] [[-Reason] <String>]
[-AsExcelOutput] [-ProgressAction <ActionPreference>] [<CommonParameters>]
This function retrieves UDE database JIT access information for a specified environment.
Get-UdeDbJit -EnvironmentId "env-123"
This will retrieve the JIT database access information for the specified environment ID. It will whitelist the public IP address of the machine running the command. It will assign the "Reader" role. It will use the default reason.
Get-UdeDbJit -EnvironmentId "env-123" -WhitelistIp "85.168.174.10"
This will retrieve the JIT database access information for the specified environment ID. It will whitelist the specified IP address "85.168.174.10". It will assign the "Reader" role. It will use the default reason.
Get-UdeDbJit -EnvironmentId "env-123" -Role "Writer"
This will retrieve the JIT database access information for the specified environment ID. It will whitelist the public IP address of the machine running the command. It will assign the "Writer" role. It will use the default reason.
Get-UdeDbJit -EnvironmentId "env-123" -Reason "Needed for data migration"
This will retrieve the JIT database access information for the specified environment ID. It will whitelist the public IP address of the machine running the command. It will assign the "Reader" role. It will use the specified reason "Needed for data migration".
Get-UnifiedEnvironment -EnvironmentId "env-123" | Get-UdeDbJit
This will retrieve the JIT database access information for the specified environment ID. It will whitelist the public IP address of the machine running the command. It will assign the "Reader" role. It will use the default reason. It will output all details directly to an Excel file.
The ID of the environment that you want to work against.
Supports wildcard patterns.
Can be either the environment name or the environment GUID.
Type: String
Parameter Sets: (All)
Aliases: PpacEnvId
Required: True
Position: 1
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: FalseIp address to whitelist for JIT database access.
Defaults to 127.0.0.1 - which will cause the function to determine the public IP address of the machine running the command.
Supports single, range and CIDR notation.
10.0.0.7 - single IP 10.0.0.7-10.0.0.20 - range 10.0.0.0/24 - CIDR notation
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 2
Default value: 127.0.0.1
Accept pipeline input: False
Accept wildcard characters: FalseThe role to assign for JIT database access.
Can be either "Reader" or "Writer".
Defaults to "Reader".
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 3
Default value: Reader
Accept pipeline input: False
Accept wildcard characters: FalseThe reason for requesting JIT database access.
Defaults to "Administrative access via d365bap.tools".
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 4
Default value: Administrative access via d365bap.tools
Accept pipeline input: False
Accept wildcard characters: FalseInstruct the cmdlet to output all details directly to an Excel file.
Will include all properties, including those not shown by default in the console output.
Type: SwitchParameter
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False{{ Fill ProgressAction Description }}
Type: ActionPreference
Parameter Sets: (All)
Aliases: proga
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseThis cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.
Author: Mötz Jensen (@Splaxi)