[Spacewalk-list] db querying

[Michael Mraka]

gian sisal:
> Hi everyone,
> I'm trying to extract data from spacewalk db, I'm not sure I'm doing it
> correctly, I've even searched for information on forums and found just two
> ways to query it (spacewalk-report and spacecmd).

Hello,

Spacecmd calls spacewalk API and can be used to extract the same
information you can find in spacewalk's webUI.

Spacewalk-report contains set of predefined reports and runs that
reports directly against spacewalk database.

You can also use spacewalk-sql which is just a wrapper around psql
(with proper credentials from rhn.conf).

> I would like to connect to my spacewalk db via GUI, can somebody tell me
> all the references and schemas eventually available and what is the best
> way to access it?

And of course you can use some graphical tool like pgAdmin to connect
directly to the database. Use login/password from rhn.conf.

Just make sure you know what you are doing and not corrupt your data.

> Thanks in advance.
> Best Regards.
> Gianfrancesco

Regards,

--
Michael Mráka
Smart Management Engineering, Red Hat