Decrypt files encrypted by cryptolocker

https://decryptcryptolocker.com/



Read more...

Active Directory Accounts that do not have Thumbnail Photo

First please download and install  Quest ActiveRoles Management Shell for Active Directory.

and execute the command below;

Get-QADUser -IncludedProperties "thumbnailPhoto" | Where-Object {$_.thumbnailPhoto -eq $null}
Read more...

Archive Database Statistics

[PS] C:\Windows\system32>Get-MailboxStatistics -Database "Archive Database Name"
Read more...

ESX Host Phyical Network Adapters MAC Addresses

Execute the command below in console or SSH session.

esxcfg-nics -l
Read more...

Disabled AD Account that have mailboxes

Please execute the command below in EMS;

get-Mailbox -resultsize unlimited | where { $_.ExchangeUserAccountControl -match “AccountDisabled”} | select name,database,organizationalunit | sort-object name | export-csv c:\disabledaccountswithmailbox.csv
Read more...

New Local Move Request Archive Database Only

[PS] C:\Windows\system32>New-MoveRequest -Identity 'user.name' -ArchiveOnly -ArchiveTargetDatabase "TargetArchiveDBName"  -BadItemLimit 300 -AcceptLargeDataLoss


Read more...

Enforce Minimum Password Length of 15 or More by using GPO

By Default you can not enforce user accounts to use more than 14 charachters passwords.

In order to increase this limit;

You should edit GptTmpl.inf file located in the address below;


\\domainname\SYSVOL\domainname\Policies$\PolicyGUID\Machine\Microsoft\Windows NT\SecEdit


How to find GUID for GPO



Read more...

How to find GUID for Group Policy Object (GPO)

 

 

cscript search.vbs "LDAP://dc=mydomain,dc=com" /C:"&(objectClass=groupPolicyContainer)(displayName=Default Domain Policy)" /P:name /S:SubTree

 

Read more...

Active Directory Query

Active Directory Query for Enabled user

(&(objectCategory=person)(objectClass=user)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))


Active Directory Query for Disabled User

(&(objectCategory=person)(objectClass=user)(!sAMAccountType=805306370)(userAccountControl:1.2.840.113556.1.4.803:=2))

Password Never Expire Users

(&(objectCategory=person)(objectClass=user)(!sAMAccountType=805306370)(userAccountControl:1.2.840.113556.1.4.803:=65536))

Open Active Directory Users and Computers
Right Click your Domain name and Click Find
Choose Custom Search
Click Advanced TAB, paste the code. Click Find Now.
Read more...

Unable to retrieve a Jide URL from the ClassPath

On run-time please add the following parameter to JVM on

Java Configuration Panel -> Java-> View -> Run Time Parameters

Double Click

Add "-Duser.language=en" (without quotation marks). Click OK

Restart your application.

Read more...

SnapVault Flex Clone Read/writeable clone

When creating a flex clone with Qtree SnapMirror (QSM) (SnapVault destination volume) based on a snapshot newer than the base snapshot for the QSM/SnapVault relationship;the qtree will be cloned in RO mode.

Below is an example of what was encountered:

filer1*> snapvault status /vol/HSQLdst/data

Snapvault secondary is ON.

Source                Destination               State          Lag        Status

filer2:/vol/HSQL/data   filer1:/vol/HSQLdst/data  Snapvaulted    00:23:23   Idle

filer1*> snap list HSQLdst

Volume HSQLdst

working...

%/used       %/total  date          name

----------  ----------  ------------  --------

  0% ( 0%)    0% ( 0%)  Sep 12 07:31  newer_than_snapvault_base_snapshot

  0% ( 0%)    0% ( 0%)  Sep 12 07:06  filer1(0050420116)_HSQLdst-base.264 (busy,snapvault)

  0% ( 0%)    0% ( 0%)  Sep 12 07:05  sv_hourly.0

  0% ( 0%)    0% ( 0%)  Sep 12 06:05  sv_hourly.1

  1% ( 0%)    0% ( 0%)  Sep 12 05:05  sv_hourly.2

  1% ( 0%)    0% ( 0%)  Sep 12 04:05  sv_hourly.3

