Do you see a performance hit for having the logging turned on? Also, is there another site with more info about the Log Parsing & Management session. I can't get funding for WWRUG.
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: Monday, July 22, 2013 4:37 PM To: arslist@ARSLIST.ORG Subject: Re: Attachments Vanishing ** Do you have server side logging turned on? If you have Filter/SQL/Escalation logging turned on you should be able to search for the INSERT/DELETE to the B table and see who did it and if you are really lucky the workflow that did it. One you know who and when you can hopefully identify a user procedure that is being done (or not done) or system oddity that is doing it. In the last 8 months or so I have become a fan of leaving server side logging on full time. I have been able to track down so many odd things by logging API/SQL/Filter/Escalations to one ~2 GB log file. PLUG: I have seen a preview of the tools that will be demonstrated in the "Log Parsing and Management" session at WWRUG13 (http://wwrug13.com/breakouts.html) and these are amazing for making that 2 GB log file something manageable and useful in a hurry. Jason On Mon, Jul 22, 2013 at 1:17 PM, Pargeter, Christie :CO IS <cparg...@lhs.org> wrote: ** This has nothing to do with Tasks. This is all around the attachments on the parent Change's Work Info tab. Our Help Desk is building these Changes with a template then go in and add a Work Info with an attachment (Summary is just "notes & CRQ" then attach the document). Then they select Next Stage & Save to the db (all of this is at the Mode = Create). Then we hear that the attachment either never arrives to the other team or it "vanishes" after a "couple of days". From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pargeter, Christie :CO IS Sent: Monday, July 22, 2013 11:16 AM To: arslist@ARSLIST.ORG Subject: Attachments Vanishing ** Has anyone had this with 7.6.4? We are getting reports of a ton of Change tasks "vanishing" from the system. I asked my DBA to turn on logging for the B tables but I am not seeing anything. We are using the Classic view of ITSM 7.6.4. Thanks ARS 7.6.4 SP 4 ITSM 7.6.4 SP 4 RKM 7.6.4 SP 4 SLM 7.6.4 SP 1 Window 2008 - 64 Bit MS SQ 2005 IIS/Tomcat MidTier 7.6.4 SP 4 _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"