Executing Microsoft PowerShell Scripts that use the VMware PowerCLI Snap-In via C# and Microsoft .NET

        void Execute_vCenter_Tasks(string vCenterIp, string vCenterUsername, string vCenterPassword)

        {             

                var shell = PowerShell.Create();

//The variable above instantiates a PowerShell object that you can add   

//scripts to

                //Add the VMware plugin to issue PowerCli commands

                //Each command should end with a semi-colon as this instructs PowerShell

                //to issue a new line.

                //Lastly, the System.Environment.NewLine equates to the carriage return

                string PsCmd = "add-pssnapin VMware.VimAutomation.Core; $vCenterServer = '" + vCenterIp + "';$vCenterAdmin = '" + vCenterUsername + "' ;$vCenterPassword = '" + vCenterPassword + "';" + System.Environment.NewLine;

                //The next line issues the connection string.

                PsCmd = PsCmd + "$VIServer = Connect-VIServer -Server $vCenterServer -User $vCenterAdmin -Password $vCenterPassword;" + System.Environment.NewLine;

                //Query and obtain a list of hypervisors

                PsCmd = PsCmd + "$VMHosts = (Get-VMHost | select Name );" + System.Environment.NewLine;

                //Establish an index for the array. Use the number of Hypervisors

                PsCmd = PsCmd + "$hostIndex = $VMHosts.Count;" + System.Environment.NewLine;

                //Write the output to a variable

                PsCmd = PsCmd + "for ($i=0; $i -le $hostIndex - 1; $i++){ Write-Output $VMHosts[$i].Name}";

                //Add the script and execute it.

                shell.Commands.AddScript(PsCmd);

                var results = shell.Invoke();

                //Parse the results and store the output into XML.

                if (results.Count > 0)

                {

                    var builder = new StringBuilder();

                    DataSet ds = new DataSet();

                    DataTable dt = new DataTable();

                    dt.Columns.Add("name");

                    dt.Columns.Add("hyperIP");

                    dt.Columns.Add("hyperUser");

                    dt.Columns.Add("hyperPassword");

                    dt.Columns.Add("idracUser");

                    dt.Columns.Add("idracPassword");

                    dt.Columns.Add("idracIp");

                    ds.Tables.Add(dt);

                    foreach (var psObject in results)

                    {

                        //Query the hypervisor name’s and grab the IP addresss

                        IPAddress[] ipList = System.Net.Dns.GetHostAddresses(psObject.ToString());

                        foreach (IPAddress ip in ipList)

                        {

                        //Add the data into a datarow and insert it into the structure

                            DataRow dr = ds.Tables[0].NewRow();

                            dr[0] = psObject;

                            dr[1] = ip;

                            dr[2] = "";

                            dr[3] = "";

                            dr[4] = "";

                            dr[5] = "";

                            dr[6 ] = "";

                            ds.Tables[0].Rows.Add(dr);

                        }

                    }

                    ds.AcceptChanges();

                    ds.WriteXml(Server.MapPath("hypervisors.xml"));

                    //Write the XML file and close it out

                    //The bottom function then populates the data into the datagrid

binddata();

                }       

        }

<?xml version="1.0" standalone="yes"?>

<vCheckSettings>

  <Host>

    <name>esx1.v50a.vse.lab</name>

    <hyperIP>172.162.27.101</hyperIP>

    <hyperUser>root</hyperUser>

    <hyperPassword>password+123</hyperPassword>

    <idracUser>root</idracUser>

    <idracPassword>calvin</idracPassword>

    <idracIp>172.10.27.101</idracIp>

  </Host>

 <Host>

    <name>esx2.v50a.vse.lab</name>

    <hyperIP>172.162.27.102</hyperIP>

    <hyperUser>root</hyperUser>

    <hyperPassword>password+123</hyperPassword>

    <idracUser>root</idracUser>

    <idracPassword>calvin</idracPassword>

    <idracIp>172.10.27.102</idracIp>

  </Host>

</vCheckSettings>