OK, whilst the views have helped a little in terms of seeing the data. I would like to export the data using SQL Server Integration Services (SSIS) into a SQL Server database and have the data refreshed on a periodic basis so we can easily report on it using SSRS (Reporting Services). This is easily achieved within SQL Server but I need more permissions to be able to extract the data from Sybase.
So my original question actually still stands. How do I grant additional permissions to the DFM Database User that I have created and/or find out the passwords to the built in Sybase database users DBA, DBO, SYS etc?
or am I stuck with exporting the data from the views using the DFM command line & then using SSIS to import these flat files into a MSSQL database? Can you schedule the 'export' to flat file?
One final question...
Does anyone know whether MSSQL will be supported in the next release of Operations Manager?
Thanks in advance.