Export alarm M2000 to csv

[orazak]

Hi Huawei expert,

can somebody share how to export alarm to csv daily, so we can collect it as database ?

thanks

[kevin_h811]

Hi ORAZAK,

Here's you'll gonna do...

ALARMS

1. Click Topology > Main Topology

2. Right click the BSC / cell you want to query the alarms with

3. Click Query alarm

a. Current fault alarms (for current alarms)

b. History fault alarms (for history alarms)

Take note that alarms collected are in .csv file....


Pls add rep and/or thanks if it does help/useful to you...

Regards//

[kaizzer545]

Query in Sybase database with priviliged user

below one manual of sybase

SYBASE.pdf - 4shared.com - document sharing - download (http://www.4shared.com/document/fD228c3K/SYBASE.html)

[dacoder]

Hi
In M2000 there is menu to browse Alarm Logs (cleared as well as uncleared alarms). After querying the alarm for particular day(s), you can save it in desired formats.

Alarms can also be browsed and saved through WebLMT.

Thanks

[sabila]

if u want to collect perhour u can check at task management
but i u want to collect it more persistent like 5 minutes update u can use isstar language
may u can search at this forum
i had share it

[orazak]

Query in Sybase database with priviliged user

below one manual of sybase

SYBASE.pdf - 4shared.com - document sharing - download (http://www.4shared.com/document/fD228c3K/SYBASE.html)

thanks to all and kaizzer for good answer, i want to generate automatically by cron. do you have default user password for sybase db in Huawei sir ?

[kaizzer545]

I think :

user:sa
pwd:emsems

but I'm not sure

[tikozo]

Kaizzer,

Do you know what the name of table and db if i can take the NE Monitor result?

I need all NodeB out of service....

V200R10

Thanks

[tester]

can somebody share how to export alarm to csv daily
M2000 does this by itself:p
Use Maintenance > Task Management > File Interface > Alarm Data Export for modification of settings

[kaizzer545]

actually not, maybe you can mapp all the DB it will tired but it's incredible to do it with sybase... no just csv


BR