$VMHostFQDNs = @(
    'itdvmmdntest07.nd.gov'
)

foreach ($VMHostFQDN in $VMHostFQDNs) {
    $VMHostName = $VMHostFQDN.Split('.')[0]
    #$CmdbCi = Get-ITDServiceNowRecord -Table cmdb_ci_server -Filter "name=$VMHostName"

    $NewITDServiceNowChangeRequestParams = @{
        RequestedByUsername       = 'zmeier';
        #ConfigurationItemSysId    = $CmdbCi.sys_id;
        Category                  = 'Systems Platforms - Systems';
        Subcategory               = 'VMware';
        Impact                    = 2;
        Priority                  = 2;
        ShortDescription          = "Upgrade $VMHostFQDN to vSphere 8.0 U3f, installing prerequisite firmware updates HPE Synergy 2025.05.01";
        Description               = "Upgrade $VMHostFQDN to vSphere 8.0 U3f, remediation for VMSA-2025-0013";
        Justification             = "Firmware updates. Security updates. Bug fixes.";
        Implementation            = "Evacuate all VMs from $VMHostFQDN.  Install new firmware version 2025.05.01.  Upgrade vSphere to 8.0 U3f.  Apply VMware Host Profiles";
        RiskImpactAnalysis        = "Low, Running virtual machines will be evacuated before update process begins.";
        BackoutPlan               = "If the upgrade fails, revert to previous firmware version and vSphere version through manual process.";
        TestPlan                  = "Sandbox environment has been tested with this upgrade.  No issues were found.";
        WhoIsImpacted             = "";
        StartTime                 = (Get-Date -Year 2025 -Month 11 -Day 7)
        EndTime                   = (Get-Date -Year 2025 -Month 11 -Day 7).AddHours(8);
        AssignmentGroup           = 'NDIT-Computer Systems Windows';
        ChangeManagerUsername     = 'khellman';
        ChangeCoordinatorUsername = 'mlaverdure';
        AssignedToUsername        = 'zmeier';
    }

    $CHG = New-ITDServiceNowChangeRequest @NewITDServiceNowChangeRequestParams
}