Old data in DW RRS feed

  • Question

  • How can I force DW synch with SCSM Db? I can see on reports some old (and deleted) services, support tiers and etc.
    • Changed type PDR2010 Tuesday, August 2, 2011 1:27 PM
    Tuesday, August 2, 2011 1:00 PM

All replies

  • You might need to add "And IsDeleted=0" to your SQL so that reports don't show deleted items.
    Wednesday, August 3, 2011 7:23 AM
  • which table does the IsDeleted column belong to ?
    Sunday, November 20, 2011 8:19 PM
  • Most of the views that point to objects have an IsDeleted column, such as IncidentDimvw, WorkItemDimvw, DisplayStringDimvw.
    Sunday, November 20, 2011 8:24 PM