puppetdb - getting a list of specific facts for specific hosts?

[Klavs Klavsen]

I'm trying to query puppetdb for a list of hosts maching a certain regex (on hostname) and only returns 2 facts (ipaddress and hostname)

I'm trying to follow:
http://docs.puppetlabs.com/puppetdb/latest/api/query/tutorial.html

and I'm not even quite sure, wether or not, I should use a facts or a nodes, or a resources query ?

I get some of the queries to return just fine.. f.ex. I can query on nodes:
curl -X GET -H 'Accept: application/json' http://localhost:8080/v2/nodes --data-urlencode 'query=["~", ["fact", "hostname"], "webserver"]'

But I can't figure out how I can make that query, return 1 extra fact (ipaddress).. ?

[Klavs Klavsen]

I also tried https://github.com/dalen/puppet-puppetdbquery - but that didn't really get me any closer :(

[Klavs Klavsen]

This gives me the ipaddress (and hostname).. now to figure out how to filter on hostname regex..

'query=["=", "name", "ipaddress"]'

[Ken Barber]

Is it acceptable to do the search based on 'certname'? ie:

curl -G 'http://localhost:8080/v2/facts' --data-urlencode
'query=["and",["~","certname","puppetdb?"],["or",["=","name","ipaddress"],["=","name","hostname"]]]'

ken.

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

[Klavs Klavsen]

Den tirsdag den 3. september 2013 20.09.19 UTC+2 skrev Ken Barber:

Is it acceptable to do the search based on 'certname'? ie:

curl -G 'http://localhost:8080/v2/facts' --data-urlencode
'query=["and",["~","certname","puppetdb?"],["or",["=","name","ipaddress"],["=","name","hostname"]]]'

 Thank you - that worked beautifully :)

Only "detail" - is that it shows 2 results for each host - one for each fact being retrieved.

[robert keating]

Can you help with this query?  I am trying to get 2 facts from all of our puppet clients in PuppetDB.  

I tried variations of the following, but no luck: ('["or", ["=", "name", "kernelversion"], ["=", "name", "instance_uuid"]]')

Thank you!

[Ken Barber]

> Can you help with this query? I am trying to get 2 facts from all of our
> puppet clients in PuppetDB.
> I tried variations of the following, but no luck: ('["or", ["=", "name",
> "kernelversion"], ["=", "name", "instance_uuid"]]')

For me this query works. Here is the full curl example in the latest
PDB (I replaced instance_uuid with operatingsystem, since I don't have
that fact and I wanted to show it working with _something_):

# curl -G 'http://localhost:8080/pdb/query/v4/facts' --data-urlencode
'query=["or",["=","name","kernelversion"],["=","name","operatingsystem"]]'
[ {
"certname" : "kb.local",
"environment" : "production",
"name" : "operatingsystem",
"value" : "Darwin"
}, {
"certname" : "kb.local",
"environment" : "production",
"name" : "kernelversion",
"value" : "14.4.0"
} ]%

ken.