myITforum_sms scripts

Query for machine with no logged on user for 30
may need to change the quotes around the numbers to single to get it to
quote:select SYS.Netbios_Name0, SYS.AD_Site_Name0, OS.LastBootUpTime0, WS.LastHWScan as 'Last Reported to SMS' from v_GS_Operating_System OS join v_r_system SYS on OS.ResourceID=SYS.ResourceID join v_gs_workstation_status ws on sys.resourceid=ws.resourceid Where OS.Version0 = '5.1.2600' and datediff(day,ws.LastHWScan,getdate()) < "2" and datediff(day,OS.LastBootUpTime0,getdate()) > "14" Order by SYS.AD_Site_Name0, OS.LastBootUpTime0

anyone have a vbs to edit registry key and push out wit...

sms client health script

sms sql help

Distributing a file from a central location overnight -

Simple way to identify/correct duplicate machines in co...

How to troubleshoot SMS Administrator console connectivity

gather the information contained in the local workstation’s “Administrators” group.