want to see applications services having knowledge article and without knowledge articles in report

[AshwiniSawant]

User want to see applications services having knowledge article and without knowledge articles in report.

Kindly suggest how to achieve this ?

[Dr Atul G- LNG]

Hi @AshwiniSawant 

The question is how you are attaching a knowledge article to an AS. Is it in the related list? If yes, create a report in the AS table and include the knowledge-related list in the related lists, with a count of zero or more. Like this

[AshwiniSawant]

Hello @Dr Atul G- LNG ,

Thank you for your prompt response. 

Currently I am using Application Services (cmdb_ci_service_auto) and Knowledge related to products (m2m_kb_ci). 

I have created database view for this. But I'm not getting expected results, I'm only getting all application services which are not having knowledge article attached to them. 

regards,

Ashwini

[Dr Atul G- LNG]

Hi @AshwiniSawant 

could you please the database view snapshot.

[AshwiniSawant]

Hello @Dr Atul G- LNG ,

PFA.