Auto Importing Config Items from SCCM server

[Gunjan]

Hi,

I am using OTRS ITSM 3.3.12. Can I import config items in OTRS CMDB from SCCM Server automatically? If yes, it would be great if someone can provide me the steps to do so.

Regards,
Gunjan

[BIG_jan]

Export-CSV from SCM and import into CMDB

Export daily to a defined path
import via cron-job "OTRS\bin\otrs.ImportExport.pl"

[Gunjan]

How will we define the path of the csv file in the script file?

[Gunjan]

Hi,

Can anyone please let me know how I can create a cron job to do the importing?

Regards,
Gunjan

[EXG133]

Best way is to create a file in /opt/otrs/var/cron
Have a look in the files there for examples. After you have created the file make sure the rights on the new file are the same as the other files and restart the otrs service.
If you want to know the possible parameters just run it with an -h as parameter

/opt/otrs/bin/otrs.ImportExport.pl -h

[Gunjan]

Hi,

Thanks for info. I created a cron job. Can you please let me know how to check whether it is running or not? I am also getting a notice info in Logs:

[Notice][Kernel::Language::FormatTimeString] No FormatTimeString() translation found for '03/20/2015 00:00:00' string!

not sure if this causing the issue.

Thanks you in Advance!

Regards,
Gunjan