SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search
Home Blogs Calendar

Garth Jones

Dynamic Subnet Collection

select
    * 
from 
    SMS_R_System
    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.%"

Digg This
Published Jul 16 2010, 11:02 AM by Garth
Filed under: , , , ,

Comments

 

Twitter Trackbacks for Dynamic Subnet Collection - Garth Jones [smsug.ca] on Topsy.com said:

Pingback from  Twitter Trackbacks for                 Dynamic Subnet Collection - Garth Jones         [smsug.ca]        on Topsy.com

July 16, 2010 10:25 AM

This Blog

Syndication

News





Proud member of the myITforum Network

Support your community. Donate to myITforum

Locations of visitors to this page View Garth Jones's profile on LinkedIn

User Groups

SMS Add-ons

Training
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems