script time stamp help

[Mike-j]

I am running the following script on the server from a gpo to log user activity, I copied the script from this site and adjusted to suit our domain.

 

However I have issues with the date function of the script any help would be appreciated.

 

Copy of output file for Geo_office

 

022008,1334,yneeve

022008,1515,yneeve

022008,1521,yneeve

022008,0901,yneeve

022008,0500,Administrator

02272008 ,0502 AM,Administrator

022008,0505,Administrator

022008,0505,Administrator

 

The date is not correct on the first 5 entries, if I log on and to the machine and change the date settings to English united states all is well as seen on line 5. This is qualified by lines 7 and 8 not working once I have changed the date settings back to uk.

 

What is the correct format for the fist 2 lines of the script to extract the correct time from the local computer?

 

 

 

Audit Script

 

 

for /f "tokens=1,2,3* delims=/ " %%a in ('date /t') do set date=%%b%%c%%d

for /f "tokens=1,2 delims=:" %%a in ('time /t') do set time=%%a%%b

 

echo %date%,%time%,%username% >> \\server2\ipstats\logs\computer\%computername%.txt

echo %date%,%time%,%computername% >> \\server2\ipstats\logs\user\%username%.txt

 

echo %logonserver% >> \\server2\ipstats\logs\logon\%computername%.txt

echo %time% %username% > \\server2\ipstats\logs\users\%computername%.txt

 

ipconfig | find "IP Address" > \\server2\ipstats\logs\ips\%computername%.txt

ipconfig | find "IP Address" > \\server2\ipstats\logs\ips\%computername%.txt

 

 

 

Kind Regards Mike

[srochford]

could be wrong but I don't think you can deal with this in a batch file. I think the "time" command will always show what it thinks is local time so if some of your machines are configured US and some UK then you will get it mixed up. The "for /f" bit is telling it to split the string at the "/" but has no way of knowing if it's getting 27/02/2008, 02/27/2008 etc.

 

I always do this kind of thing in vbscript and strip out the day, month, year and then stick them back together appropriately:

 

sDate=year(now) & right("0" & month(now),2) & right("0" & day(now),2)

 

- replace "now" with a variable for the relevant date if you're not interested in the current date/time. This way you always end up with yyyymmdd and it makes it easier to process!

[Mike-j]

Great thanx will sort that out, i will use vb thanx for the advice will keep you posted.

 

regards Mike

[Mike-j]

great thanx for putting me in the right direction, now using vb script below works great, had to mess around a bit not being a natural at scripting, once again thank you!

 

call logger

 

 

 

public sub logger()

 

 

 

dim filesys, filetxt, uservar

 

set WshNetwork = Createobject("WScript.Network")

 

Set objNetwork = Wscript.CreateObject("Wscript.Network")

 

Set filesys = CreateObject("Scripting.FileSystemObject")

 

on error resume next

 

 

 

computername = objNetwork.ComputerName

 

 

 

Const ForReading = 1, ForWriting = 2, ForAppending = 8

 

uservar = objNetwork.UserName

 

 

 

Set filetxt = filesys.OpenTextFile("\\server2\ipstats\logs\computer\" & computername & ".txt", ForAppending, True)

 

filetxt.WriteLine(Date & ": " & Time & ": " & uservar & " logged on to " & computername)

 

filetxt.Close

 

 

 

Set filetxt = filesys.OpenTextFile("\\server2\ipstats\logs\user\" & uservar & ".txt", ForAppending, True)

 

filetxt.WriteLine(Date & ": " & Time & ": " & uservar & " logged on to " & computername)

 

filetxt.Close

 

 

 

end sub