#147793 - 2005-09-14 07:29 PM
Inserting software inventory in SQL database (or access)
|
shtroumf
Fresh Scripter
Registered: 2005-08-13
Posts: 7
|
I have already made my script inserting my computers informations in a SQL database named inventory with a table named Computers. I insert the wksta name, ip, mac, mem, disk size... etc etc etc.. This is simple to implement because I Have One value for each column.. ie : Computer name = stbo, installedMem=1024, CPU speed= 1700 etc etc etc... Where I'm stuck is How can I insert the Software list of One computer into one of these colomn... For now, I export the software list to a text file, but its not a clean way of doing it.. I would like to have something like a table named software, and into that table having a colomn that can take Array of data or something like that, so i could have like.. Copmuter = stbo, Software= acrobat reader,microsoft office,McAfee, etc etc etc... and after, the table juste continu normally with InstalledRAM=1024, Harddrive=10000, Windows=Winxpsp2, etc etc etc..
I hope you understand what i say.. Im a french guy you know 
I tough about doing comething like this for the list of software. I could make a table named SOFTWARES Into it I would have a colomn named Wksta and one named Soft And it could insert data like this
Wksta , Soft stbo , microsoft office stbo , microsoft antispyware stbo , mcafee stbo , acrobat ands , microsoft office ands , microsoft antispyware ands , mcafee etc etc etc ...
I find this way of doing it a little bit Over loaded in informations... isnt it???
|
|
Top
|
|
|
|
Moderator: Jochen, Allen, Radimus, Glenn Barnas, ShaneEP, Ruud van Velsen, Arend_, Mart
|
0 registered
and 809 anonymous users online.
|
|
|