Missing Imported Software Groups after MDB Admin Console Export/Import

[Anon Anon]

Hello,

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,

Jeff

[Jean-Yves Guiblet]

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 :

 

GRP1

SWGRP

TST_GRP

 

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

 

DECLARE curs1 CURSOR FOR

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

FROM usd_swfold s1, usd_swfold s2

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

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

and s2.name='__SD_Software Library'

 

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

 

WHILE @@FETCH_STATUS=0

BEGIN

 

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

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

END

 

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.

 

 

 

Thanks.

Regards,

Jean-Yves

[Anon Anon]

Thank you Jean-Yves,

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

Thank you so much.

Jeff