Linking data displays

Highlighted
05 Base Camper

Linking data displays

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.

 

 

Tags (1)
3 REPLIES 3
Highlighted
Community Manager

Re: Linking data displays

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

Highlighted
05 Base Camper

Re: Linking data displays

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.

Tags (1)
Highlighted
Community Manager

Re: Linking data displays

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

Webinar: Keep the modern workforce connected

Unified Communications has always been an important part of companies' digital transformation efforts due to its ability to enable rich virtual collaboration and communication. But with COVID-19, we've reached a break-through point.

Join Bill Haskins, Sr. Analyst & Partner, Unified Communications at Wainhouse Research, and John Ruthven, CEO at IR discuss UC challenges companies are experiencing due to the COVOID-19 crisis.

Join webinar