[cisco-voip] Video enabled handsets

James.Brown at barclayswealth.com James.Brown at barclayswealth.com
Wed Oct 27 13:49:43 EDT 2010


Hi Stephen,

We have used the AXL toolkit (available via ccmadmin) to perform SELECTs and the occasional UPDATE (but never an INSERT).

I would also be very grateful for a copy of the tool.

Regards

James.

________________________________
From: Nate VanMaren [mailto:VanMarenNP at ldschurch.org]
Sent: 27 October 2010 18:44
To: stephen.welsh at unifiedfx.com; Brown, James : Barclays Wealth
Cc: cisco-voip at puck.nether.net
Subject: RE: [cisco-voip] Video enabled handsets

I'd love to have access to that tool.

-Nate

From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of stephen.welsh at unifiedfx.com
Sent: Wednesday, October 27, 2010 10:26 AM
To: <James.Brown at barclayswealth.com>
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Video enabled handsets

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<mailto:James.Brown at barclayswealth.com>> <James.Brown at barclayswealth.com<mailto: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<http://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> [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of John.VanLaecke at ghd.com<mailto: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<mailto:cisco-voip at puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip



NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20101027/d5f7a3c8/attachment.html>


More information about the cisco-voip mailing list