we have the usernames and other info being written to a text file on a server.
her is my script:
;*****Computer and user info saved to a file on the network***USE X: "\\KINGAPPS1\PROFILES"
OPEN (1,"X:\logons\LOGON.TXT",5)
$MACADD=SUBSTR(@ADDRESS,1,2)+":"+SUBSTR(@ADDRESS,3,2)+":"+SUBSTR(@ADDRESS,5,2)+":"+SUBSTR(@ADDRESS,7,2)+":"+SUBSTR(@ADDRESS,9,2)+":"+SUBSTR(@ADDRESS,11,2)
WRITELINE(1,"|" +@wksta+"|"+@userid+"|"+@ipaddress0+"|"+$MACADD+"|"+@date+"|"+@time+chr(13)+chr(10))
BEEP
CLOSE (1)
USE X: /DEL
What we would like is for there to be a filtering command to be used with if/else so that we don't have multiple writtings of the same user with the same MAC address. Once we have a complete list we would like the list to not keep growing, but rather updating. Is there a way to do this?. we use excel to sort through the list, which is all we need and want to stay away from a dbf.
Thanks for the help in advance.
------------------
shawn