Hi Keith,

The enhancement for the Reports section is under development and will be available in our future updates. As of now you can connect the database using Crystal reports and generate the desired reports. Please send us your contact details to support@servicedeskplus.com and we will send you the details on how to connect to the database and the tables to query for reports.

Hope this helps.

Regards,

Ankit

Dear Ankit,

Thanks a lot for your kind help. You can send me the details to my e-mail : ordinaryboyz2000@yahoo.com.

Hi
I also need to generate report. Please send me the procedure too.
nthoo@iaspire.net

Please also send me the info to connect to db and tables info.
Nickk@fieldchem.com
Thx

Nick

I would like connect to generate reports too. Please send to me the procedures too.

thiago dot moreira at elkem dot com

Please email me with the details for running reports via Crystal / Excel - will this provide a workaround for the problem with 'last month' reports now woking?

My email address is stevec@manx-telecom.com. Thanks

I would like the CR connection information as well. jonathan@agiletech.com

Hi
I also need to generate report. Please send me the procedure too.
jpicornell@miquel.es

Thank you.

Hi,

so i think i'm not the last one... Please send me the procedure too. Because the custom reports not flexible enought to me.

R.novacek@blutspende.de

...and i want it the details too. Please send to me the procedures.

jmorera@colmena.cl

I would also the details. Thank you.
tberg (at) quickparts.com

That would be very useful. Please send them to me also. I am evaluating so I need to see if the product will work for me.

scott2020@lakeregional.com

Many persons need the procedure , could you Post it to web site?

[quote="ankit"]Hi Keith,

The enhancement for the Reports section is under development and will be available in our future updates. As of now you can connect the database using Crystal reports and generate the desired reports. Please send us your contact details to support@servicedeskplus.com and we will send you the details on how to connect to the database and the tables to query for reports.

Hope this helps.

Regards,

Ankit

hello,
I am very interesting too,
mykola007(at)mail.ru

Thank you in advance
Mykola

I need to connect to Database also to generate custom report to our intranet!

Please send info to: Joao.Patrao@suma.pt

I�m evaluating your software right now and I think it is pretty good so far.
Could you mail me the procedure too?

Leon_Lionheart@web.de

Ankit,

Please send me the details for report generation. Would be a great help.

Rgds

Damian
djbunn@triley.co.uk

Me too.

phugenberg@neo.rr.com

Please mail me the details for Crystal Reports on shah_peerzada@yahoo.com

You can connect to the database through the following commands from the Server where ServiceDesk is installed:

cmd> cd C:\AdventNet\ME\Servicedesk\mysql\bin
cmd> mysql.exe -u root -P 33366 servicedesk

"servicedesk" is the name of the database. 33366 is the port on which SDP database runs. SDP uses root account to connect to the database and does not use any password. You can connect to MySQL database only from the server console.

Requests (or Tickets) information is available in WorkOrder table and Workstation information is available in SystemInfo table. You can query the related tables for other information.

Once you have connected to the Database you can connect it to the Crystal reports:

Given below the rules may help us to connect our mysql db server to CrystalReport XI

1)Download MyODBC-3.51.11-2-win ODBC driver from:
dev.mysql.com/downloads/connector/odbc/3.51.html

2)Create New Data Source Name (DSN) using below the instructions:

To open the ODBC Administrator from the Control Panel:

1.Click Start, point to Settings, and then click Control Panel.
2.On computers running Microsoft Windows 2000 or newer, double-click Administrative Tools, and then double-click Data Sources (ODBC). On computers running older versions of Windows, double-click 32-bit ODBC or ODBC|. ODBC Data Sources Icon The ODBC Data Source Administrator dialog box appears

To add a data source on Windows:

1.Open the ODBC Data Source Administrator.
2.In the ODBC Data Source Administrator dialog box, click Add. The Create New Data Source dialog box appears.
3.Select MySQL ODBC 3.51 Driver, and then click Finish. The MySQL ODBC 3.51 Driver - DSN Configuration dialog box appears.
4.In the Data Source Name box, enter the name of the data source you want to access. It can be any valid name that you choose.
5.In the Description box, enter the description needed for the DSN.
6. For Host or Server Name (or IP) box, enter the name of the MySQL server host that you want to access. By default, it is localhost.
7. In the Database Name box, enter the name of the MySQL database that you want to use as the default database.
8. In the User box, enter your MySQL username (your database user ID).
9. In the Password box, enter your password.
10. In the Port box, enter the port number if it is not the default (3306).
11. In the SQL Command box, you can enter an optional SQL statement that you want to issue automatically after the connection has been established.