filer1*> vol clone create HSQLdst_c -b HSQLdst newer_thansnapvault_base_snapshot

filer1*> snap list HSQLdst_c

Volume HSQLdst_c

working...

  %/used       %/total  date          name

----------  ----------  ------------  --------

  0% ( 0%)    0% ( 0%)  Sep 12 07:31  newer_than__snapvault_base_snapshot

  0% ( 0%)    0% ( 0%)  Sep 12 07:06  filer1(0050420116)_HSQLdst-base.264 (busy,snapvault)

the cloned qtree is created with the snapvaulted flag causing the lun within it to be R/O.

filer1*> qtree status HSQLdst_c

Volume   Tree     Style Oplocks  Status

-------- -------- ----- -------- ---------

HSQLdst_c          ntfs  enabled  normal

HSQLdst_c data     ntfs  enabled  snapvaulted

filer1*> lun show /vol/HSQLdst_c/data/data.lun

        /vol/HSQLdst_c/data/data.lun    4.0g (4301821440)    (r/o, online)

When using snapshot older than the base snapshot for the clone:

filer1*> vol clone create HSQLdst_c2 -b HSQLdst sv_hourly.0

filer1*> qtree status HSQLdst_c2

Volume                    Tree     Style Oplocks  Status

--------                 --------  ----- -------- ---------

HSQLdst_c2                         ntfs   enabled  normal

HSQLdst_c2 data                    ntfs   enabled  normal

filer1*> lun show /vol/HSQLdst_c2/data/data.lun

        /vol/HSQLdst_c2/data/data.lun    4.0g (4301821440)    (r/w, offline)

Cause

This is by design. The clone operation inherits the SnapVault/QSM base snapshot as busy, therefore,making the SnapVault property clone as RO for the specified qtrees.

Solution

To resolve this issue, use the older snapshot as the base snapshot for the clone. In this way the clone will not inherit the base snapshot for that relationship. Then the clone will be created as Read/Write (RW).

Source= Netapp Supoort

Read more...

Exchange Server - Forcing Retention Policy to manually run

Example;
Execute the command below in EMS

Start-ManagedFolderAssistant -Identity “Administrator”

For Child Domain

Start-ManagedFolderAssistant -Identity “Administrator” -DomainController dc01.root.child.com

Read more...

Enable SSH on HP Switch(es)

ProCurve Switch(config)# crypto key generate ssh
ProCurve Switch(config)# ip ssh
ProCurve Switch(config)# no telnet-server
Read more...

Disable Plain-Text HTTP server on HP Switch(s) HTTP-->HTTPS

Disable Plain-Text HTTP server on HP Switch(s) HTTP-->HTTPS


Switch(config)# no web-management plaintext
Switch(config)# crypto key generate cert 1024
Switch(config)# crypto host-cert generate self-signed
Validity start date [01/01/1970]: 08/06/2013
Validity end date   [08/09/2011]: 08/06/2023
Common name            [0.0.0.0]:
Organizational unit  [Dept Name]:
Organization      [Company Name]:
City or location          [City]:
State name               [State]:
Country code                [US]:
Switch(config)# web-management ssl
Switch(config)# wr mem
Read more...

View and Set Exchange 2010 Attachment Size

Check attachment limits

Get-TransportConfig

Set-TransportConfig -ExternalDsnMaxMessageAttachSize 50Mb
Set-TransportConfig -InternalDsnMaxMessageAttachSize 50Mb
Set-TransportConfig -MaxSendSize 50Mb
- See more at: http://www.ercanozkurt.com/?cat=4&paged=6#sthash.gkwFSjtf.dpuf

Set attachment Limits

Set-TransportConfig -ExternalDSNMaxMessageAttachSize 10MB
Set-TransportConfig -InternalDSNMaxMessageAttachSize 10MB
Set-TransportConfig -MaxSendSize 10MB

Set-TransportConfig -ExternalDsnMaxMessageAttachSize 50Mb
Set-TransportConfig -InternalDsnMaxMessageAttachSize 50Mb
Set-TransportConfig -MaxSendSize 50Mb
- See more at: http://www.ercanozkurt.com/?cat=4&paged=6#sthash.gkwFSjtf.dpuf

