vicidial.org

VICIDIAL astGUIclient discussion forum

Skip to content

Vicidial.org Home      Vicidial Forum      Vicidial Wiki      Vicidial Issue Tracker      astGUIclient Project Page


SQL scripts

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Post a reply

SQL scripts

Postby Chewy » Thu Oct 03, 2013 3:05 pm

Hey there I'm new to this system and working a bit blind so please bear with me. I'm looking at querying the Vicidial database via MSSQL using linked servers/OpenQuery for reporting on agent time stats, DMC/RPCs, list reports etc. Is there any documentation out there or any scripts anyone has to point me in the right direction - which tables I should look at or when the guys run the built in reports can I find out somewhere what SQL is running in the background?

Please let me know any more info that is needed

Many thanks
Chewy
 
Posts: 4
Joined: Thu Oct 03, 2013 2:36 pm
Top

Re: SQL scripts

Postby Natasha » Thu Oct 03, 2013 3:41 pm

MySQL running in the background :|
Natasha
 
Posts: 10
Joined: Mon Sep 30, 2013 9:51 pm
Top

Re: SQL scripts

Postby Chewy » Thu Oct 03, 2013 3:54 pm

Thanks for that :) I know it runs from MySQL thought I need to query the database from SQL Server as running a mixed environment and just need to know what queries are run against the database in any dialect of SQL thanks again
Chewy
 
Posts: 4
Joined: Thu Oct 03, 2013 2:36 pm
Top

Re: SQL scripts

Postby Chewy » Thu Oct 03, 2013 3:55 pm

this is for reporting not dialing
Chewy
 
Posts: 4
Joined: Thu Oct 03, 2013 2:36 pm
Top

Re: SQL scripts

Postby DomeDan » Fri Oct 04, 2013 5:14 am

Fire up any report in vicidial and just add &DB=1 or ?DB=1 then you will see the queries being executed for the report
or just look in the php-code :wink:
Vicidial Partner. Region: Sweden/Norway.
Does Vicidial installation, configuration, customization, add-ons, CRM implementation, support, upgrading, network-related, pentesting etc. Remote and onsite assistance.
Email: domedan (at) gmail.com
DomeDan
 
Posts: 1226
Joined: Tue Jan 04, 2011 9:17 am
Location: Sweden
Top

Re: SQL scripts

Postby Chewy » Fri Oct 04, 2013 11:07 am

DomeDan wrote:Fire up any report in vicidial and just add &DB=1 or ?DB=1 then you will see the queries being executed for the report
or just look in the php-code :wink:


Great thanks for the pointer DomeDan appreciate it :)
Chewy
 
Posts: 4
Joined: Thu Oct 03, 2013 2:36 pm
Top
Post a reply

Return to Support

Who is online

Users browsing this forum: Google [Bot] and 124 guests

Powered by phpBB® Forum Software © phpBB Group