I sort of see your point, but the second half on the script does an update (Section "Writing login information to the database).
The way I envisioned this, there are two tables, one caintains the UserID and Full name, the second contains all the other login information, preceeded by the...
I think I found my problem, and tsuji pointed me in the right direction. Although I did not get an error, I think my first loop was causing my problem. So instead of using a While / Wend, I changed the statement to an If / End If.
The function now looks like this.
Function...
Thanks tsuji and PHV for your input.
Tsuji, I will be very happy to test, but my issue, why does it work in test, that is I run it from a DOS prompt with cscript logon.vbs, and the script runs as I expect it would run. Writes the data I gather into the database. But when I run it from the...
I apologize for the confusion. I was doing some testing, and wrote the procedure to write to the database not as a function, but part of the previous section. I have changed it back using the Function call.
The script works fine if I run it when either from cscript ot wscript, fully logged...
Below is the full script. I have MsgBox in there for debug purposes. For the script to run, the user must log into the Domain and be authenticated before the the login script is run. Meaning the domain is aware of the user and the authentication level of the user.
option explicit
Dim...
At this point I am only using Microsoft Access till I know it works. When I move the DB to different locations I make sure I have sufficient privilages to the share / directory and database. I am a member of the Domain Admins group.
When I am sure the script works, I will migrate the database...
David,
That is a thought I also had, so what I did;
- put the database on the C: drive and coded the Provider to the directory.
- Setup the database on a server and configured ODBC with a DNS with a UNC path.
- Mapped a drive to the database on the server at the beginning of the script and then...
I have written a login script to gather information about the user and PC. It uses WMI and ADSI to get PC model Number, Serial Number, Memory, Operating system, Service Pack, User Login name, Full name, etc, and then writes it out to a database.
This works great when running from cscript or...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.