users via API

[Ivo_Hrbacek]

Hi guys,
I would like to ask if there are some plans to include handling users via API in future releases (local account creation, certificate generation, etc.)? Now there is no such possibility via API and I think it could be very handy when migrating from different platforms

thx for info

[Robert_Decker]

Hi Ivo,

Yes, there are plans to support User objects via API.

Unfortunately, I cannot provide estimations for release version/date at this moment.

Robert.

[Paul_Melinn]

Hi

This is also a feature I would like. Is there any update on when it may be included?

thanks

Paul

[Robert_Decker]

Hi Paul,

Our R&D is working to provide full support for users creation with a standard API commands.

Meanwhile, you can use this thread to create users with a non-standard approach - 

https://community.checkpoint.com/docs/DOC-2844

Robert.

[Paul_Melinn]

Thanks Robert, appreciate the speedy response.

We have an audit requirement to send a list of  users that are contained within a specific user group monthly. It sounds like an easy request but so far I am failing.  I'm no API / JSON expert by the way.  Do you know if there's a simple way to do this?

[Robert_Decker]

This bash script expects an users group name as its parameter, and creates a text file with this name containing all users names - 

#!/bin/sh

JQ=${CPDIR}/jq/jq

GROUP_NAME=$1
USERS_FILE="users.json"
USER_FILE="user.json"
USER_NAMES_FILE="$GROUP_NAME.txt"

> $USER_NAMES_FILE

mgmt_cli -r true show generic-objects name $GROUP_NAME details-level full -f json > $USERS_FILE
if [ $? -ne 1 ]; then
  USERS_UIDS=($($JQ -r '.objects[] | .emptyFieldName[] | .' $USERS_FILE))
  for USER_UID in ${USERS_UIDS[@]}; do
    echo 'User UID: '"$USER_UID"
     mgmt_cli -r true show generic-object uid $USER_UID -f json > $USER_FILE
     if [ $? -ne 1 ]; then
       USER_NAME=($($JQ -r '.name' $USER_FILE))
       echo 'User Name: '"$USER_NAME"
       echo $USER_NAME >> $USER_NAMES_FILE
     fi
  done
fi
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

you should run it on your management server.

Robert.

[Paul_Melinn]

Thanks again Robert

I took the script. Copied it onto my Mgt Server (/home/admin). Renamed it as Users_in_group.sh  .  Did a chmod to allow for execution (777).

In expert mode ran as "./Users_in_group.sh  Our-Group-name-var"

And got "/Users_in_group: cannot execute binary file" error message.

Excuse my lack of knowledge here but am I doing something wrong?

[Robert_Decker]

run dos2unix on it before the execution.

[Paul_Melinn]

Apologies Robert - I was offsite the least week.  I tried it there and it's working for me a treat. Thanks so much for your help.

Paul

[Paul_Melinn]

One more thing Robert - It runs fine from the command line as admin.  When I try to schedule the command via job scheduler on GAIA www GUI it gives me the following errors.

Any ideas?  It's the same user running the same command in both cases.  Maybe it's shell related?

The scheduled job is to run this command (your script is called Usergplist.sh)

 ./Usergplist.sh treas_users

The job fails with the following output:

./Usergplist.sh: line 12: mgmt_cli: command not found

./Usergplist.sh: line 14: /jq/jq: No such file or directory

[Robert_Decker]

did you apply the chmod 777 on the script?

[Paul_Melinn]

Hi Robert

Yes I did. The script works fine directly from SSH command line. It only fails, as above, via job scheduler on Web Interface.

The job scheduler command syntax is also exactly the same via SSH command line and Web interface.

Any ideas?

[Robert_Decker]

Hi Paul,

I've no idea how the job scheduler works.

Maybe Dameon Welch Abernathy‌ can assist here.

Robert.

[PhoneBoy]

That's because certain environment variables aren't set when you run via cron/job scheduler that ARE set when run from the CLI.

From the above:

1. mgmt_cli isn't in the command execution path (replace with /opt/CPshrd-R80/bin/mgmt_cli)
2. $CPDIR isn't defined (replace with /opt/CPshrd-R80)

[Paul_Melinn]

Thanks Dameon  & Robert Decker‌

I have now modified the script as below but am now getting a different error. I don't even see how this shared library is being called by the script. Reckon this is hopefully the last hurdle!

Just to confirm, the script still runs fine from CLI.

Error from Job scheduler:

/opt/CPshrd-R80/bin/mgmt_cli: error while loading shared libraries: libmgmt_cli_utils.so: cannot open shared object file: No such file or directory

Adjusted script:

#!/bin/sh

　

JQ=/opt/CPshrd-R80/jq/jq

　

GROUP_NAME=$1

USERS_FILE="users.json"

USER_FILE="user.json"

USER_NAMES_FILE="$GROUP_NAME.txt"

　

> $USER_NAMES_FILE

　

/opt/CPshrd-R80/bin/mgmt_cli -r true show generic-objects name $GROUP_NAME details-level full -f json > $USERS_FILE

