Hi
I am trying to build a database view on 4 MID SERVER TABLES
1. MID SERVER parent table where we see all the up/down Mid server
2. Mid server cluster table where, if any Mid server is part of a cluster.
3 Mid server capabilities table
4 mid server application table
my main requirement is that that on the left hand side of the table joint, I will have the main MID SERVER table and then let’s say related to a particular MID SERVER I should be able to see if that server is part of a cluster OR not , what application runs on that Mid server and what capabilities runs on that MID SERVERS. There 3-4 m2m tables available but I am unable to prepare a database view on this . Once this database view is ready then I can use that temporary table in Performance Analytics for further reporting like related to different data available on the main Mid server table
i referred to the OOB mid severs dashboard view that ServiceNow provides but I do not want to customise that and that report is not adequate to provide me with all of the above information
if I pull up a Mid server , then pertaining to that mod server I should be able to see all information including cluster or no cluster , which capabilities it is running ( rest, wmi, ssh , powershell etc) and what applications it’s running ( discovery , orchestration , etc)..
