Let's say I have 1000 computers, all nearly identical builds, users add and change things here an there, but overall very identical boxes. Let's assume I'm collecting the path, name and file version for each file on a users PC. How do I create an efficient index, I don't want to store c:\windows\system32\notepa
The concept is as follows...
machine01 has files: 1-200, 344, 421-500, 512-566, 578, 590, 600-700 etc...
Or should it go the other way
notepad.exe is on machines: 1-88, 90-95, 100
calc.exe is on machines: 2-41, 42, 44, 48-90, 92-100
Each machine writes a local inventory, ftp's the file to a server that add's the files/path/version to the db, and would then be able to through and update pointers after all the file data is entered.
Well I guess I'm kind of answering my own question, if I want to search for machines with calc.exe on them, the second example is clearly better... I'm going to ask the question anyway in case I have no idea what I'm talking about.
I'm also wanting to track the changes... machine01 had files 44, 67, 99 changed to 1002, 1003, 1004, and files 2, 19 and 55 deleted. I know I'm all over the place with this question, but it should convey the idea.
-rich
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
OK, I think I'm getting there... below is what I'm looking to match up.
Filename, path, hash's and associate then with a machine_ID
From a search prospective, what is the best way to store and retrieve...
these file names, with these file hash's are on machine_x in these path locations...
Machine 01 c:\windows\explorer.exe ae7a08c05f72a9242734c03230
Machine 01 c:\windows\system32\notepa
etc...
-rich
Business Accounts
Answer for Membership
by: KdoPosted on 2009-07-17 at 13:12:01ID: 24882441
Hi Rich,
Store the path names in one table and the file names in another. When you store a file name, store the primary key of the path name in the filename record.
CREATE TABLE pathnames
(
id integer IDENTITY, -- some syntax omitted
name varchar (3000)
);
CREATE TABLE filenames
(
id integer IDENTITY, -- omitted here, too.
pathid integer,
name varchar (150)
);
Assume two paths are in the database
id path
1 c:\
2 c:\temp
Then store the files in the root directory into the filename table
id pathid name
1 1 config.sys
2 1 autoexec.bat
3 1 command.com
And add the files in c:\temp
id pathid name
4 2 readme.txt
5 3 someotherfile
etc....
Kent