How can I use table data for data source?

[JDeancac]

Hello everyone, I need help

I have table in DBMS (MSSQL)

table name : TB_Currency
-----------------------------
time currency
-----------------------------
15:05 20000000
15:10 29394955
15:15 30302045
15:20 22020201
------------------------------
DBMS is MSSQL
table data(rows) is updated every 5 minutes

I wanna view graph on cacti using [currency] value
How can i do this?

Thanks
[/list]

[Hyperlord]

Hi,

search for MSSQL in the forums.
Do you use Cacti on Linux or Windows?
-> Check the WMI Guides...
-> http://forums.cacti.net/search.php?mode=results

Do you want to do this with SNMP?
-> Buy SNMP Informant, then set up the stuff ...

brgds

[drewshin99]

this is cool, it's for like a stock/currency graph charting? so there's no snmp involved, just graphing data in a table. it would be cool if cacti could do something like this, but i guess all you really need is rrdtool.

[gandalf]

This seems quite an easy task to me. Surely, it should be possible to access the MSSQL tables from remote; this may requires sth like an MSSQL client. Then, simply phrase your SQL that the cacti poller will execute to access the tables directly, without SNMP, cgi or stuff.
R.