can i access the sybase by sql to extract the KPI? how to do it?
can i access the sybase by sql to extract the KPI? how to do it?
Re: can i access the sybase by sql to extract the KPI? how to do it?
Yes it's possible.
1. Connect to M2000 server as dbuser
2. Run isql -SSYB -Usa -Pemsems (default parameters)
If you have M2000 DB structure please share it
Re: can i access the sybase by sql to extract the KPI? how to do it?
Hello there,
Before you can extract KPIs, you need to create a template for them. M2000 automatically creates a table for this template that starts with tbl_result_xxxxxxx (x's refers to certain index which you can find in measurement management).
Before looking into your KPIs you need to go to the database first, just type the following commands at the sql prompt,
use pmdb
go
you can use the command sp_tables to other tables in the database.
