objectnotes components

[zaji_nms]

Dear Expert,

I have concerned about xi-components called objectnotes backup, we have installed and using it in our production server and keeping all notes info in this component , but we would like to know where this notes information being stored and how do we take the backup for the same ? appreciate your quick reply.

thanks and regards,

[rajasegar]

I have asked this question before.
It is stored in the Postgresql DB

echo 'select * from xi_options;' | psql nagiosxi nagiosxi | grep objectnotes

Your notes will be truncated if it has line feed. So modify the sql statement to strip off the \r.

[tmcdonald]

Thank you raja, that's a good command to have around.

zaji, did this work out for you? As far as backups, those wouldn't be included in a snapshot the way notes from the CCM would be, but a full backup should include them as part of the Postgres dump.

[zaji_nms]

Good info. Thanks Raja and Donald for the help.