How to create a user report if the report is so large, it can't load on the browser
Posted by John Villanueva, Last modified by John Villanueva on 23 April 2020 04:45 AM
The User Report (Users > Users > User Report button) feature can provide detailed information about how users are set up. Unfortunately, if this report gets too large, it usually has difficulty loading on a browser.
One workaround for generating this kind of report is to export the data directly to a CSV file using one of the Java classes attached to this article. This workaround has to be done in the command line/terminal.
The command as well the .class used can differ depending on the version but here are some of them.
Note: If the client.cfg file does not exist, you need to run the js-client-configuration command line utility first.
Note: Since Kayako automatically renames the class filenames to lowercase, please rename the attached *.class files to MFT_UserList93.class and MFT_UserList102.class respecitively after downloading.
Note: If you're running these on Windows, replace each colon (:) with a semicolon (;). The syntax below is for Unix/Linux-based operating systems.
For versions 9.3 and 10.0
Copy the attached MFT_UserList93.class file into <mftserver installdir> then execute the following command while inside <mftserver installdir>. Please replace <domain> accordingly.
For versions 10.1 and higher
Copy the attached MFT_UserList102.class file into <mftserver installdir> then execute the following command while inside <mftserver installdir>. Please replace <domain> accordingly.
java -classpath .:./libs/ftpserver.jar:./libs/bcprov-jdk15on-158.jar MFT_UserList102 etc/client.cfg <domain> > users.csv
You should then have users.csv file generated after containing a report of all your users in CSV format.
Note: The bcprov-jdk15on*.jar can vary depending on the MFT Server version. For example, JSCAPE MFT Server v11.2 has bcprov-jdk15on-161.jar instead of bcprov-jdk15on-158.jar. Just navigate to the [mft server installdir]/lib directory and check to be sure.