[cisco-voip] need to create crystal reports from ipccx

[Matt Slaga (US)]

Just for FYI, there is no real difference between MSDE and full SQL
other than database size and redundancy.  All the same SQL queries and
access abilities exist in both.  The missing piece with a standard
install of MSDE is the SQL Enterprise Database tools (which I've seen
missing from more Unity installations than I care to count!).  The
enterprise admin tools can be added to any SQL server or any workstation
for that matter.  You can install these tools on a reporting PC and have
full access to the SQL database on the IPCCX server.

-----Original Message-----
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Paul Choi
Sent: Thursday, July 05, 2007 5:09 PM
To: Matthew Saskin; Zack Zilakakis (zzilakak)
Cc: James Grace; cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] need to create crystal reports from ipccx

My understanding is, if you're doing a single box of
IPCCX without failover, the rudimentary database on
the box is enough. However when configuring IPCCX for
multiple failover, a full install of SQL Server is
required on each node.

I'd surmise that if you have a fully redundant setup
for IPCCx, since you'd have a full SQL Server
installation, if you have a SQL-head around the office
you might be able to use her/him for the
report-generation.

--- Matthew Saskin <matt at saskin.net> wrote:

> Maybe I'm wrong here but can't you create an ODBC
> connection to an MSDE 
> instance (what IPCC express uses?)...I'm far from a
> windows expert but 
> thought that was possible.
> 
> Regardless, definitely doable w/ Enterprise -
> there's even a pdf 
> (hundreds of pages+) outlining the entire database
> schema.
> 
> -matt
> 
> Zack Zilakakis (zzilakak) wrote:
> > Hey James,
> >  
> > These reports are limited to what the system
> provides.  Custom reports 
> > would be available in an ICM/Enterprise
> deployment.
> >  
> > 
> >
>
------------------------------------------------------------------------
> > *From:* cisco-voip-bounces at puck.nether.net 
> > [mailto:cisco-voip-bounces at puck.nether.net] *On
> Behalf Of *James Grace
> > *Sent:* Thursday, July 05, 2007 3:11 PM
> > *To:* cisco-voip at puck.nether.net
> > *Subject:* [cisco-voip] need to create crystal
> reports from ipccx
> > 
> > ?
> > trying to find out how to create crystal report
> from the ipccx/ CM.  we 
> > notice the ipccx is not runing full SQL. so do i
> need to pull all call 
> > info from the CM SQL data base.  the problem is
> that we dont like the 
> > reports coming out of ipccx and want to create our
> own.  has anybody 
> > done this.
> >  
> > James Grace
> >  
> > Systems Engineer
> > Adcap Network Systems, Inc.
> > 6865 Shiloh Road East, Suite 250
> > Alpharetta, GA 30005
> >  
> > office: 678-456-6986
> > direct: 678-456-6761
> > jgrace at adcapnet.com <mailto:jgrace at adcapnet.com>
> > www.adcapnet.com <http://www.adcapnet.com/>
> > 
> > Disclaimer For ADCAP Network Systems
> > 
> > "The information transmitted is intended only for
> the person or entity to which it is addressed and
> may
> > contain confidential and/or privileged material.
> Any review, retransmission, dissemination or other
> use of,
> > or taking of any action in reliance upon this
> information by persons or entities other than the
> intended
> > recipient is prohibited. If you received this
> message in error, please contact the sender and
> delete the
> > material from all computers."
> > 
> > This original email was sent to the internet for
> delivery at 05 Jul 2007 15:10:50 -0400
> > 
> > 
> >
>
------------------------------------------------------------------------
> > 
> > _______________________________________________
> > cisco-voip mailing list
> > cisco-voip at puck.nether.net
> >
> https://puck.nether.net/mailman/listinfo/cisco-voip
> 
> 
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
> 



       
________________________________________________________________________
____________
Pinpoint customers who are looking for what you sell. 
http://searchmarketing.yahoo.com/
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

-----------------------------------------
Disclaimer:

This e-mail communication and any attachments may contain
confidential and privileged information and is for use by the
designated addressee(s) named above only.  If you are not the
intended addressee, you are hereby notified that you have received
this communication in error and that any use or reproduction of
this email or its contents is strictly prohibited and may be
unlawful.  If you have received this communication in error, please
notify us immediately by replying to this message and deleting it
from your computer. Thank you.