Is there a report that will show what services are on what devices?

[hankej]

I am wondering if there was some report or some way to see what phones have what services on them?  Phone move around quite a it in my environment and am I afraid a Panic button service, customized for a certain area, may have left that particular place.  So I would like to get a list of all my phones and the services that are on each particular phone.

Any suggestions would be great.

Thanks

[William Bell]

You may be able to get that information using the Bulk Admin tool phone report. Personally, I use a query method. A simple example is provided here:

http://www.ucguerrilla.com/2012/06/querying-ip-phone-service-subscriptions.html

You could tweak the sample query and add a "where clause" to focus just on your "Panic button" service.

HTH.

-Bill (http://ucguerrilla.com)

[hankej]

This is great.  Thank you Bill.  I assume this should be run on the subscriber?  I tried running it on the publisher and got an error:

"Column (fxDevice) not found in any table in the query (or SLV is undefined).  Here is my statment:

Thank you