topic Re: Publish System Status on Intranet in Server Management - Systems Insight Manager

Publish System Status on Intranet

Adrian Soosay — Mon, 24 Jul 2006 18:43:04 GMT

Dear forumers,
Is there any way where I can publish the system information (e.g. system status) that displayed on Insight Manager onto my company's Intranet? Have anyone done this before? Thanks.

Re: Publish System Status on Intranet

Anthony_137 — Wed, 26 Jul 2006 10:03:07 GMT

If anyone can help Adrian... i'm also interested by the solution !

Re: Publish System Status on Intranet

Paul Adams_6 — Wed, 26 Jul 2006 10:32:14 GMT

Yes, this is a great idea! I hope someone can help.

Re: Publish System Status on Intranet

Trond E. Gjelsvik-Bakke — Thu, 27 Jul 2006 01:34:30 GMT

Hello.

Yes, I have done this.
This is what I did:
I created some .asp scripts that connects to HP SIM database, and return with the status.

The entire process is all about SQL query.

Please look at the attached image

I show here servers that are: Critical, Major, Minor and Normal.

I have also collected info about diskspace on each server.

Reply to me if this was of interrest.

Re: Publish System Status on Intranet

Anthony_137 — Thu, 27 Jul 2006 02:00:16 GMT

Very interesting Trond. Can you show your asp script ?

Re: Publish System Status on Intranet

Trond E. Gjelsvik-Bakke — Thu, 27 Jul 2006 06:26:36 GMT

Hello.

Here are the DB connection and the SQL query.

set HPSIMConn=server.CreateObject("ADODB.Connection")
HPSIMConn.Open "Insight_v50_0"

set rsCrit = Server.CreateObject("ADODB.recordset")
rsCrit.Open "select DeviceName, DeviceStatus, IPAddress, ProductName from R_Inventory where DeviceKey in (select devices.deviceKey from devices JOIN notices(NOLOCK) ON devices.deviceKey = notices.deviceKey and notices.NoticeType = 1 WHERE ( devices.OverallStatus = 5 ) ) order by DeviceName ASC", HPSIMConn

set rsMaj = Server.CreateObject("ADODB.recordset")
rsMaj.Open "select DeviceName, DeviceStatus, IPAddress, ProductName from R_Inventory where DeviceKey in (select devices.deviceKey from devices JOIN notices(NOLOCK) ON devices.deviceKey = notices.deviceKey and notices.NoticeType = 1 WHERE ( devices.OverallStatus = 4 ) ) order by DeviceName ASC", HPSIMConn

set rsMin = Server.CreateObject("ADODB.recordset")
rsMin.Open "select DeviceName, DeviceStatus, IPAddress, ProductName from R_Inventory where DeviceKey in (select devices.deviceKey from devices JOIN notices(NOLOCK) ON devices.deviceKey = notices.deviceKey and notices.NoticeType = 1 WHERE ( devices.OverallStatus = 3 ) ) order by DeviceName ASC", HPSIMConn

set rsNor = Server.CreateObject("ADODB.recordset")
rsNor.Open "select DeviceName, DeviceStatus, IPAddress, ProductName from R_Inventory where DeviceKey in (select devices.deviceKey from devices JOIN notices(NOLOCK) ON devices.deviceKey = notices.deviceKey and notices.NoticeType = 1 WHERE ( devices.OverallStatus = 1 ) ) order by DeviceName ASC", HPSIMConn

Re: Publish System Status on Intranet

Anthony_137 — Thu, 27 Jul 2006 06:43:05 GMT

How the result appears in html ?

Re: Publish System Status on Intranet

Trond E. Gjelsvik-Bakke — Thu, 27 Jul 2006 07:11:22 GMT

Hello.

How familiar are you with asp scripts ??

Make an ASP file, and place the code in there.

To publish data, you will have to run through the recordset, and display one record at a time.

I have done this in a table.

I have been writing on this scripts for a while, so I don't want to make the entire script avaliable.

Do you see my point ?

All you have to do is get the rights data from HP SIM db, and present them on an representable wey on your intranet site.

I don't know how your intranet design is, and I don't know how you would have it presented.

Re: Publish System Status on Intranet

Anthony_137 — Thu, 27 Jul 2006 08:07:50 GMT

I'm newbie in script effectively...

I've understood your opinion.

I will search.

thx

Re: Publish System Status on Intranet

Adrian Soosay — Thu, 27 Jul 2006 20:29:09 GMT

Hi Trond,
I'm familiar with ASP scripts. My only problem was tring to sort out which table from the SIM database that I can extract the information. Thanks to your hardwork, I'm now able to get the information I want publish onto my company's intranet. Thanks again!

Re: Publish System Status on Intranet

Paul Adams_6 — Fri, 28 Jul 2006 08:19:35 GMT

Thank you Trond! This great stuff.

Re: Publish System Status on Intranet

Trond E. Gjelsvik-Bakke — Mon, 31 Jul 2006 05:01:38 GMT

Hello.

I am glad to be of help to you all on this. I really hope that you value my response, and give me some points :)

The best thing is to create a view. There you can add some code, as for calculating free disk space and more.

I am currently building and entire website for complete monitoring of our server room.
- Server Status
- Used disk space for each server
- Temperatur in our server room
- and more will come, WMI and more...

Adrian:
I have provided you with the entire asp file for serverstatus.

You might have to edit it, to make it fit for your needs and design.