List servers per application and environment

[Legacy User]

Hi, we need to extract a report  with Node, Application and environments assigned. Is there any way to do this?

 

Thanks.

[Michael Gebhardt]

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?

[Jacky_Mahadab]

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 e
inner join applications a on a.id = e.applicationId
inner join server_type_instance ste on ste.ENVIRONMENT_ID = e.ID
inner join servers s on s.id = ste.MAPPED_SERVER
inner join server_types st on st.id = ste.SERVER_TYPE
where s.server_name like 'SRV552';

 

 

Thanks

Jacky 

[Michael Gebhardt]

ah, I was missing out on the server_type_instance table on my try to get this together 

 

thanks jacky

[Legacy User]

Thanks Jacky!