Re: WQL Query

Tech-Archive recommends: Fix windows errors by optimizing your registry

Yes, you can added more subnets as needed, don't forget that you need to add
an "OR" for each new subnet.

"Paul" <Paul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:04A89A70-115B-46FE-AE27-BEE617983A4F@xxxxxxxxxxxxxxxx
Garth,
Thanks for the info, If I need to scan multiple subnets then I assume you
just add SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress like
"x.x.x.%"
for the other subnets?

Regards
Paul

"garth" wrote:

This should do the trick. The text in Red will find all WS with an IP
address that begins with "192.168.1."

select distinct SMS_G_System_COMPUTER_SYSTEM.Name,
SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress from SMS_R_System
inner join SMS_G_System_COMPUTER_SYSTEM on
SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner
join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION on
SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceID =
SMS_R_System.ResourceId where
SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress like "192.168.1.%"


"Paul" <Paul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C937A1F1-EE87-4EFC-9F2D-8B77B6448F02@xxxxxxxxxxxxxxxx
Hi
I need some help writing a query. What I need to do is create a
collection
of all machines using specific subnets so I can deploy a application to
them.
Any help worul be great


.

Relevant Pages

  • Re: Windows XP network problem...
    ... Look into setting up a DHCP server utilizing DDNS to resolve host names ... across multiple subnets. ... But, if you have pre-windows 2000 machines, then you're pretty much ... > Windows recognizes names instead of IP addresses for network requests, ...
    (microsoft.public.win2000.networking)
  • Re: NetBIOS Problem
    ... I have multiple WinXP and a couple of Win98 machines on a network. ... the subnets, which tells me that I do have IP connectivity. ...
    (microsoft.public.windowsxp.network_web)
  • Re: Graduate deployments
    ... I have about 6500 machines that I want to accomplish ... include subnets. ... This will prevent multiple clients from being sent ... Add additional site boundries as you want to ...
    (microsoft.public.sms.swdist)
  • Re: NetBIOS Problem
    ... I have multiple WinXP and a couple of Win98 machines on a network. ... NetBIOS enabled printers. ... the subnets, which tells me that I do have IP connectivity. ...
    (microsoft.public.windowsxp.network_web)
  • Re: NetBIOS Problem
    ... I have multiple WinXP and a couple of Win98 machines on a network. ... NetBIOS enabled printers. ... the subnets, which tells me that I do have IP connectivity. ...
    (microsoft.public.windowsxp.network_web)