SDP Query
SELECT
wo
.
WORKORDERID "Request ID"
,
icd
.
NAME "Item"
,
dateadd
(
s
,
datediff
(
s
,
GETUTCDATE
()
,
getdate
())
+
(
wo
.
CREATEDTIME
/
1000
),
'1970-01-01 00:00:00'
)
"Created Time"
,
dateadd
(
s
,
datediff
(
s
,
GETUTCDATE
()
,
getdate
())
+
(
wo
.
DUEBYTIME
/
1000
),
'1970-01-01 00:00:00'
)
"DueBy Time"
,
datediff
(
d
,
dateadd
(
s
,
datediff
(
s
,
GETUTCDATE
()
,
getdate
())
+
(
wo
.
DUEBYTIME
/
1000
),
'1970-01-01 00:00:00'
),
GETDATE
())
"Aging(Days)"
,
ti
.
FIRST_NAME "Technician"
,
std
.
STATUSNAME "Request Status"
FROM
WorkOrder wo
LEFT
JOIN
SiteDefinition siteDef
ON
wo
.
SITEID
=
siteDef
.
SITEID
LEFT
JOIN
SDOrganization sdo
ON
siteDef
.
SITEID
=
sdo
.
ORG_ID
LEFT
JOIN
WorkOrderStates wos
ON
wo
.
WORKORDERID
=
wos
.
WORKORDERID
LEFT
JOIN
ItemDefinition icd
ON
wos
.
ITEMID
=
icd
.
ITEMID
LEFT
JOIN
CategoryDefinition cd
ON
wos
.
CATEGORYID
=
cd
.
CATEGORYID
LEFT
JOIN
SDUser td
ON
wos
.
OWNERID
=
td
.
USERID
LEFT
JOIN
AaaUser ti
ON
td
.
USERID
=
ti
.
USER_ID
LEFT
JOIN
StatusDefinition std
ON
wos
.
STATUSID
=
std
.
STATUSID
WHERE
((
cd
.
CATEGORYNAME
=
N
'Incident Observation Report(IOR)'
)
OR
(
cd
.
CATEGORYNAME
=
N
'Non Compliance (NC)'
))
AND
((
sdo
.
NAME
=
N
'Great Eastern Office'
)
OR
(
sdo
.
NAME
=
N
'Menara Great Eastern'
))
I need to schedule in SDP to run this query weekly. Please put in the syntax for me to generate the report weekly
I am using MS SQL . Please attend to this urgent.
Kanten