Hi,
You can definitely manage CMDB data with RRR|Chive, but I go against
regular forms.
If you are working with ARX-files, you can not do a SYNCTOTARGET on the
first run, as the ARX-file has not been created yet.
Please do a transfertype=COPY instead in that case.
After the ARX-file has been created, you can do a
transfertype=SYNCTOTARGET to gransfer the Delta (modified and deleted
records) to the ARX-file.
If you do this at the same time as using a qualifier, you will get a
failure if the database name in the ARX-file dose not match the field
label. In this case, you can use Field IDs instead.
I guess I have to add a few things to make this more straight forward:
- Fix it so that you can do SYNCTOTARGET against empty ARX-files
- Allow for different queries against source and target, if you want to do
SYNCTOTARGET and the field names does not match
- Prevent running against Join-forms, or possibly make this supported
ADV: If anyone wants to pay me to do any of these tasks, feel free to
contact me off list :-)
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> Hi Misi,
>
> source_server = cmdbServerAtACustomerSite
> source_tcp = 7711
> source_user = dkellett
> source_password = PROMPT
> source_form = BMC.CORE:BMC_ComputerSystem
> target_dir = f:\exp
> target_form = BMC.CORE:BMC_ComputerSystem
> qual = ('Company' = "Bluechip") AND ('400127400' = "BMC.ASSET")
> AND ('400079600' = "BMC_COMPUTERSYSTEM")
> transfertype = SYNCTOTARGET
> logfile = CS.log
> loglevel = DEBUG
> progressbar = YES
>
> But yes I understand that a normal join can not be imported to etc but the
> CMDB has filters (invoke cmdb engine) to import data on MERGE.
>
> I just found this utility that looked easy to use and thought I would give
> it a go. So well done Misi, its a good tool, just wish I could use it to
> keep two CMDB's in sync :)
>
> If the list is getting bored then I am happy to take this off list I just
> thought that I would post that here as I couldn't find anyone that had
> used this tool to sync the CMDB and if we can share the information then
> great!
>
> Will try this at the regular forms too and let you know if I get the same
> error.
>
> Thanks again
> Danny
>
>> Hi,
>>
>> Sorry, I should have spotted this before...
>>
>> The source server is set to DIR, meaning a directory with ARX-files,
>> right?
>>
>> I would suspect that the ARX-file uses the database names of the fields,
>> so you have to specify those in lieu of labels.
>>
>> Please give us the first 5 lines of the ARX-file in question!
>>
>> The error does not come from the AR Server, it comes from the
>> RRR|Chive-server-simulator parsing the ARX-file...
>>
>> Best Regards - Misi, RRR AB, http://rrr.se
>>
>>> Hi List,
>>>
>>> Trying to export CMDB data with rrrChive. Anyone tried or had issues
>>> with
>>> this?
>>>
>>> I have a qual: ('Company' = "Bluechip") AND ('400127400' = "BMC.ASSET")
>>> AND ('400079600' = "BMC_COMPUTERSYSTEM")
>>>
>>> But I get this:
>>>
>>> ARLoadARQualifierStruct(server=DIR, form=BMC.CORE:BMC_ComputerSystem,
>>> qual=('Company' = "Bluechip") AND ('400127400' = "BMC.ASSET") AND
>>> ('400079600' = "BMC_COMPUTERSYSTEM"))
>>>
>>> API CALL SEVERITY: AR_RETURN_ERROR, failure, status contains details
>>>
>>> ARStatusList: contains 1 messages
>>>
>>> Number: ARERR 666001
>>>
>>> Message: Could not find field.
>>>
>>> Append: BMC.CORE:BMC_ComputerSystem:('Company' = "Bluechip") :Company
>>>
>>> I have tried with the field id too of: 1000000001 but still the same.
>>>
>>> The field is on the join form of computer system. Is there a problem
>>> with
>>> joins and rrrChive?
>>>
>>> Anyway, just thought I would ask.
>>> Thanks
>>> Danny
>>>
>>> _______________________________________________________________________________
>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>>>
>>
>> _______________________________________________________________________________
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
