topic HPSIM Reporting SQL OUTPUT in Server Management - Systems Insight Manager

HPSIM Reporting SQL OUTPUT

Annette Jones_2 — Fri, 26 Nov 2004 10:29:19 GMT

Anyone know MSSQL2000 for Windows, I thought I would create a report for capacity management, cut and paste the sql output into MSSQL2000 query analyzer, which works fine. However I need the output of the sql statement to write to a file so that it can be collected on a daily basis.

Any idea's on how to output to a file?

ta

Re: HPSIM Reporting SQL OUTPUT

Rob Buxton — Sun, 28 Nov 2004 14:20:00 GMT

I use the osql utility. Not sure where it comes from, but it has a number of qualifiers among them an input for the SQL Statement and an output for, well the output!
There's also isql, but it's not quite as powerful as osql.

But, SQL does not naturally provide a neat display. You'll need to format the output.

Re: HPSIM Reporting SQL OUTPUT

Aravindh Rajaram — Mon, 06 Dec 2004 23:44:50 GMT

Go to Query Analyzer and then press Ctrl+Shift+F

Then execute the query. Now you'll get the save dialog box to store the output of the query on to a file.

To get the results in the grid (on the query analyzer itself) press Ctrl+D and then execute the query.