[cisco-voip] Video enabled handsets

[stephen.welsh at unifiedfx.com]

Hi James & group,

I created a windows command line utility I called RUNSQL.EXE ages ago, it basically communicates to UCM remotely and executes SQL statements on the UCM database (like the one from James and other similar threads before this one).

The primary advantage of having this facility as a command line utility, was the ability to save the results to a local CSV file etc. instead of trying to examine a SSH Log file.

So for John's problem of reporting on video enabled devices it would save the results to a CSV file for further analysis in Excel etc.

I guess two questions:

1) Has anyone seen a tool like that before?
2) Would anyone other than me find it useful?

Also,
One feature I used if for was SQL Updates, for example I was able to bulk configure items that either BAT didn't cover, or was just too painful to do in certain versions of UCM, for example Bulk Presence Licensing. Do many people like me perform SQL Updates at points?

Thanks

Stephen


On 27 Oct 2010, at 09:24, <James.Brown at barclayswealth.com> <James.Brown at barclayswealth.com> wrote:

> Maybe there are more efficient ways, but here is what I would do...
>  
> 1. Connect to CLI
> 2. Execute run sql SELECT a.name FROM Device a WHERE a.xml LIKE '%<videoCapability>1</videoCapability>%'
>  
> Regards
>  
> James.
> 
> From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of John.VanLaecke at ghd.com
> Sent: 27 October 2010 03:17
> To: cisco-voip at puck.nether.net
> Subject: [cisco-voip] Video enabled handsets
> 
> Hey all, 
> 
> Anyone know how I can report all devices that have video enabled ? 
> 
> Regards,
> 
> John Van Laecke 
> Senior Voice Engineer
> 
> _____________________ 
> This email and all attachments are confidential. For further important information about emails sent to or from GHD or if you have received this email in error, please refer to http://www.ghd.com/emaildisclaimer.html .
> _____________________ 
> This e-mail has been scanned for viruses by MessageLabs.
> 
> Barclays Wealth is the wealth management division of Barclays Bank PLC. This email may relate to or be sent from other members of the Barclays Group.
> 
> The availability of products and services may be limited by the applicable laws and regulations in certain jurisdictions. The Barclays Group does not normally accept or offer business instructions via internet email. Any action that you might take upon this message might be at your own risk.
> 
> This email and any attachments are confidential and intended solely for the addressee and may also be privileged or exempt from disclosure under applicable law. If you are not the addressee, or have received this email in error, please notify the sender immediately, delete it from your system and do not copy, disclose or otherwise act upon any part of this email or its attachments.
> 
> Internet communications are not guaranteed to be secure or without viruses. The Barclays Group does not accept responsibility for any loss arising from unauthorised access to, or interference with, any Internet communications by any third party, or from the transmission of any viruses. Replies to this email may be monitored by the Barclays Group for operational or business reasons.
> 
> Any opinion or other information in this email or its attachments that does not relate to the business of the Barclays Group is personal to the sender and is not given or endorsed by the Barclays Group.
> 
> Barclays Bank PLC. Registered in England and Wales (registered no. 1026167).
> Registered Office: 1 Churchill Place, London, E14 5HP, United Kingdom.
> 
> Barclays Bank PLC is authorised and regulated by the Financial Services Authority.
> 
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20101027/1807942a/attachment.html>