Dell OMCI SMBiosSettings - Hardware Inventory Extension
By request, the WakeOnLan settings out of the WMI Namespace created by Dell's Open Manage Client Instrumentation; the Dell_SMBIOSSettings, specifically the WakeOnLan attributes. Below is the mof edit; to be added to the bottom of sms_def.mof on your primary site servers, inboxes\clifiles.src\hinv. Note most of the attributes are FALSE. If you determine you would like those additional attributes, at any time you can change them from FALSE to TRUE. Also below is a sample report for the WakeonLan returned results. The results come back as an integer; so interpretation is needed at the report. If you do want to turn on additional attibutes, in the attached is a text file. If you follow the pattern of the WakeOnLan info, you'll see the other attributes' patterns, and be able to create your own Select Case... reports.
// Dell SMBIOS Settings
// These settings are available when the following optional application for
// managed Dell systems is installed.
// Dell Open Manage Client Instrumentation (OMCI)
// This edit was tested using v7.6 of Dell OMCI
// Note: the majority of options, changed from FALSE to TRUE, report an
// integer (0, 1, 2, 3, etc.) Those integers would need to be correctly
// interpreted at the report level.
[ SMS_Report (TRUE),
SMS_Group_Name ("Dell SMBIOS Settings"),
SMS_Class_ID ("CUSTOM|Dell_SMBiosSettings|1.0"),
SMS_Namespace (FALSE),
Namespace ("\\\\\\\\.\\\\root\\\\dellomci") ]
class Dell_SMBIOSSettings : SMS_Class_Template
{
[SMS_Report (FALSE) ] sint32 AGPSlot;
[SMS_Report (FALSE) ] sint32 AmbientLightSensor;
[SMS_Report (FALSE) ] sint32 AFSMode;
[SMS_Report (FALSE) ] sint32 AutoOn;
[SMS_Report (FALSE) ] sint32 AutoOnHour;
[SMS_Report (FALSE) ] sint32 AutoOnMinute;
[SMS_Report (FALSE) ] sint32 BluetoothDevices;
[SMS_Report (FALSE) ] sint32 BootSequence;
[SMS_Report (FALSE) ] sint32 BuiltinFloppy;
[SMS_Report (FALSE) ] sint32 BuiltinNIC;
[SMS_Report (FALSE) ] sint32 BuiltinNIC2;
[SMS_Report (FALSE) ] sint32 BuiltinPointingDevice;
[SMS_Report (FALSE) ] string Caption;
[SMS_Report (FALSE) ] sint32 CellularRadio;
[SMS_Report (FALSE) ] sint32 Charger;
[SMS_Report (FALSE) ] sint32 ChassisIntrusion;
[SMS_Report (FALSE) ] sint32 ChassisIntrusionStatus;
[SMS_Report (FALSE) ] sint32 ClearSystemEventLog;
[SMS_Report (FALSE) ] sint32 CoolAndQuiet;
[SMS_Report (FALSE) ] sint32 CPUVirtualization;
[SMS_Report (FALSE), key] sint32 DellInstanceID;
[SMS_Report (FALSE) ] string Description;
[SMS_Report (FALSE) ] sint32 ESataPorts;
[SMS_Report (FALSE) ] sint32 ExpressCharge;
[SMS_Report (FALSE) ] sint32 ExternalHotkey;
[SMS_Report (FALSE) ] sint32 FastBoot;
[SMS_Report (FALSE) ] sint32 HardDiskAcousticMode;
[SMS_Report (FALSE) ] sint32 HardDiskFailover;
[SMS_Report (FALSE) ] sint32 HotDocking;
[SMS_Report (FALSE) ] sint32 Hyperthreading;
[SMS_Report (FALSE) ] sint32 IDEController;
[SMS_Report (FALSE) ] sint32 IntegratedAudio;
[SMS_Report (FALSE) ] sint32 IntegratedRAIDController;
[SMS_Report (FALSE) ] sint32 IntegratedSASController;
[SMS_Report (FALSE) ] sint32 IntegratedSATAController;
[SMS_Report (FALSE) ] sint32 IntegratedUSBHub;
[SMS_Report (FALSE) ] sint32 InternalMiniPCI;
[SMS_Report (FALSE) ] sint32 KeyboardIllumination;
[SMS_Report (FALSE) ] sint32 Keypad;
[SMS_Report (FALSE) ] sint32 LimitCPUIDValue;
[SMS_Report (FALSE) ] sint32 LowPowerS5;
[SMS_Report (FALSE) ] sint32 MediaCardAnd1394;
[SMS_Report (FALSE) ] sint32 Microphone;
[SMS_Report (FALSE) ] sint32 ModuleBayDevice;
[SMS_Report (FALSE) ] sint32 MonitorToggling;
[SMS_Report (FALSE) ] sint32 MultiCore;
[SMS_Report (FALSE) ] sint32 NMIButton;
[SMS_Report (FALSE) ] sint32 NodeInterleave;
[SMS_Report (FALSE) ] sint32 NoExecute;
[SMS_Report (FALSE) ] sint32 NumLock;
[SMS_Report (FALSE) ] sint32 Onboard1394;
[SMS_Report (FALSE) ] sint32 OnboardModem;
[SMS_Report (FALSE) ] sint32 OSInstallMode;
[SMS_Report (FALSE) ] sint32 ParallelPortConfiguration;
[SMS_Report (FALSE) ] sint32 ParallelPortMode;
[SMS_Report (FALSE) ] sint32 PasswordBypass;
[SMS_Report (FALSE) ] sint32 PCCard;
[SMS_Report (FALSE) ] sint32 PCCardAnd1394;
[SMS_Report (FALSE) ] sint32 PCISlots;
[SMS_Report (FALSE) ] sint32 PenMissingIndication;
[SMS_Report (FALSE) ] sint32 PenResumeOn;
[SMS_Report (FALSE) ] sint32 PointingDevice;
[SMS_Report (FALSE) ] sint32 POSTF12KeySetting;
[SMS_Report (FALSE) ] sint32 POSTF2KeySetting;
[SMS_Report (FALSE) ] sint32 POSTHelpDeskKeySetting;
[SMS_Report (FALSE) ] sint32 POSTMEBxKeySetting;
[SMS_Report (FALSE) ] sint32 PowerManagementSettings;
[SMS_Report (FALSE) ] sint32 PrimaryParallelATAMaster;
[SMS_Report (FALSE) ] sint32 PrimaryParallelATASlave;
[SMS_Report (FALSE) ] sint32 PrimaryVideo;
[SMS_Report (FALSE) ] sint32 RadioTransmission;
[SMS_Report (FALSE) ] sint32 SafeUSB;
[SMS_Report (FALSE) ] sint32 SATADIPM;
[SMS_Report (FALSE) ] sint32 SecondaryParallelATAMaster;
[SMS_Report (FALSE) ] sint32 SecondaryParallelATASlave;
[SMS_Report (FALSE) ] sint32 SerialATAChannel1;
[SMS_Report (FALSE) ] sint32 SerialATAChannel2;
[SMS_Report (FALSE) ] sint32 SerialATAChannel3;
[SMS_Report (FALSE) ] sint32 SerialATAChannel4;
[SMS_Report (FALSE) ] sint32 SerialATAChannel5;
[SMS_Report (FALSE) ] sint32 SerialATAChannel6;
[SMS_Report (FALSE) ] sint32 SerialATAChannel7;
[SMS_Report (FALSE) ] sint32 SerialATAChannel8;
[SMS_Report (FALSE) ] sint32 SerialCommunication;
[SMS_Report (FALSE) ] sint32 SerialPort1Configuration;
[SMS_Report (FALSE) ] sint32 SerialPort2Configuration;
[SMS_Report (FALSE) ] sint32 SERRDMIMessage;
[SMS_Report (FALSE) ] sint32 SetCMOSToDefault;
[SMS_Report (FALSE) ] string SettingID;
[SMS_Report (FALSE) ] sint32 SingleByteECCLogging;
[SMS_Report (FALSE) ] sint32 SingleCoreTurboMode;
[SMS_Report (FALSE) ] sint32 SmartCardReader;
[SMS_Report (FALSE) ] sint32 SMARTErrors;
[SMS_Report (FALSE) ] sint32 SpeakerVolume;
[SMS_Report (FALSE) ] sint32 SpeedStep;
[SMS_Report (FALSE) ] sint32 TabletButtons;
[SMS_Report (FALSE) ] sint32 TertiaryParallelATAMaster;
[SMS_Report (FALSE) ] sint32 TertiaryParallelATASlave;
[SMS_Report (FALSE) ] sint32 TrustedPlatformModule;
[SMS_Report (FALSE) ] sint32 TrustedPlatformModuleActivation;
[SMS_Report (FALSE) ] sint32 UARTPowerDown;
[SMS_Report (FALSE) ] sint32 USBEmulation;
[SMS_Report (FALSE) ] sint32 USBFlashDriveEmulation;
[SMS_Report (FALSE) ] sint32 USBFrontPanelPorts;
[SMS_Report (FALSE) ] sint32 USBPort00;
[SMS_Report (FALSE) ] sint32 USBPort01;
[SMS_Report (FALSE) ] sint32 USBPort02;
[SMS_Report (FALSE) ] sint32 USBPort03;
[SMS_Report (FALSE) ] sint32 USBPort04;
[SMS_Report (FALSE) ] sint32 USBPort05;
[SMS_Report (FALSE) ] sint32 USBPort06;
[SMS_Report (FALSE) ] sint32 USBPort07;
[SMS_Report (FALSE) ] sint32 USBPort08;
[SMS_Report (FALSE) ] sint32 USBPort09;
[SMS_Report (FALSE) ] sint32 USBPort10;
[SMS_Report (FALSE) ] sint32 USBPort11;
[SMS_Report (FALSE) ] sint32 USBPort12;
[SMS_Report (FALSE) ] sint32 USBPort13;
[SMS_Report (FALSE) ] sint32 USBPort14;
[SMS_Report (FALSE) ] sint32 USBPort15;
[SMS_Report (FALSE) ] sint32 USBPorts;
[SMS_Report (FALSE) ] sint32 USBPortsExternal;
[SMS_Report (FALSE) ] sint32 USBPortsUserAccessible;
[SMS_Report (FALSE) ] sint32 USBRearDual;
[SMS_Report (FALSE) ] sint32 USBRearQuad;
[SMS_Report (FALSE) ] sint32 USBWake;
[SMS_Report (FALSE) ] sint32 VideoExpansion;
[SMS_Report (FALSE) ] sint32 VideoMemorySize;
[SMS_Report (FALSE) ] sint32 VTforDirectIO;
[SMS_Report (TRUE) ] sint32 WakeupOnLAN;
[SMS_Report (TRUE) ] sint32 WakeupOnLANMethod;
[SMS_Report (FALSE) ] sint32 WiFiCatcherChanges;
[SMS_Report (FALSE) ] sint32 WiFiLocator;
[SMS_Report (FALSE) ] sint32 WirelessDevice;
[SMS_Report (FALSE) ] sint32 WirelessLAN;
[SMS_Report (FALSE) ] sint32 WirelessSwitchBluetoothControl;
[SMS_Report (FALSE) ] sint32 WirelessSwitchCellularControl;
[SMS_Report (FALSE) ] sint32 WirelessSwitchChanges;
[SMS_Report (FALSE) ] sint32 WirelessSwitchWirelessLANControl;
};
And.. the Sample Report:
select Case when DellSM.WakeupOnLan0 = 1 then 'Other'
when DellSM.WakeupOnLan0 = 2 then 'Unsupported'
when DellSM.WakeupOnLan0 = 3 then 'Magic Packet'
end as 'WakeupOnLan',
Case when DellSM.WakeupOnLANMethod0 = 1 then 'Other'
when DellSM.WakeupOnLANMethod0 = 2 then 'Unsupported'
when DellSM.WakeupOnLANMethod0 = 3 then 'Disabled'
when DellSM.WakeupOnLANMethod0 = 4 then 'Enabled for add-in NIC'
when DellSM.WakeupOnLANMethod0 = 5 then 'Enabled for on-board NIC'
when DellSM.WakeupOnLANMethod0 = 6 then 'Enabled for all NICs'
when DellSM.WakeupOnLANMethod0 = 7 then 'Enabled with boot to NIC'
when DellSM.WakeupOnLANMethod0 = 8 then 'LAN or WLAN'
when DellSM.WakeupOnLANMethod0 = 9 then 'WLAN only'
END as 'WakeuponLAN Method'
from v_R_System as SYS
inner join v_gs_dell_smbios_settings0 as DellSM on
sys.resourceid=Dellsm.Resourceid
where SYS.Netbios_Name0 = @compname
With a CompName prompt SQL statement of
begin
if (@__filterwildcard = '')
SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS ORDER By SYS.Netbios_Name0
else
SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS
WHERE SYS.Netbios_Name0 like @__filterwildcard
ORDER By SYS.Netbios_Name0
end