We have a BSM 9.26 IP2 installed. We have another instance in SaaS and HP use a FTP to drop a file with info that we use to fill another application and we’d like to know what is the query HP use in order to extract the info from the database and fill the *.csv file you drop in the FTP. In a previous version, before to have it in SaaS, we used :
SELECT EVENT_METER.EM_DATE_TIME ,TRANSACTIONS.TRANSACTION_NAME ,TRANSACTIONS.RANK_1_FROM ,TRANSACTIONS.RANK_1_TO ,EVENT_METER.EM_STATUS_ID ,EM_RESULT_VALUE.EVENT_METER ,EM_RESULT_VALUE.DBDATE FROM EVENT_METER ,TRANSACTIONS WHERE EVENT_METER_1.EM_TRANSACTION_ID = TRANSACTIONS.TRANSACTION_ID AND EVENT_METER_1.EM_LOCATION_ID = LOCATIONS.LOCATION_ID
But as I checked in the current database, this query is not valid anymore. Attached you can find the file with the info.
Anyone know where that info is stored now ? I need to update the query in order to be able to extract the info.
Thanks in advance