if
(
    exists wmi "root\DELLOMCI"
)
then
(
    item 1 of
    (
        1, "Other"; 2, "Unknown"; 3, "OK"; 4, "Non-critical"; 5, "Critical"; 6, "Non-recoverable"
    )
    whose
    (
        exists
        (
            item 0 of it,
            (
                integer value of selects "GlobalStatus from Dell_Configuration" of wmi "root\DELLOMCI"
            )            
        )
        whose
        (
            item 0 of it is item 1 of it
        )        
    )    
)
else
(
    items 1 of
    (
        0,"Unknown";5,"OK";10,"Degraded/Warning";15,"Minor failure";20,"Major failure";25,"Critical failure";30,"Non-recoverable error"
    )
    whose
    (
        exists
        (
            item 0 of it,
            (
                integer values of selects "HealthState from DCIM_ComputerSystem" of wmi "root/dcim/sysman"
            )            
        )
        whose
        (
            item 0 of it is item 1 of it
        )        
    )    
)

if
(
    exists wmi "root\DELLOMCI"
)
then
(    
    (
        if it = "1" then "Other" else if it = "2" then "Unsupported" else if
        (
            it = "3"
        )
        then "Locked" else if it="4" then "Unlocked" else "n/a"
    )
    of
    (
        string values of selects "PasswordStatusLockUnlock from Dell_Configuration" of wmi "root\DELLOMCI"
    )    
)
else
(    
    (
        items 1 of items 0 of it
    )
    of
    (
        items 0 of it, items 1 of it, items 2 of it
    )
    whose
    (
        item 0 of item 0 of it as integer = item 2 of it as integer
    )
    of
    (        
        (            
            (
                string values 0 of item 0 of it, string values 0 of item 1 of it
            )
            ;
            (
                string values 1 of item 0 of it, string values 1 of item 1 of it
            )
            ;
            (
                string values 2 of item 0 of it, string values 2 of item 1 of it
            )
            ;
            (
                string values 3 of item 0 of it, string values 3 of item 1 of it
            )
            ;
            (
                string values 4 of item 0 of it, string values 4 of item 1 of it
            )
            ;
            (
                string values 5 of item 0 of it, string values 5 of item 1 of it
            )
            ;
            (
                string values 6 of item 0 of it, string values 6 of item 1 of it
            )
            ;
            (
                string values 7 of item 0 of it, string values 7 of item 1 of it
            )            
        )
        , string values of item 2 of it, string values 0 of item 3 of it
    )
    of
    (
        properties "PossibleValues" of it, properties "PossibleValuesDescription" of it, properties "AttributeName" of it, properties "CurrentValue" of it
    )
    of select objects "AttributeName, CurrentValue, PossibleValues, PossibleValuesDescription from dcim_BIOSEnumeration where AttributeName='Password Status Lock'" of wmi "root/dcim/sysman"
)

if
(
    exists wmi "root\DELLOMCI"
)
then
(    
    (
        if it = "1" then "Other" else if it = "2" then "Unsupported" else if it = "3" then "Detected" else if it="4" then "Not Detected" else if it = "5" then "Clear" else "n/a"
    )
    of
    (
        string values of selects "ChassisIntrusionStatus from Dell_SMBIOSsettings" of wmi "root\DELLOMCI"
    )    
)
else
(    
    (
        items 1 of items 0 of it
    )
    of
    (
        items 0 of it, items 1 of it, items 2 of it
    )
    whose
    (
        item 0 of item 0 of it as integer = item 2 of it as integer
    )
    of
    (        
        (            
            (
                string values 0 of item 0 of it, string values 0 of item 1 of it
            )
            ;
            (
                string values 1 of item 0 of it, string values 1 of item 1 of it
            )
            ;
            (
                string values 2 of item 0 of it, string values 2 of item 1 of it
            )
            ;
            (
                string values 3 of item 0 of it, string values 3 of item 1 of it
            )
            ;
            (
                string values 4 of item 0 of it, string values 4 of item 1 of it
            )
            ;
            (
                string values 5 of item 0 of it, string values 5 of item 1 of it
            )
            ;
            (
                string values 6 of item 0 of it, string values 6 of item 1 of it
            )
            ;
            (
                string values 7 of item 0 of it, string values 7 of item 1 of it
            )            
        )
        , string values of item 2 of it, string values 0 of item 3 of it
    )
    of
    (
        properties "PossibleValues" of it, properties "PossibleValuesDescription" of it, properties "AttributeName" of it, properties "CurrentValue" of it
    )
    of select objects "AttributeName, CurrentValue, PossibleValues, PossibleValuesDescription from dcim_BIOSEnumeration where AttributeName='Chassis Intrusion Status'" of wmi "root/dcim/sysman"
)

