RTSM TQL to query nodes starting with specific letters. Does any one used such tql ?

[sanitin]

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.

[Edward_C_OMi1]

Hello,

Can you provide more details on how are you doing this, screenshots would help a lot.

[Chris_Workman]

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.

[sanitin]

Even I tired this in past but it does pick all nodes having "vdw" in the name be it in middle , end or starting.

[Chris_Workman]

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.

[Kia_Saunders]

You can try using [<first letter> - <second letter>]. I.e. [a-f]% means words that start a though f.