ITMS Administrator Group

 View Only

  • 1.  Site Management - Need help to create dynamic Filters based on Site

    Posted Feb 11, 2014 07:01 PM


    First off, our AD Site to subnet assignment is unusable, too messy.

     

    I created Sites and Subnets manually, assigning subnets to sites.  Now I am stump on how to create Filters based on the Sites I created, so that It would display desktops and servers or is there a better way of doing this?

    Thanks 



  • 2.  RE: Site Management - Need help to create dynamic Filters based on Site

    Posted Feb 12, 2014 01:50 PM

    Can anyone help me with this?



  • 3.  RE: Site Management - Need help to create dynamic Filters based on Site

    Posted Feb 12, 2014 03:17 PM
    select                              
    comp.[Guid]                
    from vSubnet sub                              
    left join vSiteSubnetMap vss on vss.[SubnetGuid] = sub.[guid]                              
    left join vSite vs on vs.[Guid] = vss.[_ResourceGuid]                              
    join vItem vi on vi.[guid] = sub.[Guid]                              
    join Inv_AeX_AC_TCPIP tcp on tcp.[subnet] = sub.[Subnet]                              
    join vComputer comp on comp.[guid] = tcp.[_ResourceGuid]                             
     
    Where vs.Name like '%SITENAMEGOESHERE%'
     
    oR 
     
    select guid from vcomputer vc 
    Left Join [Inv_AeX_AC_TCPIP] tcpip On vc.Guid = tcpip.[_ResourceGuid]
    And tcpip.[_id] = ( Select top 1 tcpip2.[_id] From [Inv_AeX_AC_TCPIP] tcpip2  
    Where vc.Guid = tcpip2.[_ResourceGuid]   
    AND tcpip2.[IP Address] NOT IN ('127.0.0.1', '0.0.0.0', '')   
    AND tcpip2.[IP Address] IS NOT NULL  Order By tcpip2.[IP Address] Asc
    )
     
    left join  vSubnet sub on tcpip.[subnet] = sub.[Subnet]
    left join vSiteSubnetMap vss on vss.[SubnetGuid] = sub.[guid]  
    left join vSite vs on vs.[Guid] = vss.[_ResourceGuid] 

    Where vs.Name like '%SITENAMEGOESHERE%'

     

    If this works mark as solution please



  • 4.  RE: Site Management - Need help to create dynamic Filters based on Site

    Posted Feb 12, 2014 03:46 PM

    I've had a very similar experience with our AD environment being pretty much unusable.

    To counter this with filters, I've had to create custom SQL filters following the same information created in the sites you've made.  I know this is kind of double work for organizing subnet data, but it works for us.

    So first, is creating a new filter: Raw SQL:

    SELECT
       [vri1_Computer].[Guid],
       [vri1_Computer].[Name]
    FROM
       [vRM_Computer_Item] AS [vri1_Computer]
          LEFT OUTER JOIN [Inv_AeX_AC_TCPIP] AS [dca2_AeX AC TCPIP]
             ON ([vri1_Computer].[Guid] = [dca2_AeX AC TCPIP].[_ResourceGuid])
    WHERE
                ([dca2_AeX AC TCPIP].[Subnet] between N'160.22.80.0' and N'160.22.99.254') --LAN
                or
                ([dca2_AeX AC TCPIP].[Subnet] between N'160.22.100.0' and N'160.22.114.254') --LAN
                or
                ([dca2_AeX AC TCPIP].[Subnet] between N'160.22.116.0' and N'160.22.127.254') --LAN      
                or
                ([dca2_AeX AC TCPIP].[Subnet] between N'10.20.116.0' and N'10.20.119.255') --Wireless

    Then you will have to create an update membership task to keep this data current at regular intervals.

    I hope this heps. 



  • 5.  RE: Site Management - Need help to create dynamic Filters based on Site
    Best Answer

    Posted Feb 12, 2014 04:21 PM

    Here is an easier method:-  https://www-secure.symantec.com/connect/blogs/how-create-site-filters-based-manually-created-sites



  • 6.  RE: Site Management - Need help to create dynamic Filters based on Site

    Posted Feb 12, 2014 07:40 PM

    Thanks Guys!