Thank you very much for the great explanation. :)
On Thursday, February 15, 2018 at 3:07:34 PM UTC-8, Nick Lewis wrote: > > On Thu, Feb 15, 2018 at 2:11 PM John Bishop <[email protected] > <javascript:>> wrote: > >> Hello, >> >> I'm new to using PQL and i'm having a bit of difficulty. I'm trying >> to return the ipaddress of any node where the value of three trusted facts >> (pp_application, pp_role and pp_environment) meets some criteria. >> >> I have a query which will return only the nodes that i care about, but >> I'm having a problem structuring the query to also return the top level >> ipaddress fact with the results. Any help would be appreciated. Thank >> you. >> >> $test_query = '["from", "facts", >> ["and", >> ["subquery", "fact_contents", >> ["and", >> ["~>", "path", ["trusted", "extensions", >> "pp_application"]], >> ["=", "value", "someapp"]]], >> ["subquery", "fact_contents", >> ["and", >> ["~>", "path", ["trusted", "extensions", "pp_role"]], >> ["=", "value", "appserver"]]], >> ["subquery", "fact_contents", >> ["and", >> ["~>", "path", ["trusted", "extensions", >> "pp_environment"]], >> ["=", "value", "development"]]]]]]' >> >> > In PuppetDB, a "fact" is an entry with [certname, environment, name, > value]. A subquery between "facts" and "fact_contents" means "find facts > whose value matches this fact_contents query". In this case, that will > return the "trusted" fact. You then want to lookup the corresponding > "ipaddress" fact for matching nodes. Since you're really looking up the > value of one fact using a query based on another fact, you want to use your > existing query as a fact subquery. > > ["from", "facts", > ["and", > ["=", "name", "ipaddress"], > ["subquery", "facts", > ["and", > ["subquery", "fact_contents", > ["and", > ["~>", "path", ["trusted", "extensions", "pp_application"]], > ["=", "value", "someapp"]]], > ["subquery", "fact_contents", > ["and", > ["~>", "path", ["trusted", "extensions", "pp_role"]], > ["=", "value", "appserver"]]], > ["subquery", "fact_contents", > ["and", > ["~>", "path", ["trusted", "extensions", "pp_environment"]], > ["=", "value", "development"]]]]]]] > > > The facts subquery will restrict the outer facts query to return facts > only for nodes that match the subquery. > > However, there's a more straightforward way to achieve this using PQL > <https://puppet.com/docs/puppetdb/5.1/api/query/v4/pql.html> rather than > the AST query language > <https://puppet.com/docs/puppetdb/5.1/api/query/v4/ast.html> you're using. > > facts[certname, value] { > name = "ipaddress" and > certname in inventory[certname] { > trusted.extensions.pp_application = 'someapp' and > trusted.extensions.pp_role = 'appserver' and > trusted.extensions.pp_environment = 'development' > } > } > > > This query uses the inventory entity to find nodes with the three specific > trusted extensions, and then looks up the ipaddress fact for each of those > nodes and returns the node name and the value of the ipaddress fact. > > I don't have an environment available with those particular trusted > extensions in use, so I can't verify it's 100% correct, but it should at > least be on the right track. > > $test_results = puppetdb_query($test_query) >> >> Notify { '*** query results ***\r': >> message => "data: ${test_results}", >> } >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Puppet Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/puppet-users/89e396e9-e4f0-44b1-bc71-efaf99829556%40googlegroups.com >> >> <https://groups.google.com/d/msgid/puppet-users/89e396e9-e4f0-44b1-bc71-efaf99829556%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> For more options, visit https://groups.google.com/d/optout. >> > -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/8c1ea67b-bc17-4a1c-8418-98c58f4c68fc%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
