Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..
154 views

UCMDB Views, models, queries

Hi Team,

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.

Regards

Bhaskar

Labels (1)
0 Likes
3 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: UCMDB Views, models, queries

Hello,

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.

Best Regards,

Gabi Medan

 

 

Highlighted
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

Re: UCMDB Views, models, queries

Hello

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.

 

Regards

 

 

____________________________
Alan Alberto Rojas
uCMDB Engineer
allan-alberto.rojas.vargas @microfocus.com



Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..

Re: UCMDB Views, models, queries

@Alan Rojas Vargas , @GabiMedan1 ,

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.

Enrichment
Basic
Class Model
Data In
History
Modeling
VIEW
TQL
Management Zones
Authorization
Domains
Integrations
Reconciliation
HA
Snapshots
ViewArchive
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.