Changing the IP address of your Solarwinds server

Issue:

In the event that it is necessary to change the IP address assigned to your SolarWinds server, completing the following procedure will ensure that all related SolarWinds components are made aware of the update.

Resolution:

To change the IP address of your SolarWinds server:

1. Using an account with administrative privileges, log on to your SolarWinds server.

1. Click Start > All Programs > SolarWinds Orion > Advanced Features > Orion Service Manager.
2. Click Shutdown Everything.
   Note: Do not close Orion Service Manager at this time.
3. Change the IP address of your SolarWinds server.

1. Click Start > All Programs > SolarWinds Orion > Configuration and Auto-Discovery > Configuration Wizard.

1. Check Services, Database, and Website, and then complete the Configuration Wizard, providing the new IP address of your SolarWinds server, when prompted. For more information, see “Completing the Orion Configuration Wizard” in the SolarWinds Orion NPM Administrator Guide.
2. On your SQL Server, open SQL Server Management Studio (click Start > All Programs > Microsoft SQL Server > SQL Server Management Studio).
3. Using an account with the sysadmin role, log in to the SQL Server instance hosting your SolarWinds database.
4. Click + to expand Databases > YourSolarWindsDatabase > Tables.
5. Right-click the Engines table, and then click Select Top 1000 Rows.
6. Note the EngineID assigned to the SolarWinds server with the changed IP address.
7. If you have more than 200 alerts defined for objects monitored by the polling engine installed on the updated server, use the New Query Editor (right-click the Alerts table and then click Script Table as > UPDATE To > New Query Editor Window) to create a query that updates the EngineID for these alerts, as required.
8. If you have fewer than 200 alerts defined for objects monitored by the poling engine installed on the updated server:

1. Right-click the Alerts table.
2. Click Edit Top 200 Rows.

1. Edit the EngineID, as required.

For more information, see the SolarWinds technical reference, “Orion NPM Migration”

Webmin installation on ubuntu 11.10 server

Webmin is a web-based interface based on Perl for system administration under Unix-based systems. With Webmin, you can easily set up, via your web browser, new user accounts, manage disk quotas, configure files, control the Apache server as well as MySQL and PHP. In this guide, we will see how to install Webmin on a server running Ubuntu 11.04 or 11.10.

 Webmin Installation:

Before we start, you should first install the LAMP web server on your system. Now follow these instructions to install Webmin on Ubuntu 11.10/11.04:

1. Open the Terminal and run this command:

sudo gedit /etc/apt/sources.list

At the end of the file, add these two lines, then save and close:

deb http://download.webmin.com/download/repository sarge contrib

deb http://webmin.mirror.somersettechsolutions.co.uk/repository sarge contrib

2. Import now the GPG key using these commands:

wget http://www.webmin.com/jcameron-key.asc

sudo apt-key add jcameron-key.asc

sudo apt-get update

3. Install now Webmin with this command:

sudo apt-get install webmin

Accessing Webmin:

To start Webmin, open this address using your web browser:

https://ubuntu:10000/

To login to webmin, you need to use your root account details. If you still haven’t assigned a password to your root account, then create a root password using this command via the terminal:

sudo passwd

Enter a new password, then resubmit it to confirm. Then use your root account access details to login to webmin.

To restart Webmin, use this command:

sudo /etc/init.d/webmin restart

Citrix XenDesktop 5.0 Database Error

Error:

We need to Reset Existing Database,

Resetting the XenDesktop 5 SQLExpress Database:

A number of the Citrix products (XenDesktop, Provisioning Server, etc.) are capable of utilizing a SQLExpress database to allow for a simple installation experience. Unfortunately, if your install gets whacked or you want to start over there isn’t a simple, GUI way to delete the SQLExpress database in order to start over. Many people end up either installing, or using existing installs, of the full SQL toolstack to accomplish the task. Or they end up scrappping what they’ve done and start over. This post describes the process of deleting the database using the CLI tools that are installed with SQLExpress itself. I will discuss the specifics for XenDesktop 5, but the process is similar for other products.

I must preface this to say that I have not done rigorous testing to determine if there are detrimental side-effects to the following process. I’ve used it a number of times and have not experienced abnormalities. But, as always, this is not endorsed by Citrix and your mileage may vary.

Use at your own risk!

• Close Desktop Studio.

• Stop Services

• Citrix AD Identity Service

• Citrix Broker Service

• Citrix Configuration Service
• Citrix Diagnostic Facility COM server

• Citrix Host Service

• Citrix Machine Creation Service

• Citrix Machine Identity Service

• Click the Start menu, type “cmd<enter>”

Note: Different versions of SQLExpress store the sqlcmd command in different directories. It’s easiest to use Windows Explorer to search C:\Program Files\Microsoft SQL Server for the correct location.

• Change to the binary directory where sqlcmd resides:cd \Program Files\Microsoft SQL Server\100\Tools\Binn<enter>