Click OK to add this data source.
Note: Upon clicking OK, the Data Sources dialog box appears, and the ODBC Administrator updates the registry formation. The username and connect string that you entered become the default connection values for this data source when you connect to it. You can also test whether your settings are suitable for connecting to the server using the button Test Data Source. This feature is available only for the MyODBC 3.51 driver.

Note: The options listed under Driver Trace Options are disabled (grayed out) unless you are using the debugging version of the driver DLL.

To modify a data source on Windows:

1.Open the ODBC Data Source Administrator. Click the appropriate DSN tab.
2. Select the MySQL data source that you want to modify and then click Configure. The MySQL ODBC 3.51 Driver - DSN Configuration| dialog box appears.
3. Modify the applicable data source fields, and then click OK. When you have finished modifying the information in this dialog box, the ODBC Administrator updates the registry information.

3) Install Crystall Report

4) Click Standard Report Wizard...Select Create New Connection

5) Select ODBC(RDO)...a window will popup and select data source you have created

Hope this helps,

Regards,

Ankit

There are so many tables. Which one is storing the "Request Description"?
thanks.

Requests (or Tickets) information is available in WorkOrder table and Workstation information is available in SystemInfo table. You can query the related tables for other information.

-Ankit-

Please, include me in this list

marcel.furumoto@dendrite.com

I too would like this information

aoden@spectrum-metals.com

The same procedure can be used for an easy reporting tool (mysql,sql and a lot of ther dbms) with an scheduling option !

www.dbxtra.com

I'm intrested too can you give me the details: a.sinesi@ietgroup.net
Thanks

Hi

can you send me full details pls? test1729@hotmail.co.uk

Hi All,

The steps posted earlier in this post give the complete information about how to connect to Database of ServiceDeskand how to connect our mysql db server to CrystalReport XI.

We will soon be posting a complete schematic diagram for the database tables which will help you to know about the tables details.

Hope this helps,

Ankit

Please send me the procedure too. Because the custom reports not flexible enough.

My email address is: phawkins@cftrust.org.uk

Me too Please
jarnold@aquamix.net

Please send me the details. Thank you.

freddie.tsang@peel.ccac-ont.ca

Please refer to the previous pages in this discussion @ http://forums.manageengine.com/forumHome.do?forumGroupId=49000000002007&forumTopicId=49000002659655& for the same.

Regards
Karthik

The page you gave to us is only guidance to connect Crystal Report with SD plus database, but not show a complete schematic diagram for the database tables so we still have problem to generate customizable and flexible report from SD plus database.

So please kindly sent us a complete schematic diagram for the database tables as per your promise.

Thanks.


Regards,

Keith.

Keith,

Attached is an diagram showing the database schema in SD+ and the tables to be queried for Request Reports and Workstation Reports.

Post your comments.

Regards
Karthik 

Please email me with the details for running reports via Crystal / Excel on watare@mastermindkenya.co.ke

Could email me the details please.... petera@mhs.org.uk

thanks :D

Pls refer to the discussion in this topic @ http://forums.manageengine.com/forumHome.do?forumGroupId=49000000002007&forumTopicId=49000002659655&

Regards
Karthik

Please can I have a copy of the details on how to connect to the database -darrenc@chemdry.co.uk.

Cheers

scotthiggins@trcorporation.com

How is the time fields encoded? When I look at them, they are a useless number...I do I reformat them?

Can you tell me what format your time fields are in? The numbers do not seem to make sense.

Thank you

Use from_unixtime([columnname]/1000) while selecting this field in the database to get external reports.

Hope this helps,

Regards,

Ankit

What�s about the Asset shema? For me it is more important to generate specified Hardware reports than Wororder reports.

The reports fot workorders are very good in SD but the hardwarereport possibilitys are only called a joke.

Wich are the tables for Hardware? Systeminfo, workstationri, and the other system* tables I have identified so far. Wich context they are?

Would be happy for every information!

Thx
Carsten Bliessen

I am trying to connect to the DB from my laptop using crystal and continue to get an error where login is failing. ODBC connects fine from my laptop but crystal will not.. I have added my machine to be allowed in the MySQL admin, but will not connect. Anyone had any luck connecting from remote machine with crystal? Any ideas?

/Robert

