I believe you can also control web access using the Common Phone Profile configurations. I need to enable the "Settings Access" field for phones. Many have overridden the "Settings Access" at the phone level. Any advice? John, Are you sure 8. You would have to query for a specific phone model in BAT in order to access these settings. For instance, use BAT Update Phone to query for Cisco phones if you have those and you should then have the ability to update the "Settings Access" field.
Hi Bill, like the poster before, thanks for posting this information on your blog. I ran across it while searching for a way to find all DNs with CallFwd set. A reply you posted in a Cisco forum got me half way there but was hoping you could move me forward further towards my goal. Also is there a way to filter the DN's by first number of DN and exported into a csv file with neat and tidy columns? Current code I used from your post : run sql select d. Your wisdom will be appreciated! The callforwarddynamic table contains a timestamp value.
From what I can tell, it is modified when the CFD table is modified. The value is in epoch time. It appears you can use that value for "last known config" and then do some subtraction from current epoch time to get the value of duration.
When you say filter the DNs by first number, is your intention to only select DNs that start with a specific number or are you asking about sorting? To sort, you can use "order by n. To filter, you can use "n. The example would catch all DNs or Patterns that start with the number 3. Note, this will also catch route patterns, translations, etc..
You can use the tkpatternusage field in the numplan table to limit your query to pattern type of DN. I have multiple lines associated to the same phone and i'm trying to write a query to get only Line [1] "main line" ,any help please?? Sarah, Great question! I just published an entry that should answer your question. We also use a number of non-standard attributes to store data. Have you ever tried updating these values? If so, have you ever needed to go back and tweak after an upgrade?
To my surprise, I was actually able to update them with a 'run sql update' CLI command. Thanks for the awesome knowledge transfer!!! Hi and thanks a lot for this very useful blog. I propose you a slightly modified version of your request in order to take into account the use of extension mobility with huntgroups : run sql select lg. Hi, trying to figure out how to count unique trunks on a 8. I've tried: run sql select count tm. Jeremy, May need you to clarify the objective.
What are you classifying as a trunk? Bill, This blog entry helped me solve a problem where I needed to list DN's which are members of Line Groups - I need this as part of a data validation exercise - the customer's CUCM is all over the place as they have no management process for users who leave and new starters often just use a phone with an old staff members profile!! Anyway my query is below in case others find it useful. I figure, why not?
So, I am going to go for a query a week. Let's see how it goes. Anyone looking to build a custom query to run against their CUCM system may want to take a look at the following resources: Cisco Data Dictionaries Informix DBM resources I classify tables in the CUCM databases into three 3 categories: Standard Tables: Tables which contain the core data values of a particular object like devices, number patterns, end users, etc.
Enumeration or "type" Tables: Used by other tables to resolve enumerator IDs to some name or moniker. That is understating their purpose somewhat, but from a SQL query point of view you will use type tables mainly to resolve enumerator values to a human readable format. Mapping Tables: Basically connects unique records from one table to unique records in another table. Standard tables and mapping tables use a unique key that is always named: pkid.
Enumeration or "type" tables also have a unique key that is always named: enum. Whenever a field in a table is linked to another table or another record in the same table, the following field name conventions are used: fk x : This is a foreign key unique value in another table. That table will be named x and the foreign key field will always be pkid. The table will be named type x and the foreign key will always be enum.
The table will be named x. For some basic examples on using the various table types, you can check out one of the posts I wrote on the Chesapeake NetCraftsmen blog site. If you are going to use the CLI to execute queries in production, and are unsure of the resource impact, I recommend testing queries and monitoring your systems with RTMT to make sure you understand the impact.
Microsoft, you've really dropped the ball on this one. The reporting tool included in the resource kit looks like a developer knocked something up in a few spare minutes just to prove the functionality of the service they were developing CDR.
To top it all off there is NO schema documentation for the database that I can find , so even if you do have resources available with the necessary skills, there's an added cost while you try to sort it out. So basically for those that can customize reports, there is an additional several thousand dollars in expense developing reports. Multiply that by the thousands of companies that will probably implement this. I have something that I am writing for myself, shoot me an email and I'll send you some info.
Send the email to imwire [at] eventure. I apologize for the plug, but Instant Technologies has developed a very nice, easy to use, application to displaying a lot of the information that you may require from the logs. Information is available www. Specifically, our application is an asp. We have recently ported this to OCS We are also looking at providing additional searching and reporting.
Sign in. United States English. The idea is very nice, because for things like statistics this implementation is ideal:. Thank you for the post. I am not familiar with the functionality in MySQL. Can you please explain it? Would be very cool from Microsoft, if they would include something like this! Related Articles. How to rename a SQL Server database. How to determine SQL Server database transaction log usage. Understanding how SQL Server stores data in data files. Copy a SQL Server database with just the objects and no data.
How to stop and start SQL Server services. Popular Articles. Rolling up multiple rows into a single row and column for SQL Server data.
0コメント