The web blog http://www.learnsccd.com strives to be a comprehensive guide to SCCD, TADDM, SERVICE NOW and MAXIMO tools. This is a personal site maintained solely by me. I intend to update it regularly.For live updates please follow us on.

Maximo/SCCD Start Center Result Set Queries

Maximo/SCCD Start Center Result Set Queries

My SRs
----------
(historyflag = 0) and (PMSCCRID is null)and (status in (select value from synonymdomain where maxvalue in ('NEW','PENDING','QUEUED','INPROG') and domainid in ('SRSTATUS'))) and owner =  :USER  order by internalpriority,targetfinish ASC


My Teams Service Requests
----------------------------------
(owner=:USER or ownergroup in (select persongroup from persongroupteam  where respparty=:USER)) and status not in (select value from synonymdomain where maxvalue in ('RESOLVED','CLOSED') and domainid in ('SRSTATUS'))


My Late Service Requestes
---------------------------------
(owner=:USER) and status not in (select value from synonymdomain where maxvalue in ('RESOLVED','CLOSED') and domainid in ('SRSTATUS') ) and (targetfinish is not null) and (actualfinish is null) and (targetfinish <= current timestamp)


Service Request SLA Breach
-----------------------------------
(historyflag = 0) and (status in (select value from synonymdomain where maxvalue not in ('RESOLVED','CLOSED','SLAHOLD') and domainid in ('INCIDENTSTATUS'))) and
((actualstart is null and coalesce(adjustedtargetresponsetime,targetstart) < current timestamp) or (actualfinish is null and coalesce(adjustedtargetresolutiontime,targetfinish) < current timestamp))


Unassigned SRs
-------------------
(historyflag = 0) and (PMSCCRID is null) and (status in (select value from synonymdomain where maxvalue in ('NEW','PENDING','QUEUED','INPROG') and domainid in ('SRSTATUS'))) and owner is null  order by internalpriority,targetfinish ASC


All Open Service Requests
----------------------------------
status in (:&synonymlist&_srstatus[NEW,QUEUED,INPROG,PENDING,SLAHOLD])


Service Request No SLA Applied
----------------------------------------
(historyflag = 0) and (status in (select value from synonymdomain where maxvalue not in ('RESOLVED','CLOSED') and domainid in ('INCIDENTSTATUS'))) and ticketuid not in (select ownerid from slarecords)


All Late Service Requested
---------------------------------
status not in (select value from synonymdomain where maxvalue in ('RESOLVED','CLOSED') and domainid in ('SRSTATUS') ) and (targetfinish is not null) and (actualfinish is null) and (targetfinish <=  current timestamp) order by targetfinish


Service Request SLA Breach
-----------------------------------
(historyflag = 0) and (status in (select value from synonymdomain where maxvalue not in ('RESOLVED','CLOSED','SLAHOLD') and domainid in ('INCIDENTSTATUS'))) and
((actualstart is null and coalesce(adjustedtargetresponsetime,targetstart) < current timestamp) or (actualfinish is null and coalesce(adjustedtargetresolutiontime,targetfinish) < current timestamp))