I have recently purchased your software. Please send me the Crystal reports connections details to watare@mastermindkenya.co.ke

Refer to the discussion @ http://forums.manageengine.com/forumHome.do?forumGroupId=49000000002007&forumTopicId=49000002659655& for the information on the database schema.

Refer to the discussion @ http://forums.manageengine.com/forumHome.do?forumGroupId=49000000002007&forumTopicId=49000002659655& for information on connecting to the database using crystal reports.

-Kevin-

While using the schema I can not find where the link between workored and technician resides. Some of the links int he schema go to nowhere.

Please help.

/Robert

Thanks for the schema map - it will be very useful. Please can you explain where the TIME SPENT records are held in relation to the WORKORDER (tickets), so I can join the time spent entries with the ticket ID's.

This request has also been posted by another user at;

http://forums.manageengine.com/forumHome.do?forumGroupId=49000000002007&forumTopicId=49000002660601

Thanks. Keith.

Here is an evolving article that will help you create your own reports using Crystal Reports based on ServiceDesk Plus database.

ServiceDesk Plus & Crystal Reports

Download PDF

This evolving article needs your contribution and feedback to be complete. The article is posted in Zoho- an online word processor. I have given Read and Write permission to everyone who had given their email id in the SDP forums. If you need Write permission to the article, send an email to support at servicedeskplus.com

Alex

Keith,

Refer the latest post @ http://forums.manageengine.com/forumHome.do?forumGroupId=49000000002007&forumTopicId=49000002660601 for the same.

Regards
Karthik

robert,

Find that in the WorkOrderStates. The technician id is identified as OWNERID and this is linked to AaaUser.

Hope this clarifies.

-Kevin-

Ankit,

Please send me the details for report generation. Would be a great help

molafy@hotmail.com

thanks
molafy

Here is an evolving article that will help you create your own reports using Crystal Reports based on ServiceDesk Plus database.

ServiceDesk Plus & Crystal Reports

Download PDF

This evolving article needs your contribution and feedback to be complete. The article is posted in Zoho- an online word processor. I have given Read and Write permission to everyone who had given their email id in the SDP forums. If you need Write permission to the article, send an email to support at servicedeskplus.com

Alex

hello,
I am very interested too, for evaluation purposes

pirsonjj@prvlimburg.nl

Thank you in advance

Will this work with Crystal Reports XI Standard or do you have to have Pro?

Scott,

Refer to the discussion @ http://forums.manageengine.com/forumHome.do?forumGroupId=49000000002007&forumTopicId=49000002661607&

-K-

I would also the details. Thank you
clasmay(at)gmail(dot)com

Thank you in advance
Oriondelsur

Refer the discussion @ http://forums.manageengine.com/forumHome.do?forumGroupId=49000000002007&forumTopicId=49000002659655& for the same

Kevin

hi even i want the details to generate reports.
I can use either HTML format or can use Crystal Reports.
But i need the interfacing between my HTML(or jsp) to these reprts.
Kindly reply
my mail is sucharit_amity@yahoo.co.in
thsnks

Hi Sucharit,

It is not possible to create an interface between HTML(or jsp) with the Crystal Reports.
Feel free to write to us.

Regards,
Hima

I would like connect to the database and generate reports too. Please email me all required details

Regards,
Anthony
apozerski@prc.com.au
Prima Consulting Pty Ltd
20 Collins St, Melbourne VIC 3000

Hi Anthony,

Please have the complete information regarding the integration of crystal reports with ServiceDesk from the link below:

http://www.zohowriter.com/public/13706/27397

Hope this helps,

Regards,

Ankit

Hi

I wonder if someone can help me with some queries in Service Desk.

If the queuename has been changed from one to another, and then later on from the latter to another one, why is it that I can see only the very latest queuename.

The same with the Technician, created Date and the Assign Date.

For example:
a call belongs to QueuenameA and assigned to TechnicianA at TimeA, then the changed to QueuenameB and assigned to TechnicianB at TimeB, and again changed to QueuenameC and assigned to TechnicianC at TimeC.

When I query the database all I came up with is the latest information, which in the above case would be QueuenameC, TechnicianC and TimeC.

Does anybody know how the query can be twisted around so that it shows all the steps of moving a workorder from one to another.

Your help would be very much appreciated.

Atia

Hi atiaran,

Please check this Query if this suffice:

