paepcke.de/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)

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

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

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

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

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

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

pkg.go.dev/paepcke.de/uniex

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

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

Yes, Please! PRs Welcome!