• Connect to the local SQLExpress database instance:sqlcmd -S localhost\SQLEXPRESS<enter>

• List the databases to determine the name of the database to drop:sp_databases<enter>go<enter>

• Drop the databasedrop database CitrixXenDesktopDB<enter>go<enter>

• List the databases again to validate it is no longer there:sp_databases<enter>go<enter>

• Exit sqlcmd:exit<enter>

• Start Services

• Citrix AD Identity Service

• Citrix Broker Service

• Citrix Configuration Service

• Citrix Diagnostic Facility COM server

• Citrix Host Service

• Citrix Machine Creation Service

• Citrix Machine Identity Service

When the services spin up the have a rude awakening because the database that existed when they shut down no longer exists. We now have to tell XD5 to start over.

• Open Desktop Studio

• On the “Specify the address of a Controller in the site you wish to administer” window select “This machine” and click OK

• Click Yes when prompted with, “The services are no longer permitted to access the configured database. Would you like to reset the services and retry?”

• Click “Desktop deployment” on the main Desktop Studio screen

• Complete the wizard as usual, with the exception of selecting “Use existing database” for the “Database configuration” element and leaving the default values.

• Click OK to automatically create the database

VMware ESXi Host OS version updation issue in EMC Storage

Issue:

VMware ESXi OS information updated in EMC-> Hosts screen. At first ESXi 4.1 hosts connected to EMC SAN through FC Connectivity. After upgrading ESXi from 4.1 to 5.0.0, still OS version is ESXi 4.1.0 in EMC Hosts tab. It is not updated to ESXi 5.0.0 for longer.

Steps to perform:

1.Disable agent push feature in for registration in ESXi.

In the vSphere Client, select the host in the inventory.

Click the Configuration tab and click Advanced Settings under Software.

Select Disk in the left panel and scroll to Disk.EnableNaviReg.

Change the default value to “0”.

Reboot the ESXi host for the changes to take effect.

2.  De-register the host initiators in connectivity status tab.

3.  Restart the Management Server.

Note: This procedure must be performed on both storage processors to be effective!

Open a new browser window.Type in the address bar-> http: // xxx.xxx.xxx.xxx/setup

Where xxx.xxx.xxx.xxx is the IP address of the storage processor (SP A).

When the screen has loaded, type in the Username and Password used to access Navisphere/Unisphere User Interface (UI).

Once logged in, click the “Restart Management Server” button.

Once the page has loaded, click the “Yes” option, and then click “Submit.”

Follow the same steps for SP B.

4.  Re-enable the Disk.EnableNaviReg = 1

Try to register the host initiators back.

5.  Please click “Update now” for some times in Storage Array. Now OS version will updated

LDAP Custom Queries

In order to configure and use server query do the following.

Go to Active Directory Users and Computers:

Right click the Saved Queries folder and select New, Query.

Enter an appropriate Name and Description.

Make sure the query root is set to the domain level you want the query to pertain to.

Select the Include subcontainers check box if you want the query to search all subcontainers.

Click Define Query.

In the Find dialog box, click the Find drop-down arrow and select Custom Search.

On the Advanced tab, enter your LDAP query string into the Enter LDAP query box.

Click OK twice.

Active Directory Saved Queries Templates

Find Groups that contains the word admin

(objectcategory=group)(samaccountname=*admin*)

Find users who have admin in description field

(objectcategory=person)(description=*admin*)

Find all Universal Groups

(groupType:1.2.840.113556.1.4.803:=8)

Empty Groups with No Members

(objectCategory=group)(!member=*)

Finds all groups defined as a Global Group, a Domain Local Group, or a Universal Group

(groupType:1.2.840.113556.1.4.804:=14)

Find all User with the name Bob

(objectcategory=person)(samaccountname=*Bob*)

Find user accounts with passwords set to never expire

(objectCategory=person)(objectClass=user)(userAccountControl:1.2.840.113556.1.4.803:=65536)

Find all users that never log in to domain

(&(&(objectCategory=person)(objectClass=user))(|(lastLogon=0)(!(lastLogon=*))))

Find user accounts with no log on script

(objectcategory=person)(!scriptPath=*)

Find user accounts with no profile path

(objectcategory=person)(!profilepath=*)

Finds non disabled accounts that must change their password at next logon

(objectCategory=person)(objectClass=user)(pwdLastSet=0)(!useraccountcontrol:1.2.840.113556.1.4.803:=2)

Finds all disabled accounts in active directory

(objectCategory=person)(objectClass=user)(!useraccountcontrol:1.2.840.113556.1.4.803:=2)

Finds all locked out accounts

(objectCategory=person)(objectClass=user)(useraccountcontrol:1.2.840.113556.1.4.803:=16)

Finds Domain Local Groups

(groupType:1.2.840.113556.1.4.803:=4)

Finds all Users with Email Address set

(objectcategory=person)(mail=*)

Finds all Users with no Email Address

