[Spacewalk-list] How to tell what Errata has been applied

[Matt Moldvan]

William is right, this will get you what you need.  :)

You'll also need php and php-pgsql packages installed, assuming it's a
RHEL/CentOS system you'll be putting this on.

On Fri, Feb 24, 2017 at 1:53 PM William H. ten Bensel <WHTENBEN at up.com>
wrote:

> I believe the User and password are stored in the rhn.conf
>
> awk -F= '/db_[user|password]/ {print $2}' /etc/rhn/rhn.conf
>
> - Thanks and good luck
>
>
>
> From:        Daryl Rose <darylrose at outlook.com>
> To:        "spacewalk-list at redhat.com" <spacewalk-list at redhat.com>
> Date:        02/24/2017 12:44 PM
>
>
> Subject:        Re: [Spacewalk-list] How to tell what Errata has been
> applied
>
> Sent by:        spacewalk-list-bounces at redhat.com
> ------------------------------
>
>
>
> This email originated from outside of the company. Please use discretion
> if opening attachments or clicking on links.
> ------------------------------
>
>
> Matt,
>
> Thank you very much for this tool.  I'll give it a try, however, I'm not
> sure what the postgres db user and password is.  I don't remember what I
> set those to when I installed SW.
>
> Is there a way for me to pull that information from the database?
>
> Thanks
>
> Daryl
>
> ------------------------------
>
> *From:* spacewalk-list-bounces at redhat.com <
> spacewalk-list-bounces at redhat.com> on behalf of Matt Moldvan <
> matt at moldvan.com>
> *Sent:* Friday, February 24, 2017 10:08 AM
> *To:* spacewalk-list at redhat.com
> *Subject:* Re: [Spacewalk-list] How to tell what Errata has been applied
>
> I hacked together some PHP which connects directly to the Postgres
> database and provides some "pretty" reports to operations folks and anyone
> else that wanted to see what we'd done (Information Security/Compliance/App
> teams/etc).
>
> I just took a few minutes to sanitize it and upload it to GitHub, if
> you're interested.  It's not overly pretty, but it works for our needs...
>
> *https://github.com/sandwormusmc/spacewalk-php-reports*
> <https://github.com/sandwormusmc/spacewalk-php-reports>
> GitHub - sandwormusmc/spacewalk-php-reports
> <https://github.com/sandwormusmc/spacewalk-php-reports>
> github.com
> Contribute to spacewalk-php-reports development by creating an account on
> GitHub.
>
>
> Feedback welcome.  :D
>
> On Tue, Feb 21, 2017 at 10:11 AM Daryl Rose <*darylrose at outlook.com*
> <darylrose at outlook.com>> wrote:
> Is there a way to list what errata has already been applied to a machine?
> I can list what is available, but I need to know what has been applied.
>
> Thank you.
>
> Daryl
> _______________________________________________
> Spacewalk-list mailing list
> *Spacewalk-list at redhat.com* <Spacewalk-list at redhat.com>
>
> *https://www.redhat.com/mailman/listinfo/spacewalk-list*
> <https://www.redhat.com/mailman/listinfo/spacewalk-list>This email
> originated from outside of the company.  Please use discretion if opening
> attachments or clicking on links.
>
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
>
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
>
> **
>
>
>
> This email and any attachments may contain information that is
> confidential and/or privileged for the sole use of the intended recipient.
> Any use, review, disclosure, copying, distribution or reliance by others,
> and any forwarding of this email or its contents, without the express
> permission of the sender is strictly prohibited by law. If you are not the
> intended recipient, please contact the sender immediately, delete the
> e-mail and destroy all copies.
>
> **
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20170224/48be400c/attachment.htm>