Publish System Status on Intranet

[Adrian Soosay]

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.

[Anthony_137]

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

[Paul Adams_6]

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

[Trond E. Gjelsvik-Bakke]

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.

[Anthony_137]

Very interesting Trond. Can you show your asp script ?

[Trond E. Gjelsvik-Bakke]

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

[Anthony_137]

How the result appears in html ?

[Trond E. Gjelsvik-Bakke]

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.

[Anthony_137]

I'm newbie in script effectively...

I've understood your opinion.

I will search.

thx

[Adrian Soosay]

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!

[Paul Adams_6]

Thank you Trond! This great stuff.

[Trond E. Gjelsvik-Bakke]

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.