How to edit condition in 'Total CI' in CMDB Workspace

saranyavs
Tera Expert

Hi All,

 

How to Edit condition in Total CI in CMDB Dashboard, currently it showing all ICs including retired, We need only Operational CIs. Please assist where to modify the condition.

 

saranyavs_1-1739185430388.png

 

Regards,

Saranya

 

6 REPLIES 6

Saurabh Singh3
Kilo Guru

Hi Saranya,

 

I am assuming that you are checking the OOB CMDB Dashboard you can just go the All reports (sys_report) and search for this particular report name in that list search with "Total CI" you should be able to find them.

If its OOB please be advised its best practices to copy the report and do the changes as reqiured on the filter condition.

 

Regards,

Saurabh

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @saranyavs 

 

Go to pa_indicators table and search for the total CI.

 

 

AGLearnNGrow_0-1739189707280.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]

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

Thank you for the reply.

 

I checked the source, but Base aggregate Data table is mentioned,there is no cmdb_ci table .

 

saranyavs_0-1739194175521.png

 

Yes, that true @saranyavs 

Yes, you can add conditions similar to how you have conditions on the state.

*************************************************************************************************************
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]

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