Back end Database
Hi,
We want to look at some fields in the SD+ Database - for example, see below:
SELECT wo.WORKORDERID "Request ID",
pd.PRIORITYNAME "Priority",
aau.FIRST_NAME "Requester",
dpt.DEPTNAME "Department",
FROM WorkOrder wo,
PriorityDefinition pd,
AaaUser aau,
DepartmentDefinition dpt
So the fields would be things like WORKORDERID, PRIORITYNAME, etc. Can you advise where on our ServiceDesk Server that I can find the database?
We want to look at some fields in the SD+ Database - for example, see below:
SELECT wo.WORKORDERID "Request ID",
pd.PRIORITYNAME "Priority",
aau.FIRST_NAME "Requester",
dpt.DEPTNAME "Department",
FROM WorkOrder wo,
PriorityDefinition pd,
AaaUser aau,
DepartmentDefinition dpt
So the fields would be things like WORKORDERID, PRIORITYNAME, etc. Can you advise where on our ServiceDesk Server that I can find the database?