I don't think you are going to get this via OQL and I'm not sure you would be able to get it as a PDF because of two things. First, FunctionalCI doesn't include a field for Asset and serialnumber by default, you would need to pull back info from a sub class. Second, the contact connection is a one to many using a linking table so you wouldn't get that in your standard grid. If you have access to the MySQL database you can definitely run a standard T-SQL query to get this info then export it as a csv. An example for a Server finalclass would be "SELECT s.name,s.asset_number,s.serialnumber,c.friendlyname from view_Server AS s JOIN lnkcontacttofunctionalci AS l ON l.functionalci_id = s.id JOIN view_contact AS c ON l.contact_id = c.id;"
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hey,
I have to export some data as PDF file. The information I need is:
Can someone help me to figure out the query?
I don't think you are going to get this via OQL and I'm not sure you would be able to get it as a PDF because of two things. First, FunctionalCI doesn't include a field for Asset and serialnumber by default, you would need to pull back info from a sub class. Second, the contact connection is a one to many using a linking table so you wouldn't get that in your standard grid. If you have access to the MySQL database you can definitely run a standard T-SQL query to get this info then export it as a csv. An example for a Server finalclass would be "SELECT s.name,s.asset_number,s.serialnumber,c.friendlyname from view_Server AS s JOIN lnkcontacttofunctionalci AS l ON l.functionalci_id = s.id JOIN view_contact AS c ON l.contact_id = c.id;"