if
(
    exists wmi "root\DellOMCI"
)
then
(    
    (        
        (
            string value of Property "BuildNumber" of it
        )
        & " (Build Date: " &
        (
            date
            (
                "est" as time zone
            )
            of time value of property "ReleaseDate" of it
        )
        as string & ")"
    )
    of
    (
        select object "BuildNumber, ReleaseDate from Dell_BIOSElement" of wmi "root\DELLOMCI"
    )    
)
else
(    
    (        
        (
            string value of Property "Version" of it
        )
        & " (Build Date: " &
        (
            date
            (
                "est" as time zone
            )
            of time value of property "ReleaseDate" of it
        )
        as string & ")"
    )
    of
    (
        select object "Version, ReleaseDate from DCIM_BIOSElement" of wmi "root\dcim\sysman"
    )    
)

item 1 of
(
    1, "Other"; 2, "Unknown"; 3, "Desktop"; 4, "Low Profile Desktop"; 5, "Pizza Box"; 6, "Mini Tower"; 7, "Tower"; 8, "Portable"; 9, "Laptop"; 10, "Notebook"; 11, "Handheld"; 12, "Docking Station"; 13, "All in One"; 14, "Sub Notebook"; 15, "Space-Saving"; 16, "Lunch Box"; 17, "Main System Chassis"; 18, "Expansion Chassis"; 19, "SubChassis"; 20, "Bus Expansion Chassis"; 21, "Peripheral Chassis"; 22, "Storage Chassis"; 23, "Rack Mount Chassis"; 24, "Sealed-Case PC"
)
whose
(
    exists
    (
        item 0 of it,
        (
            if
            (
                exists wmi "root\DELLOMCI"
            )
            then
            (
                integer value of selects "ChassisTypes from Dell_Chassis" of wmi "root\DELLOMCI"
            )
            else
            (
                integer values of selects "ChassisPackageType from DCIM_Chassis" of wmi "root/dcim/sysman"
            )            
        )        
    )
    whose
    (
        item 0 of it is item 1 of it
    )    
)

if
(
    exists wmi "root\DELLOMCI"
)
then
(
    item 1 of
    (
        1, "Other"; 2, "Unsupported"; 3, "Off"; 4, "Last"; 5, "On"
    )
    whose
    (
        exists
        (
            item 0 of it,
            (
                integer value of selects "ACPowerRecoveryMode from Dell_Configuration" of wmi "root\DELLOMCI"
            )            
        )
        whose
        (
            item 0 of it is item 1 of it
        )        
    )    
)
else
(    
    (
        items 1 of items 0 of it
    )
    of
    (
        items 0 of it, items 1 of it, items 2 of it
    )
    whose
    (
        item 0 of item 0 of it as integer = item 2 of it as integer
    )
    of
    (        
        (            
            (
                string values 0 of item 0 of it, string values 0 of item 1 of it
            )
            ;
            (
                string values 1 of item 0 of it, string values 1 of item 1 of it
            )
            ;
            (
                string values 2 of item 0 of it, string values 2 of item 1 of it
            )
            ;
            (
                string values 3 of item 0 of it, string values 3 of item 1 of it
            )
            ;
            (
                string values 4 of item 0 of it, string values 4 of item 1 of it
            )
            ;
            (
                string values 5 of item 0 of it, string values 5 of item 1 of it
            )
            ;
            (
                string values 6 of item 0 of it, string values 6 of item 1 of it
            )
            ;
            (
                string values 7 of item 0 of it, string values 7 of item 1 of it
            )            
        )
        , string values of item 2 of it, string values 0 of item 3 of it
    )
    of
    (
        properties "PossibleValues" of it, properties "PossibleValuesDescription" of it, properties "AttributeName" of it, properties "CurrentValue" of it
    )
    of select objects "AttributeName, CurrentValue, PossibleValues, PossibleValuesDescription from dcim_BIOSEnumeration where AttributeName='AC Power Recovery Mode'" of wmi "root/dcim/sysman"
)