Get-TransportConfig

Get-TransportConfig

Get-TransportConfig

Get-TransportConfig

Read more...

Check Free Space on Exchange Server DB

Get-MailboxDatabase -Status | ft name,databasesize,availablenewmailboxspace -auto
Read more...

GRANT Permission to specific column in Table MS SQL Server

GRANT SELECT (Columnname) ON [DBNAME].[TableName] TO Username

Example;

GRANT SELECT (PerColumn) ON [YNS].[Table1] TO HRUser
Read more...

Grant Permission to View MS SQL Server

First you should create user and assign public server role for releated database.



GRANT SELECT ON [DBNAME].[SCHEMAName].[ViewName] TO Username

Example;

GRANT SELECT ON [YNS].[dbo].[V_Personnel] TO ViewUser1
Read more...

Search and Delete specific message from all mailboxes Exchange 2010

Search and Delete specific message from all mailboxes Exchange 2010

First user account that you will perform this function must have specific rights

Execute the command below ( I am going to use administrator account)

Add-RoleGroupMember "Discovery Management" -Member "administrator"

Execute the command below ( I am going to use administrator account)

New-Managementroleassignment -Role "Mailbox Import Export" -User "Administrator"




After Adding Permission you should close and reopen EMS console


Search and Delete

Get-mailbox | search-mailbox -searchquery "Subject:'MustbeDeleted'" -DeleteContent

Command is going to request confirmation for operate type= A [Yes to All]

Note: Target mailbox you indicated below will not be searched for keywords


If you get error like below;

a positional parameter cannot be found that accepts argument

Close and reopen EMS console.

If you get error like below;

The property keyword isn’t supported

Remove RE: or FW: from subject part in the command than try command again.


Subject must be indicated completely and properly in order command to operate.


Other Search Parameters

Ex.       attachment:report.pptx
Ex.       cc:paul shen or cc:pauls or cc:pauls@contoso.com
Ex.       from:bharat suneja or from:bsuneja or from:bsuneja@contoso.com
Ex.       sent:yesterday

Multiple Parameters Example

[PS] C:\Windows\system32>Get-mailbox | search-mailbox -searchquery "Subject:'mustbedeleted' AND Received: > $('07/08/2014 10:00:00') AND Received: < $('07/08/2014 11:00:00')" -DeleteContent


Get-mailbox | search-mailbox -searchquery 'from:"no-reply@sharepoint.com"' -DeleteContent


    Mailbox Search Role   This role allows you to search for messages across multiple mailboxes in your organization. Administrators aren’t assigned this role by default. To search multiple mailboxes, add yourself as a member of the Discovery Management role group.
   Mailbox Import Export Role   This role allows you to delete messages from a user’s mailbox. This role isn’t assigned to administrators by default. To delete messages from users’ mailboxes, add the Mailbox Import Export role to the Organisation Management role group.



Automated Script

http://gallery.technet.microsoft.com/Simplying-Discovery-Search-1fbfde94











Read more...

Exchange 2010 Backup Status Check Commands.

Get-MailboxDatabase -Status | fl Name,Server,LastF*Backup,LastI*Backup, LastD*Backup
Read more...

Block specific SSID on Windows OS

In order to block SSID

netsh wlan add filter permission=block ssid=ssidname networktype=infrastructure

OR

netsh wlan add filter permission=block ssid=ssidname networktype=adhoc



In order to allow SSID

netsh wlan delete filter permission=block ssid=ssidname networktype=infrastructure

OR

 netsh wlan delete filter permission=block ssid=ssidname networktype=adhoc
Read more...

Removing Sysadmin Role from sa user

It is not possible to remove sysadmin role rights from sa user neither by using Management Studio nor by SPs.

I 've found an alternative way to accomplish this process.

1) Rename existing sa username by using the command below;

ALTER LOGIN sa WITH NAME = newusername

2) Create a new user account named sa

3) Assign appropriate Server Roles and Configure User Database mapping.


Read more...