I am facing an issue with an Item, which i have configured to use the key of a user parameter defined by me. Below are the details of the issue. Any help would be much appreciated.

Problem statement -
We need to capture the result of a SQL query (on a MS SQL database) in Zabbix GUI (in the form of a graph). We already have this SQL server host configured and monitored in Zabbix.

Action Steps -
I created a user parameter in the zabbix agent configuration file on the SQL server host machine by adding the following line -
UserParameter=pages.gen,sqlcmd -U <user> -P <pwd> -Q "<my sql query>"
I then restarted the zabbix agent service on SQL server host machine
Now I added an item for SQL server host in Zabbix with Item key as pages.gen

Issue -
I cannot see the Item value in Zabbix and last check field for this item shows up as Never.
I was able to successfully verify my user parameter from the Zabbix server command line using - zabbix_get -s <host ip> -p 10050 -k pages.gen, and it returns the correct query result.

Kindly advise me where am I going wrong here.

Ps : All values stated above within <> contain actual values, which I have not shared for security reasons.