vCenter Operation Manager Alerts export to excel

[raj_rooban]

I don't find any option to export Alerts data into excel if we want to manipulate the data in a spreadsheet. Is there a way we can export or any alternative tips for the same?

[gradinka]

you can try leveraging the LogFile otubound plugin. Or the Repository adapter (it's desribed in the administration guide).

[aaghabekyan]

Also you can create RSS feed from Alerts widget, then convert html to excel. About creating LogFile outbound plugin, this is also can be useful, you can recieve .txt notification for each of alert, then merge into one file and convert txt file to excel.

[Ramraj_4k]

/usr/lib/vmware-vcops/tools/RepositoryAdapter/Conf/Conf.properties file

If your vcops is installed on the appliance mode...then mention only the FSDB details...rest of the SQL & Oracle DB is applicable for the Vcops - exe based installation either in Windows /Linux based OS.

Updat the follwoing value only ..

#source FSDB

sourcefsdbDriver=com.integrien.fsdbjdbcdriver.FSDBJDBCDriver

sourcefsdbUrl=rmi\://<IP address>\:1199/DBMS

Mention the output path :

#incremental = false means full for maxDays days

incremental = false

maxDays = 365

retryConnectCount = 5

#milliseconds

delayBetweenRetries = 10000

exportToCsv = true

csvFilePath = C:/csv.csv

csvDelimiter = ,