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 foreman-users+unsubscr...@googlegroups.com. To post to this group, send email to foreman-users@googlegroups.com. Visit this group at https://groups.google.com/group/foreman-users. For more options, visit https://groups.google.com/d/optout.
