Just What You Needed

I have been preparing for a class, I am teaching this fall (see www.scriptingtraining.com for details), I was playing with WMI, we must show some good technical fine-tuning queries.

The best one I can think of, which I would like to share with you in this weeks column, you wrote that the WMI queries, we should be as specific as possible. Heres an example of a WMI query is not very specific: objwmi bleak, bleak colresults strcomputer , objresult , strwmiquery strcomputer = "remotexp" a objwmi = getobject ( "winmgmts:" _ strcomputer "ootcimv2") strwmiquery = "* win32_operatingsystem " a colresults = objwmi.execquery (strwmiquery) each objresult in colresults objresult.reboot next year now, it would not cause the performance of any significant growth slowdown, but notice that the query is retrieved win32_operatingsystem all instances, it retrieval of all instances of property - but not do anything with them. The script is just an example of the implementation of each boot method.

As long as possible, you want to just remove the case to meet your needs, and only performance, you need people. In such circumstances, we do not need any nature, so we should choose a single piece of a small group of fine-tuning things, as much as possible. Here for the amendment: objwmi bleak, bleak colresults strcomputer , objresult, strwmiquery strcomputer = "remotexp" a objwmi = getobject ( "winmgmts:" _ strcomputer "ootcimv2") strwmiquery = "primary, by the" _ "win32_operatingsystem Primary = true" a objwmi.execquery colresults = ( strwmiquery) each objresult in colresults objresult.reboot next year now, I only have one instance (there is usually only one), as well as my own only one property . It is, therefore, a more effective, resource friendly version of the question. Try to fine-tune your WMI queries in this fashion. This is a good practice and, in some circumstances can save time and effort.