Is there something in the phone name that in the alert you could use a contains or start with statement?
Unfortunately, no. Our naming scheme didn't allow for something like that. I did find a solution though. I created a Custom SWQL Alert, and set the SWQL condition to VOIP Phone. Then added this as the statement.
WHERE (Name LIKE 'SEPXXXXXXXXX'
OR Name LIKE 'SEPXXXXXXXXX'
OR Name LIKE 'ATAXXXXXXXXX')
AND Name NOT IN
WHERE Status = 2)
I was forced to do a SWQL alert because I found that if I just tried to alert off of the 'Status' of the phone that it wouldn't compare the Status of a phone in multiple call managers. This made the alert quite unreliable as there were multiple results in the database (Up to four - one for each call manager) and from what I can see it only evaluated the first result for each phone.
Nice! I've been trying to figure out if there's a way to use this query against a specific set of call manager nodes so that I only generate alerts for a specific customer. Do you know of any easy way to build that into the query? I'm afraid my SWQL/SQL skills are lacking.