Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

Example SQL to Validate a Unique Service Item Name

How do I ensure prior to the Service Item being created that the name is unique...

The DDR SQL Query using the REQUESTCENTERDS datasource can be used as example code to write your DDR to validate if the Service Item name is unique and avoid errors in the SI creation...

select 'Error: Please enter a unique Name' AS ErrorDescription, count(*) AS nameCount from SiVirtualMachineInstance where upper(Name) = upper(#VMInstance.Name#) having count(*) >0 union select '' AS ErrorDescription, count(*) AS nameCount from SiVirtualMachineInstance where upper(Name) = upper(#VMInstance.Name#) having count(*) = 0

 

  • Intelligent Automation
Everyone's tags (1)
136
Views
0
Helpful
0
Replies
This widget could not be displayed.