SQL Query to list the filename processed

[Marilyn Singley]

I have a query that I run -- that lists the FILEname DST -- etc. 
However that's not enough for a Developer -- wants to find the Name of the file that was processed as well. 

Anyone have any ideas ?  I tried several other options in EH, but none list the exact filename that was processed. 


select Eh_client, Eh_name, EH_HostDST, EH_FILENAMEDST, EH_Message, EH_Sent, EH_RDate, Eh_ah_idnr, Eh_Title from Eh
where Eh_otype = 'EVNT'
and EH_client = 200
and EH_name like '%EVNT.FILE.TRIGGER.NAMEOFAPPLICATION%'
order by EH_RDate

Thanks
Marilyn

[Peter Grundler]

Hi Marily,

I assume that the task is already deactivated, therefore no longer available in EH. You have to query AH instead.

best regards,
Peter

------------------------------
Capture Europe
------------------------------

[Marilyn Singley]

Thanks.. I tried that and I still can't find the filename processed:

select Ah_client, Ah_name, AH_TimeStamp4, AH_HostDST, AH_FILENAMEDST, AH_Sent,
Ah_Title from Ah where Ah_otype = 'EVNT'

and AH_client = 200
and AH_name like '%EVNT.FILE.TRIGGER.APPLICATION%'
and trunc(AH_TimeStamp4)>=trunc(sysdate -1)

[Peter Grundler]

Hi Marilyn,

please try to start with a simple query like

select AH_Name, AH_FileNameDst
from AH
where AH_OType = 'EVNT'
and AH_Name = 'EVNT.FILE.TEST'




If you get meaningful results, add additional statements one by one.

kind regards,
Peter



------------------------------
Capture Europe
------------------------------