Count the Number of Licensed Users (Users Assigned to Roles)

Use the script in this section to generate the Role Assignment Report to count the number of users for an environment.

Create provisionedUsersCount.bat by copying the following script.

Note:

  • Input parameters to run provisionedUsersCount.bat are username, password/password_file, service_url, and report_file_name. For example, at the command prompt, enter a command similar to the following:

    provisionedUsersCount.bat jdoe password.epw https://example.oraclecloud.com myRole_assign.CSV

    If the password contains special characters, see Handling Special Characters.
  • If you are using the PDF version of this document: To avoid line breaks and footer information that will render this script unusable, copy the script from the HTML version of this topic.

@echo off

set paramRequiredMessage=Syntax: provisionedUsersCount.bat USERNAME PASSWORD/PASSWORD_FILE URL REPORT_FILE_NAME

if "%~1" == "" (
      echo User Name is missing.
	echo %paramRequiredMessage%
	exit /b 1
  )

if "%~2" == "" (
	echo Password or Password_File is missing.
	echo %paramRequiredMessage%
	exit /b 1
  )

if "%~3" == "" (
	echo URL is missing.
	echo %paramRequiredMessage%
	exit /b 1
  )

if "%~4" == "" (
	echo Role Assignment Report File Name is missing.
	echo %paramRequiredMessage%
	exit /b 1
  )

call epmautomate.bat login %~1 "%~2" %~3 
REM call epmautomate.bat login %~1 "%~2" %~3

if %errorlevel% NEQ 0 exit /b 1
   call epmautomate.bat roleAssignmentReport "%5"
if %errorlevel% NEQ 0 exit /b 1
   call epmautomate.bat downloadFile "%5"
if %errorlevel% NEQ 0 exit /b 1

set filePath="%cd%\%4"

if exist %filePath% (
	SETLOCAL EnableDelayedExpansion
	set /a lineCount=0
	set /a userCount=0
	set userHeaderFound=false
	for /f "tokens=*" %%A in ( 'type %filePath%' ) do (
		set /a lineCount+=1
		set line=%%A
		
		REM Fetch username from role assignment information row
		if !userHeaderFound!==true (
			for /f "delims=," %%i in ("!line!") do (
				set userName=%%i
      	)
		if NOT !userName! == "" (
		  if !userCount! gtr 0 if NOT !userName! == !lastUserName! (
			  set /a userCount+=1
      	set users[!userCount!]=!userName!
				)
  		if !userCount! == 0 (
				set /a userCount+=1
				set users[!userCount!]=!userName!
				)
      set lastUserName=!userName!
			)
		)

		REM Check for headers of Role Assignment Report
		if "!line!"=="User Login,First Name,Last Name,Email,Role,Granted through Group" (
				set userHeaderFound=true
		    )
    if "!line!"=="User Login,First Name,Last Name,Email,Roles,Granted Through" (
        set userHeaderFound=true
		 )
	)

	echo Number of Users: !userCount!
	for /l %%n in (1,1,!userCount!) do ( 
  REM echo !users[%%n]!
	)
	endlocal

) else (
	  echo Invalid provisioning report file path - %filePath%.
)