CA Service Management

Hi

i want to import Router /Switches information into CMDB. i have  already exported network topology (devices and relations between them) from ca spectrum in an xml file now i want import all these in CMDB using GRloader.

Please help me with this utility to import XML file so i can see all CI's in CMDB.

for example. following is the name of xml file which i need to import. what will be the command?

networks_switch.xml

This is syntax of GRLoader:

C:\temp>grloader -help
09:30:47.084 CI and Relationship Loader for CA Service Desk Manager R17.0
Invalid option (-help ) or missing argument
Usage:
Required:
-u *** - Userid for logon
-p *** - Password for logon
-s *** - Server URL including port (I.E. http://localhost:8080

Optional:
-cfg *** - configuration file. enter grloader -hc for details
-i *** - Input XML file
-e *** - Error XML file (defaults to inputname_err.xml)
-N *** - Path to nx.env, used when running JVM only
-v - Show GRLoader version
-h - This help
-hc - configuration file help

Processing Options
-a - Allow updates to Configuration Items
-n - Allow new CIs to be created
-maxerror n - set maximum number of errors
-maxwarn n - set maximum number of warnings
-maxci n - maximum number of CIs to process
-maxrel n - maximum number of relationships to process
-cor - change order required
-iia - ignore invalid attributes
-addjar *** - adds specified jar to grloader classpath
-aer yes/no - allow embedded relationships (yes)
-P - Preload data - improves performance for large processing
-slump - use slump protocol (may require addditional configuration)
-tf *** - file name to be used to translate values of attributes
-D *** - Name prefix for relations (defaults to "GRLoader")
-I - Ignore case of lookup attributes
-E - Allow overwriting of output XML files
-ad ***=*** - Set attribute default value
-ua - Update always. Disables identical data optimization

Output Options
-T *** - Trace Level
-C - Check input XML only
-simci - simulate ci operations only
-simrel - simulate relationship operations only
-nospinner - Don't show spinner
-sc *** - show class attributes for specified class
-scx *** - generate xml for the specified class

TWA Options
-lftwa - use transaction work area(twa) instead of xml input file
-lttwa - write input file to twa
-chg *** - only process twa transactions for this change reference number
-lttwar - load transactions into the ready state
-lftwai - inactivate successful transactions

Spreadsheet Input Options
-ssf *** - filename of excel spreadsheet
-sss *** - name of sheet within excel spreadsheet
-ssfr n - first row of the spreadsheet to be imported
-sslr n - last row of the spreadsheet to be imported
-ssfc n - first col number or letter of the spreadsheet to be imported
-sslc n - last col number or letter of the spreadsheet to be imported
-sses x - separator character for multiple embedded relationships
CSV Input Options
-csvf *** - csv file name
-csvsep x - csv field separator (,)
-csvesc x - csv field escape character (\)
-csvquote x - csv quote character (")
-csvcom x - csv comment character (#)
Database Input Options
-dbdriver *** - java class name for the database driver of the input database
-dbuser *** - database username of the input database
-dbpswd *** - database password
-dbstmt *** - database select statement
-dburl *** - url used to locate the database

Replace Symbolic Options
-rs - enable symbolic replacement in the input data
*now* unique timestamp
*userid* signed on user
*inputfile* name of input file
*cicount* current ci count
*relationcount* current relationship count
09:30:47.168 GRLoader ended

you can see if it is not that easy to follow here and maybe the doc helps a bit

Using GRLoader - CA Service Management - 17.1 - CA Technologies Documentation 

Hi ChiCHen

Thanks for the information

Can you confirm me if we can export the devices in XML file directly?

GRloader is designed to load CIs to the repository so yes, though there will be some challenges doing that. Make sure you back up your mdb before running this command.

Sorry Chichen, i was supposed to ask if Can you confirm me if we can export the devices in XML file directly from CA Spectrum?

Sorry I don't know much of CA Spectrum.

Is there some other community for Spectrum? Or you can log a case with Spectrum team.

Bottom, GRLoader requires info in XML file with matching tags.

Have a look at "Chapter 9: CA Spectrum Infrastructure Manager Integrations" of the attached CA_SDM_Integrations Green book that may help...