access a file of a list of exes on a box

[MasterMindTiger]

I am needing to create a way to pull off every .exe off of computers in a network and file them in a sql database. i have the database worked and set up and am only hung up on the part of getting my list. would anyone out there have a sugestion of how i should do this. i have though about a batch file that runs a login and then pulling the file but the only batch i have found will give me the same answer as if i run dir at a command line.

Any suggestions on this would be helpful.
Thank you for you time if you read this.

 

[giadich]

some ideas for you:

1. why dont you write some vb code to obtain a list of exe files and put that info in the db?

2. if the list has subfolders then loop through each one and repeat step #1.

3. you insert should check for duplicates.

4. should run this periodically to obtain update or have some service running in the background to monitor file addtion/removal and take appropriate action.

5. since you mention DIR command, you could also run it, redirect the output to a text file, have your vb code process that file.

 

[MasterMindTiger]

Thank. i guess what i was really asking was how do i take the text file i get from the computer and insert it into the database.

Directory of c:\Documents and Settings\harlajc

10/29/2007 11:45 AM 630,784 GoToAssist_chat2way__320_en.exe
1 File(s) 630,784 bytes

Directory of c:\Documents and Settings\harlajc\Application Data\U3\temp

04/05/2006 07:38 PM 110,592 cleanup.exe
1 File(s) 110,592 bytes

This is an example of the file i get out of the bat. I have to have the file name and the file size out of this file. i just dont know how to set up my code to pull that to my SQLDB.

 

[giadich]

open the text file, read the file and parse the content. If you find an exe then insert/update the db.

 

[cjard]

I am needing to create a way to pull off every .exe off of computers in a network and file them in a sql database. i have the database worked and set up and am only hung up on the part of getting my list.

Read this. Its 2.0, but the doc says the method is avail on 1.1 too:

http://msdn2.microsoft.com/en-us/library/07wt70x2(vs.80).aspx Directory.GetFiles Method