select wo.WORKORDERID 'Request ID',woh.OPERATION, COALESCE((select STATUSNAME from StatusDefinition where wohd.COLUMNNAME = 'STATUSID' and ( wohd.PREV_VALUE = STATUSID) ), (select aau.FIRST_NAME from AaaUser aau where wohd.COLUMNNAME = 'OWNERID' and wohd.PREV_VALUE = aau.USER_ID)) 'Assign From',COALESCE((select STATUSNAME from StatusDefinition where wohd.COLUMNNAME = 'STATUSID' and ( wohd.CURRENT_VALUE = STATUSID) ), (select aau.FIRST_NAME from AaaUser aau where wohd.COLUMNNAME = 'OWNERID' and wohd.CURRENT_VALUE = aau.USER_ID)) 'Assign To' from WorkOrder wo LEFT JOIN WorkOrderHistory woh ON wo.WORKORDERID =
woh.WORKORDERID LEFT JOIN WorkOrderHistoryDiff wohd ON woh.HISTORYID =
wohd.HISTORYID where wohd.COLUMNNAME in ( 'OWNERID' ) order by 1

Regards,

Ankit

Hi atiaran,

Please check this Query if this suffice:

select wo.WORKORDERID 'Request ID',woh.OPERATION, COALESCE((select STATUSNAME from StatusDefinition where wohd.COLUMNNAME = 'STATUSID' and ( wohd.PREV_VALUE = STATUSID) ), (select aau.FIRST_NAME from AaaUser aau where wohd.COLUMNNAME = 'OWNERID' and wohd.PREV_VALUE = aau.USER_ID)) 'Assign From',COALESCE((select STATUSNAME from StatusDefinition where wohd.COLUMNNAME = 'STATUSID' and ( wohd.CURRENT_VALUE = STATUSID) ), (select aau.FIRST_NAME from AaaUser aau where wohd.COLUMNNAME = 'OWNERID' and wohd.CURRENT_VALUE = aau.USER_ID)) 'Assign To' from WorkOrder wo LEFT JOIN WorkOrderHistory woh ON wo.WORKORDERID =
woh.WORKORDERID LEFT JOIN WorkOrderHistoryDiff wohd ON woh.HISTORYID =
wohd.HISTORYID where wohd.COLUMNNAME in ( 'OWNERID' ) order by 1

Regards,

Ankit

-----------------------------------------------------------------------------------------

Hi Ankit

Thanks for your help.

I managed to change bits and peaces such as the names of the tables to match the names of the tables I've got. But when I run the query I actually come across another error message, which I attach.

Could you please help as I have no idea where to go from there.

Thanks a lot
Atiaran

Hey,

I tried this query with the Query Editor, it worked like a charm. Why dont you try the default report tool instead of using other softwares?

Kev//

Hey!
Please send me the procedures as well.
brian@greatnecklibrary.org

Thanks!

The discussions in this thread talk much about this. It is best you use the default report tools available with the application rather than crystal reports. the one available with the application is exhaustive.

kev//

Hi please send me the details aswell thank you:
tamiko.pratt@elabs.de :lol:

what details do you want? The thread discusses much abt this information. The Reports section have been enhanced.

Be specific to help you better.

rgds
karthik

Please send me the procedure to generate report in php through crystal report. My mail address is
samamun001@yahoo.com

What is the recommended version of Crystal Reports to use with ServiceDesk Plus
or what version are you using?
Thank you.

This Thread is confusing. Connecting to the db in MSSQL is easy using ODBC. Is support saying that If I send the spec's for the report you will provide a query for the requirement?

KKevin:

I beg to disagree with your assessment of the reporting module. Personally it works ok for me, but my executives continually ask for what may seem like the most ridiculous reports that I cannot find available options in the app, so I must use a external tool to mine data.

Use from_unixtime([columnname]/1000) while selecting this field in the database to get external reports.

Hope this helps,

Regards,

Ankit

Will the above conversion work in MSSQL 2005 :?:

OH! and will this also work in the Query Editor in Service Desk?

This will work only if the backend database is MySQL.

If it is MSSQL, you have to use dateadd(s,'CREATEDTIME/1000','01-01-1970')

This will work only if the backend database is MySQL.

If it is MSSQL, you have to use dateadd(s,'CREATEDTIME/1000','01-01-1970')

I attempted a query using that conversion. The error I get is

Incorrect syntax near ')'.

This will work only if the backend database is MySQL.

If it is MSSQL, you have to use dateadd(s,'CREATEDTIME/1000','01-01-1970')

