Exporting list of CI with Contacts

[Wong]

Hello,

I am migrating my existing CMDB to iTop and one of the features I found
missing was to be able to export a CSV/Excel list with column showing
contacts that are associated with each CI.

Is there any way for that to be possible?

Thanks everyone!

[Jeffrey Bostoen]

You're migrating to iTop, right?

And you want to import using CSV, and link contacts right away in one go?

[Vincent @ Combodo]

Execute this OQL query and "export CSV or excel" the result

SELECT A,B FROM FunctionalCI AS A JOIN lnkContactToFunctionalCI AS l ON l.functionalci_id=A.id JOIN Contact AS B ON l.contact_id=B.id

You can replace FunctionalCI class by any class below to get more information about the CI
Same thing with Contact which can be replaced by Person
In both cases keep lnkContactToFunctionalCI as is.