ServiceDesk Plus how generate report WORKLOG TASK without REQUESTID
I cant find solution how get data - worklog for task, which are not assigned to requests.
Go to custom report module in serwicedesk
make reaport (below)
export table to excel
for column TIME SPENT please use this function "=XX/(1000*60)"
where XX its your column with TIME SPENT
for column STARTTIME and ENDTIME use this function "=xx/86400000+DATA(1970;1;1)"
where xx its your column with this data
after gets results please convert column - view date from content cell
done,
select
wochar.workorderid "RequestID",
ttocharge.taskid "TaskID",
ct.chargeid "ChargeID",
ct.DESCRIPTION "Description",(select case when ct.TIMESPENT=0 then null when ct.TIMESPENT=-1 then null else ct.TIMESPENT end) "Time Spent",ct.TOTAL_CHARGE "Total Charge",
(select case when ct.CREATEDTIME=0 then null when ct.CREATEDTIME=-1 then null else ct.CREATEDTIME end) "Created Time",
(select case when ct.TS_STARTTIME=0 then null when ct.TS_STARTTIME=-1 then null else ct.TS_STARTTIME end) "Starttime",
(select case when ct.TS_ENDTIME=0 then null when ct.TS_ENDTIME=-1 then null else ct.TS_ENDTIME end) "Endtime",ct.OTHER_CHARGE "Other Charge",ct.TECH_CHARGE "Tech Charge",rccb.FIRST_NAME "Created By",rctd.FIRST_NAME "Technician" from ChargesTable ct
left join WorkOrderToCharge wochar ON wochar.CHARGEID = ct.CHARGEID
LEFT JOIN TaskToCharge ttocharge ON ct.CHARGEID = ttocharge.CHARGEID
LEFT JOIN AaaUser rccb ON ct.CREATEDBY=rccb.USER_ID
LEFT JOIN SDUser rcti ON ct.TECHNICIANID=rcti.USERID
LEFT JOIN AaaUser rctd ON rcti.USERID=rctd.USER_ID
left join workorder wo on wo.workorderid=wochar.workorderid
where wochar.workorderid is null
Go to custom report module in serwicedesk
make reaport (below)
export table to excel
for column TIME SPENT please use this function "=XX/(1000*60)"
where XX its your column with TIME SPENT
for column STARTTIME and ENDTIME use this function "=xx/86400000+DATA(1970;1;1)"
where xx its your column with this data
after gets results please convert column - view date from content cell
done,
select
wochar.workorderid "RequestID",
ttocharge.taskid "TaskID",
ct.chargeid "ChargeID",
ct.DESCRIPTION "Description",(select case when ct.TIMESPENT=0 then null when ct.TIMESPENT=-1 then null else ct.TIMESPENT end) "Time Spent",ct.TOTAL_CHARGE "Total Charge",
(select case when ct.CREATEDTIME=0 then null when ct.CREATEDTIME=-1 then null else ct.CREATEDTIME end) "Created Time",
(select case when ct.TS_STARTTIME=0 then null when ct.TS_STARTTIME=-1 then null else ct.TS_STARTTIME end) "Starttime",
(select case when ct.TS_ENDTIME=0 then null when ct.TS_ENDTIME=-1 then null else ct.TS_ENDTIME end) "Endtime",ct.OTHER_CHARGE "Other Charge",ct.TECH_CHARGE "Tech Charge",rccb.FIRST_NAME "Created By",rctd.FIRST_NAME "Technician" from ChargesTable ct
left join WorkOrderToCharge wochar ON wochar.CHARGEID = ct.CHARGEID
LEFT JOIN TaskToCharge ttocharge ON ct.CHARGEID = ttocharge.CHARGEID
LEFT JOIN AaaUser rccb ON ct.CREATEDBY=rccb.USER_ID
LEFT JOIN SDUser rcti ON ct.TECHNICIANID=rcti.USERID
LEFT JOIN AaaUser rctd ON rcti.USERID=rctd.USER_ID
left join workorder wo on wo.workorderid=wochar.workorderid
where wochar.workorderid is null