I have already developped an application that does the hardware and software inventory of my managed assets.
For
software and
service table i suggest to you to use another kind of table schema to preserve the db integrity rules and to execute query in a faster way.
The informations about a service/software are more or less always the same, same name, description, version, location, and so on (many computers have exactly the same services/softwares) ... same services/softwares on many machines and this means that i have to repeat for all of them the same informations in every record. It is not very good table design. Right?
From OA Software table:
[quote]160 CNT0029.domain.net Microsoft Office Professional Edition 2003 11.0.7969.0 MsiExec.exe /I{90110410-6000-11D3-8CFE-0150048383C... 20060713 Microsoft Corporation \\domain.net \Share\ALE\Deployment\APPL\Office2K3Pr...
http://www.microsoft.com/support 168 20060824205126 20060824200825
365 A4E9DF80-79BD-11D8-8961-B932DE2EA168 Microsoft Office Professional Edition 2003 11.0.7969.0 MsiExec.exe /I{90110410-6000-11D3-8CFE-0150048383C... 20060726 Microsoft Corporation E:\MSOCache\All Users\90000410-6000-11D3-8CFE-0150...
http://www.microsoft.com/support 184 20060824205303 20060824201007
554 DTS0041.domain.net Microsoft Office Professional Edition 2003 11.0.7969.0 MsiExec.exe /I{90110410-6000-11D3-8CFE-0150048383C... 20060712 Microsoft Corporation \\domain.net\Share\ALE\Deployment\APPL\Office2K3Pr...
http://www.microsoft.com/support 169 20060824205505 20060824201204
821 CNT0017.domain.net Microsoft Office Professional Edition 2003 11.0.7969.0 MsiExec.exe /I{90110410-6000-11D3-8CFE-0150048383C... 20060713 Microsoft Corporation \\domain.net\Share\ALE\Deployment\APPL\Office2K3Pr...
http://www.microsoft.com/support 168 20060824205126 20060824201628
1093 A4E9DF80-79BD-11D8-8961-B932DE2EA182 Microsoft Office Professional Edition 2003 11.0.7969.0 MsiExec.exe /I{90110410-6000-11D3-8CFE-0150048383C... 20060726 Microsoft Corporation E:\MSOCache\All Users\90000410-6000-11D3-8CFE-0150...
http://www.microsoft.com/support 184 20060824205303 20060824201810