if [ $? -ne 1 ]; then

USERS_UIDS=($($JQ -r '.objects[] | .emptyFieldName[] | .' $USERS_FILE))

for USER_UID in ${USERS_UIDS[@]}; do

echo 'User UID: '"$USER_UID"

/opt/CPshrd-R80/bin/mgmt_cli -r true show generic-object uid $USER_UID -f json > $USER_FILE

if [ $? -ne 1 ]; then

USER_NAME=($($JQ -r '.name' $USER_FILE))

echo 'User Name: '"$USER_NAME"

echo $USER_NAME >> $USER_NAMES_FILE

fi

done

fi

[Robert_Decker]

Hi Paul,

The libmgmt_cli_utils.so library is used internally by mgmt_cli tool.

It is located in - "/opt/CPshrd-R80/lib" folder. You have to reference this folder too in your command execution path.

Robert.

[Paul_Melinn]

Hi Robert

I have played around with this for a while with no luck.

Is this what you mean below?  I doubt it...  it doesn't look right to me and I'm a complete novice.  If so - it's still failing with the same error.

Sorry about this - how should the "/opt/CPshrd-R80/lib/" be included in the command execution path?

Thanks again

#!/bin/sh

　

JQ=/opt/CPshrd-R80/jq/jq

　

GROUP_NAME=$1

USERS_FILE="users.json"

USER_FILE="user.json"

USER_NAMES_FILE="$GROUP_NAME.txt"

　

> $USER_NAMES_FILE

　

/opt/CPshrd-R80/bin/mgmt_cli -r true show /opt/CPshrd-R80/lib/generic-objects name $GROUP_NAME details-level full -f json > $USERS_FILE

if [ $? -ne 1 ]; then

USERS_UIDS=($($JQ -r '.objects[] | .emptyFieldName[] | .' $USERS_FILE))

for USER_UID in ${USERS_UIDS[@]}; do

echo 'User UID: '"$USER_UID"

/opt/CPshrd-R80/bin/mgmt_cli -r true show /opt/CPshrd-R80/lib/generic-object uid $USER_UID -f json > $USER_FILE

if [ $? -ne 1 ]; then

USER_NAME=($($JQ -r '.name' $USER_FILE))

echo 'User Name: '"$USER_NAME"

echo $USER_NAME >> $USER_NAMES_FILE

fi

done

fi

[PhoneBoy]

In your script, include the following line before any commands are executed:

source /opt/CPshrd-R80/tmp/.CPprofile.sh

This should set all the necessary variables.

(Note this may need to be changed after major upgrades)

Then you can do the mgmt_cli commands without paths (e.g. mgmt_cli -r true show generic-objects name $GROUP_NAME details-level full -f json > $USERS_FILE)

[Paul_Melinn]

Thanks Dameon - that's a very useful command. All working now.  Thanks for all you help ( & Robert too).

Paul

[Daniel_Taney]

Thank you for this! I hit the same well getting a script to run & found this point. Problem solved!

[Flo]

Hey @Robert_Decker 

thank you so much for the script.

I have testet it. It also works on R80.30 Mgmt.

Only small things have to be adapted.

#!/bin/sh
JQ=/opt/CPshrd-R80.30/jq/jq
GROUP_NAME=$1
USERS_FILE="users.json"
USER_FILE="user.json"
USER_NAMES_FILE="$GROUP_NAME.txt"
> $USER_NAMES_FILE
/opt/CPshrd-R80.30/bin/mgmt_cli -r true show generic-objects name $GROUP_NAME details-level full -f json > $USERS_FILE
if [ $? -ne 1 ]; then
USERS_UIDS=($($JQ -r '.objects[] | .emptyFieldName[] | .' $USERS_FILE))
for USER_UID in ${USERS_UIDS[@]}; do
echo 'User UID: '"$USER_UID"
/opt/CPshrd-R80.30/bin/mgmt_cli -r true show generic-object uid $USER_UID -f json > $USER_FILE
if [ $? -ne 1 ]; then
USER_NAME=($($JQ -r '.name' $USER_FILE))
echo 'User Name: '"$USER_NAME"
echo $USER_NAME >> $USER_NAMES_FILE
fi
done
fi

[Karen_Askelson]

Would anyone happen to have a script that would list all users and all groups with users?  We have a client that requests a list of users and groups every month.  I was able to use this script to get the groups individually and then merged the txt files into an Excel spreadsheet, but would like to avoid that last step if at all possible.

Thanks in advance!

[Davehills1977]

Hi All,

I have tried using this script via CMD line on my primary MDS and get the following error

Error: The parameters of show-generic-objects command should be provided in pairs (key and value). You have provided an odd number of parameters which suggests that you are probably missing a parameter.

basically what i am trying to achieve is to extract all of the users from a group within a specific domain. Is it possible from this script?

SACn is the name of the group I am trying to get a list of users from.. obviously nothing here specifies the domain, do i need to include that somehow?

-----------------------------------------------------------------------------------------

