Automatic import CMDB data from AD

[Kris]

Hiya all,

I'm working on the following:

I managed to build a VBS script that will fill a custom attribute for computer objects in AD.
This script uses WMI data to get the required data from the machine and stores it in 'ExtensionAttribute1' as a semicolon seperated text-string.
This script runs during the logon script, so every time a user logs on, the computer data is updated.
Then I created a script that retreives the 'ExtensionAttribute1' attribute for all computer objects and stores it in a CSV file.
Which obviously is a semicolon CSV file
I have this script scheduled to run once every hour
It takes less than a second to run... (mind you, our AD is single domain, and we only have about 250 computers)
So I created an Import template, which maps the fields from the file to the fields in CMDB.
Et voila, I can populate the CMDB with the IMPORT function.

So the question is: Can I run the import automatically, like maybe once an day, or even once an hour?
I tried the Generic Agent, but I cant quite see how that would work...

Any help would be greatly appreciated.

And if someone would like to have the scripts n stuff I'd be happy to share

Thanks!
Kris

[crythias]

Check out the otrs.ImportExport.pl script.

[Kris]

Brilliant! Thanks!

Although it throws some errors (on a import file that runs fine from the manual Import thingy) it does seem to import records.
Any ideas on the errors?

Code: Select all

C:\OTRS\OTRS\bin>perl otrs.ImportExport.pl -n 000001 -a import -i /otrs/CMDB_Import/cmdb_from_ad.txt

Read File /otrs/CMDB_Import/cmdb_from_ad.txt.
Import in process...
ERROR: OTRS-ImportExport-10 Perl: 5.12.3 OS: MSWin32 Time: Fri Jun  7 15:25:28 2013

 Message: ImportError at line 76, ErrorCode: 2012 'EOF - End of data in parsing input stream'

 Traceback (3952):
   Module: Kernel::System::ImportExport::FormatBackend::CSV::ImportDataGet (v1.29) Line: 325
   Module: Kernel::System::ImportExport::Import (v1.44) Line: 2188
   Module: otrs.ImportExport.pl (v1.3) Line: 128


Import of 75 ITSMConfigItem records: 0 failed, 75 succeeded
Import of 75 ITSMConfigItem records: 2 Changed
Import of 75 ITSMConfigItem records: 73 Skipped

[crythias]

unknown. Look here: viewtopic.php?f=62&t=17205