Hi Marco,
Thanks for your feed-back.
I should rephrase my initial question...
The main purpose to obtain the Group and URL from the url_response probe is to get them on reports or queries to the database, later on.
Although it's very useful to get the Group and URL on the alert message, we are unable to extract and treat that information to a report (having those values in separate columns, for every alarm).
So, we were inspired by your suggestion and are using another field (source override) to insert both Group and URL on each alarm (separated by a pipe "|" character).
In this way we are able to get these two values on a column, for each and every url_response alarm.
This would allow us to know how many alarms were created for each URL or Group of URLs, by querying the NAS_TRANSACTION_SUMMARY alarm table on UIM.
However, we have a problem. Currently we are unanle to separate the two values in two separate columns...
Example:
select source from [uim].[dbo].[NAS_TRANSACTION_SUMMARY] where supp_key='URLResp/mysite.com/httpError'
This returns both the URL and Group on the same column (source).
Unfortunately, SQL Server 2014 doesn't provide a built-in SPLIT function (T-SQL).
Do you know if UIM has created any stored procedure on the DB that would allow me to do it?
Do you know any other way of splitting the two values into two different fields/columns ?
Is it possible to create our own SQL functions on the UIM Database?
Thanks