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

[William H. ten Bensel]

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
GitHub - 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> 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
https://www.redhat.com/mailman/listinfo/spacewalk-listThis 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.
**
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20170224/d899fd37/attachment.htm>