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

AshwiniSawant
Tera Contributor

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

 

Kindly suggest how to achieve this ?

13 REPLIES 13

Dr Atul G- LNG
Tera Patron
Tera Patron

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

 

AGLearnNGrow_0-1747136332812.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

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

 

 

Hi @AshwiniSawant 

 

could you please the database view snapshot.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hello @Dr Atul G- LNG ,

 

PFA.

AshwiniSawant_0-1747206335574.png