Tauf, Status History is stored in the H version of a table, or if you use views, it's stored in the sh view of the form. There is one row for each record in the main table and two columns for each status, one is the user, the other is the time.
_____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Chowdhury, Tauf Sent: Friday, January 29, 2010 10:02 AM To: [email protected] Subject: Reporting on Status*-History field in ITSM ** All, When I use the User Tool reporting on an incident, I have the "field" Status*-History available with "sub fields" like New.TIME and Assigned.User and Assigned.TIME. I can export to CSV and all is well. However, I guess it's not really a field since I can't find it on the form using the Admin tool. What I'm trying to do is find the field either on the form or the DB level so I can expose it to the Remedy Analytics Universe. Any help on this or just some insight as to how those "Fields" are generated/captured would be helpful Environment: AR 7.1, ITSM 7.0.3 Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Informatics-Infrastructure Office: 631.858.7765 Mobile:646.483.2779 _____ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
