D4WNO

I have an Excel document already that pulls loads of information from Remedy and displays it in the spreadsheet. I just need a new column that can pull the text from this field but look specifically for that wording only as the audit trail contains a lot of information

Thank you but I already have a report which contains all the other data, I just need to add this final step into the Excel document

Good morning all, I hope you can help as I can't find a solution to this elsewhere on the web. I work for a set of Support teams and I need to see if I can pull a report that shows when certain tickets were passed over to our teams. The only field that I can see this information within is under The History Info tab, then Audit Trail dropdown. The text I require looks something like this within the trail: "25/05/2011 16:38:53 iss28126 Assigned to Group [ERP-IT-REQUEST-FINANCE > ERP-SAP-FINANCE]" I need to somehow report (preferably via an existing report I have within Excel that pulls data from Remedy) on examples like below. I have a list of ticket IDs and I want to be able to search on If "Audit Trail2 contains "Assigned to Group [any group] > ERP-SAP-FINANCE then tell me the date (or pull the whole section and I'll just look at the first 10 digits containing date once the data is in my report) Is there a better way to do this as it's proving really tricky? If this date was held in a field by itself then I could pull the data easily, but I've got to first extract it from a whole audit trail/history. Would really appreciate it if anyone has any ideas, thanks all.

That's great, just tried that and got my answer

Hi everyone, I have a question around dates within BMC Remedy 7.5. We are an international company and use the same platform globally. My question is around the view of dates. For example, in the UK we would see date 11th April 2012 as 11/04/12, in the US they use 04/11/12. Does it depend on how a particular users Remedy is set up as to how they see dates automatically entered by the system? What I mean is if 2 people in the UK and the US were looking at the same ticket at the same time, would they be seeing the dates the same or in their own country's format?