Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

Publish System Status on Intranet

Adrian Soosay
Occasional Advisor

Publish System Status on Intranet

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.
11 REPLIES
Anthony_137
Frequent Advisor

Re: Publish System Status on Intranet

If anyone can help Adrian... i'm also interested by the solution !
Antho
Paul Adams_6
Advisor

Re: Publish System Status on Intranet

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

Re: Publish System Status on Intranet

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
Frequent Advisor

Re: Publish System Status on Intranet

Very interesting Trond. Can you show your asp script ?
Antho

Re: Publish System Status on Intranet

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
Frequent Advisor

Re: Publish System Status on Intranet

How the result appears in html ?
Antho

Re: Publish System Status on Intranet

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
Frequent Advisor

Re: Publish System Status on Intranet

I'm newbie in script effectively...

I've understood your opinion.

I will search.

thx
Antho
Adrian Soosay
Occasional Advisor

Re: Publish System Status on Intranet

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
Advisor

Re: Publish System Status on Intranet

Thank you Trond! This great stuff.

Re: Publish System Status on Intranet

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.