-
Notifications
You must be signed in to change notification settings - Fork 0
/
Auto_Rbac_csv.ps1
37 lines (30 loc) · 1.03 KB
/
Auto_Rbac_csv.ps1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
#Import-Module Az.Resources
#Connect-AzAccount -UseDeviceAuthentication
$csv = Import-Csv -Path "Rbac\sid-123.csv"
#Loop to iterate between all rows in the csv file.
$p = 0
foreach ($row in $csv) {
$ObjectId = $row.ObjectId
$RoleDefinitionId = $row.RoleDefinitionId;
$Scope = $row.Scope
$RoleDefinitionName = $row.RoleDefinitionName
$SignInName = $row.SignInName
$p = $p + 1;
$row | Add-Member -NotePropertyName 'RowNo' -NotePropertyValue $p
$RowNo = $row.RowNo
#$test1 = $row.test1
#$test1
#$RoleDefinitionId = $row.RoleDefinitionId
#$RoleDefinitionId.Substring(102);
try {
# Assuming RoleDefinitionId is a string, you're trying to substring it
# Also, the first 102 characters are same and not accepted for as a RoleDefinitionId.
$RoleDefinitionId.Substring(102)
}
catch {
Write-Host "Error occurred while processing RoleDefinitionId: $_"
# Log the error, or handle it as needed
}
$RoleDefinitionId.Substring(102)
#Test condition to check whether roleDefination is null or not.
}