K1000 Wake on Lan Report
I need a report from KACE which shows the Dell Bios settings, in particular I need to know which PC's have the Wake on LAN setting enabled / disabled.
Please can you supply me the SQL statements to build the required query.
Community Chosen Answer
You can do this with a combination of Dell OMCI (which needs to be installed on each machine) and the K1000 with custom inventory rules. OMCI expands WMI on the machine to show the BIOS settings and even allows changes to be made.
There is an example of this in the KB - https://support.software.dell.com/kb/126032
The way I use it is slightly more complication and probably not to everyone's taste, but what I do is have a PowerShell script that finds the settings I'm looking for and save them as a Registry Value which I then collect via a Custom Inventory Rule.
My PowerShell script is added into the K1000 as a scripting task that runs against a Smart Label for all OptiPlex and Latitude machines every 2 hours.
Once the Custom Inventory Field has been populated you can then create reports.