| Author |
Message |
|
|
|
This version has not fixed the problem with Follow-up user drop down being blank in the filter/ selection screen.
|
|
|
Can anybody tell me where escalation rules are stored in the database? I would like to work with these records directly since the interface for managing escalation rules is so very clunky and I prefer to work with code directly.
Thank you!
Tennyson
|
|
|
|
Sweet.... thanks!
|
|
|
Hello SysAiders,
I am trying to find a way to easily copy our existing category structure from one SysAid implementation to another. Does anybody know where the categories are stored behind the scenes? I have searched the database for a while now and cannot seem to find the master list of categories anywhere. The SR table seems to store the category as a string rather than a foreign key! Please don't tell me that categories are stored in a flat file! 
Thanks in advance,
Tennyson
|
|
|
SysAid appears to be working fine. We have set up categories and escalation rules, as well as entered a few SRs to test.
I would still like to find the database, where ever it might be, if not because I am baffled then because it would save us time to copy our categories into the new installation of SysAid. Can you tell me where SysAid stores it's default Derby database so I can look there? Maybe SysAid is somehow bypassing it's serverConf.xml file?
-Tennyson
|
|
|
Hello potential friends and enemies,
I have just finished setting up SysAid for the first time. What baffles me is that, although I set it up to use MsSQL, I cannot find the database anywhere!
Here's my connection string from serverConf.xml:
<dbConf>
<dbDriver>net.sourceforge.jtds.jdbc.Driver</dbDriver>
<dbUrl>jdbc:jtds:sqlserver://localhost:1433</dbUrl>
<dbUser>*******</dbUser>
<dbPassword>*******</dbPassword>
<dbType>mssql</dbType>
<dbEncoding>utf-8</dbEncoding>
<dbMultiply>false</dbMultiply>
<dbMainName>ilient</dbMainName>
</dbConf>
I've connected to localhost with SQL Management Studio and cannot find the ilient database anywhere. Can anybody please tell me where to look to find the SysAid database? I would like to write a DTS package to import tickets from our old helpdesk system.
Thanks,
Tennyson Hull
|
|
|
