Server Information Database

[Greg Stark_1]

We are in the process of developing a Access database to house all of our server information such as:

hostname
ip
hardware info
apps
db's
support #'s
lease/own info
etc..

Before I get too far exposing my terrible Access skills, I thought I'd check the forum to see if anyone already has created such a thing.

Thanks again,
Greg

[Michael Tully]

You can use a number of things.

Have a look in the two recent script postings:

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x836cc1c4ceddd61190050090279cd0f9,00.html
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x026250011d20d6118ff40090279cd0f9,00.html

We use a tool called 'SIR' from HP. As far as I know this tool is only available in Australia/New Zealand. It is a web based tool that collects information and creates a front end web page.

[Sridhar Bhaskarla]

Hi Greg,

Everyday we find one or the other thing. Here is what I think

Host Name
Primary SA
Secondary SA
Model
Serial Numer
System Handle
Asset
OS
OS Patch
PDC level
Total RAM (Mb)
Processors
Address
Location
Tile
Environment
Business System
IP Address
Primary DNS Server
Secondary DNS server
Internal Disk & capacity
External Disk type & capacity
Role (Database|application)
Database Instance
Application Name

Some of them can be automated.

-Sri

[Sunil Sharma_1]

Hi,
Except support and lease info u can collect all other information from script generally used by HP representative called NICKEL

it collect all server hardware and software related information in html formt.

You can ask this from Your HP representive. I don't have it now if yo really want just let me know i will get it...

Sunil S