Puppet users - Nov 2013 - how to exports facts from puppetdb

Hi,

How can i export all the facts for all the nodes from puppetdb in cvs/xls 
format.

My objective is to us Business Object or some other tool for creating my 
infrastructure reports.

Can someone help/redirect me to the right documentation?

Kaustubh

-- 
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/82854235-afb0-471f-ba9b-02589743369b%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

On Nov 21, 2013, at 8:53 PM, kaustubh chaudhari <kaustubh5@gmail.com>
wrote:
> Hi,
> 
> How can i export all the facts for all the nodes from puppetdb in cvs/xls
format.
> 
> My objective is to us Business Object or some other tool for creating my
infrastructure reports.
> 
> Can someone help/redirect me to the right documentation?
See the documentation here:

http://docs.puppetlabs.com/puppetdb/1.5/api/query/v3/facts.html

In a nutshell, you can do something like: curl http://localhost:8080/v3/facts

...that will return all the facts for all systems as a JSON object. You can take
that and then transform it to CSV using Perl/Python/Ruby/JS or any other
language or tool with JSON support.

Hope that helps,
deepak
> 
> Kaustubh
> 
> -- 
> 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+unsubscribe@googlegroups.com.
> To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/82854235-afb0-471f-ba9b-02589743369b%40googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
-- 
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/0E27E84A-D1D5-41C0-BD65-36525E21EE45%40puppetlabs.com.
For more options, visit https://groups.google.com/groups/opt_out.

Thanks Deepak,

I will try that!!!

On Thursday, November 21, 2013 10:53:20 PM UTC-5, kaustubh chaudhari
wrote:
>
> Hi,
>
> How can i export all the facts for all the nodes from puppetdb in cvs/xls 
> format.
>
> My objective is to us Business Object or some other tool for creating my 
> infrastructure reports.
>
> Can someone help/redirect me to the right documentation?
>
> Kaustubh
>
-- 
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/69cf99a8-ec2f-446f-b632-371a3f0c4240%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.