Tectia

Exporting Information from Database

The ssh-mgmt-engine command, located in <server-root>/server/sbin (by default /opt/ssh-mgmt/server/sbin), can be run with special options to export various information from the database and output it to stdout in Tab Separated Values (TSV) format.

The usage of the command is as follows:

# ssh-mgmt-engine --data-dump-<type>=FILE

In the command <type> can be hosts, users, or groups. You can get a list of all options by running the command with the -h option.

When ssh-mgmt-engine is invoked with one or more of these options, the engine is not started normally but the data is dumped to the file(s) and that instance of ssh-mgmt-engine exits. Note, that the ssh-mgmt-engine has to be running when these data-dumping options are used, otherwise the connection to the database will fail.

Running the data-dump commands can take several minutes, depending on the size of the database.

--data-dump-hosts=FILE

Dump information on managed hosts to FILE. The first output line is the header, and the following lines contain host information, one line per host.

The host information includes data on host machine, installed Tectia configurations, and installed certificates.

The following information on the host machine is output:

Name
Operating system
OS version
Kernel version
Computer model
Processor type
Number of processors
Processor speed (MHz)
Memory size (MB)
Domain name
IP address(es)
Hardware address(es)
Host id
All host names
Host type
Boot identifier
Number of reboots seen
Last connection established
Last seen
Internal host number
Management agent version
Management agent version (for search)
Host internal identifier
Shared secret
Number of connections
Number of applications with local changes 
Host has pending changes
Is the host active (= exists)?
Group in views 0 - 15
Distribution group
Current distribution group
Is the host a distribution server?
Secure Shell version
Secure Shell server running

The following information on the Tectia configurations on the host is output:

Unix server 4.x configuration
 Version
 Deployed
Windows server 4.x configuration
 Version
 Deployed
Server G3 configuration
 Version
 Deployed
Unix client 4.x configuration
 Version
 Deployed
Client G3 configuration
 Version
 Deployed
Windows client 4.x configuration
 Version
 Deployed
Management agent configuration
 Version
 Deployed

The following information on the host certificate is output:

issuer_id
serial_number
issued_at
not_after
status
crldp_id
revoked_at
revoke_reason
certapp
--data-dump-users=FILE

Dump information on the Tectia Manager admin user accounts to FILE. The first output line is the header, and the following lines contain admin user information, one line per user.

The following information on the admin users is output:

username
real-name
e-mail-address
last-login
auth
groups
--data-dump-groups=FILE

Dump information on the Tectia Manager admin groups to FILE. The first output line is the header, and the following lines contain admin group information, one line per group.

The following information on the admin groups is output:

group-id
group-name
group-description
group-special
manual-management
edit-auto-assign
manage-groups
license-admin
view-configurations
administer-configurations
edit-configurations
reports
manage-ds-hier
deploy-csm-client
view-audit-log
event-log
manage-icbs
<view-based rights>