Discussion Locked

Create a database log of programs ran.

0 helpful
18 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have 43 computers that I manage in a Lab. I am looking for a cheap way to create a log for a database to understand the computer usage in my lab.

Basically, I need to log the programs ran on each computer on my network then compile that listing on a database or text delimited file. I can pull it into my database program to create statistics of programs used on a day by day basis.

I asked other people before and they said look on the web. Any suggestions or even ideas of what to search for. The suggestion or answer that I use will get the Points.

18 replies

by shmaltz

You can use perfomance moniter to moniter any computer on your network and then output the results into a text file and then import it to any database.

by jpeterso

I would need more detail to accept this answer.

1. Is there a way to have each computer log the executable file (Program) ran on each computer automatically?

2. What is the Procedure.

Thanks for the input.

by shmaltz

In winnt go to start programs administrativ tools performance moniter.
From the menu choose view>log.
From the edit menu choose add to log
Then choose the computer.
Then choose the objects you wana log (the objects are things that are too difficult to explain here)
Then choos data from from the options menu and choose a file name.
Be carefull as the log file can grow in size.
Also be sure to use the right intervalls for that reason.
When you are done logging choose data from from the options menu (make sure log file is checked not current activity)
Choose report view from the view menu and save as cvs file from the file menu then u can inport it into a database.

by jpeterso

We're getting there. I am stuck on one point.

In the objects, which one do I choose to moniter individual programs ran for statistics.

So, close,

Thanks for your help.

by shmaltz

hi
I was not online for a while so i could not answer.
You should moniter the cpu and the memory you will have to choose the right threads in order to get the results you want (which program is using the memory/cpu).
I am not going to explain toyou threads here as it is a very complicated subjuct, but you should buy a book on winnt that includes this subject (Performance moniter)and learn how to moniter programs.
I am telling you that this is the way to go to use performance moniter its one of the bast tools that microsoft included in its oprating systems.

by shmaltz

if you also want to moniter the network you should also choose the network object also by monitering the page file you can see if you need to add memory (if its being accessed to often).

by jpeterso

The network is not what I need to moniter. It is programs executed. I need to moniter 30 computers for all executable files ran on that machine, time and date would be prefered. Then I want every computer to log that information into one file. Then I can manipulate the data anyway I want.

My investigation of the Performance Moniter, tells me that I must enter each computer information for every thread that I want to moniter. That does not sound that easy, objects seems to be an easier method, but why should I do the investigation. I asked a question and if I need more explaining, I should get more of an explanation. Not "that it is very difficult, buy a nt book to solve your problem". If you do not know how to explain youranswer than someone else should answer it for you.

Jeremy

by daniel_macnish

Here's an answer that I haven't tried myself, but I see no reason why it won't work:

Create a batch file for each program run on the workstations.
eg. outlook.bat if you use outlook.exe

In that batch file, add a line that writes the application name, date and time to a text file, and then runs the original executable.
eg. echo outlook >computername.txt
echo date /t >>computername.txt
echo time /t >>computername.txt
outlook.exe

(Note the use of two >'s on the second and third line - means to append to the file rather than overwrite.)

Now point all application shortcuts to the batch file rather than the original executable, and go from there.

There are a couple of problems with this solution as stated:
I think that date /t and time /t (display both without trying to set them) only work on NT. It won't track usage if someone types outlook.exe at the Run prompt, or if they double-click directly on the executable. But then I don't know how locked down your lab is...
Hope this helps.

by jpeterso

Interesting. . . This is easier than the first solution. My only question is; Does this insert only one line per activation?

by daniel_macnish

Presently, my solution will create three lines per execution in the log file. To change it to create one, move the statements onto one line and separate them with commas:

echo date /t, outlook >logfile.txt

by jpeterso

Looking better, my only other problem is that I can only moniter the start of the programs and nothing else. A student may walk into the lab and see the program they want to use is already running. Then I am stuck, I don't know that a new person is using that program. (Like Netscape, the most popular program known to labs. . .) Also, I want to moniter the length of time that they are on the program. Any suggestions?

by spn

Hello
I can see the problem,get hold of a program called Task Monitor(download trail/full from taskmon.com)

A nice little program that will run in the backgroud ,of win9x and NT platforms.The new version seems very funtional with the client andserver installation.It audits applications opened ,etc,etc.Not ideal but I don't know of a better solution other than implamenting a full NT enviorment.(but i'll keep my eyes open.)
SPiNner

by jpeterso

Interesting program, but it does not create a log of everything running on the machine. (At least from my quick observation. . .) My main goal is to take this data to my boss and tell him which programs are being used the most.

This discussion is closed to new replies.