Support Center Schema - 8 series

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 :
  • WorkOrder_Account
To map Contract to a WorkOrder/Request :
  • WorkOrder_ServiceCTR

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
  • AaaOrganization
  • Customer
To populate the SubAccount information
  • AaaOrganization
  • Customer
  • SubAccount

To populate the Contract information
  • ServiceCTR
  • ServiceCTRInfo

To map the contacts to the Account
  • Customer_Requester
To map a Account Manager to the Account
  • Customer_Salesrep

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 M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial

                      • Related Articles

                      • 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 ...

                      • 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 ...

                      • Excess license usage shown for support reps in SCP 8.1

                        1. Go to reports - > New query report, and execute the below query.  select * from aaauser aaau join sduser sdu on aaau.user_id=sdu.userid inner join helpdeskcrew hd on sdu.userid=hd.technicianid inner join aaalogin aaal on ...

                      • Query for Support Rep list in DB

                        Please run this query to find the list of Support Reps available with login in the system select * from aaauser aaau join sduser sdu on aaau.user_id=sdu.userid inner join helpdeskcrew hd on sdu.userid=hd.technicianid inner join aaalogin aaal on ...

                      • How to configure SAML with Azure AD

                        This guide will help us configure SAML for users who want to use Azure AD as their IdP and also give you insights on a few issues that you might run into while configuring SAML in an Azure Environment. In an ideal environment, customers will have an ...

                        Related Products