WakeUP management

[_pi]

I successfully use for long time my simple solution to wake up computers in the office from home, when i need to administrate them.
qm ist listening on the server with qm net.
I just send the name of the computer and the function on the server has all the mac addresses needed.
But this is 'hardcoded' and not convenient to maintain.

I tend use an excel file where i manage pc-name and mac addresses.

What do you suggest?

Thanks.

Function WakeUp

Code:

Copy      Help

function $whichPC
str target_mac go
str server1="192.168.2.250"
str wol="C:\wol.exe"
sel whichPC
,case "johanna pc"
,,target_mac="30-9C-23-80-C3-68"    
,case "david"
,,target_mac="44-37-E6-89-E3-0F"    
,case "marina"
,,target_mac="CC-52-AF-4B-47-3F"    
,case "office"
,,target_mac="40-2C-F4-EA-13-3F"            
,case "simon"
,,target_mac="00-21-CC-68-F9-BA"        
,case "datev"
,,target_mac="00-23-24-80-9D-EB"            
,case "licht"
,,target_mac="00-13-3B-0F-12-E6"        
,case "minh"
,,target_mac="00-21-CC-4A-1F-DA"        
,case "rodas"
,,target_mac="54-EE-75-40-0D-EC"            
,,
,case else
,,end


go.format("''%s'' ''%s''", target_mac server1)
run wol go
out go