Skip to Content

How to generate user reports as CSV files in Ezeelogin?

383  Nesvin KN July 30, 2024  Features & Functionalities

Exporting Remote Server Access Data for SSH Gateway users as CSV Files.

Overview: This article explains how to generate CSV reports of Gateway users.

Note: Running the below scripts will prompt for the Ezeelogin administrator password. The Ezeelogin administrator password (super admin user) is the user's password created at the time of installation.

1. Run the following script to generate reports for all users. 

root@gateway:# php  /usr/local/ezlogin/eztool.php  -user_report -out filename.csv

2. Run the following script to generate the report for a single user. 

root@gateway:# php  /usr/local/ezlogin/eztool.php  -user_report username -out filename.csv

3. Run the following script to generate the report for multiple users. 

root@gateway:# php  /usr/local/ezlogin/eztool.php  -user_report username1,username2 -out filename.csv

For example, the following script generates the report for all users in Ezeelogin to the "  allreport.csv  " file.  

root@gateway:#  php /usr/local/ezlogin/eztool.php -user_report -out allreport.csv

#########################
# Ezeelogin Tool #
#########################

Checking environment... The memory limit is less than 4 GB. If the script crashes abruptly without any errors, try increasing the PHP memory limit.
done (1736)
Checking license... done (1991)

Enter the Ezeelogin administrator password: Admin!2345

The content of the "  allreport.csv  " file is shown below. 

root@gateway:# cat allreport.csv


username,firstname,lastname,email,usergroup,status,last_login_at,last_login_from,user_created,user_expiry,servername,IP,description,servergroup,ssh_user

admin,Administrator,,,Admins,Active,"2021-12-10 04:50:15",192.168.29.29,"2021-12-01 06:26:09",Never,gw.ezee.co,192.168.29.178,,linux-servers,tech
admin,Administrator,,,Admins,Active,"2021-12-10 04:50:15",192.168.29.29,"2021-12-01 06:26:09",Never,sub-jake-linu16,192.168.29.254,,linux-servers,root
admin,Administrator,,,Admins,Active,"2021-12-10 04:50:15",192.168.29.29,"2021-12-01 06:26:09",Never,Ad-wind-RDP,192.168.29.79,,RDP-machine,Administrator
monica,monica,,[email protected],Dummy,Active,"2021-12-01 07:29:04",127.0.0.1,"2021-12-01 07:27:47",Never,gw.ezee.co,192.168.29.178,,linux-servers,jake
monica,monica,,[email protected],Dummy,Active,"2021-12-01 07:29:04",127.0.0.1,"2021-12-01 07:27:47",Never,sub-jake-linu16,192.168.29.254,,linux-servers,jake
decker,decker,,[email protected],Dummy,Active,"2021-12-01 07:46:24",127.0.0.1,"2021-12-01 07:31:44",Never,sub-jake-linu16,192.168.29.254,,linux-servers,root

The following example shows how to view the list of servers that a user has.

root@gateway:#  php /usr/local/ezlogin/eztool.php -user_report ezadmin -out ezadmin_report.csv

root@gateway:# cat ezadmin_report.csv

username,firstname,lastname,email,usergroup,status,last_login_at,last_login_from,user_created,user_expiry,servername,ip,description,servergroup,ssh_user

ezadmin,Administrator,,,Admins,Active,"2022-12-08 06:44:01",192.168.1.3,"2022-12-06 11:12:30",Never,centos.server,192.168.1.2,,production.server,root
ezadmin,Administrator,,,Admins,Active,"2022-12-08 06:44:01",192.168.1.3,"2022-12-06 11:12:30",Never,ubuntu.server,192.168.1.1,,production.server,root

Related Articles:

License expired when generating user reports.
Rating: 3 (3 Votes)