Scott, Thanks for the link. I have tried using ARUtilities off and on since it first came out, and it doesn't seem to work well in my environment (I'm assuming it's a SQL Server 2005 problem)
Thanks, Shawn Pierson -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Scott Parrish Sent: Monday, August 20, 2007 7:33 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy workflow modification auditing ** Shawn, I utilize ARUtilities to help me find all workflow modified by a single user. I'm sure there is probably a way to get the same information utilizing SQL, but figure someone has already done it for me. It's a great tool for other things as well. I don't leave home without it. www.arutilities.com <http://www.arutilities.com/> Scott Parrish IT Prophets, LLC (770) 653-5203 http://www.itprophets.com <http://www.itprophets.com/> ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Monday, August 20, 2007 8:25 AM To: arslist@ARSLIST.ORG Subject: Remedy workflow modification auditing Good morning all, Let's say, hypothetically, that you work in an environment with an OOTB ITSM 7 environment, and you have been given a directive to not modify any OOTB workflow without getting prior approvals from all I.T. directors as well as the VP over I.T., plus you have to document things in detail, and follow best practices to make sure your modifications and workflow are easily identifiable. Then let's say, also hypothetically, that you work with someone whose skill with Remedy matches their ability to follow the rules. Since this hypothetical person has made changes to the OOTB workflow without any documentation, and seems to suffer from amnesia, I would (hypothetically) like to be able to audit any changes that this person may have made and restore them to the original OOTB workflow. Does anyone know how to find all workflow that has been modified by a single user? I've been thinking of trying to build a SQL query to help me find this stuff, but I'm not sure if there is an easier way. Also, is there any way to integrate Visual SourceSafe into Remedy and make it required, to where there is no way through the Admin tool to disable it? VSS is not any good if it gets disabled by someone who thinks it's slowing their computer down, rather than the (hypothetical) program that randomly changes their desktop background image. Thanks, Shawn Pierson Private and confidential as detailed here <http://www.sug.com/disclaimers/default.htm#Mail> . If you cannot access hyperlink, please e-mail sender. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ Private and confidential as detailed <a href="http://www.sug.com/disclaimers/default.htm#Mail">here</a>. If you cannot access hyperlink, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"