Vat of Knowledge

Everest Corporate is an excellent tool to gather informatoin about a computer. It can collect such information as:

• Computer summary
• Computer name
• Motherboard
• Memory
• CPU
• Chipset
• BIOS
• Hard drives
• Operating system
• Service packs
• Installed software
• Scheduled software
• Services
• Processes
• Network
• Security

And a lot more. It can also be run at the command line and output in many different formats including HTML, CSV or SQL DB.

Creating the SQLDB

I’ll cover this quickly as I have to get going here, but I need to jot it down for future reference, as it’s something of an undocumented pain in the ass. You have to really dig for the on forum article about it over at www.lavalys.com/forum to find it. Here’s the deal:

FIRST you have to START the Enterprise Manager and there YOU’VE to add a new database with the name “Everest”.

THEN YOU can start the query analyser and there select at the top the Database (“Everest”) and then you can copy and paste the schema and Then run the query.

The query they’re referring to is in the Everest installation folder under “SQL_Schema” folder. Click on start, run and type in “isqlw” to start the query analyzer. Connect to the SQL server in question and highlight the Everest database on the left. Paste the contents of DB – SQL Server.sql into the query window and run it. Walla, your Everest DB is ready to go now and accept input.

To get the database feature working, simply open up the GUI of Everest on the network machine that will be hosting the command line script. Go to file, preferences, database and connect to the database. You can also import data from CSV into this database by hand or you can use the command line switch /DATABASE.

Share/Bookmark