<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style type="text/css" style="display:none;"></style> </head> <body dir="ltr"> <div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr"> <p>Matt,</p> <p><br> </p> <p>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.</p> <p><br> </p> <p>Is there a way for me to pull that information from the database?</p> <p><br> </p> <p>Thanks</p> <p><br> </p> <p>Daryl</p> <div style="color: rgb(0, 0, 0);"> <hr tabindex="-1" style="display:inline-block; width:98%"> <div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> spacewalk-list-bounces@redhat.com <spacewalk-list-bounces@redhat.com> on behalf of Matt Moldvan <matt@moldvan.com><br> <b>Sent:</b> Friday, February 24, 2017 10:08 AM<br> <b>To:</b> spacewalk-list@redhat.com<br> <b>Subject:</b> Re: [Spacewalk-list] How to tell what Errata has been applied</font> <div> </div> </div> <div> <div dir="ltr"> <div dir="ltr" class="gmail_msg">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).</div> <div dir="ltr" class="gmail_msg"><br> </div> <div dir="ltr" class="gmail_msg">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...</div> <div dir="ltr" class="gmail_msg"><br> </div> <div dir="ltr" class="gmail_msg"><a href="https://github.com/sandwormusmc/spacewalk-php-reports" id="LPlnk676706" previewremoved="true">https://github.com/sandwormusmc/spacewalk-php-reports</a></div> <div id="LPBorder_GT_14879567021490.5669646951277965" style="margin-bottom: 20px; overflow: auto; width: 100%; text-indent: 0px;"> <table id="LPContainer_14879567021470.9957877018345223" cellspacing="0" style="width: 90%; background-color: rgb(255, 255, 255); position: relative; overflow: auto; padding-top: 20px; padding-bottom: 20px; margin-top: 20px; border-top: 1px dotted rgb(200, 200, 200); border-bottom: 1px dotted rgb(200, 200, 200);"> <tbody> <tr valign="top" style="border-spacing: 0px;"> <td id="TextCell_14879567021480.8565725634926888" colspan="2" style="vertical-align: top; position: relative; padding: 0px; display: table-cell;"> <div id="LPRemovePreviewContainer_14879567021480.8701104826660229"></div> <div id="LPTitle_14879567021480.5617633409631297" style="top: 0px; color: rgb(0, 120, 215); font-weight: normal; font-size: 21px; font-family: wf_segoe-ui_light, "Segoe UI Light", "Segoe WP Light", "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; line-height: 21px;"> <a id="LPUrlAnchor_14879567021480.11436973223818181" href="https://github.com/sandwormusmc/spacewalk-php-reports" target="_blank" style="text-decoration: none;">GitHub - sandwormusmc/spacewalk-php-reports</a></div> <div id="LPMetadata_14879567021480.7272997574818023" style="margin: 10px 0px 16px; color: rgb(102, 102, 102); font-weight: normal; font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 14px; line-height: 14px;"> github.com</div> <div id="LPDescription_14879567021490.8282395185536247" style="display: block; color: rgb(102, 102, 102); font-weight: normal; font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 14px; line-height: 20px; max-height: 100px; overflow: hidden;"> Contribute to spacewalk-php-reports development by creating an account on GitHub.</div> </td> </tr> </tbody> </table> </div> <br> <div dir="ltr" class="gmail_msg"><br> </div> <div dir="ltr" class="gmail_msg">Feedback welcome. :D<br class="gmail_msg"> <br class="gmail_msg"> <div class="gmail_quote gmail_msg"> <div dir="ltr" class="gmail_msg">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:<br class="gmail_msg"> </div> <blockquote class="gmail_quote gmail_msg" style="margin:0 0 0 .8ex; border-left:1px #ccc solid; padding-left:1ex"> <div dir="ltr" class="gmail_msg"> <div id="m_3098399695965309676m_-4885158118481294064divtagdefaultwrapper" dir="ltr" class="gmail_msg" style="font-size:12pt; color:#000000; font-family:Calibri,Arial,Helvetica,sans-serif"> <p class="gmail_msg">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.</p> <p class="gmail_msg"><br class="gmail_msg"> </p> <p class="gmail_msg">Thank you.</p> <p class="gmail_msg"><br class="gmail_msg"> </p> <p class="gmail_msg">Daryl</p> </div> </div> _______________________________________________<br class="gmail_msg"> Spacewalk-list mailing list<br class="gmail_msg"> <a href="mailto:Spacewalk-list@redhat.com" class="gmail_msg" target="_blank">Spacewalk-list@redhat.com</a><br class="gmail_msg"> <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> </div> </div> </div> </div> </div> </body> </html>