CA Client Automation

 View Only
  • 1.  Missing Imported Software Groups after MDB Admin Console Export/Import

    Posted Feb 25, 2016 03:23 PM


    I exported the Software Groups from one manager and imported into a new manager.

    Many of the Software Groups imported and were populated with the Software Packages.

    While comparing the Software Groups to confirm the import there are a few SWG that are not visible inn Software Package Library.

    I attempted to manually create the missing SWG and  received a message the SWG already exists.

    I then checked EVERY SWG that I have to see if it was created another SWG.

    They do not.

    I queried the dbo.usd.swfold table in the MDB and it shows the group name I am missing.

    Has anyone seen this before and know how to fix it?

    Going to open an issue as well.


    Please advise,


  • 2.  Re: Missing Imported Software Groups after MDB Admin Console Export/Import
    Best Answer

    Broadcom Employee
    Posted Feb 26, 2016 11:21 AM

    Hi Jeff,


    MDB Admin Console tool is exporting and importing the Software Group by using alphabetic order.

    This could cause a problem for some subgroups.


    For example :

    A Software Group "SWGRP" contains 2 subgroups "GRP1" and "TST_GRP"

    MDB Admin Console will export/import the SW groups in this order :






    During import of GRP1, the group will be created in table usd_swfold but as group SWGRP does not exist already, the link between SWGRP and GRP1 is not created (in table usd_link_swgrp).

    So group GRP1 is present in database in table usd_swfold but it is not visible in ITCM GUI.


    Import of group TST_GRP has not this problem as the group SWGRP is present during importation. So link could be created.


    In order to repair this problem, you could execute this SQL procedure on the mdb :



    DECLARE @objectid1 BINARY(16)

    DECLARE @objectid2 BINARY(16)

    DECLARE @date INT



    SELECT s2.objectid, s1.objectid,DATEDIFF(ss, convert(datetime,'19700101'), getdate())

    FROM usd_swfold s1, usd_swfold s2

    WHERE<>'__SD_Software Library' and s1.type=1

    and s1.objectid not in (select grpchild from usd_link_swgrp)

    and'__SD_Software Library'


    OPEN curs1 FETCH NEXT FROM curs1 INTO @objectid1, @objectid2, @date





       INSERT INTO usd_link_swgrp VALUES (@objectid1, @objectid2, @date)

       FETCH NEXT FROM curs1 INTO @objectid1, @objectid2, @date



    CLOSE curs1

    DEALLOCATE curs1



    The missing software groups will appear under Software Package Library.

    Then you could Cut/Paste them to put them under the correct Software Group.







  • 3.  Re: Missing Imported Software Groups after MDB Admin Console Export/Import

    Posted Feb 26, 2016 01:20 PM

    Thank you Jean-Yves,

    The script worked perfectly. A little tedium to get them reorganized, but fixed my problem.

    Thank you so much.