THE INFORMATION IN THIS ARTICLE APPLIES TO:
DISCUSSION
User data is different than User Configuration and is not in the ARM module. Only metrics from users who upload and downloads files are in the ARM database.
(Refer to KB#11283 for details of using the EFT Migration and Sync Tool instead of scripting.)
Configuring COM API
COM API is required for the any type of script to run and affect
settings in EFT. This is true for EFT Migration and Sync Tool. It also
requires the same functionality as VB scripting/Powershell when
connecting to the service.
- Remote administration must be enabled on EFT.
- Either the EFT administration interface must be installed or the
DLL’s must be on the system where the script is run: C:\Program Files
(x86)\Common Files\Globalscape\SFTPCOMInterface\
- User ID of either a GS administrator account or AD auth (if you have HSM module).
How do we use the script to enforce settings?
Let’s start by breaking down the script.
Connecting to EFT:
CRLF = (Chr(13)& Chr(10))
txtServer = "localhost"
txtPort = "1100"
txtAdminUserName = "test"
txtPassword = "test"
txtSiteName = "EFT FTP"
txtSettingsLevel = "Default Settings"
Modify Security Settings:
In this case, no modification is required of the actual logic of the script.
For each name in users
set userSettings = site.GetUserSettings(name)
Fullname = userSettings.Fullname
Locked = userSettings.IsLocked
Phone = userSettings.Phone
Fax = userSettings.Fax
Pager = userSettings.Pager
Email = userSettings.Email
Custom1 = userSettings.Custom1
Custom2 = userSettings.Custom2
Custom3 = userSettings.Custom3
Comment = userSettings.Comment
PhysHomeDir = site.GetPhysicalPath(name)
HomeDirString = userSettings.GetHomeDirString
lastModifiedBy = userSettings.LastModifiedBy
lastModifiedTime = FormatDateTime(userSettings.LastModificationTime, 1)
lastconnectionTime = FormatDateTime(userSettings.LastConnectionTime, 1)
accountCreationTime = FormatDateTime(userSettings.AccountCreationTime, 1)
As you see, the script will loop through ALL users on the EFT Site (specified from above section) and will find all details relating to that user accounts.
The generated file from the run will create an “output_users.csv” file that can now be imported into Excel or any other product.
*Note: This process is only about extracting information from the EFT system for documentation and not about importing information from a RAW comma delimited text file.