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_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