I attempted a query using that conversion. The error I get is

Incorrect syntax near ')'.

If you're trying this in Crystal, the syntax is slightly different. Try the following:

dateadd("s",{WorkOrder.CREATEDTIME}/1000,#01-01-1970#)

I had to play around with it to notice the "s, #s, and {}s.

~Marj ^_^

Please also provide me with the details on using your ServiceDesk database so that I may generate reports more complex than your good wizard interface allows. An ER diagram would help as well. Thank you. (current build 7005)

Hi Keith,

The enhancement for the Reports section is under development and will be available in our future updates. As of now you can connect the database using Crystal reports and generate the desired reports. Please send us your contact details to support@servicedeskplus.com and we will send you the details on how to connect to the database and the tables to query for reports.

Hope this helps.

Regards,

Ankit

If you start a new query report in SDP (where you write the SQL yourself), there is a "Table Schema" drop-down menu there for displaying graphical representations of various sets of linked tables. That should help you out.

Yes, thank you, I discovered that option via New Query Report long ago. However, as a view into the database, the options offered are incomplete. Example: a report for management to see which Groups Technicians are members of; Task reports; various utility reports I made for myself such as one to aid Technicians in finding the right Category starting point for applicable Items; a sequenced, detailed report for management as well as myself on the Business Rules in effect; and more. I was hoping for a thorough ER diagram and perhaps a Data Dictionary. In the absence of same, I've been working on making an ER diagram in SQL Server, experimenting to find specific useful columns of data - a bit time consuming. While forum comments in this topic are general in what could be asked for, I was hopeful there would be more extensive aids than the table schema pulldown offered for more ambitious reporting. Thanks for responding.

I hear what you are saying. I myself have gotten to the point where I have a pretty good working knowledge of where things are at in the database, but I haven't ever attempted to document it or map it out, since as you said, it's very time consuming. Of course, my company doesn't need such extensive reporting capabilities, or else I might be more inclined to do what you are doing. If there are some specific pieces of data you are looking for, I could probably help you find them though

BJM, thank you very much. I shall bookmark you.

Whenever I add the date formatting to a custom query report, the report runs, but I cannot save the date formatting with the query report.

When I save the report, it removes the date formatting so I have to go back and add it in each time.

Hi We would also like to create external reports; please send info to pbarton@severntrentservices.co.uk

Hi
I also need to generate report using crystal report. Please send me the procedure too.
cb.asokan@gmail.com

Thank you.

Hi,

Please refer to the link below to integrate Crystal reports:

http://forums.manageengine.com/forumHome.do?forumGroupId=49000000002007&forumTopicId=49000002659655&

http://forums.manageengine.com/forumHome.do?forumGroupId=49000000002007&forumTopicId=49000002659655&

regards,
Priya K

please also send me the details .

Sjmolyneaux@tasol.com.au

please also send me the details .

Please email me with the details for running reports via Crystal / Exce

cabuathier@kirkwood.com

I would like to generate the report too. Please send me the procedures. Tahnk you

Best Regards,
Supon W.
supon@cobrainter.com

hi all,

if anyone has *current* info available on how to run reports on SD+ 7505 on MSSQL i would be really thankful. Stuff like documentation, dataschemes, sample reports or anything that would be helpful. I have to create custom reports for the mgmt in crystal that cannot be run from the standard reporting wizard before the end of march.

thanks a million! the email:
s.cremers <at> fritom <dot> com

Is this being implement as official in latest releases???

I would like information on how to connect to crystal reports also, please email me at lee.mackreath@mactag.com

please send me the connection details at lee.mackreath@mactag.com

Try the instructions on one of the above posts:

You can connect to the database through the following commands from the Server where ServiceDesk is installed:

cmd> cd C:\AdventNet\ME\Servicedesk\mysql\bin
cmd> mysql.exe -u root -P 33366 servicedesk

"servicedesk" is the name of the database. 33366 is the port on which SDP database runs. SDP uses root account to connect to the database and does not use any password. You can connect to MySQL database only from the server console.

Requests (or Tickets) information is available in WorkOrder table and Workstation information is available in SystemInfo table. You can query the related tables for other information.

Once you have connected to the Database you can connect it to the Crystal reports:

Given below the rules may help us to connect our mysql db server to CrystalReport XI

1)Download MyODBC-3.51.11-2-win ODBC driver from:
dev.mysql.com/downloads/connector/odbc/3.51.html

