Hi, we need to extract a report with Node, Application and environments assigned. Is there any way to do this?
should be doable with a dabatase query, just a bit hard to figure this out as a customer without ER-Diagram.
Maybe Jacky_Mahadab can help out here?
Try this one
use nolio_db55;select s.server_name as node_name, e.name as environment_name, a.APP_NAME as application_name, st.SERVER_TYPE_NAME as server_type_name from environments einner join applications a on a.id = e.applicationIdinner join server_type_instance ste on ste.ENVIRONMENT_ID = e.IDinner join servers s on s.id = ste.MAPPED_SERVERinner join server_types st on st.id = ste.SERVER_TYPEwhere s.server_name like 'SRV552';
ah, I was missing out on the server_type_instance table on my try to get this together