Hi,
Yes, you’re right. "select * from ds_computer where" will return the same result on all clients without filter like ds_name = %computername%. However, %computername% cannot be used in WMI filter.
Currently, we have two options:
1. Create a MOF file and fill some information on client so that we can query these customized information form WMI filter.
2. Change win32_operatingsystem properties, such as description and then use filter "select * from win32_operatingsystem where description like '%WMIFILTER%'". TOochange win32_operatingsystem’s properties, we can do it remotely via script or startup
script.
To create a MOF file, please refer to the following sample:
=========================
#pragma namespace ("\\\\.\\Root\\cimv2")
instance of __Win32Provider as $PropProv
{
Name="RegPropProv";
Clsid="{72967901-68EC-11d0-B729-00AA0062CBB7}";
};
instance of __PropertyProviderRegistration
{
Provider=$PropProv;
SupportsPut = TRUE;
SupportsGet = TRUE;
};
[DYNPROPS]
class WMIFILTER
{
[key]string Keyname="";
string ou;
string description;
};
[DYNPROPS]
instance of WMIFILTER
{
KeyName="WMIfilter";
[PropertyContext("local|HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Windows NT\\CurrentVersion|currentou"), Dynamic, Provider("RegPropProv")] ou;
[PropertyContext("local|HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Windows NT\\CurrentVersion|currentdescription"),Dynamic, Provider("RegPropProv")] description; };
=========================
After the MOF file has been compiled on the client machines, a WMI filter can be used that looks like this in the root\cimv2 namespace:
SELECT * FROM WMIFILTER WHERE ou="Ouname"
WMI Helps Those Who Help Themselves
http://msdn.microsoft.com/en-us/library/ms974554.aspx
To change the properties, please refer to:
$computer=gwmi win32_operatingsystem –computername "computername"
$computer.description="WMIFILTER"
$computer.put()
Thanks.
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial
to other community members reading the thread.
