Skip to main content

SysAid Reports


LJ
  • New SysMate
  • 1 reply
How can I get my SysAid tables into an Access Front End? I am much more familiar with access so I can create custom reports on the fly as needed. Thanks. LJ

22 replies

Ori
Active talker
Forum|alt.badge.img
  • Active talker
  • 262 replies
  • November 6, 2008
Dear LJ, Can you please let us know what database are you using in your implantation? You can only use databases that has ODBC connection (MySQL / MS-SQL / Oracle) so if you are using the embedded one (Derby), you will not able to perform this. Best Regards. Ori Sharon.

LJ
  • Author
  • New SysMate
  • 1 reply
  • November 6, 2008
Is there anyway to change the database from derby to MySQL?

Ori
Active talker
Forum|alt.badge.img
  • Active talker
  • 262 replies
  • November 12, 2008
Dear LJ, To migrate the database from the embedded database to an external type (Microsoft SQL, MySQL or Oracle) you need to send us the database and our support team will perform the migration. We usually schedule this to be done over the weekend, to minimize downtime on your end. If you send us your database on Friday/Saturday evening, we could have it ready by Monday morning. If you are interested, please send us an email to helpdesk@sysaid.com and attach your ...\SysAidServer\root\WEB-INF\conf\serverConf.xml file and tell us which database type you are interested in migrating to. Also, please tell us which version of SysAid are you currently using + when you wish to schedule this for. Best Regards. Ori Sharon.

  • Community Enthusiast
  • 25 replies
  • February 16, 2009
Hi, I also would like to migrate from Derby to MS Sql 2005 database. Can anyone guide me on how to do it? I already install Ms SQL and SysAid.. but did not managed to connect them together.. :( Thanks in advance..

  • Community Enthusiast
  • 25 replies
  • February 17, 2009
I'm having this error: Exception while checking configuration: Logon failed: Login failed for user 'administrator'. The user is not associated with a trusted SQL Server connection. Anyone can help me out? Need it urgently.. Anyway thanks in advance..

BJINS
Active talker
  • Active talker
  • 424 replies
  • February 17, 2009
Your Administrator account is probably not the one you use to access the SQL Server. In Active Directory create a user for SysAid Access, and then give it full permissions via groups for SQL then use this username and password in SysAid for access to the SQL Database. Let me know if this resloves the issue! M

  • Community Enthusiast
  • 25 replies
  • February 17, 2009
ok, thanks BJINS.. i'll try on that later.. by the way, do i have to set a connection between ms sql to derby using firebird odbc? thanks..

BJINS
Active talker
  • Active talker
  • 424 replies
  • February 17, 2009
I don't quite understand your question, Newbie. Are you currently on a SQL database or are you on Derby and looking to migrate onto a MS-SQL database. With any work regarding working directly with the database structure you are best contacting the Helpdesk at SysAis Support directly and have them deal with it. Either email helpdesk@sysaid.com or submit a ticket at https://helpdesk.sysaid.com

  • Community Enthusiast
  • 25 replies
  • February 18, 2009
hi BJINS, i still got the same error.. have tried to use all available username and password related to ms sql.. but still in vain.. :( is there any possible method to encounter this? need to install the software asap.. :( anyway, are u using ms sql 2005 db as your db? would u mind to share your steps in installing sysaid and connecting it with ms sql? thanks..

BJINS
Active talker
  • Active talker
  • 424 replies
  • February 18, 2009
I am not using MS SQL presently (purely due to the lack of foresight from the up-aboves) however I have experienced this error before. I would suggest taking a zipped copy of your logs and sending them to Ilient and opening a Service Request. That will most likely get the problem solved quicker than on here. Sorry I can't be of more use! M

  • Community Enthusiast
  • 25 replies
  • February 18, 2009
I see.. then, you're using what type of database? Is there any charges is I ask for Ilient to help set up my database? :-s Anyway thanks BJINS for answering my questions. ;)

BJINS
Active talker
  • Active talker
  • 424 replies
  • February 18, 2009
I am using a Derby Database. If you have already purchased SysAid full version then i believe a service like that would be free of charge. Also, if you are using the free version for evaluation I believe the free service may also be available. I will PM a member of the service desk and sales to ask them to help you.

  • Community Enthusiast
  • 25 replies
  • February 18, 2009
Oo.. you're using Derby. I thought you're using external database. Currently I'm using trial version. Will purchase once managed to run on production environment successfully. :D Anyway, thanks a lot BJINS for helping out and will help me again. Sorry to keep troubling you.

BJINS
Active talker
  • Active talker
  • 424 replies
  • February 18, 2009
Not at all! That's what everyone is here for! I have PM'd Ilient, so you should hear from someone in the next couple of days! =) M

Forum|alt.badge.img
  • Active talker
  • 2082 replies
  • February 18, 2009
newbie, If you still have issues connecting the SQL database to SysAid, please open a service request by sending an email to helpdesk@sysaid.com and we will be glad to assist you with connecting the database. Also, if you are currently trialing SysAid using derby, you can continue using it, and later down the road, we can migrate your database to SQL. Best regards. Haim

  • Community Enthusiast
  • 25 replies
  • February 18, 2009
thanks a lot BJINS.. ;)

  • Community Enthusiast
  • 25 replies
  • February 20, 2009
thanks haim.. i already managed to install sysaid with ms sql 2005 database.. but havent finished creating table in the database.. but when trying to key in data in sysaid.. it works. so, may i know where is all the data that i stored? :-s

  • Community Enthusiast
  • 25 replies
  • February 20, 2009
hi guys, there's 1 more questions that i would like to know.. if the link between external database and sys aid is successful, does that mean all the tables needed in the database is auto created by sysaid? meaning, we just need to create an empty table before installing sysaid.. that's all. then we can start using sysaid as normal just like using embedded database? thanks in advance..

techguy
Active talker
Forum|alt.badge.img+1
  • Active talker
  • 1229 replies
  • February 21, 2009
The SysAid software installation, does all the table creation for you. You do not need to manually create any tables.

  • Community Enthusiast
  • 25 replies
  • February 23, 2009
already found the auto created table in the database. thanks a lot techguy.. ;)

  • 2 replies
  • November 10, 2021
Hello All, I have been asked to generate a detailed report based on the number of tickets a single department has submitted. The report should detail who submitted the ticket and the current status of the ticket(s). This report is to run monthly. Any suggestions? Jeff Tademy Service Desk Tech Culver City

Maayan Karstaedt
SysAider
Forum|alt.badge.img
Jeff T
Hello All, I have been asked to generate a detailed report based on the number of tickets a single department has submitted. The report should detail who submitted the ticket and the current status of the ticket(s). This report is to run monthly. Any suggestions? Jeff Tademy Service Desk Tech Culver City
Hi Jeff T! Nothing like a good report to show all your hard work and identify what can be optimized even more :) We see you have the 'Advanced reporting' license in place so all you need to do in order to create the report is: In your top ribbon go to: Analytics > Reports > Create New Report Choose from dropdown "Report Type (entity):" > Service Record Access report created > click pencil icon "Edit" > in tab "Data" start adding relevant fields once all the relevant data is in, choose the column you want to sum things by (i.e. Department) click the arrow next to the column header and choose "Group by this field" in order to organize your report, check out this guide for more details: https://community.sysaid.com/help-page.htm?helpPageId=4201 Making IT count, Cheers, Maayan

Want Some cookies?

No, literally. We have some. 😉 By continuing browsing on our site you agree to our cookie policy.

 
Cookie settings