Deployment Solution

 View Only
  • 1.  DS 7.1 tokens for local Site Server on Subnet

    Posted Jun 23, 2014 01:51 PM

    In DS 7.1 one of the challenges is that SMA clients do not always register to a local Task Server unlike Package Services, and because DS tasks are coded to look to the Task Server to which the client connected, DS task such as images can go across WAN.

     

    Below is a sql query that can be used for mapping a client to connect local Site Server...

    SELECT TOP 1 ds.[Task Server]
    FROM [dbo].[vComputer]
    JOIN [dbo].[Inv_AeX_AC_TCPIP] ON [dbo].[vcomputer].[Guid] = [dbo].[Inv_AeX_AC_TCPIP].[_ResourceGuid]
    AND  [dbo].[Inv_AeX_AC_TCPIP].[IP Address] = [dbo].[vcomputer].[IP Address]
    JOIN [dbo].[vSubnet] ON [dbo].[vSubnet].[Subnet] = [dbo].[Inv_AeX_AC_TCPIP].[Subnet] and [dbo].[vSubnet].[Subnet Mask] = [dbo].[Inv_AeX_AC_TCPIP].[Subnet Mask]
    JOIN [dbo].[vSiteSubnetMap] ON [dbo].[vSiteSubnetMap].[SubnetGuid] = [dbo].[vSubnet].[Guid]
    JOIN [dbo].[vSite] on [dbo].[vSite].[Guid] = [dbo].[vSiteSubnetMap].[_ResourceGuid]
    JOIN (
     SELECT
      [vSite].[Name] as Site
      ,[vComputer].[Name] as [Task Server]
     FROM [dbo].[vComputer]
     JOIN [dbo].[Inv_AeX_AC_Client_Agent] on [dbo].[Inv_AeX_AC_Client_Agent].[_ResourceGuid] = [dbo].[vcomputer].[Guid]
     AND [dbo].[Inv_AeX_AC_Client_Agent].[Agent Name] = 'Deployment Task Server Handlers'
     JOIN [dbo].[Inv_AeX_AC_TCPIP] ON [dbo].[vcomputer].[Guid] = [dbo].[Inv_AeX_AC_TCPIP].[_ResourceGuid]
     AND  [dbo].[Inv_AeX_AC_TCPIP].[IP Address] = [dbo].[vcomputer].[IP Address]
     JOIN [dbo].[vSubnet] ON [dbo].[vSubnet].[Subnet] = [dbo].[Inv_AeX_AC_TCPIP].[Subnet] and [dbo].[vSubnet].[Subnet Mask] = [dbo].[Inv_AeX_AC_TCPIP].[Subnet Mask]
     JOIN [dbo].[vSiteSubnetMap] ON [dbo].[vSiteSubnetMap].[SubnetGuid] = [dbo].[vSubnet].[Guid]
     JOIN [dbo].[vSite] on [dbo].[vSite].[Guid] = [dbo].[vSiteSubnetMap].[_ResourceGuid] 
     ) ds on ds.Site = [vSite].Name
    WHERE [dbo].[vComputer].[Guid] = '%COMPUTERID%'



  • 2.  RE: DS 7.1 tokens for local Site Server on Subnet

    Posted Jun 23, 2014 04:05 PM

    DS 7.1 Token sql query for a Computer Site. SQL query is based on computer associated Site.

     

    SELECT  [vSite].[Name]
    FROM [dbo].[vComputer]
    JOIN [dbo].[Inv_AeX_AC_TCPIP] ON [dbo].[vcomputer].[Guid] = [dbo].[Inv_AeX_AC_TCPIP].[_ResourceGuid]
    AND  [dbo].[Inv_AeX_AC_TCPIP].[IP Address] = [dbo].[vcomputer].[IP Address]
    JOIN [dbo].[vSubnet] ON [dbo].[vSubnet].[Subnet] = [dbo].[Inv_AeX_AC_TCPIP].[Subnet] and [dbo].[vSubnet].[Subnet Mask] = [dbo].[Inv_AeX_AC_TCPIP].[Subnet Mask]
    JOIN [dbo].[vSiteSubnetMap] ON [dbo].[vSiteSubnetMap].[SubnetGuid] = [dbo].[vSubnet].[Guid]
    JOIN [dbo].[vSite] on [dbo].[vSite].[Guid] = [dbo].[vSiteSubnetMap].[_ResourceGuid]
    WHERE [dbo].[vComputer].[Guid] = '%COMPUTERID%'