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
SQL scripts
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
6 posts
• Page 1 of 1
Re: SQL scripts
by 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
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
Re: SQL scripts
by 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
or just look in the php-code
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
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
Re: SQL scripts
by 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
Great thanks for the pointer DomeDan appreciate it
- Chewy
- Posts: 4
- Joined: Thu Oct 03, 2013 2:36 pm
6 posts
• Page 1 of 1
Who is online
Users browsing this forum: Google [Bot], Majestic-12 [Bot] and 136 guests