miscITfinds

Monday, October 22, 2007

Friday, October 19, 2007

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.

Calculating the Last Logon Time

Calculating the Last Logon Time

Set objUser = GetObject("LDAP://cn=Ken Myer, ou=Finance, dc=fabrikam, dc=com")
Set objLastLogon = objUser.Get("lastLogonTimestamp")
intLastLogonTime = objLastLogon.HighPart * (2^32) + objLastLogon.LowPart
intLastLogonTime = intLastLogonTime / (60 * 10000000)
intLastLogonTime = intLastLogonTime / 1440
Wscript.Echo "Last logon time: " & intLastLogonTime + #1/1/1601#