Monday, 8 February 2016

RightFax Management Pack from Infront consulting


RightFax Management Pack from infront

  • Infornt Consulting has released a deep dirve Management pack for RightFax.
  • This helps Montior RightFax End to end and give great visibility of the problems that arises.
  • You can see a detail video from Infornt Consulting on how it works below


Dell EqualLogic Storage MP Suite for SCOM v 6.0 supports PS 6610 and Firmware 8.1.x

Dell EqualLogic Storage MP Suite for SCOM v 6.0


  • The Dell EqualLogic Storage Management Pack Suite v6.0 enables System Center 2012 R2 Operations Manager, System Center 2012 SP1 Operations Manager, System Center 2012 Operations Manager and System Center Operations Manager 2007 R2 to Discover, Monitor and accurately depict the status of Dell EqualLogic PS Arrays on a defined network segment.
  • The new version supports EqualLogic devices PS6610.
  • Latest version also support Firmwares 8.1.x



Installation Steps by Step:

  • Download the file to a directory on your hard drive. The file downloaded is a self-extracting executable.
  • Go to the location where you downloaded the file and double-click the executable to unzip the files. The default extraction folder is " C:\Program Files\Dell Management Packs\EqualLogic Storage Management Suite\6.0 ". You may select a different location for file extraction by editing the path.
  • Launch the Dell_EqualLogic_Management_Pack_Suite_x86_x64.exe file from the extracted location. The welcome screen for Dell EqualLogic Management Pack is displayed.
  • Click Next. The license agreement is displayed.
  • To continue the installation, accept the license terms after reading them, and click Next.
  • Click Change (if required) to change the default installation folder and click Next. The Ready to Install the Program screen is displayed.
  •  Click Install. The Installing Dell EqualLogic Storage Management Pack progress screen is displayed.
  • Click Finish on the Install Shield Wizard Completed screen.

Citrix Aquires Comtrade Managemet pack

Citrix Aquires Comtrade Managemet pack

  • Citrix Product is one of the most important product that is monitored via SCOM
  • Almost 50 % of desktops and app are Citrix Apps in any environment.
  • Comtrade was the only reliable MP for Citrix across the world for SCOM.
  • Citrix has now aquired Comtrade MP which means we will get it lke HP mp's free of cost .

Read More:-->

Sunday, 7 February 2016

SQL Query to get the Maintenance Mode History for Particular Server SCOM 2016


SQL Query to get the Maintenance Mode History for Particular Server SCOM 2016



  • Many time you get questions from Management whether the particular server was in Maintenance mode and how long.
  • It has always been a challenge for SCOM engineer to pull the Data, as there is now easy way to pull this information.
  • You can use the below SQL query to get that information.
  • What this query does is that it queries the "OperationsManagerDW" database in "ManagedEntity"  table "MaintenanceMode" Table and "MaintenacenModeHistory" table where the ManagetEntity Row ID matches Maintenance mode Manage entity RowID and Maintenance Mode RowId matches Maintenance Mode Manage Entity Row ID.
  • Replace the "Servername" with server name you wan the report for and you will get the Maintenance mode History report for the server


********************
USE OperationsManagerDW
SELECT ManagedEntity.DisplayName, MaintenanceModeHistory.*
FROM ManagedEntity WITH (NOLOCK) 
INNER JOIN
MaintenanceMode ON ManagedEntity.ManagedEntityRowId = MaintenanceMode.ManagedEntityRowId 
INNER JOIN
MaintenanceModeHistory ON MaintenanceMode.MaintenanceModeRowId = MaintenanceModeHistory.MaintenanceModeRowId
where DisplayName Like '%servername%'

*******************

Wednesday, 3 February 2016

SCOM 2012 R2 UR9 Upgrade Step by Step

SCOM 2012 R2 UR9 Upgrade Step by Step

  • Microsoft released UP(update Roleup) every now and then. They generally do lot of bug fixes in these update.Today Microsoft has released SCOM UR9 Upgrade. Lets go Step by Step in this upgrade.
