You using the API for this or querying the database? Querying the database is the way to insanity . . .
I did this for Satellite 5.x, but haven't looked at it for Katello/Satellite6 yet. Not sure if all the queries are in place yet. There was a ticket raised for querying the outstanding packages on a host based on the Errata that are in Library rather than the hosts own environment. This would allow you to see outstanding Errata as they come into Katello/Satellite before they're promoted through your environments. Have now been asked to look into this for work on our Satellite 6.2 install, so will share what I can. On Friday, 26 August 2016 14:22:01 UTC+1, Craig Elston wrote: > > Can anyone point me in the right direction? > > I am looking to query outstanding errata per host/content host/system > directly from the foreman database. I have a requirement to have weekly > reports sent to a team of engineers. > > I have been able to find most of the fields that I need, but the errata > per server is eluding me. > > Any help would be appreciated. > > Craig Elston > -- You received this message because you are subscribed to the Google Groups "Foreman users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/foreman-users. For more options, visit https://groups.google.com/d/optout.
