CMDB Group based on location with exclusion for computer name with a letter P.

[Amy Stamper]

Hello, 

I am new to CMDB and have a question.  We are trying to autofill The Approval Group, Managed by group, Change Group, and Support Group based on Location.  We have a case where if the computer name starts with the Letter P then the computer is supported by a different group. I am having trouble figuring out how to say assign by location but exclude if the Name starts with a P.  There is an option to say Name Starts With but not Name Does not start with. Anyone know how i could work around this? 

[J Siva]

Hi @Amy Stamper 
We don't have an OOB functionality. As a workaround try the below filter combinations to exclude the record where the name starts with "C" Modify the letter as per your requirement.
In the sample below I've taken "Description" field as an example. 

Explanation: 
The condition 'Description Between a and b' includes all records where the description starts with the letter 'a' or 'b'.
Similarly, 'Description Between d and none' includes all records where the description starts with 'd' and subsequent letters.
By combining these two conditions, we effectively exclude records where the description begins with the letter 'c'. Additionally, I used the 'Description is empty' condition to include records that do not have a value in the Description field.

Output:

Actual records: 

After applying the filter:

Hope this helps.
Regards,
Siva

[Pratiksha]

Try dynamic ci group. That will help you auto populate all the above fields. In cmdb query builder you can the same query suggested by @J Siva it will work.