if
(
    exists wmi "root\DELLOMCI"
)
then
(
    item 1 of
    (
        1, "Other"; 2, "Unsupported"; 3, "Disabled"; 4, "Every Day"; 5, "Weekdays"
    )
    whose
    (
        exists
        (
            item 0 of it,
            (
                integer value of selects "AutoOn from Dell_SMBIOSsettings" of wmi "root\DELLOMCI"
            )            
        )
        whose
        (
            item 0 of it is item 1 of it
        )        
    )    
)
else
(    
    (
        items 1 of items 0 of it
    )
    of
    (
        items 0 of it, items 1 of it, items 2 of it
    )
    whose
    (
        item 0 of item 0 of it as integer = item 2 of it as integer
    )
    of
    (        
        (            
            (
                string values 0 of item 0 of it, string values 0 of item 1 of it
            )
            ;
            (
                string values 1 of item 0 of it, string values 1 of item 1 of it
            )
            ;
            (
                string values 2 of item 0 of it, string values 2 of item 1 of it
            )
            ;
            (
                string values 3 of item 0 of it, string values 3 of item 1 of it
            )
            ;
            (
                string values 4 of item 0 of it, string values 4 of item 1 of it
            )
            ;
            (
                string values 5 of item 0 of it, string values 5 of item 1 of it
            )
            ;
            (
                string values 6 of item 0 of it, string values 6 of item 1 of it
            )
            ;
            (
                string values 7 of item 0 of it, string values 7 of item 1 of it
            )            
        )
        , string values of item 2 of it, string values 0 of item 3 of it
    )
    of
    (
        properties "PossibleValues" of it, properties "PossibleValuesDescription" of it, properties "AttributeName" of it, properties "CurrentValue" of it
    )
    of select objects "AttributeName, CurrentValue, PossibleValues, PossibleValuesDescription from dcim_BIOSEnumeration where AttributeName='Auto On'" of wmi "root/dcim/sysman"
)

if
(
    exists wmi "root\DELLOMCI"
)
then
(    
    (
        concatenation of string values of properties "AutoOnHour" of it & ":" & concatenation of string values of properties "AutoOnMinute" of it
    )
    of
    (
        select objects "AutoOnHour, AutoOnMinute from Dell_SMBIOSsettings" of wmi "root\DELLOMCI"
    )    
)
else
(    
    (
        string value of selects "CurrentValue from DCIM_BIOSEnumeration where InstanceID='Root/MainSystemChassis/AutoOnHourObj'" of it & ":" & string value of selects "CurrentValue from DCIM_BIOSEnumeration where InstanceID='Root/MainSystemChassis/AutoOnMinObj'" of it
    )
    of wmi "root/dcim/sysman"
)

if
(
    exists wmi "root\DELLOMCI"
)
then
(
    item 1 of
    (
        1, "Other"; 2, "Unsupported"; 3, "Disabled"; 4, "Enabled for add-in NIC"; 5, "Enabled for on-board NIC"; 6, "Enabled for all NICs"; 7, "Enabled with boot to NIC"; 8, "LAN or WLAN"
    )
    whose
    (
        exists
        (
            item 0 of it,
            (
                integer value of selects "WakeupOnLAN from Dell_SMBIOSsettings" of wmi "root\DELLOMCI"
            )            
        )
        whose
        (
            item 0 of it is item 1 of it
        )        
    )    
)
else
(    
    (
        items 1 of items 0 of it
    )
    of
    (
        items 0 of it, items 1 of it, items 2 of it
    )
    whose
    (
        item 0 of item 0 of it as integer = item 2 of it as integer
    )
    of
    (        
        (            
            (
                string values 0 of item 0 of it, string values 0 of item 1 of it
            )
            ;
            (
                string values 1 of item 0 of it, string values 1 of item 1 of it
            )
            ;
            (
                string values 2 of item 0 of it, string values 2 of item 1 of it
            )
            ;
            (
                string values 3 of item 0 of it, string values 3 of item 1 of it
            )
            ;
            (
                string values 4 of item 0 of it, string values 4 of item 1 of it
            )
            ;
            (
                string values 5 of item 0 of it, string values 5 of item 1 of it
            )
            ;
            (
                string values 6 of item 0 of it, string values 6 of item 1 of it
            )
            ;
            (
                string values 7 of item 0 of it, string values 7 of item 1 of it
            )            
        )
        , string values of item 2 of it, string values 0 of item 3 of it
    )
    of
    (
        properties "PossibleValues" of it, properties "PossibleValuesDescription" of it, properties "AttributeName" of it, properties "CurrentValue" of it
    )
    of select objects "AttributeName, CurrentValue, PossibleValues, PossibleValuesDescription from dcim_BIOSEnumeration where AttributeName='Wake-On-LAN'" of wmi "root/dcim/sysman"
)

if
(
    exists wmi "root\DELLOMCI"
)
then
(    
    (
        if it = "1" then "Other" else if it = "2" then "Unsupported" else if it = "3" then "Magic Packet" else "<not available>"
    )
    of
    (
        string values of selects "WakeupOnLANMethod from Dell_SMBIOSsettings" of wmi "root\DELLOMCI"
    )    
)
else
(
    "<not available>"
)

