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 ?

[AshwiniSawant]

Hi @Dr Atul G- LNG , There is no other way to fulfill this requirement ?

Even using database view as well ?

[Dr Atul G- LNG]

Hi @AshwiniSawant 

I think you can do this via a DB view. It’s similar to the Incident table and SLA task table. You’ll need to find the exact tables, meaning the AS table and the related Knowledge table, and then build a WHERE clause. Just follow the OOTB setup for incidents and task SLAs and build your DB view along the same lines.

[Devi D]

@AshwiniSawant  Create a Database view joining cmdb_ci_service(update your table name here) with kb_knowledge (left join)

in the view services with a matching KA will show the data and services without KA's will show null KA field's.

you can then build a report from this view with filter conditions

[AshwiniSawant]

Hello Devi, 

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 also used left join.

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