Support Center Schema - 8 series
To populate the WorkOrder/Request information, the tables that need tobe populated are :
- WorkOrder
- WorkOrderStates
- WorkOrder_Threaded
- WorkOrderToDescription
- WorkOrder_Fields (If there are any WorkOrder Addl Fields)
To map Account and SubAccount to a WorkOrder/Request :
To map Contract to a WorkOrder/Request :
To populate the Contact information, the tables used are :
- AaaUser
- SDUser (Check the Status Field. Should be set to ACTIVE)
To populate the SupportRep information, the tables used are :
- AaaUser
- SDUser
- HelpDeskCrew
To populate the Account Manager information, the tables used are :
- AaaUser
- SDUser
- Account_Manager
To populate the Account information
To populate the SubAccount information
- AaaOrganization
- Customer
- SubAccount
To populate the Contract information
To map the contacts to the Account
To map a Account Manager to the Account
Date conversion :
Date fields are available as long in the database. Pls usethe following conversion rule :
Long_Date = (UNIX_TIMESTAMP(DATE('2006-07-24 00:00:00'))* 1000)
Also
longtodate(wo.createdtime)
New to ADSelfService Plus?
Related Articles
6. Database Schema
Request Module Column Name Column Value Joining Table Request ID wo.workorderid workorder wo Request Subject wo.title workorder wo Request created time longtodate(wo.createdtime) workorder wo Request category cd.CATEGORYNAME LEFT JOIN ...
How to get the login logo at the center ?
1. Login to the application as an administrator, goto Admin-> Self service portal settings-> Customize login page-> Customize Now 2. In the Edit page add entry   a few times as shown in the screenshot below, until you see it appears in the ...
To center the Login page logo in SupportCenter Plus 11.0
By default, the logo for the login page in SupportCenter Plus is aligned to the left. Like below: To have the logo aligned to center, please go to Global Settings --> Application Settings --> Customize now Under logo-heading, text-align: center; can ...
Support Groups
This Report is used to export the list of Support groups configured in the application with the complete details. MSSQL SELECT qd.QUEUENAME "Support group", ci.DESCRIPTION "Description", su.first_name "Owned By", STUFF( (SELECT ',' + au.first_name ...
End of Support - Builds details
Dear Users Support will be provided only for the Supportcenter Plus builds (released within one year from the current date). We recommend you upgrade to the latest version to continue receiving support. As per Feb-24 - We stopped support of all ...