UCMDB Views, models, queries
How to find number of Views, Models, Queries and reports present in UCMDB as a count? There are hundreds of views in our environment. so, I want to know the count of views, models, Views, Enrichment rules present in UCMDB.
Please let me know if there is a way.
There are more ways with api or from jmx /DB.
For example login to jmx and invoke jmx method "runSupportHandlersForAllCategories". In the zip fie you will download there are several files. You can check VIEW ,TQL and Enrichment files were you will find the resource count.
There is not way to get a count of the TQL,VIEW,QUERIES from the application, so you will run the support handler to get the count from the zip file or to list them from the method listresourcesbycategory and to get a list of the resources then you can export the information and to do the count. The problem it that they are xml definitions and we can not do a query to get the count, other way would be to know the tables and to do a query count easy.
Alan Alberto Rojas
Thanks for the replies,
I have used "runSupportHandlers" for below categories separately and got some useful results. and also used "listresourcesbycategory " which gave some useful information.
These categories gives most of the information related to UCMDB environment.