Find Answers

Filter Search Results
All Operating Systems:
All Products:
All Solution Types:
Source:
 
Ask a Question
Example: "Database could not be verified"  
Tips | Start Over | Solutions | Alerts | Patches | Defects  
  Results
PDF Serena Service Manager
... ................................................. 4 Incidents – TSM_INCIDENTS ............................................. ...
CMS-XML Trend report may not work after upgrade to 11.0+ - error begins with - Database exception in CReportExecTrend::ExecuteDataCollection() using SQL:
select l.TS_ID, l.TS_SUBMITDATE, l.TS_LEVEL_2_TECHNICIAN from TSM_INCIDENTS l where ( tsm_incidents .ts_id in (select ts_itemid from ts_changeactions where ts_tableid=(select ts_tables.ts_id from ts_tables where ts_name = 'Incidents') and ts_userid=(select ts_users.ts_id
CMS-XML How can I do SLA Reporting via Standard SBM listing Reports?
Oracle – Service Request Violations in last month @where TSM_INCIDENTS .TS_ID in (SELECT ITEM_ID FROM SLA_ITEM where RISK_CATEGORY=’V’ AND START_DATE >= add_months(trunc(sysdate,'mm'),-1) and START_DATE < trunc(sysdate, 'mm' and ITEM_TABLE_ID=1011
CMS-XML Example for using SLA details in SBM reports via Advanced SQL Conditions
ORACLE Example for all items in last month that violated their SLA: @where TSM_INCIDENTS .TS_ID in (SELECT ITEM_ID FROM SLA_ITEM where (RISK_CATEGORY='V' OR RISK_CATEGORY='L' OR RISK_CATEGORY='M') AND START_DATE >= add_months(trunc(sysdate,'mm'),-1)
PDF Microsoft Word - ssm_schema_doc
... ................................................. 4 Incidents – TSM_INCIDENTS ............................................. ...

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs