How to stop SCCM from installing Files on System or C drive

* SCCM by default install site server role component on first available NTFS drive.

* In order to avoid the files being installed, we need to create a magic file on the drive so that SCCM understand and ignore me.

*The Magical file name is "no_sms_on_drive.sms"

* You need to create this empty file and place on the drive which you want SCCM to ignore.

Install Bash Shell on Windows to Execute Linux Commands from Windows

Install Bash Shell on Windows to Execute Linux Commands from Windows

• To install Bash,your PC should be running a 64-bit version of Windows 10 Anniversary Update build 14393 or later
• Now Open Settings -> Update and Security -> For developers
• Select the Developer Mode radio button

• Then from Start, search for "Turn Windows features on or off" (type 'turn')
• Select Windows Subsystem for Linux (beta)

• Click OK
• Now Open a PowerShell prompt as administrator and run:

Enable-WindowsOptionalFeature -Online -FeatureName Microsoft-Windows-Subsystem-Linux

• Restart your computer when prompted

Install Azure CLI 2.0 on Apple mac OS Step by Step Tutorial

Install Azure CLI 2.0 on Apple mac OS Step by Step Tutorial

• To install Azure CLI on your Mac OS type the following command

curl -L https://aka.ms/InstallAzureCli | bash

• Then restart your command shell for some changes to take effect.

exec -l $SHELL

Install SQL Server tools on Red Hat Enterprise Linux Step by Step tutorial

Install SQL Server tools on Red Hat Enterprise Linux

• Enter superuser mode.

sudo su

• Download the Microsoft Red Hat repository configuration file.

curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/msprod.repo

• Exit superuser mode.

exit

• Run the following commands to install 'mssql-tools' with the unixODBC developer package.

sudo yum update

sudo yum install mssql-tools unixODBC-utf16-devel

Uninstall SQL Server on Red Hat Enterprise Linux Step by Step Tutorial

Uninstall SQL Server on Red Hat Enterprise Linux Step by Step Tutorial

• In order to remove the mssql-server package, follow these steps:

• Run the remove command. This will delete the package and remove the files under /opt/mssql/. However, this command will not affect user-generated and system database files, which are located under /var/opt/mssql.

sudo yum remove mssql-server

• Removing the package will not delete the generated database files. If you want to delete the database files use the following command:

sudo rm -rf /var/opt/mssql/

Upgrade SQL Server on Red Hat Enterprise Linux Step by Step Totorial

Upgrade SQL Server on Red Hat Enterprise Linux Step by Step Totorial

• In order to upgrade the mssql-server package, execute the following command:

sudo yum update mssql-server

• These commands will download the newest package and replace the binaries located under /opt/mssql/. The user generated databases and system databases will not be affected by this operation.

Install SQL Server on Red Hat Enterprise Linux 7.3 Step by Step Tutorial

Install SQL Server on Red Hat Enterprise Linux 7.3 Step by Step Tutorial

Video:

• You need at least 3.25GB of memory to run SQL Server on Linux. 

• To install the mssql-server package on RHEL, follow these steps:

• Enter superuser mode.

sudo su

• Download the Microsoft SQL Server Red Hat repository configuration file:

curl https://packages.microsoft.com/config/rhel/7/mssql-server.repo > /etc/yum.repos.d/mssql-server.repo

• Exit superuser mode.

exit

• Run the following commands to install SQL Server:

sudo yum install -y mssql-server

• After the package installation finishes, run the configuration script and follow the prompts. Make sure to specify a strong password for the SA account (Minimum length 8 characters, including uppercase and lowercase letters, base 10 digits and/or non-alphanumeric symbols).

sudo /opt/mssql/bin/sqlservr-setup

• Once the configuration is done, verify that the service is running:

systemctl status mssql-server

PowerShell Commmand to Disable DHCP on the Network Interface

PowerShell Commmand to Disable DHCP on the Network Interface

• In Server we generally dont use DHCP to assign IP address.
• We usuall set Static IP Address to Server.
• So we need to disable the DHCP.
• To disable DHCP from Powershell use the Command "Set-NetIPInterface" with option -DHCP Disabled

