Release Automation

Expand all | Collapse all

List servers per application and environment

Jump to Best Answer
  • 1.  List servers per application and environment

    Posted 01-17-2017 12:53 PM

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

     

    Thanks.



  • 2.  Re: List servers per application and environment

    Posted 01-18-2017 02:26 AM

    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?



  • 3.  Re: List servers per application and environment
    Best Answer

    Posted 01-18-2017 03:17 AM

    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 



  • 4.  Re: List servers per application and environment

    Posted 01-18-2017 05:12 AM

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

     

    thanks jacky



  • 5.  Re: List servers per application and environment

    Posted 01-19-2017 09:18 AM

    Thanks Jacky!