<div dir="ltr">William is right, this will get you what you need. :)<div> </div><div>You'll also need php and php-pgsql packages installed, assuming it's a RHEL/CentOS system you'll be putting this on. </div></div> <div class="gmail_quote"><div dir="ltr">On Fri, Feb 24, 2017 at 1:53 PM William H. ten Bensel <<a href="mailto:WHTENBEN@up.com">WHTENBEN@up.com</a>> wrote: </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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 <<a href="mailto:darylrose@outlook.com" class="gmail_msg" target="_blank">darylrose@outlook.com</a>> To: "<a href="mailto:spacewalk-list@redhat.com" class="gmail_msg" target="_blank">spacewalk-list@redhat.com</a>" <<a href="mailto:spacewalk-list@redhat.com" class="gmail_msg" target="_blank">spacewalk-list@redhat.com</a>> Date: 02/24/2017 12:44 PM Subject: Re: [Spacewalk-list] How to tell what Errata has been applied Sent by: <a href="mailto:spacewalk-list-bounces@redhat.com" class="gmail_msg" target="_blank">spacewalk-list-bounces@redhat.com</a> <hr noshade class="gmail_msg"> This email originated from outside of the company. Please use discretion if opening attachments or clicking on links.<hr class="gmail_msg"> 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<hr class="gmail_msg"> From: <a href="mailto:spacewalk-list-bounces@redhat.com" class="gmail_msg" target="_blank">spacewalk-list-bounces@redhat.com</a> <<a href="mailto:spacewalk-list-bounces@redhat.com" class="gmail_msg" target="_blank">spacewalk-list-bounces@redhat.com</a>> on behalf of Matt Moldvan <<a href="mailto:matt@moldvan.com" class="gmail_msg" target="_blank">matt@moldvan.com</a>> Sent: Friday, February 24, 2017 10:08 AM To: <a href="mailto:spacewalk-list@redhat.com" class="gmail_msg" target="_blank">spacewalk-list@redhat.com</a> 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... <a href="https://github.com/sandwormusmc/spacewalk-php-reports" class="gmail_msg" target="_blank">https://github.com/sandwormusmc/spacewalk-php-reports</a><table width="100%" style="border-collapse:collapse" class="gmail_msg"><tr valign="top" height="8" class="gmail_msg"><td width="100%" bgcolor="white" style="border-style:solid none solid none;border-color:#c8c8c8;border-width:1px 0px 1px 0px;padding:1px 1px" class="gmail_msg"><a href="https://github.com/sandwormusmc/spacewalk-php-reports" class="gmail_msg" target="_blank">GitHub - sandwormusmc/spacewalk-php-reports</a> <a href="http://github.com" class="gmail_msg" target="_blank">github.com</a> Contribute to spacewalk-php-reports development by creating an account on GitHub.</td></tr></table> Feedback welcome. :D On Tue, Feb 21, 2017 at 10:11 AM Daryl Rose <<a href="mailto:darylrose@outlook.com" class="gmail_msg" target="_blank">darylrose@outlook.com</a>> 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 <a href="mailto:Spacewalk-list@redhat.com" class="gmail_msg" target="_blank">Spacewalk-list@redhat.com</a> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" class="gmail_msg" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><tt class="gmail_msg">This email originated from outside of the company. Please use discretion if opening attachments or clicking on links.</tt><tt class="gmail_msg"> _______________________________________________ Spacewalk-list mailing list <a href="mailto:Spacewalk-list@redhat.com" class="gmail_msg" target="_blank">Spacewalk-list@redhat.com</a> </tt><tt class="gmail_msg"></tt><a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" class="gmail_msg" target="_blank"><tt class="gmail_msg">https://www.redhat.com/mailman/listinfo/spacewalk-list</tt></a> ** 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 <a href="mailto:Spacewalk-list@redhat.com" class="gmail_msg" target="_blank">Spacewalk-list@redhat.com</a> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" rel="noreferrer" class="gmail_msg" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a></blockquote></div>