Can you clear your data out of the Service Manager Database? RRS feed

  • Question

  • Hello,

    We have been entering test incidents and service requests into what will be our production Service Manager 2012 system and database to test functionality.  We're going to go live January 2nd.  I was curious if there is a way to purge all of your tickets so we can start fresh.  It would also be nice to purge everything out of the data warehouse.  Is this possible to do our does it put the integrity of the databases in danger?  It's not essential to do this but it would be nice to have.

    Also, a side question is if there is a way to delete a single ticket if it is created erroneously?  I thik per ITIL, you should not do this but can you?


    Friday, December 21, 2012 6:29 PM


  • You can use PowerShell cmdlets to delete work items:

    Get-SCSMObject –Class (Get-SCSMClass –Name System.WorkItem.Incident$) –Filter “Title –like ‘%something%’”| Remove–SCSMObject –Force

    The easiest way to clear the data warehouse is:

    • unregister dw
    • deinstall dw
    • delete SQL dbs
    • reinstall dw
    • register dw again

    Hope this helps.

    Andreas Baumgarten | H&D International Group

    Friday, December 21, 2012 7:57 PM