6 Replies Latest reply on Feb 15, 2018 2:19 AM by Marco Colombo

    My OBJLEL ETL creates entries, doesn't match to existing servers

    John Tillotson
      Share This:

      I created an OBJREL csv file using data from my CMDB.  My objective is to create a domain with my critical business applications and the servers they use.

      This all seems to work as I get the tree structure I want and the servers are added to the Business Application.

      Example shown of how one of the Business Applications is created


      2018-02-07 12:00:00;ASSERT;APP;Apps S-Z;AppsSZ;;;svc
      2018-02-07 12:00:00;ASSERT;APP;Apps S-Z;AppsSZ;APP;_ROOTAPP_
      2018-02-07 12:00:00;ASSERT;APP;SECTION 18;SECTION18_id;;;svc
      2018-02-07 12:00:00;ASSERT;APP;SECTION 18;SECTION18_id;APP;AppsSZ
      2018-02-07 12:00:00;ASSERT;SYS;RCOSVR88516;RCOSVR88516
      2018-02-07 12:00:00;ASSERT;SYS;RCOSVR88516;RCOSVR88516;APP;SECTION18_id
      2018-02-07 12:00:00;ASSERT;SYS;RCOVSVR3465;RCOVSVR3465
      2018-02-07 12:00:00;ASSERT;SYS;RCOVSVR3465;RCOVSVR3465;APP;SECTION18_id
      2018-02-07 12:00:00;ASSERT;SYS;STOVSVR0056;STOVSVR0056
      2018-02-07 12:00:00;ASSERT;SYS;STOVSVR0056;STOVSVR0056;APP;SECTION18_id
      2018-02-07 12:00:00;ASSERT;SYS;STOVSVR0057;STOVSVR0057
      2018-02-07 12:00:00;ASSERT;SYS;STOVSVR0057;STOVSVR0057;APP;SECTION18_id
      2018-02-07 12:00:00;ASSERT;SYS;RCOVSVR0385;RCOVSVR0385
      2018-02-07 12:00:00;ASSERT;SYS;RCOVSVR0385;RCOVSVR0385;APP;SECTION18_id


      The problem is that I was expecting for servers that were already in TSCO, there would be a match.  The match is made for physical Windows servers, AIX LPARs and Solaris LDOM's but not for VMware VM's or physical Linux servers.  Why match on some server types but not others?


      The first server in the list, RCOSVR88516, which is a physical Windows server is fine.  The others in the list are VM's and they don't match to existing systems.  You can see by a search there are now two entries with the same name, different sysid's.  The first one (sysid=255145) created by OBJREL, the second (219381), is the system created by my vmware ETL.

      Why do some systems types from my OBJREL ETL match (physical Windows servers, AIX & Solaris virtual machines), and other's don't (physical Linux, vmware VM's).