How to create a report for Orphan Server (Server without Application Service)

[PRADEEPREDDY GU]

Can anyone help me on this

How to create a report for Orphan Server (Server without Application Service)

[sivasankaris · Accepted solution]

Hi @PRADEEPREDDY GU ,

You can use CMDB Query Builder to get the data, but if you wanna show it in report you may Need to create Database View..

Step 1: Using CMDB Query Builder

1. Open Configuration > CMDB Query Builder.

2. Create a New query.

3. Drag the Server class onto the canvas.

4. Drag the Application Service class onto the canvas.

5. Connect them with a line.

6. Click on the connection line and check the box for No Relations (this creates a "Left Join" where the right side(relation to a server) is null).

7. Run the query.

8. There you can see the data for Orphan Servers.

Alternative Step : Creating Database View

You Need to create a database view which combines both the tables server and rel_ci and from these database view.. you need to create the report.. If you wanna go for this database view.. Let me know , will give you the steps..

If this helps, Please Mark it as helpful and please Accept My Solution...

Best Regards,

SIVASANKARI S 

[PRADEEPREDDY GU]

Hi @sivasankaris ,

1.I checked the query builder i found few servers but in those some are mapped with application service but some are not mapped.

PFA....

how do i get the exact list  Server without Application Service.

2.

Alternative Step : Creating Database View
send me the steps

[sivasankaris]

Hi @PRADEEPREDDY GU ,

Can you share the screenshots of the query builder which you created and also the rel_ci records of the server which are mapped with application server(wrongly came in the query builder..)

[Saurabh851]

Hi, Did you get this resolved?

Even I am getting the servers which have relationship with service instance.