Troubleshooting

Configuring Microsoft® System Center Configuration Manager 2007 Inventory to utilize Dell™
OpenManage™ Client Instrumentation 8.0.1 for WakeOnLan Reporting
6
SQLQuery = "select
\nNetbios_Name0, Operating_System_Name_and0, DBIOS.AttributeName0,
\nCase when DBIOS.CurrentValue0 = 1 then 'Disabled'
\nwhen DBIOS.CurrentValue0 = 4 then 'LAN'
\nwhen DBIOS.CurrentValue0 = 6 then 'LAN or WLAN'
\nwhen DBIOS.CurrentValue0 = 7 then 'WLAN Only'
\nEND as 'WakeuponLAN'
\nfrom v_R_System SYS
\nInner Join v_GS_DCIM_BIOS_Enumeration0 DBIOS on SYS.ResourceID=DBIOS.ResourceID
\nwhere DBIOS.AttributeName0 = 'Wake On Lan'";
StatusMessageDetailSource = FALSE;
UnicodeData = FALSE;
XColLabel = "";
YColLabel = "";
};
// ***** End *****
References
Lai, Benjamin and Martell, Nathan. 2008. Integrating Dell™ OpenManage™ Client Instrumentation with
Microsoft® System Center Configuration Manager. Retrieved from
http://media.community.dell.com/en/dtc/attach/omci_sccm_whitepaper.pdf