Home General Discussion

Data Warehouse--no attachments, action logs and history?

Carol_LeeCarol_Lee Customer IT Monkey ✭
May I know if it is by design that work items' attachments, Action Logs and History cannot be transferred to Data Warehouse?  If so, why?  Our company policy says we have to keep everything for at least 10 years.  We cannot delete records from the database if they are not readily available in the Data Warehouse.  Please advise.

Best Answer

Answers

  • Justin_WorkmanJustin_Workman Cireson Support Super IT Monkey ✭✭✭✭✭
    @Brian_Wiest is right.  The DW doesn't capture anything past a summary.  I've gone through a similar process of archiving attachments from resolved incidents.  
  • Nick_FlintNick_Flint Customer Advanced IT Monkey ✭✭✭
    edited June 2018
    @Brian_Wiest Did you deploy the Action Log extension in a SCSM 2012 or SCSM 2016 environment?
  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
    Both
  • Carol_LeeCarol_Lee Customer IT Monkey ✭
    Thanks for the advice @Brian_Wiest @Justin_Workman.  I will need to go back to my team to see what needs to be done.
  • Carol_LeeCarol_Lee Customer IT Monkey ✭
  • Marc_DroesbeckMarc_Droesbeck Customer IT Monkey ✭

    @Brian_Wiest, Very interested by your solution also ! can you send us a other link ? http://www.systemcentercentral.com/extract-attachments-from-scsm-workitems/ is no longer available

    or post how you did your extact solution for : We did a variation where we are grabbing all attachments after closure and extracting them into a SharePoint document library, then appending the resolution field with the file path. 

    that would be so much apprecited you have no idea !

    Thx in Advance !

  • Justin_WorkmanJustin_Workman Cireson Support Super IT Monkey ✭✭✭✭✭

    @Marc_Droesbeck - I can't speak to uploading directly to sharepoint, but the app I posted here might help in a manual capacity if nothing else.

  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
Sign In or Register to comment.