How to get (POS/ATM)terminal ids inactive from one month/Week.

[G_Prasad]

Hi Team,

I want to configure one display and report which will show the list of terminal ids which are not transacting(inactive) since last month or week.

So we can do it by checking transaction time but from which record? which record can be use to fetch transaction records and compare its transaction time from 1 month.

It is not possible to use TRANDET record to compare transaction time as we have a huge transaction volume and will not able to fetch last month transactions to compare.

To clear my query, please find attached image.

It is showing total count of inactive terminals, I also want to see terminal Id's and its other details.

Thanks in advance.

[ChristopherS]

@G_Prasad  

The only record that has this "out of the box" is the "ATMMON" aka "Base24ATM"  (even though it says Base24 its the same record on Base24, Base24eps, Postilion, Connex) record that spans multiple and only applies to ATMs as it has "Last Message Time" and "Last Transaction Time".

Our Postilion POSTERMS record I believe off the top of my head also has these similar fields (though I'd need to double check) as ATMMON.. I am not aware of any equivalent on any other platform like getting it from the PSTD (if I am recalling right) on Base24.  Its something we could look at building in services though to do as I believe we've loked at doing it before for a customer and knows its possible. 

[G_Prasad]

Getting data from ATMMON may solve it for ATM terminals, how to get data for POS terminals?

Is there any DB which collect POS transactions data of more than a month so that we can fetch it by applying transaction time criteria.

Thanks,

Tushar Devkar

[ChristopherS]

@G_Prasad 

Q: Is there any out of the box database collection the keeps Transaction Detail (TRANDET) for extended periods of time?

A: Out of the box, no other than Business Insight but that is not available for thresholds or displays without services putting together something relatively quickly to show this to you out of that data source. 

Though a Prognosis database collection could be setup for this purpose but it would grow very large and would be a bit slow.. and off a Base24 system if not done correctly can negatively effect processing to setup a continous read off the TLF/PTLF.  Business Insight does this in a low impact manner and it basically does it by doing limited pulls of data vs. continous. 

If you wanted to do it yourself and specifically for this purpose, you could setup a short small database collection (<1 day at most but even possibly 1 hour), then use a summary database collection with autosum job to summarize up terminal and last transaction time once an hour or every 30 minutes.. then build a report off of that summary.

[ChristopherS]

@G_Prasad 

The other approach is use a transaction summary on an ASSOCIATE by the TERMID filtered by your terminals only (otherwise you might get some odd results).

Then you might be able to use the META Interval time to get the information you want. It might not get you exact times but it would at least tell you the day or a narrower time.. it might be a bit tricky though depending on the number of terminals you have and a couple of other complicating factors... but should be absolutely doable.

Christopher