application monitoring - application name in reports.

Math's picture

Hi juice.
I created an application monitoring policy to monitor tu usage if corel draw. The report usage / user returns me the result with “Corel Graphics Application” as application name.
How can I specify the report to use “Corel draw” as application name instead?
My application monitoring policy’s fields are:
Definition name: corel draw
Internal Name :coreldrw

Thanks a lot for your help.

(all

appologies if I posted under the wrong forum, I am not familliar with the site yet)

DeborahAlbrecht's picture

use CASE in SELECT statement

In the SELECT statement use the CASE. See Example below.

CASE WHEN [column] LIKE ‘Corel Graphics Application%’ THEN ‘Corel Draw’
END as ‘Corel Draw’

This should work for you.

Good luck!

-d

-d

Math's picture

thanks.

will try that.
much appreciated.