Creation of report of the server table with a running process

[Bhaskar Banerj1]

I have a server table, in which each server has around 60-70 running processes under it. One of the processes is named as: "Test". I want to make a report of the list of servers which do not have the "Test" process under it. I have tried using the filter conditions, but it is not showing the correct result. I tried scripting but could not find the condition "not one of" so I can select the needed servers that do not have "Test" as running process. What can I do to get this report accurately ? 

[Sam Ogden]

Hi Bhaskar,

You can use the related list condition in the report builder to achieve this.  In my PDI I created a running process called 'Test' linked to just one server:

I have a total of 40 servers on the instance:

I created a report with the following 'No selected table records are related to a record' related list condition:

This brought back 39 results:

Hope this helps.

Thanks

Sam

[Bhaskar Banerj1]

Hi Sam,

I tried you solution, but am facing a small problem. When I am creating the report following your conditions, it is only returning the servers which has no running processes. For example if a server does not have "test" process but has 3-4 other running processes, it is not getting displayed in the report.

Do you have a solution for this ? 

Thanks,

Bhaskar

[Sam Ogden]

Hi Bhaskar,

I'm taking it then you want a list of all servers that have running processes against them, but exclude any where the only running process is "Test", if my understanding is correct then you just need to adjust the related list condition:

Update the condition to use 'Greater than or Equal to 1' and then the name is not the name of the process you want to exclude

I included adding running processes to 3 servers, OWA-SD-01 has Test and ServiceNow as running processes, SAP LoadBal01, just has ServiceNow as a running process and PS LoadBal01 has just Test as a running process, as you can see it brings back the 2 expected results

Hope this helps

Thanks

Sam

[palanikumar]

There is no direct option available. You can create a database view between server and process table with left join enabled and get the desired output