(objectcategory=person)(!mail=*)

Find all Users, Groups or Contacts where Company or Description is Contractors

(|(objectcategory=user)(objectcategory=group)(objectcategory=contact))(|(description=North*)(company=Contractors*))

Find all Users with Mobile numbers 712 or 155

(objectcategory=user)(|(mobile=712*)(mobile=155*))

Find all Users with Dial-In permissions

(objectCategory=user)(msNPAllowDialin=TRUE)

Find All printers with Color printing capability

Note: server name must be changed

(&(&(&(uncName=*Servername*)(objectCategory=printQueue)(printColor=TRUE))))

Find Users Mailboxes Overriding Exchange Size Limit Policies

(&(&(&objectCategory=user)(mDBUseDefaults=FALSE)))

Find all Users that need to change password on next login.

(&(objectCategory=user)(pwdLastSet=0))

Find all Users that are almost Locked-Out

Notice the “>=” that means “Greater than or equal to”.

(objectCategory=user)(badPwdCount>=2)

Find all Computers that do not have a Description

(objectCategory=computer)(!description=*)

Find all users with Hidden Mailboxes

(&(objectCategory=person)(objectClass=user)(msExchHideFromAddressLists=TRUE))

Find all Windows 2000 SP4 computers

(&(&(&(objectCategory=Computer)(operatingSystem=Windows 2000 Professional)(operatingSystemServicePack=Service Pack 4))))

Find all Windows XP SP2 computers

(&(&(&(&(&(&(&(objectCategory=Computer)(operatingSystem=Windows XP Professional)(operatingSystemServicePack=Service Pack 2))))))))

Find all Windows XP SP3 computers

(&(&(&(&(&(&(&(objectCategory=Computer)(operatingSystem=Windows XP Professional)(operatingSystemServicePack=Service Pack 3))))))))

Find all Vista SP1 computers

(&(&(&(&(sAMAccountType=805306369)(objectCategory=computer)(operatingSystem=Windows Vista*)(operatingSystemServicePack=Service Pack 1)))))

Find All Workstations

(sAMAccountType=805306369)

Find all 2003 Servers Non-DCs

(&(&(&(samAccountType=805306369)(!(primaryGroupId=516)))(objectCategory=computer)(operatingSystem=Windows Server 2003*)))

Find all 2003 Servers – DCs

(&(&(&(samAccountType=805306369)(primaryGroupID=516)(objectCategory=computer)(operatingSystem=Windows Server 2003*))))

Find all Server 2008

(&(&(&(&(samAccountType=805306369)(!(primaryGroupId=516)))(objectCategory=computer)(operatingSystem=Windows Server 2008*))))

——————————————————————————

#Find All Workstations

(sAMAccountType=805306369)

#Find all 2003 Servers Non-DCs

(&(&(&(samAccountType=805306369)(!(primaryGroupId=516)))(objectCategory=computer)(operatingSystem=Windows Server 2003*)))

#Find all 2003 Servers – DCs

(&(&(&(samAccountType=805306369)(primaryGroupID=516)(objectCategory=computer)(operatingSystem=Windows Server 2003*))))

#Find all Server 2008

(&(&(&(&(samAccountType=805306369)(!(primaryGroupId=516)))(objectCategory=computer)(operatingSystem=Windows Server 2008*))))

#Find all Windows 2000 SP4 computers

(&(&(&(objectCategory=Computer)(operatingSystem=Windows 2000 Professional)(operatingSystemServicePack=Service Pack 4))))

#Find all Windows XP SP2 computers

(&(&(&(&(&(&(&(objectCategory=Computer)(operatingSystem=Windows XP Professional)(operatingSystemServicePack=Service Pack 2))))))))

#Find all Windows XP SP3 computers

(&(&(&(&(&(&(&(objectCategory=Computer)(operatingSystem=Windows XP Professional)(operatingSystemServicePack=Service Pack 3))))))))

#Find all Vista SP1 computers

(&(&(&(&(sAMAccountType=805306369)(objectCategory=computer)(operatingSystem=Windows Vista*)(operatingSystemServicePack=Service Pack 1)))))

(&(&(&(&(sAMAccountType=805306369)(objectCategory=computer)(operatingSystem=Windows 7*)(operatingSystemServicePack=Service Pack 1)))))

(&(&(&(samAccountType=805306369)(primaryGroupID=516)(objectCategory=computer)(operatingSystem=Windows Server 2008*))))

(&(&(&(&(&(&(samAccountType=805306369)(!(primaryGroupId=516)))(objectCategory=computer)(operatingSystem=Windows 7*))))))

#Modify Password Never Expires Flag for all Users

dsquery user OU=OU-Name,DC=Microsoft,DC=Com | dsmod user -pwdneverexpires no

#Password Never Expires Flag Users

(objectCategory=person)(objectClass=user)(userAccountControl:1.2.840.113556.1.4.803:=65536)