Standby / Hibernation / Wake-On-LAN

[alcachofa]

When doing some software updates during non business hours I found out that some machines went to standby/hibernation and I couldnt deploy the updates. Is there any way to disable standby/hibernation in the remote machines through SMS?

Can SMS use Wake-On-LAN technology so even when the PCs are powered down I can remotely turn them on and so they can receive the software updates?

 

[tbrennans]

yes,

http://www.1e.com/SoftwareProducts/NightWatchman/Index.aspx

http://www.1e.com/SoftwareProducts/SMSWakeUp/Index.aspx

 

[alcachofa]

There is no freeware program to do this?

 

[tbrennans]

Not that I'm aware of, although some nic cards have it built in, its just figuring out how to activate it with a script correctly....as 1e did

 

[globalstrata]

For the Hibernation use AD GPOs

For Wake-on-Lan, create a query that gets the computer name, mac address, ip address and subnet mask, then write a sctipt the runs WolCMD (freeware command prompt from

http://www.depicus.com)

using the information from the query above and use task manager or SMS to schedule the script to be run.

I can post the query SQL command on Monday when I go to the office. But that is what we use.


Gladys Rodriguez
GlobalStrata Solutions

http://www.globalstrata.com

 

[alcachofa]

Thanks Gladys. I would appreciate very much if you could post the SQL query you are using.

Thanks again.

 

[globalstrata]

select distinct SR.NetbiosName, NAC.MACAddress, NAC.IPAddress, NAC.IPSubnet from SMS_R_System inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION as NAC on NAC.ResourceID = SMS_R_System.ResourceId inner join SMS_R_System as SR on SR.ResourceId = NAC.ResourceID where NAC.DHCPEnabled = 1 and SR.Client = 1 and NAC.IPAddress like "X.X.x.%" order by SR.NetbiosName

I would define IP subnet like 192.168.2.% in the above query to ensure that all the computers that show have an IP address

Hope this helps,


Gladys Rodriguez
GlobalStrata Solutions

http://www.globalstrata.com

 

[globalstrata]

So basically this is what I do. I put that query in the Query section. Then, if I want to run it against a collection, I just edit the properties and tell it to use the collection as a basis. Then, I export to a text file and run a script that does the following:

Convert the spaces to commas and delete the semicolons that are with the MAC address. Then I run the WolCMD against the file.


Gladys Rodriguez
GlobalStrata Solutions

http://www.globalstrata.com