Upgrading the Management Server:

  • Extract the Files that you downloaded to C:\Bin\UR9 folder


  • Login using the SCOM service account or account which has local admin,SCOM admin and SA Admin on SCOM database.Usually your SCOM service account will have these acc. So i suggest to use it.
  • Now Open Command Prompt in elevated mode and Go to "C:\Bin\UR9" folder
  • Type "KB3129774-AMD64-Server.msp"


      •  This will lauch Update.You will be prompted to restart your system after the update.Click yes and system will restart
      • Once its up check the Application log for Event ID 1036. Make sure it successful.


        •  Also check the DLL Versions in the Operations Manager\Server folder and make sure its showing 7.1.10226.1177


            •  You Should upgrade your additional management server in same way.

            Upgrade SCOM Webconsole and SCOM Console:


            • Now Open Command Prompt in elevated mode and Go to "C:\Bin\UR9" folder
            • Type "KB3129774-AMD64-ENU-WebConsole.msp"




            •  This will update the Web console.
            • Next Type "KB3129774-AMD64-ENU-Console.msp"


            •  This will update the Console.


            Updating the Gateway Servers:

            • Login to your Gateway server. Copy the Downloaded file  TO "C:\Bin\UR9" Folder
            • Now Open Command Prompt in elevated mode and Go to "C:\Bin\UR9" folder
            • Type "KB3129774-AMD64-Gateway.msp"

            • This will update the Gateway Server



             Update the SCOM Databases:


            • First Make sure you have stopped all SCOM services on your Management server and restart the SQL Server service once
            • Login to the SCOM Database Server
            • Open a SQL management studio query window, connect it to your Operations Manager database.
            • Now go to the upgrade Management server at below location %SystemDrive%\Program Files\Microsoft System Center 2012 R2\Operations Manager\Server\SQL Script for Update Rollups
            • Copy the SQL Scripts "update_rollup_mom_db.sql" and execute in the Query windows. This script could faill but continue trying till it succeeds




            • Try re-running the script several times until it completes without errors.  In a production environment, you have to shut down the services (sdk, config, and healthservice) on your management servers, to break their connection to the databases, to get a successful run. 
            • Once OperationsManager DB is update close the Query window.
            • Now open a SQL management studio query window, connect it to your OperationsManagerDW database.
            • Copy the SQL Scripts "UR_Datawarehouse.sql" and execute in the Query windows. This script could faill but continue trying till it succeeds.



            Import the management packs:
            • There are 55 management packs in this update!.Most of these we don’t need 
            • The path for these is on your management server, after you have installed the “Server” update: \Program Files\Microsoft System Center 2012 R2\Operations Manager\Server\Management Packs for Update Rollups
            • You can install the MP Shown below and ignore the rest.Total 19 MP's will come.



              Updating the Agents:

              • Login to SCOM Management server
              • Open SCOM Console==>Administration Tab
              • Click on "Pending Management".Select all the agent you see and Click "Approve".

              Thursday, 5 November 2015

              How to Install Zabbix on Red Hat Linux or Cent OS Step by Step



              How to Install Zabbix on Red Hat Linux or Cent OS


              Zabbix is the fastest growing monitoring tool today in market. Lot oc companies want to cut down the cost on monitoring and move to Opensource and Zabbix has emerged as the prefered choice.

              Step 1: Installing repository configuration package


              • Install the repository configuration package. This package contains yum configuration files.


              Command:

              # rpm -ivh http://repo.zabbix.com/zabbix/2.4/rhel/6/x86_64/zabbix-release-2.4-1.el6.noarch.rpm



              Step 2: Installing Zabbix packages

              Install Zabbix packages. This example  install Zabbix server and web frontend with mysql database on same server

              Command:

              # yum install zabbix-server-mysql zabbix-web-mysql zabbix-agent

              If you want to install agent only for monitoring follow the below steps

              # yum install zabbix-agent



              Step 3:Creating initial database

              Create zabbix database and user on MySQL. Import initial schema and data.

              Command:

              # cd /usr/share/doc/zabbix-server-mysql-2.4.0/create
              # mysql -uroot zabbix < schema.sql
              # mysql -uroot zabbix < images.sql
              # mysql -uroot zabbix < data.sql

              Edit database configuration in zabbix_server.conf

              # vi /etc/zabbix/zabbix_server.conf
              DBHost=localhost
              DBName=zabbix
              DBUser=zabbix
              DBPassword=zabbix

              You can give any complex password you want.

              Step 4:Start Zabbix server process:

              # service zabbix-server start

              Step 5:Editing PHP configuration for Zabbix frontend

              Apache configuration file for Zabbix frontend is located in /etc/httpd/conf.d/zabbix.conf. Some PHP settings are already configured.

              # vi /etc/httpd/conf.d/zabbix.conf

              php_value max_execution_time 300
              php_value memory_limit 128M
              php_value post_max_size 16M
              php_value upload_max_filesize 2M
              php_value max_input_time 300
              # php_value date.timezone Europe/Riga
              It's necessary to uncomment the “date.timezone” setting and set the right timezone for your location.

              After changing the configuration file restart the apache web server.

              # service httpd restart

              Step 6: Done Your server is ready


              • Zabbix frontend is available at http://ipddress/zabbix in the browser. 


              Default username/password is Admin/zabbix.


              Enjoy!