Unable to filter Polycom user agent in Call quality Dashboard (on-prem)

Skype for business CQD on-premise deployment by default will not add the category for third party endpoints. Following article may be helpful for adding a new category for third party endpoints.

When you try to add a user agent filter in CQD dash board, you may see the message like ' we could not find any matching record'.

I have verified manually in QOEarchive user agent table in SQL database and polycom endpoints does exist , however their category is set to NULL by default.

Create a new category for Polycom devices in user agent def table like below. I have specified a sample UAType (15000) for polycom devices.

INSERT INTO [QoEArchive].[dbo].[UserAgentDef] (UAType,UAName,UACategory)
VALUES ('15000','PolycomVVC-VVX_400-UA/','Polycom')

Update all polycom endpoints to the new UAtype/category in user agent table. Please see the sample query below.

UPDATE [QoEArchive].[dbo].[UserAgent]
SET UAType = 15000
WHERE UserAgent like 'polycom%'

Now, Polycom endpoints are assigned with a proper UAtype in user agent table.

Wait for 15 minutes to complete the Cube processing and replication. Now, you can filter the polycom user agents in CQD dashboard.


Comments (0)

Skip to main content