topic No Report Data for Server 2008 R2 in Server Management - Systems Insight Manager

No Report Data for Server 2008 R2

Pber — Thu, 01 Mar 2012 18:04:30 GMT

When I run a Inventory or software firmware baseline report (likely others as well), I get no data returned for any of my 2008 R2 servers. Only by 2003 servers return data. My HPSim server is 6.3 and I'm using the latest agents.

Do others have this issue?

Is there a fix?

Thanks

Pat

Re: No Report Data for Server 2008 R2

shocko — Mon, 05 Mar 2012 12:32:40 GMT

Post the results of an identify against such a server then also run a data collection job against it.

Re: No Report Data for Server 2008 R2

Pber — Tue, 06 Mar 2012 19:33:40 GMT

I think the issue is worse than I thought. I actually don't get any Software baseline information at all for any new server. Any existing server has software baseline information until I do a data collection. As soon as I do a data collection, the software baseline information is cleared. The results for both overwrite and historical data collections are the same. (I have the bi-weekly data collection task disabled and I just do data collections as needed).

Re: No Report Data for Server 2008 R2

Pber — Tue, 06 Mar 2012 19:54:09 GMT

I queried the HPSIM database directly using the query provided from the HPSim report and it produces the same results... no baseline. However if I look at the R_SWFWBaselineInformation table using SQL Management Studio, the baseline information is all there and up to date. Is there an issue with the SQL statement generated from HPSIM?

Re: No Report Data for Server 2008 R2

Pber — Tue, 06 Mar 2012 20:11:35 GMT

Digging through the SQL queries and what is returned between HPSim's generated SQL and just querying the R_SWFWBaselineInformation table directly and I've found one value that seems to be the culprit. One of the columns in R_SWFWBaselineInformation is snapshotID and HPSim always queries for a R_SWFWBaselineInformation.snapshotID = -1, however my table has values of -1 and -2. If I change the HPSim SQL query to include both snapshotID's of -1 and -2 it works.

So I'm thinking this is a bug within HPSim. It needs to query for not just a snapshotID of -1.