Set-NetIPInterface -InterfaceAlias "Admin" -DHCP Disabled -PassThru

• You should specifyf or which interface you want to disable the DHCP, So you have to give the InterfaceAlias as well.

Active Directory Certficate Services on Windows 2012 R2 Installation Step by Step

Active Directory Certificate Services on Windows 2012 R2 Installation Step by Step:

Video:

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!

Can IIS Managment Pack run on Low Privilege account

Can IIS Management Pack run on Low Privilege account

• The IIS Management Pack relies on the IIS metabase, which requires administrator rights. Because of this requirement, the Management Pack cannot be run using a low-privilege account on an agent computer

SCOM 2012 R2 Data warehouse command to get information on Various Tables and how much space they are talking

SCOM 2012 R2 Data warehouse command to get information on Various Tables and how much space they are talking

• SCOM Data warehouse is the one where we store all data for longtime.
• Usually this will be in terabytes of data and will fill very fast if not confiureged properly
• Most offten you can see that the Datawarehouse if Full or going to be full and you want to find out what is the configuration and which Table is taking the most data
• Microsoft has pushed a command line tool in SCOM 2012 R2 called dwdatarp.exe
•  To get the list of tables using more space and configuration use the below command

dwdatarp.exe -s SQLServer\DatabaseName -d OperationsManagerDW > c:\dwoutput.txt

• This will give you the output with Space used and the How many days of data is stored.

Command to Get List of Patches installed on Windows 2008 R2 and Windows 2012

Command to Get List of Patches installed on Windows 2008 R2 and Windows 2012

• Manytime we get request from application owners who request for list of patches instaled and on what date
• You can use the below command to get the list of Patches from the server. This will Create a html file called hotfix.html in your C: drive.

• wmic qfe list brief /format:htable > "c:\hotfix.html"

Add new Disk on Virtual Servers in Windows Azure

Extend Disk on Virtual Servers in Windows Azure

• First Login to Windows Azure portal and your Virtual Mahcine and select "Attach an Empty Disk"

• Now enter the Disk Size you want and click Create

Install SCOM 2012 R2 agent on Servers Hosted in Microsoft Azure Cloud

Install SCOM agent on Servers Hosted in Microsoft Azure Cloud

• Microsot Azure is the Cloud Solution from Microsoft. You can Install SCOM agents and Monitor them using your Existing SCOM environment.
• To Install SCOM agent on Windows Serve hosted in Microsoft Azure Cloud
• Logon to Your Azure Portal
• Then Click on Operation Insight Tab on the left

• Then Click on the Workspace that you see 

• Now You will be taken to the Dashboard Page,Now Click on SERVERS Tab

Now Click on "Enable OP INSIGHTS"

• And Install SCOM agent on the Server. This will install SCOM agent on server automatically.

 

• Now Login to Your Server and Go to Control Panel and Open Microsoft Monitoring Agent. YOu can see that the agent ins installed.If you have In house SCOM server then configure you Management server and your SCOM management group. in Operations Manager Tab. By Default it Connects to Microsoft Operaions Manager

• You can see that after some time MP's get downloaded and Monitoring Start.

Get-Process:How to capture the list of process running on the Computer using Powershell

How to capture the list of process running on the Computer using Powershell

• To list all process running on the computer use the Command

           Get-Process

          This will give you list of all the process running on your system.

• To count number of process running on the system,use

          (get-process).count

• To output the Process to textfile so that you can send email to your support team with details,use

         get-process | out-File -FilePath c:\temp\testpr.txt

         This will give you output to text file.

• If you want only to check if particular process is running, then use

          get-process | select-string "goog"

How to Check if Powershell is installed on your Computer?

How to Check if Powershell is installed on your Computer?

• To check if Powershell is installed on your Computer
• Go to C: Drive and  Click on "Windows" Folder
• Now click on Sytem32 folder then Click on "WindowsPowerShell" Folder
• Now depending on the Version of Powershell installed You will se it as v1.0 or v2.0 or v3.0. This tell you what version of Powershell is installed.
• Now in our case is v1.0. Click on v1.0 folder.
• You will see a "Powershell.exe". This confirms that Powershell is installed on your system.