Need WMI query to find DELL BIOS settings for SATA Operations, is it set to AHCI OR RAID On

I would start by looking at the raw data to see what you get:

selects "* from Win32_SCSIController" of WMIs

or:

selects "* from Win32_DiskDrive" of wmis

It sounds like what you really want to get is the settings in the Dell BIOS. You generally want to do that with Dell Command Monitor. You will need to install Dell Command Monitor, then it will let you query Dell BIOS specific settings using WMI.