markabrand affrmwbpdhgmailcom hi tim thanks maybe right couple extra loops looking bad cheers mark 11032008 tim golden wrote tim golden wrote snip elixirbased solution realise rereading post doesnt really solve concern multiple loops etc doubt really problem spirit question heres raw sqlite solution noddy untested youve said youre newish python theres black magic fairly free generator expressions getattrfu think approach might useful need explanation feel free ask import os sys import sqlite3 import wmi osremove ctempwmidb db sqlite3connect ctempwmidb classes_wanted win32_process win32_service generate dictionary class name wmi class c wmiwmi wmi_classes dict class_wanted getattr c class_wanted class_wanted classes_wanted create simplistic sqlite table wmi class one untyped column per attribute class_name wmi_class wmi_classesitems dbexecute create table class_name join p p wmi_classproperties dbcommit wmi class add instances rows corresponding sqlite table class_name wmi_class wmi_classesitems dbexecutemany insert values class_name join p p wmi_classproperties join p wmi_classproperties getattr c p p cproperties c wmi_class dbcommit _______________________________________________ pythonwin32 mailing list kpitckaew45pythonorg httpmailpythonorgmailmanlistinfopythonwin32 wed 06 aug 2008 174641 1100 pythonwin32 advice architecting program design python