OVERVIEW

paepcke.de/uniex

UNIEX

• Exports UNIFI Controller Inventory Database (mongoDB) to [csv|json]
• Adds missing attributes (latest used hostname, latest used ip, latest seen, ...) via parsing all device and stat records
• Converts Timestamps (eg. unix nano time) into RFC3339 (parseable by excel, human readable) format
• Fast, even for large corp inventory (in-memory, parallel processing)

SCREENSHOT CLI

⚡️QUICK START

go run paepcke.de/uniex/cmd/uniex@main

⚡️PRETTY PRINT CSV OUTPUT VIA BAT

go run paepcke.de/uniex/cmd/uniex@main | bat -l csv

⚡️PRETTY PRINT JSON OUTPUT VIA JQ

UNIEX_FORMAT=json go run paepcke.de/uniex/cmd/uniex@main | jq

⚡️HOW TO INSTALL

go install paepcke.de/uniex/cmd/uniex@main

⚡️PRE-BUILD BINARIES (DOWNLOAD)

https://github.com/paepckehh/uniex/releases

SUPPORTED OPTIONS

# Optional (via env variables)
- UNIEX_MONGODB   - mongodb uri, default: mongodb://127.0.0.1:27117
- UNIEX_FORMAT    - export format, default: csv [csv|json]

DOCS

pkg.go.dev/paepcke.de/uniex

🛡 License

This project is licensed under the terms of the BSD 3-Clause License license. See LICENSE for more details.

📃 Citation

@misc{uniex,
  author = {Michael Paepcke},
  title = {Export UNIFI MongoDB Inventory Database},
  year = {2024},
  publisher = {GitHub},
  journal = {GitHub repository},
  howpublished = {\url{https://paepcke.de/uniex}}
}

CONTRIBUTION

Yes, Please! PRs Welcome!