Hey

Do you want to export or import? Export would be something like this:

import-module smlets
$class = get-scsmclass sqlserver.database (your class here)
get-scsmobject -class $class | export-csv -path c:\temp\sqldatabases.csv (your file here)

for import check these blog post -->
http://blog.scsmfaq.ch/2011/01/02/csv-import-of-objects/
http://blog.scsmfaq.ch/2011/05/20/csv-import-of-objects-using-type-projections/

regards
Marcel

Marcel,

thanks for your answer,
SMLets work for the 2012 version?

Regards

Hi

I'm not sure if all cmdlets work, but most of them yes.

regards
Marcel

Hi Marcel,

Another question, this mechanism export relationships with other CIs?

Regards

Hi

Maybe this could be useful:

Import-module smlets
get-scsmclass system.workitem.incident$|get-scsmobject -Filter "Title -like '*hard*'"|Export-Csv -Path c:\Temp\export.csv

Change the name of the class to your specific class and give it a go!

You need to have the smlets installed for this to work (smlets.codeplex.com)

Hi,
importing data from CSV is easy. Just build up your XML file with the necessary properties you want to fill and use the import CSV wizard within SCSM in Administration, Connectors on the right side "Import from CSV file". If you need a sample please respond here.

"João Faria Gonçalves" wrote in message news:92877466-116c-4d1a-a304-6acbbeea2e5b@communitybridge.codeplex.com...

thanks for the help,

one more question, Is it possible to import data from csv file using a smlets?

I've created a tool that allows exporting configuration item classes to CSV/XML. This can then be used with the native import functionality in the Service Manager console.

Export tool:

http://gallery.technet.microsoft.com/System-Center-Server-7fddf821

Hope that helps.

Noah