General discussion

Locked

Create a database log of programs ran.

By jpeterso ·
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.

This conversation is currently closed to new comments.

18 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Create a database log of programs ran.

by shmaltz In reply to Create a database log of ...

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.

Collapse -

Create a database log of programs ran.

by jpeterso In reply to Create a database log of ...

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.

Collapse -

Create a database log of programs ran.

by shmaltz In reply to Create a database log of ...

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.

Collapse -

Create a database log of programs ran.

by jpeterso In reply to Create a database log of ...

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.

Collapse -

Create a database log of programs ran.

by shmaltz In reply to Create a database log of ...

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.

Collapse -

Create a database log of programs ran.

by shmaltz In reply to Create a database log of ...

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).

Collapse -

Create a database log of programs ran.

by jpeterso In reply to Create a database log of ...

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

Collapse -

Create a database log of programs ran.

by daniel_macnish In reply to Create a database log of ...

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.

Collapse -

Create a database log of programs ran.

by jpeterso In reply to Create a database log of ...

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

Collapse -

Create a database log of programs ran.

by daniel_macnish In reply to Create a database log of ...

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

Back to Windows Forum
18 total posts (Page 1 of 2)   01 | 02   Next

Related Discussions

Related Forums