Linking data displays

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
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

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)
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: The Journey to Microsoft Teams - Readiness Phase (part 2)

Having looked at the planning phase in session one of this series, we will turn our focus to the readiness phase. The all important technical capabilities assessment, ensuring the network, endpoints and users are adequately prepared for the move.

Hear first hand from IR's Global Head of Information Systems and Technology, Jason Schwendinger, on how he has been tackling these issues.

Join webinar