1 Reply Latest reply on Sep 6, 2013 11:14 AM by prakashraj

    Need a script to produce report of our cluster environment to Excel -please help...

    MikeRScot Lurker

      hey guys,

      I need to run an automated script which will export the information about cluster, hosts, vms and data stores into Excel/CSV

       

      What Id like is something like

       

      Set path to save document to required location

      Create Excel workbook with todays date

      Create Hosts Information worksheet

      Create Datastore Information worksheet

      Create VM Information worksheet

          

      For each cluster in clusters$

           For each host in hosts$             
                Add hosts information to Hosts worksheet including (name, version, cpus, cores, memory, cluster)

                Add datastore data to Datastore information worksheet  (name, type, total size GB, freespace GB, freespace %)

           Next

                    
           For each VM in vm$

                Add VM data to VM Information worksheet  (name, cpu, memory, power, description, tools ver, cluster)

           Next

      Next

       

      Save all info to excel.

       

      Sorry how rough this is but am very flaky on dev/scripting knowledge. I hope someone can assist or has a script already produced.

       

      Cheers,

      Mike