if
(
    exists wmi "root\DELLOMCI"
)
then
(    
    (
        concatenation of string values of properties "BootOrder" of it & " " & concatenation of string values of properties "BootDeviceName" of it & " (" & concatenation of
        (
            concatenation "Enabled" of substrings separated by "1" of concatenation "Disabled" of substrings separated by "0" of string values of properties "Status" of it
        )
        & ")"
    )
    of
    (
        select objects "* from Dell_BootDeviceSequence" of wmi "root\DELLOMCI"
    )    
)
else
(    
    (
        item 1 of it & " " & item 3 of it as trimmed string & " (" &
        (
            if item 1 of it as integer = 0 then "Disabled" else "Enabled"
        )
        & ")"
    )
    of
    (
        string value of property "PartComponent" of items 0 of it, string value of property "AssignedSequence" of items 0 of it, string value of property "__Path" of items 1 of it, string value of property "ElementName" of items 1 of it
    )
    whose
    (
        item 0 of it as uppercase = concatenation "/" of substrings separated by "\" of item 2 of it as uppercase
    )
    of
    (
        select objects "* from DCIM_OrderedComponent" of it, select objects "* from DCIM_BootSourceSetting" of it
    )
    of wmi "root/dcim/sysman"
)

if
(
    exists wmi "root\DELLOMCI"
)
then
(
    item 1 of
    (
        0, "Password not matched"; 1, "Password matched"; 2, "Not yet verified"; 3, "Password disabled by jumper"; 4, "Password not enabled"
    )
    whose
    (
        exists
        (
            item 0 of it,
            (
                integer value of selects "PasswordVerification from Dell_Configuration" of wmi "root\DELLOMCI"
            )            
        )
        whose
        (
            item 0 of it is item 1 of it
        )        
    )    
)
else
(
    "<not available>"
)

if
(
    exists wmi "root/DELLOMCI"
)
then
(
    exists
    (
        boolean values of selects "AMTEnabled from Dell_IntelAMTSettings" of wmi "root\DELLOMCI"
    )
    whose
    (
        it = true
    )    
)
else
(
    exists
    (
        boolean values of selects "AMTSupported from DCIM_AMTSettings" of wmi "root/dcim/sysman"
    )
    whose
    (
        it = True
    )    
)

if
(
    exists wmi "root\DELLOMCI"
)
then
(
    item 1 of
    (
        1, "Other"; 2, "Unsupported"; 3, "S1"; 4, "S3"
    )
    whose
    (
        exists
        (
            item 0 of it,
            (
                integer value of selects "SuspendMode from Dell_SMBIOSSettings" of wmi "root\DELLOMCI"
            )            
        )
        whose
        (
            item 0 of it is item 1 of it
        )        
    )    
)
else
(    
    (
        items 1 of items 0 of it
    )
    of
    (
        items 0 of it, items 1 of it, items 2 of it
    )
    whose
    (
        item 0 of item 0 of it as integer = item 2 of it as integer
    )
    of
    (        
        (            
            (
                string values 0 of item 0 of it, string values 0 of item 1 of it
            )
            ;
            (
                string values 1 of item 0 of it, string values 1 of item 1 of it
            )
            ;
            (
                string values 2 of item 0 of it, string values 2 of item 1 of it
            )
            ;
            (
                string values 3 of item 0 of it, string values 3 of item 1 of it
            )
            ;
            (
                string values 4 of item 0 of it, string values 4 of item 1 of it
            )
            ;
            (
                string values 5 of item 0 of it, string values 5 of item 1 of it
            )
            ;
            (
                string values 6 of item 0 of it, string values 6 of item 1 of it
            )
            ;
            (
                string values 7 of item 0 of it, string values 7 of item 1 of it
            )            
        )
        , string values of item 2 of it, string values 0 of item 3 of it
    )
    of
    (
        properties "PossibleValues" of it, properties "PossibleValuesDescription" of it, properties "AttributeName" of it, properties "CurrentValue" of it
    )
    of select objects "AttributeName, CurrentValue, PossibleValues, PossibleValuesDescription from dcim_BIOSEnumeration where AttributeName='Standby State'" of wmi "root/dcim/sysman"
)

if exists
(
    wmi "root\DELLOMCI"
)
then
(    
    (
        integer floor of it as string & " MB"
    )
    of sum of
    (        
        (
            string value of properties "Capacity" of it
        )
        as floating point /
        (
            1024*1024
        )        
    )
    of select objects "Capacity from dell_physicalmemory where Capacity <> null" of wmi "root\DELLOMCI"
)
else
(    
    (
        integer floor of it as string & " MB"
    )
    of sum of
    (        
        (
            string value of properties "Capacity" of it
        )
        as floating point /
        (
            1024
        )        
    )
    of select objects "Capacity from dcim_physicalmemory where Capacity <> null" of wmi "root/dcim/sysman"
)