MID Server Report and Trend

[Sangeeta Das]

Hi Folks, Any help /suggestion on this would be very much appreciated-

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)..

[Tanushree Maiti]

Hi @Sangeeta Das 

The MID Server dashboard is a central place for MID Server users to monitor ongoing operations.

MID Server dashboard 

https://www.servicenow.com/community/developer-forum/how-to-report-on-number-of-times-the-mid-server...