markabrand affrmwbpdhgmailcom hi necessarily wrong clear youre bothering pull server information client separately though services running server s1 appear different queried client c1 c2 maybe theres something im missing sorry client customer create table processes client varchar 100 server varchar 100 name varchar 100 status varchar 100 etc thats youre saying hey seem caption status name attributes surely sort denormalisation applies would say beware terribly tempting create databasewithinadatabase without real gain unless really offering something create wmi_objects table 11 subordinates dont db structure outlined fine try explain better quite clear mind achievable build database tables queries happening form list win32_process add instance tableprocess list win32_service add instance tableservice etc etc win32_ query wanted implement looking object based pythonic way replace loops seemed loops differ win32_ class call example would define class service class process put method class contained loop define class service class process class manager put loops manager class ways strike clumsy looking better way represent behaviour thanks assistance tim cheers mark 11032008 tim golden wrote markabrand wrote hi new python wish writing program learning experience may even get used good welcome wonderful world python purpose program retrieve store historical purposes systeminfo multiple clients multiple windows servers using tim goldens wmiwrapper broadly algorithm something like client server getinfowin32_process getinfogetwin32_service writesysteminfo toadb endfor endfor necessarily wrong clear youre bothering pull server information client separately though services running server s1 appear different queried client c1 c2 maybe theres something im missing snip slightly confused post seems mixing rdbms terminology class queries id love help mark entirely clear whether youre asking advice rdbms structures tables use data class structures fit data returned classes wearing database hat moment seems though obvious table structure description noddy structure dont usually create bunch v100 fields create table services client varchar 100 server varchar 100 name varchar 100 status varchar 100 etc create table processes client varchar 100 server varchar 100 name varchar 100 status varchar 100 etc youre saying hey seem caption status name attributes surely sort denormalisation applies would say beware terribly tempting create databasewithinadatabase without real gain unless really offering something create wmi_objects table 11 subordinates dont class structure within python sort caveats apply use python core data structures lists dicts sets tuples much possibly theyre simple welldefined theyre optimized hell back least since theyre used python part internals dont feel go around creating hierarchies classes anyway wasnt want explain plans feel free post back tjg _______________________________________________ pythonwin32 mailing list kpitckaew45pythonorg httpmailpythonorgmailmanlistinfopythonwin32 wed 06 aug 2008 174117 1100 pythonwin32 advice architecting program design python