SIM Reports

[cmellor]

Hi, I have been tasked with setting up a couple of CIM reports and having them report to a sharepoint site on another server.

Is there an easy way to do this. Or does anyone have any examples I could like at.

I would like to get the warranty info to report to sharepoint.

Thanks

[Rob Buxton]

I don't have any examples, but the way I'd start is to use the HPSIM reports to generate a report that seemed to extract the data I wanted.
You can then view the SQL and build this into a batch file to extract the data directly from the HPSIM database.

Or you could look at the command line utility mxreport. I've not tried that approach, but I have created web pages that use data extracted directly from the HPSIM database.

[NJK-Work]

Another option is to use SQL server DTS (data transformation services) to pull the data and manipulate if needed. This is assuming your SIM server uses SQL 2000 or SQL 2005 (not MSDE) as DTS comes as part of the full SQL product.

I am totally SQL illiterate, but even with my limited knowledge of SQL I was able to dig in make some good use of DTS - so don't let it intimidate you :). We use it to extract SIM data, transform it, and bring it into a custom servers database (that also uses SQL 2000 as the backend). But DTS can export to other formats such as text or XLS. You should be able to export data to a format suitable for you, transform it as needed, and then send it to SharePoint.

Nelson