2 Replies Latest reply on Apr 29, 2019 7:14 PM by Steven Seitz

    Strip domain value from FQDN

    Steven Seitz
      Share This:

      Looking for a way to remove 3 possible domains from the DNS Name field.  The possible domains are :

       

      .net.test.com

      .utility.test.com

      .comp.pge.com

       

      I'm in the DNS Name field in BMC_ComputerSystem, The values could be (for example)

       

      computername1.net.test.com

      computername2.utility.test.com

      computername3.comp.test.com

       

      I only want the hostname in the field, not the FQDN

       

      I thought perhaps the replace function, but have not been able to determine the formula yet

       

      REPLACE ($DNS Host Name$, ?, ?)

       

      Many thanks in advance.

       

      -Steve