Rene’s Blog

Nice article about checking the free disk space on a VMFS volume.

I changed the vb script “Pingmany” in to HTA code. This gives a more flexible use of the script.

  hta_pingmany V1.0 (3.1 KiB, 236 hits)

[print_link]
Working at a customer with three Virtual Centers (VC), I needed a way to document the security roles and their permissions, and a easy/consistent way to apply these role/permissions to the other VC’s.

So I created an Excel sheet to generate SQL files per role (incl. permissions), which can be imported directly in the VC (MS-SQL) Database to create the roles.

Scroll down to the end of this post to download the sheet.

Note: This sheet is created and tested on VC 2.0.1.

How to use the excel sheet and the generated sql files.

• Open the sheet in excel. When you open the excel sheet allow macro’s to execute.

• Fill in the names of the roles in the first cell of the column, eg. replace the text ‘Role 1′ with ‘Operations’.

• If the permissions in columns are set, press ‘Generate SQL Role.

• Select the role to generate and press ‘OK’.

• The <role_name>.sql file will be written in the c:tempvc-sql folder.
• Logon to the MS-SQL server with Administrator rights to the Virtual Center Database.
• Copy the sql file on to the MS-SQL server, eg. ‘c:temp’
• Start the ‘Microsoft SQL ServerQuery Analyzer’.
• Log on to the SQL server (local) with windows authentication.

• Choose in the tool bas the right VC database.
• Open the <role_name>.sql file with File -> Open.
• The sql statements of the <role_name>.sql file is displayed in the Query screen.

• To execute the sql statements on the selected VC database, press the green arrow on the toolbar.
• The result of is displayed below the Query screen.

• To see the role in the virtual center, restart the virtual center service on the VC server.

• In the column you will see the new ‘Operations’ role added.

• When the ‘Operations’ role is checked you will see the permissions.

Download

  VI roles and permissions Excel sheet v0.1b (94.5 KiB, 879 hits)

Update 14-01-08

Find here a schema of the VC database.

To perform the check of availability of many servers I created a simple vb script. This script will read a list of servers from a excel sheet, ping the servername (or ip adress) and will punt the result in a other column of the excel sheet.

  vbs Ping Many (2.4 KiB, 256 hits)

To perform the check of the power status of HP servers you can user the ILO(2) interface. I created a simple vb script. This script will read a list of servers from a excel sheet, perform the check on the ILO(2) interface and and will punt the result in a other column of the excel sheet.

  vbs Check Power (153.3 KiB, 237 hits)