RTSM TQL to query nodes starting with specific letters. Does any one used such tql ?
I am trying to create dynaminc models for Dev and QA server so that nodes could be added automatically in the respective model on the basis of sarting 3 letters- example nodes starting with "vdw" should be added to Dev Model, similarly nodes starting with "vpl" should be added to Prod model.
Can you provide more details on how are you doing this, screenshots would help a lot.
Edward Campos Monge.
Customer Support Engineer
If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation.”
If I understand your question correctly, you want to build a model that would create a CI Collection that will be automatically populated with CIs that start with the same three letters (vdw for example). We have utilized a similar method, and have had success. To make a new one I would do the following:
1. In Administration > RTSM Administration > Modeling > Modeling Studio select New Pattern Based Model.
2. When the Pattern Based Model Wizard opens select New Model, CI Collection, provide a name for the new CI Collection and select next.
3. At the query selection page select Create New Query and finish.
4. In the query builder add a node to your query and right click on it to navigate to Query Node Properties.
5. When the Query Node Properties window appears add a new criteria under the Attributes tab.
6. Attribute Name: Name, Operator: like ignore case (use %), Paramerterized: no, value: vdw%
7. click ok
8. right click the node to add to model output.
9. Save the new model.
This has worked for us in the past. I hope this helps.
If the wildcard '%' is only at the end, such as vdw%, it should only find CIs that have vdw at the beginning. If you put the wildcard on both sides, such as %vdw%, it will find vdw at any position within the name. Testing on my system confirms this for me. I hope this helps.