Search results for query: *

have you run icmdba and created the logger database?

Make sure you have a label on routing client abc for route ###### mapped to dialed number abc.12334. Assuming you are doing this in version 4.6.2+ there is a tab in the dialed number utility called dialed number label. Also - FYI until you get this problem resolved calls that ICM chooses to...

FYI - CMS Is ODBC Compliant. Check with your provider on how to set this up.

How do you delete multiple task results from HP SIM 4.1 SP1? Anybody got a SQL for this? Also is there a full DB schema anywhere?

What pieces (Agent, Extension, VDN, Vector, Skill) of the Dial Plan can be 7 digits in ICM 4.6.2? What problems are there if you have 7 digit VDNs?

I have a page that uploads a file to the web server, it redirects back to itself and copies the file to the sql server and does a bcp to load the file into sql redirects back to itself again and runs a stored procedure on the sql box that joins the table populated by the uploaded file to another...

I also forgot to mention the web server is using Basic Text authentication. The sql box (version 7.0) is using NT Authentication.

I have a page that uploads a file to the web server, it redirects back to itself and copies the file to the sql server and does a bcp to load the file into sql redirects back to itself again and runs a stored procedure on the sql box that joins the table populated by the uploaded file to another...

Check this out - http://www.cisco.com/en/US/products/sw/custcosw/ps1001/products_tech_note09186a00801eb011.shtml

What type of authenication is your SQL box using - i.e. Mixed Mode, NT Authentication, SQL???

Anybody know how to use an AppGateway in an Admin Script?

Is there a way to get the DNIS to go all the way to the Agent - both PC and Phone? I need to be able to point multiple (100s) of DNIS to single VDNs but, have to preserve the DNIS.

I inherited 2 proliant 6000s, I pulled the drives and memory out of 1 of them and put them into the other. I ran the System Erase Utility. The problem I am having is when I try to run the Array Configuration Utility from the Smart Start CD after reboot it does not boot to the utility.

I kinda figured that'd happen. You really have no choice but to change your schema. And add in a table that will have a many to one relationship with both the Dpartment and Transaction tables.

Check out the CreateControl function.

Add this function to a module in your DB then call it in your SQL. Function FirstColumn(strTableName As String) FirstColumn = CurrentDb.TableDefs(strTableName).Fields(0).Name End Function Example... SELECT firstcolumn("TableName") FROM TableName;

Here ya go... select year, month1 as months from TableName union all select year, month2 from TableName union all select year, month3 from TableName order by year, months

Something like this should work.... SELECT Department.DepartmentID, TRANSACTION.TRANSACTION_ID, Business1.BusinessID, TRANSACTION.SHOP_ID FROM (Business1 INNER JOIN WorkGroups ON Business1.BusinessID = WorkGroups.BusinessID) INNER JOIN (Departments INNER JOIN [TRANSACTION] ON...

Please post your SQL

Use A Pass-Through Query to hit your SQL tables. Then include that query as a seperate "table" in a regular select query. Something like... Pass-Through Query Named Pezs: SELECT SERVICES.SERVICE_NUM, SERVICES.CLAIM_NUM, FROM SERVICES Access Query: SELECT * FROM Pezs INNER JOIN...