Home Analyst Portal

Purge ServiceManagement DB of Deleted tickets (test tickets)

Joshua_WalkerJoshua_Walker Customer Adept IT Monkey ✭✭
I deleted a few test tickets in the SM console and i need to purge the Portal db. I know i had found it in the KB but i forget where and i have been searching but cant find it.

Comments

  • Geoff_RossGeoff_Ross Cireson Consultant Super IT Monkey ✭✭✭✭✭
    Hey Joshua, run this against ServiceManagement DB:
    truncate table workitems
    Then restart cachebuilder to repopulate the remaining work items.
  • Joshua_WalkerJoshua_Walker Customer Adept IT Monkey ✭✭
    Thanks!
  • Joshua_WalkerJoshua_Walker Customer Adept IT Monkey ✭✭
    Acutally now i have another problem after running that command and restarting cachebuilder service, i only see 2 tickets in the portal and nothing else and the rest of my team dont see any tickets....
  • Joshua_WalkerJoshua_Walker Customer Adept IT Monkey ✭✭
    Acutally now i have another problem after running that command and restarting cachebuilder service, i only see 2 tickets in the portal and nothing else and the rest of my team dont see any tickets....
    Needed to also run 

    truncate table LastModifed
  • Fredrik_BorchseniusFredrik_Borchsenius Customer IT Monkey ✭
    Take a look at this KB for more information :)

    https://support.cireson.com/KnowledgeBase/View/1142#/
  • Joshua_WalkerJoshua_Walker Customer Adept IT Monkey ✭✭
    thats the post i was looking for :)
Sign In or Register to comment.