Where are the Customized Collections stored?

[Stefan Laemmer]

Hi all,
can anyone tell me where the customized collections in SIM 5.0 sp3 are stored ? I am thinking of moving my SIM to a new machine and dont want to have to start from scratch with all my Custom Collections i have. But looking around didnt find anything.

I've done a mxcollection, but i only see the tree or the members of a collection, but not the actual filters or machine names in there.

Tia!!
-Stefan

[Aravindh Rajaram]

You can get all the required info in the doc available at http://h10018.www1.hp.com/wwsolutions/misc/hpsim-helpfiles/hpsim_5_migratingNewSystem.pdf

[Stefan Laemmer]

Sorry, but i dont see anything in the pdf that says where the collections are stored. Maybe you can point me to a certain page ? Alos, the migraion procedures here dont apply to a SIM running an external SQL DB, only a local MSDE move to an external SQL DB and changing name & ip.

[Stefan Laemmer]

found it:

While migrating other things thorugh the mx commands (CLI)..
Export from old system with:
mxquery -l f > FILENAME.XML

Import to new system with:
mxquery -a -f FILENAME.XML -X force

Yeah.. The -x force is to force the system to accept systems that dont exist. The Query output has to be edited to remove the System Defaults first !!

-Stefan

PS:

Also, one needs the Collections (Queries are the old way, collections the new way)..

Export:
List all collections first (to see the names): mxcollection -ln > COLLNames.TXT

Then run for each Collection, where <"CollectionName"> is the exact name, exclosed with quotes:
mxcollection -lf <"CollectionName"> > FILENAME.XML

Import (repeat for each FILENAME):
mxcollection -a -f FILENAME.XML