Is it possible to create an event or alert everytime a phone registers with callmanager. I would like to see it displayed on the VoIP page.
Hi,
event won't work, but it should be possible via custom SQL alert. let me take a look on this.
our Engineering team has came with following custom SQL query:
SELECT DISTINCT n.Caption, vcpcd.Extension, vcp.Name, vcp.MAC_Address, vcp.IP_Address, DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), GETDATE()), vcpcd.LastRegisteredUTC) AS RegistrationTime
FROM VoipCCMPhones vcp
INNER JOIN VoipCCMMonitoring vcm ON vcm.ID = vcp.VoipCCMMonitoringID
INNER JOIN Nodes n ON n.NodeID = vcm.NodeID
INNER JOIN VoipCCMPhonesCiscoData vcpcd ON vcpcd.VoipCCMPhonesID = vcp.ID
WHERE vcpcd.LastRegisteredUTC > DATEADD(MINUTE, -1 * (SELECT CASE WHEN Value IS NULL THEN DefaultValue ELSE Value END FROM VoipConfig WHERE Name='CCMPollingIntervalMinutes'), GETUTCDATE())
AND vcp.Status = 1
please us AdvancedAlert SQL query in Orion to try it.
thanks,
Michal
