
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
TQL are stored in?
hi all.....
can u tell me, where are the tql stored by UCMDB.
like the "FOLDER NAME" or the "DATABASE"
PLZ HELP
P.S. This thread has been moved from Application Perf Mgmt (BAC / BSM) Support and News Forum to CMS and Discovery Support and News Forum. - Hp Forum Moderator

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Everything (discovery scripts, views, TQLs, reports etc.) is stored in the database.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Thanks for the reply......
but can you please tell me, in which schema and table is the TQL is stored.
Please help..... 🙂


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi Rohit,
By default the uCMDB stores all data like CIs, Relationships, Views, TQLs etc. in CMDB Schema.
History information is stored in CMDB History schema.
However during Installation if you have changed the Schema Name than it might get stored in some different schema.
I never saw information regarding which table the TQL's are stored in, however you can get in touch with DB team to get you the table list for that schema, that might give you an idea.
-Puneet
Puneet
If you find this reply helpful, Click the KUDOS button on the bottom to say 'Thanks'

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Puneet Thnaks for the reply....
after going through the database tables, i have found that the table name in UCMDB 9 is "CDM_TQL_QUERY_1" and the schema is UCMDB.
can u plz tell me to whome in DB i can conntect for furthure details...
Rohit


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Rohit,
I didn't understand that, i thought your question was "Which Schema/Table the TQL's are stored in?" and by your reply i am assuming that you have got the answer.
If you can explain what is your requirement, it would be helpful.
PS - TQL's are not stored in uCMDB Server unless you create a package for that.
-Puneet
Puneet
If you find this reply helpful, Click the KUDOS button on the bottom to say 'Thanks'

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
thanks for the reply puneet
my main requirment is to import the TQL in UCMDB, which was exported as XML.
but i want to import them using either JAVA code or any other way but not using the GUI tool....
PLZ HELP....

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Puneet
Thanks for telling about the packages.
using your hint my problem is solved.
Thanks Regards
Rohit