#!/bin/sh
JQ=/opt/CPshrd-R80.20/jq/jq
GROUP_NAME=$1
USERS_FILE="users.json"
USER_FILE="user.json"
USER_NAMES_FILE="$GROUP_NAME.txt"
> $USER_NAMES_FILE
/opt/CPshrd-R80.20/bin/mgmt_cli -r true show generic-objects name $SACn details-level full -f json > $USERS_FILE
if [ $? -ne 1 ]; then
USERS_UIDS=($($JQ -r '.objects[] | .emptyFieldName[] | .' $USERS_FILE))
for USER_UID in ${USERS_UIDS[@]}; do
echo 'User UID: '"$USER_UID"
/opt/CPshrd-R80.20/bin/mgmt_cli -r true show generic-object uid $USER_UID -f json > $USER_FILE
if [ $? -ne SACn ]; then
USER_NAME=($($JQ -r '.name' $USER_FILE))
echo 'User Name: '"$USER_NAME"
echo $USER_NAME >> $USER_NAMES_FILE
fi
done
fi

--------------------------------------------------------------------------------------------------

Many thanks in advance

Dave

[Eduardo_Santos]

Hi All,

I ran this script and its working great in R80.30, but I would like the help of experts in scripts to improve this as follows:

Instead of running with ./script.sh <group_name) what can be done to we run something like ./script.sh and it returns a file with all existent groups and its users.

Sample:
result.txt

group1
     user1
     user2
     user3
group2
     user3
     user4
     user8
group6
     user1
     user8
     user10

Thanks if anybody can help..

[mrvic02]

@Eduardo_Santos 

Congrats you ran it without issues. Can you please provide the scripts you used and how to run it in your management server?

Thanks,

Vince

[madu1]

This would be amazing!  Did anyone find a solution to output all groups with member users yet? 🤔

[Rick_Rodrix]

Hi there, thanks a lot for this script, it worked fine for me on 2022 using r81.10.
I'm not very familiar with scripts, I'd like to add beyond "Username" others fields such as "Name","Comments". 
Is it possible a help for that?

TIA.

[madu1]

This script isn't working for me.

Even when I run with ./users.sh GROUPNAME the output text file is empty - no username shown.

Does anyone know what I'm doing wrong?

#!/bin/sh
source /opt/CPshrd-R81.10/tmp/.CPprofile.sh
JQ=/opt/CPshrd-R81.10/jq/jq
GROUP_NAME=$1
USERS_FILE="users.json"
USER_FILE="user.json"
USER_NAMES_FILE="$GROUP_NAME.txt" > $USER_NAMES_FILE
/opt/CPshrd-R81.10/bin/mgmt_cli -r true show generic-objects name $GROUP_NAME details-level full -f json > $USERS_FILE
if [ $? -ne 1 ]; then
USERS_UIDS=($($JQ -r '.objects[] | .emptyFieldName[] | .' $USERS_FILE))
for USER_UID in ${USERS_UIDS[@]}; do
echo 'User UID: '"$USER_UID"
/opt/CPshrd-R81.10/bin/mgmt_cli -r true show generic-object uid $USER_UID -f json > $USER_FILE
if [ $? -ne 1 ]; then
USER_NAME=($($JQ -r '.name' $USER_FILE))
echo 'User Name: '"$USER_NAME"
echo $USER_NAME >> $USER_NAMES_FILE
fi
done
fi

(R81.10 T139)

[mrvic02]

Tried to used below script with different path location since I'm using R80.40 but still I'm getting below error.

The parameters of show-generic-objects command should be provided in pairs (key and value). You have provided an odd number of parameters which suggests that you are probably missing a parameter.

--------------------------

#!/bin/sh
JQ=/opt/CPshrd-R80.40/jq/jq
GROUP_NAME=$1
USERS_FILE="users.json"
USER_FILE="user.json"
USER_NAMES_FILE="$GROUP_NAME.txt"
> $USER_NAMES_FILE
/opt/CPshrd-R80.40/bin/mgmt_cli -r true show generic-objects name $GROUP_NAME details-level full -f json > $USERS_FILE
if [ $? -ne 1 ]; then
USERS_UIDS=($($JQ -r '.objects[] | .emptyFieldName[] | .' $USERS_FILE))
for USER_UID in ${USERS_UIDS[@]}; do
echo 'User UID: '"$USER_UID"
/opt/CPshrd-R80.40/bin/mgmt_cli -r true show generic-object uid $USER_UID -f json > $USER_FILE
if [ $? -ne 1 ]; then
USER_NAME=($($JQ -r '.name' $USER_FILE))
echo 'User Name: '"$USER_NAME"
echo $USER_NAME >> $USER_NAMES_FILE
fi
done
fi

-------------------------------

By the way the steps I performed to run the scripts are below.

1. Login to the Management Server. In expert mode, execute chmod +x users.sh.

2. Execute ./users.sh

Hope you can help me. Thanks,

Vince

[Jonas_Rosenboom]

Try changing step 2 to include the name of the group you want to get the user information for:

./users.sh GROUP_NAME