Have you been able to figure this out? I would be glad to help if needed. 
How are you determining which are the masters vs. clients? The first two in 
the list become masters or some other logic?

On Saturday, December 2, 2017 at 2:39:18 AM UTC-5, parwinderjit singh wrote:
>
> Hi Larry,
>
> Can you help me out. I am attaching one excel file and i want to make my 
> host file like below
>
> [cloudera_master]
> orion-RHEL-05        ansible_ssh_host=10.48.21.53  host_fqdn=orion-RHEL-05
> orion-RHEL-06        ansible_ssh_host=10.48.21.54  host_fqdn=orion-RHEL-06
>
> [cloudera_client]
> orion-RHEL-05        ansible_ssh_host=10.48.21.53  host_fqdn=orion-RHEL-05
> orion-RHEL-06        ansible_ssh_host=10.48.21.54  host_fqdn=orion-RHEL-06
> orion-RHEL-07        ansible_ssh_host=10.48.21.55  host_fqdn=orion-RHEL-07
> orion-RHEL-08        ansible_ssh_host=10.48.21.56  host_fqdn=orion-RHEL-08
> orion-RHEL-09        ansible_ssh_host=10.48.21.57  host_fqdn=orion-RHEL-09
>
> regards
> parwinder
>
>
> On Sat, Dec 2, 2017 at 10:56 AM, Larry Smith <[email protected] 
> <javascript:>> wrote:
>
>> Not sure if you figured this out yet or not. But thought I would share 
>> with you how I was able to do this and it works really well. I do not use 
>> the CSV lookup as it didn't seem to work how I needed it to (or I just 
>> couldn't make it work) so I just used the file lookup.
>>
>>
>> https://everythingshouldbevirtual.com/automation/ansible-parsing-csv-list-hosts-ip-hostnames-mac/
>>
>>
>> On Wednesday, November 22, 2017 at 8:52:00 PM UTC-5, parwinderjit singh 
>> wrote:
>>>
>>> Hi All,
>>>
>>>
>>> I have a excel sheet which contain 1000 server hostname  with there IP 
>>> address. I have to create a ansible host file from that sheet. My question 
>>> is, is there a east way to create a ansible host file or i have to manually 
>>> create hostfile for all 100 server ?
>>>
>>>
>>> Thanks & Regards,
>>>
>>> -- 
>> You received this message because you are subscribed to a topic in the 
>> Google Groups "Ansible Project" group.
>> To unsubscribe from this topic, visit 
>> https://groups.google.com/d/topic/ansible-project/YzQCV3D5ZM4/unsubscribe
>> .
>> To unsubscribe from this group and all its topics, send an email to 
>> [email protected] <javascript:>.
>> To post to this group, send email to [email protected] 
>> <javascript:>.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/ansible-project/d370377e-6f7b-4b5a-8728-1a821f2f7cdd%40googlegroups.com
>>  
>> <https://groups.google.com/d/msgid/ansible-project/d370377e-6f7b-4b5a-8728-1a821f2f7cdd%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 
"Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ansible-project/775cf08b-c6fd-4554-b678-90094c8ed330%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to