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.

Reply via email to