How to export hrdata and assetsdata from UBA

Available Languages

Updated:October 1, 2026

Document ID:SPLK053804

Bias-Free Language

The documentation set for this product strives to use bias-free language. For the purposes of this documentation set, bias-free is defined as language that does not imply discrimination based on age, disability, gender, racial identity, ethnic identity, sexual orientation, socioeconomic status, and intersectionality. Exceptions may be present in the documentation due to language that is hardcoded in the user interfaces of the product software, language used based on RFP documentation, or language that is used by a referenced third-party product. Learn more about how Cisco is using Inclusive Language.

Applicability

UBA 5.4.x

Description

In the UBA backend, critical data such as HR account information and asset details are stored in the "hrdataaccounts" and "assetsdata" tables.

Verify Tables

Exporting these tables into CSV format is useful for reporting, backup, or integration with other systems.

The export process uses the "psql" command-line tool to extract the required data. Proper verification of table presence ensures that accurate information is exported and helps avoid errors during extraction.

Investigation

The following steps confirm the presence of the required tables in the database before proceeding with export operations:

Connect to the "caspidadb" Database:
```
psql -d caspidadb -U caspida
```
Verify the presence of hrdataaccounts and assetsdata tables in the database schema:
```
\dt hrdataaccounts
\dt assetsdata
```
Run the below command to exit the database:
```
\q
```

Resolution

The following steps outline the process to export the "hrdataaccounts" and "assetsdata" tables to CSV files and verify the exports:

Connect to the "caspidadb" Database:
```
psql -d caspidadb -U caspida
```
Export hrdataaccounts Table to CSV. This command exports the data to a file named hrdataaccounts.csv in the home directory of the current user:
```
\copy hrdataaccounts TO '~/hrdataaccounts.csv' CSV HEADER
```
Export assetsdata Table to CSV. This command exports the data to a file named assetsdata.csv in the home directory of the current user:
```
\copy assetsdata TO '~/assetsdata.csv' CSV HEADER
```
Verify the exported CSV files using the following command:
```
ls -lrt ~ | grep ".csv"
```
View the contents of assetsdata.csv:
```
cat assetsdata.csv
```
Run the following command to exit the database:
```
\q
```