myITforum and Windows IT Pro Forums

 Is it possible to create a collection based on site boundaries?

Author Message
bmair

  • Total Posts : 311
  • Scores: 0
  • Reward points : 32500
  • Joined: 3/3/2003
  • Location: Da Bronx
  • Status: offline
Is it possible to create a collection based on site boundaries? Tuesday, August 16, 2011 12:27 PM (permalink)
0
Hi all!
 
I was just wondering if it is possible to create a collection based on the site boundary of a site - for example a secondary site?  For example, if the boundary is like 123.45.67.1 - 123.45.67.139; 123.54.76.30 - 123.54.76.45. 
 
For boundaries like my example, a query based on the IP addresses would be too cumbersome.  So, I started thinking it would be nice if I could just tie it to the site boundaries.  I searched but couldn't find anything helpful.
 
Thanks in advance,
Bancroft
Affiliated Computer Services, Inc.
Information Management Senior Analyst
New York, New York
 
#1
    skissinger

    • Total Posts : 5126
    • Scores: 504
    • Reward points : 198060
    • Joined: 9/13/2001
    • Location: Sherry Kissinger
    • Status: offline
    Re:Is it possible to create a collection based on site boundaries? Tuesday, August 16, 2011 12:46 PM (permalink)
    0
    what boundaries a box is in is queries from the client to either AD or to your SLP; and happens dynamically.

    I don't think that is ever reported via inventory.

    The only thing might be is *if* your boundaries are always based solely on ADSites, then you could use that; because ADSite is reported in v_r_system from heartbeat.

    But it looks like you use IPranges.  So I think you're SOL

    I'm thinking... IPSubnets.  and #2 has some blog about how to query using a range with multiple periods. (like IP subnet).  This isn't specifically for ipsubnet, but I think it'll give you an idea:  http://myitforum.com/cs2/blogs/jnelson/archive/2008/10/17/123258.aspx

    The only problem with that is that's SQL, not WQL.  I don't think WQL let's you use the braces  [ ]
    mofmaster@myitforum.com
    My Blog
    Microsoft MVP 2007-2015 - ConfigMgr
     
    #2
      bmair

      • Total Posts : 311
      • Scores: 0
      • Reward points : 32500
      • Joined: 3/3/2003
      • Location: Da Bronx
      • Status: offline
      Re:Is it possible to create a collection based on site boundaries? Tuesday, August 16, 2011 1:40 PM (permalink)
      0
      Thanks, skissinger,
         This does look interesting.  I will give it go and see what happens.
      Bancroft
      Affiliated Computer Services, Inc.
      Information Management Senior Analyst
      New York, New York
       
      #3
        msutliff

        • Total Posts : 211
        • Scores: 6
        • Reward points : 46790
        • Joined: 7/31/2003
        • Location: Oklahoma
        • Status: offline
        Re:Is it possible to create a collection based on site boundaries? Friday, April 27, 2012 1:12 PM (permalink)
        0
        I had to do something similar today.
        To make a collection based on the IP Ranges: 
        10.18.16.0/20 and 10.18.32.0/20
         
        Select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where
        SMS_R_System.IPSubnets like '10.18.1[6-9].0'  
        or SMS_R_System.IPSubnets like '10.18.4[0-7].0'  
        or SMS_R_System.IPSubnets like '10.18.[2-3][0-9].0'
         
        #4
          theChad

          • Total Posts : 4
          • Scores: 0
          • Reward points : 28470
          • Joined: 8/24/2010
          • Location: Dallas, Texas
          • Status: offline
          Re:Is it possible to create a collection based on site boundaries? Monday, May 07, 2012 6:13 PM (permalink)
          0
          We ensure our Boundary descriptions are consistent and meaningful, then use the query below to build a location based collections from them.
          select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System  inner join SMS_Boundary on SMS_Boundary.Value = SMS_R_System.IPSubnets  where SMS_Boundary.DisplayName = "BoundaryDescription"

           
           
           
          #5
            Darren

            • Total Posts : 99
            • Scores: 2
            • Reward points : 53470
            • Joined: 10/25/2007
            • Status: offline
            Re:Is it possible to create a collection based on site boundaries? Monday, May 15, 2017 3:39 PM (permalink)
            0
            Have you had any success using this (or another) query with wildcards?
            example below wanting to include New York and Boston, but exclude Los Angeles:
            select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_Boundary on SMS_Boundary.Value = SMS_R_System.IPSubnets where SMS_Boundary.DisplayName = "EAST%"
             
            Boundary descriptions:
            • EAST New York
            • EAST Boston
            • WEST Los Angeles
             
            #6
              gjones

              • Total Posts : 2802
              • Scores: 146
              • Reward points : 232080
              • Joined: 6/5/2001
              • Location: Ottawa, Ontario, Canada
              • Status: offline
              Re:Is it possible to create a collection based on site boundaries? Tuesday, May 16, 2017 8:40 AM (permalink)
              0
              You need to use like and not "=" within the query.
               
              #7
                theChad

                • Total Posts : 4
                • Scores: 0
                • Reward points : 28470
                • Joined: 8/24/2010
                • Location: Dallas, Texas
                • Status: offline
                Re:Is it possible to create a collection based on site boundaries? Tuesday, May 16, 2017 8:55 AM (permalink)
                0
                If you want the criteria to be New York and Boston, why use East as the keyword?
                Start with
                select  SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType,  SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier,  SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client  from  SMS_R_System inner join SMS_Boundary on SMS_Boundary.Value =   SMS_R_System.IPSubnets

                and try these limiting statements...
                where SMS_Boundary.DisplayName like "EAST%" and SMS_Boundary.DisplayName not like "%Los Angeles%"

                where SMS_Boundary.DisplayName like "%New York%" or SMS_Boundary.DisplayName like "%Boston%"

                 
                #8
                  Online Bookmarks Sharing: Share/Bookmark

                  Jump to:

                  Current active users

                  There are 0 members and 1 guests.

                  Icon Legend and Permission

                  • New Messages
                  • No New Messages
                  • Hot Topic w/ New Messages
                  • Hot Topic w/o New Messages
                  • Locked w/ New Messages
                  • Locked w/o New Messages
                  • Read Message
                  • Post New Thread
                  • Reply to message
                  • Post New Poll
                  • Submit Vote
                  • Post reward post
                  • Delete my own posts
                  • Delete my own threads
                  • Rate post

                  2000-2017 ASPPlayground.NET Forum Version 3.9