Videos on how to make a simple database

[Jonathan_Mc]

Hi

One thing I am struggling with is how we get the product to track a singe record and record that in a data base so it can be viewed over time(in a graph format). Your UK service desk have been very helpful validating that the rcords are coming into Prognosis(which they are) but how do a i build a database to track the values and trend them over time.

As an examle, I am trying to track device Phone(PH) via the Avaya status record for the UP condition and count all registartion for phone type IP. Registraations of IP phones should be pretty static but  want to see where it fluctuates and trend it over time(day/week). Is there a simple guide or video available to show me the key steps I need to go

through?

I know I need to get on the advanced course(or get myself out to Denver !) but any pointers would be greatly appeciated.

Thanks for looking

Jon

[GeraldC1]

Hi Jon

I sent you a video for how to create something like what you're describing.

 HTH

[Jonathan_Mc]

Hi Gerald

That would be great !

I havent received anything yet though.

Thanks

[GeraldC1 · Accepted solution]

Hi @Jonathan_Mc 

No problem. Try this. Please let me know how it goes. The video has no sound just highlighted how-to steps.

If my reply answered your question please click on the 'Accept as Solution' button to help others find the answer, thanks.

[Jonathan_Mc]

Thanks Gerald- this is brilliant.

Last thing- how woud I then view the results of the collected data over time in a graph format? can I do this direct from the DB and define a time/range and could this also be published to the web UI?

Thanks again.

Jon

[Jonathan_Mc]

Hi Gerald

I think I have worked out what to do now - thanks again for your support.

This has been extremely helpful to me.

All the best Jon

[GeraldC1]

Hi Jon

You're welcome! I'm glad it helped.
All the best.
Gerald

[GeraldC1 · Accepted solution]

Hi @Jonathan_Mc 

Here's a video for viewing the results from the first video over time in a graph format in the web UI.

HTH 

[GeraldC1]

More details in this How To Guide:

https://community.ir.com/t5/How-to-Guides/Video-guide-on-how-to-make-a-simple-database-collection-an...