Linking data displays

[Colin_Haycock]

Hi

This might have been asked before but I couldn't find anything on the forums.

I'm trying to build a display that combines information from multiple views

I am tracking Avaya phone status changes in MpAvailability and I want to combine that with the information in AvayaPhone using the common extension number field so that I can display the current state associated with the estension. Ideally I also want to include a last call date record from AV-CDRs and the station name and building AvayaPhoneDetails.

The objective is to build a display that we can use to identify extensions not being used.

[GeraldC1]

Hi,

That's a cool idea. Here's a Community post with one way to track last up time where an availability threshold can populate MpAvailability from an Avaya phone status field. It can only do this based on one record.

https://community.ir.com/t5/Unified-Communications/Avaya-Phone-Status-Idea-Suggestion/m-p/5537#M3011

Regarding merging records an easier way would be to use drill-downs in Prognosis, where clicking on an entry, in MpAvailability, could open up a display with more details about that entry, based on the unique identifier in the MpAVailability being able to match rows in the other records. I hope that makes sense.

HTH

[Colin_Haycock]

Thanks yes, I already saw that and have implemented it to track the phone up/down time.

I don't really want an interactive display, the idea is to be able to generate a list we can easily export to Excel which we can then use as the input to a batch station removal job.

[GeraldC1]

Well done! 

To merge the records there is a way at the code level but would require our Consulting Services to put in a custom solution as a paid scope of work. Please contact your account manager at IR if you are interested.

Otherwise, writing the data out to an SQL database is one way of doing it and then SQL scripting should be able to merge those. Prognosis database collections can write to SQL via ODBC.  Help reference:
https://community.ir.com/t5/Online-Help/bg-p/Online-Help?Prognosis_11-5/mergedProjects/System_Functi...

HTH