2)Create New Data Source Name (DSN) using below the instructions:

To open the ODBC Administrator from the Control Panel:

1.Click Start, point to Settings, and then click Control Panel.
2.On computers running Microsoft Windows 2000 or newer, double-click Administrative Tools, and then double-click Data Sources (ODBC). On computers running older versions of Windows, double-click 32-bit ODBC or ODBC|. ODBC Data Sources Icon The ODBC Data Source Administrator dialog box appears

To add a data source on Windows:

1.Open the ODBC Data Source Administrator.
2.In the ODBC Data Source Administrator dialog box, click Add. The Create New Data Source dialog box appears.
3.Select MySQL ODBC 3.51 Driver, and then click Finish. The MySQL ODBC 3.51 Driver - DSN Configuration dialog box appears.
4.In the Data Source Name box, enter the name of the data source you want to access. It can be any valid name that you choose.
5.In the Description box, enter the description needed for the DSN.
6. For Host or Server Name (or IP) box, enter the name of the MySQL server host that you want to access. By default, it is localhost.
7. In the Database Name box, enter the name of the MySQL database that you want to use as the default database.
8. In the User box, enter your MySQL username (your database user ID).
9. In the Password box, enter your password.
10. In the Port box, enter the port number if it is not the default (3306).
11. In the SQL Command box, you can enter an optional SQL statement that you want to issue automatically after the connection has been established.

Click OK to add this data source.
Note: Upon clicking OK, the Data Sources dialog box appears, and the ODBC Administrator updates the registry formation. The username and connect string that you entered become the default connection values for this data source when you connect to it. You can also test whether your settings are suitable for connecting to the server using the button Test Data Source. This feature is available only for the MyODBC 3.51 driver.

Note: The options listed under Driver Trace Options are disabled (grayed out) unless you are using the debugging version of the driver DLL.

To modify a data source on Windows:

1.Open the ODBC Data Source Administrator. Click the appropriate DSN tab.
2. Select the MySQL data source that you want to modify and then click Configure. The MySQL ODBC 3.51 Driver - DSN Configuration| dialog box appears.
3. Modify the applicable data source fields, and then click OK. When you have finished modifying the information in this dialog box, the ODBC Administrator updates the registry information.

3) Install Crystall Report

4) Click Standard Report Wizard...Select Create New Connection

5) Select ODBC(RDO)...a window will popup and select data source you have created


Maljeev

Visit the below link for:
FAQ's,Troubleshooting doc's,RoadMap's,Known Issue's,SupportLogin

Go to Reports-->New Query reports-->Select the Module for which you require the database schema-->Click on Get.

Can we create a new user only for select access?  That way the reports could be run from another machine without having to give the user access to the server and then complete access to crash it as well.

The NewqueryReport option(query editor) has been restricted for users with SDAdmin role alone in version 8.0 and so if that user is an administrator he can execute the queries(select queries alone) from the queryeditor of the application.

Maljeev
ServiceDesk Plus Support

View our Knowledge Base Articles @
http://www.manageengine.com/products/service-desk/support.html

On the application under Reports you have an option to view the data model to the right handside,next to "Custom Settings",where you need to choose software which should provide you with the database schema for the Software module.

Maljeev

SDP Support - FAQ
ServiceDesk Plus - Help Desk Software of your Choice

The procedure to connect to Crystal Reports is provided on this forum post in one of the conversations above.

Maljeev

SDP Support - FAQ
ServiceDesk Plus - Help Desk Software of your Choice

We do not see the path C:\AdventNet\ME\Servicedesk\mysql\bin . We do have on a different drive Servicedesk\mysql\bin but is not located in AdventNet\ME\ . Is this the same thing? And is that what we should be inputting instead? And when connecting for Crystal Reports what do those two lines of code exactly do? do they need to be done or can I start with the part downloading of tdhe MyODBC-3.51.11-2-win ODBC Drive and setup from there and successfully connect in once I have established a connection?

William

The path should be pointed to [ServiceDesk-HOME]\mysql\bin folder where ServiceDesk-HOME refers to installation folder of ServiceDesk plus.
SDP Support - FAQ
ServiceDesk Plus - Help Desk Software of your Choice

You can get the DB schema for each module under Reports-->New query reports-->select the module-->Press Get.

would you please send me the information to integrate Crystal Reports with OpManager? Thanks
cespinosa at ti-america dot com

Hi,