Speed up windows search indexing

Run gpedit.msc

Enable policy Computer Configuration -> Administrative Template -> Windows Components -> Search -> Disable indexer backoff

Restart Windows Search service:
net stop wsearch
net start wsearch

Source: www.question-defense.com

Excel: Convert date to US month name

=TEXT(Today(),"[$-409]mmmm, yyyy")

Kill service with stopping status

sc queryex servicename 
taskkill /f /pid [PID]

For example:

C:\>sc queryex WSearch

SERVICE_NAME: WSearch
TYPE               : 10  WIN32_OWN_PROCESS
STATE              : 4  RUNNING
                                (STOPPABLE, NOT_PAUSABLE, ACCEPTS_SHUTDOWN)
WIN32_EXIT_CODE    : 0  (0x0)
SERVICE_EXIT_CODE  : 0  (0x0)
CHECKPOINT         : 0x0
WAIT_HINT          : 0x0
PID                : 5604
FLAGS              :

C:\>taskkill /t /f /pid 5604

Get list of all Office 365 users and their licenses

Here is PowerShell script to get list of all users and their licenses:

#######begin script#######

cls

Import-Module msonline

Connect-MsolService

Function Get-UserLicenseList {

$MasterList = @()

Get-MsolUser -All  | % {

$Object = New-Object PSObject -Property @{

DisplayName = $null

UserPrincipalName = $null

AssignedLicense = $null}

$Object.DisplayName = (Get-MsolUser -UserPrincipalName $_.UserPrincipalName).DisplayName

$Object.UserPrincipalName = (Get-MsolUser -UserPrincipalName $_.UserPrincipalName).UserPrincipalName

$Object.AssignedLicense = ((Get-MsolUser -UserPrincipalName $_.UserPrincipalName).licenses | select accountskuid).accountskuid

$MasterList += $Object}

$MasterList | Out-GridView

}

Get-UserLicenseList

#######end script#######

Source: comunity.office365.com

Enabling inactive Outlook add-ins that keep being unloaded

If you cannot enable addin:
1. Remove addin from File->Options->Add-Ins->COM Add-Ins and exit Outlook
2. Run REGEDIT and remove all disabled addins from
[HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Outlook\Resiliency\DisabledItems]
3.Remove specified addin from
[HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Outlook\Addins]
4. Reinstall specified addin
For example Microsoft exchange Add-In is located in
C:\Program Files\Microsoft Office 15\root\office15\ADDINS\UmOutlookAddin.dll

Source: www.outlook-apps.com

Group Policy ADM template for Internet Explorer Proxy Server settings

Create file and paste the code:

;----------------------------------------------------------------------------------------------
;IE_Proxy_Settings_AllBuilds.ADM
;------------------------------------------------------------------------------------------------
CLASS USER
CATEGORY "Windows Components"
CATEGORY "Internet Explorer"

 POLICY "Enable Proxy"
 EXPLAIN !!PVHelp
 KEYNAME "Software\Microsoft\Windows\CurrentVersion\Internet Settings"
  VALUENAME "ProxyEnable"
  VALUEON NUMERIC 1
  VALUEOFF NUMERIC 0
 END POLICY

 POLICY "Proxy Server"
 EXPLAIN !!ProxyServerHelp
 KEYNAME "Software\Microsoft\Windows\CurrentVersion\Internet Settings"
  PART "Proxy Server" EDITTEXT REQUIRED
  VALUENAME "ProxyServer"
  DEFAULT "192.168.0.254:8080"
 END PART
 END POLICY

 POLICY "Proxy ByPassList"
 EXPLAIN !!ProxyByPassList
 KEYNAME "Software\Microsoft\Windows\CurrentVersion\Internet Settings"
  PART "Proxy ByPassList" EDITTEXT REQUIRED
  VALUENAME "ProxyOverride"
  DEFAULT ".domain.com"
 END PART
 END POLICY

 END CATEGORY;
 END CATEGORY;
[strings]
PVHelp="Enable or Disable the Proxy"
ProxyServerHelp="Please type in the Proxy Server Address and include any port information. Example: 192.168.0.254:8080"
ProxyByPassList="Enter addresses separated by semicolon. To bypass local address use the format ;<local> for more info go to http://technet.microsoft.com/en-us/library/dd361953.aspx"


;------------------------------------------------------------------------------------------------
 
After loading the template using Add/Remove for Administrative Templates, you'll find under User > Admin Templates > Classic Administrative templates the three settings which can be used to define the proxy server.

Source: columbiabrain.blogspot.com

Check applied GPO for current user

Check which GPO are applied:

gpresult /r

Check applied GPO settings:

gpresult /v >>%userprofile%\Desktop\resutl.txt

Unlock Autodesk USB installation media

You can unlock usb flash with Phison MPALL

MPALL_F1_7F00_DL17_v363_0C / Phison MPALL v3.63.0C-DL17
Start it, put your usb stick into your USB 3.0 port.
Click update, then settings.
Choose advance settings and load the ini file.
Click save, and ok on a pop-up window.
Close settings window by clicking on "x".
Click start, the process lasts for about a minute and it's done

Here is detailed instruction for different versions: whatrevitwants.blogspot.com

For newer versions you need to start flash drive into TESTMOD.
To do it you need to open caseing and find chip with 64 pins. Shorten 34x35 pins (for PS2251-03-Q chip) and plug into usb port. After few seconds release pins.

Start Phison MPALL:
Setting type - Basic Settings - New settings
1. Choose controller: PS2251-03;
2. Specify host port where flash drive is pluged in;
3. Do ISP - Select burner and firmware files;
4. Perform low level format;
5. specify partition mode - 3.

Save settings, close setting window, press update, then start. 

##################################################################
Flash drive information extractor:

Controller: Phison 2303 (2251-03)
Possible Memory Chip(s):
  Toshiba TH58NVG8T2JTA20
  Toshiba TH58TEG8T2JTA20
  Toshiba TH58TEG8T2JBA4C
  Toshiba TC58NVG7T2JTA00
  Toshiba TC58TEG7T2JTA00
Memory Type: TLC
Flash ID: 983AA892 7650
Chip F/W: 01.09.53
Firmware Date: 2013-11-15
ID_BLK Ver.: 1.2.74.0
MP Ver.: MPALL v3.72.0B
VID: 13FE
PID: 5200
Manufacturer:       
Product: USB DISK 3.0
Query Vendor ID:       
Query Product ID: 2303 PRAM     
Query Product Revision: 1.00
Physical Disk Capacity: 31009800192 Bytes
Windows Disk Capacity:  0 Bytes
Internal Tags: 2QAP-S8P4
USB Version: 2.00
Declared Power: 300 mA
ContMeas ID: F872-01-00

Working Burner + F/W ISP files: BN03V117M.BIN + FW03FF01V10953M_20131115.BIN

##################################################################
 
Here you can find pinouts for PS2251-03-Q: https://bitbucket.org/
Here you can find lates binaries for your chip: http://www.usbdev.ru/files/phison/
Here you can find instructions for Phison MPALL: http://www.usbdev.ru/
Here you can download Flash Drive Information Extractor: http://www.usbdev.ru/files/usbflashinfo/

Create and configure room list for outlook 2013/365

At firs verify that Windows PowerShell can run scripts:
Get-ExecutionPolicy

If the value returned is anything other than RemoteSigned, you need to run:
Set-ExecutionPolicy RemoteSigned

Connect to online Exchange server run:
$LiveCred = Get-Credential 
and type the credentials of an cloud administrator account

Then run:
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell/ -Credential $LiveCred -Authentication Basic -AllowRedirection

After that run:
Import-PSSession $Session

When you are online check for existing Room List Distribution groups and  Room mailboxes:
Get-DistributionGroup | Where {$_.RecipientTypeDetails -eq "RoomList"} | Format-Table DisplayName,Identity,PrimarySmtpAddress
and
Get-Mailbox | Where-Object {$_.RecipientTypeDetails -eq "RoomMailbox"} | Format-Table DisplayName,Identity,PrimarySmtpAddress

Create new Room List Distribution group:
New-DistributionGroup -Name Building_nr1 -DisplayName "Buildings display name" –PrimarySmtpAddress building_nr1@yourdomain.com –RoomList

Create new Room Mailbox:
New-MailBox -UserPrincipalName room_nr1@yourdomain.com -Name "Room nr1" -Room

Add existing Room Mailboxes to Room List Distribution Group:
Add-DistributionGroupMember –Identity Building_nr1 -Member room_nr1@yourdomain.com

When you're finished using the server-side session, always disconnect Windows PowerShell by running the following command:
Remove-PSSession $Session

Detailed procedure described here:  Use Windows PowerShell in Exchange Online
and here:  Enable Room Finder with Room List Distribution Group

Configure classic workspace for AutoCAD 2015

Solution 1:
Open the Customize User Interface dialog box (or type the command CUI).
Select the desired workspace or create a new one.
Use the plus symbol to open the Toolbars tree in the left window.
Drag the toolbars you want to the toolbars tree in the right window.
Click Apply and then click OK to close the configuration editor.

Solution 2:
The classic workspace can be imported from a previous version:
In the Ribbon - Manage Tab, click "Import" (or type command CUIIMPORT).
In the customization editor, click the Transfer Tab. The current configuraton file is in the right pane.
In the left pane, load the configuration file (acad.cuix) from AutoCAD 2014 or an earlier version
(C:\Program Files\Autodesk\AutoCAD 201X\UserDataCache\en-us\Support).
Under the workspace list in the left pane, drag and drop "AutoCAD Classic" to the workspace list in the right pane.
Click Apply and then click OK to close the configuration editor.

Source: http://knowledge.autodesk.com

Cannot resize full screen Remote Desktop Connection

To force full sreen press Ctrl+Alt+Break

Install windows 8 without installation key

To skip installation key request you need to put file ei.cfg into instalation DVD/USB /sources folder:

[EditionID] 
Professional 
[Channel] 
Retail 
[VL] 
0

If you leave [EditionID] parameter blank - during installation process you will be able to choose which versionto install.

Clear windows 8 startup in registry editor.

Run Regedit

HKCU\Software\Microsoft\Windows NT\CurrentVersion\Windows
Clear any value in key Load

Find out old AC Computers

PowerShell script:

# Gets time stamps for all computers in the domain that have NOT logged in since after specified date

$time = Read-host "Enter a date in format mm/dd/yyyy"
$time = get-date ($time)
$date = get-date ($time) -UFormat %d.%m.%y

# Get all AD computers with lastLogonTimestamp less than our time
Get-ADComputer -Filter {LastLogonTimeStamp -lt $time} -Properties LastLogonTimeStamp |

# Output hostname and lastLogonTimestamp into CSV
select-object Name,@{Name="Stamp"; Expression={[DateTime]::FromFileTime($_.lastLogonTimestamp)}} | export-csv old_users.csv -notypeinformation

Source: http://blog.mattvogt.net/

When VLOOKUP is not working because of numbers stored as text

If you want to store data with leading zero (Format cell-> Special) - you will have problems with LOOKUP formulas because of "The number in this cell is formatted as text or preceded by an apostrophe". The simplest solution is to multiply search range with 1.

Example:
=VLOOKUP($A$2:$A$718*1;Sheet2!$A$3:$B$725;2;FALSE)

Create symbolic link from remote to local folder

To create  symbolic link to remote folder:

C:\Windows\system32>mklink /d "D:\DATA\IT\ISO" "\\SERVER_NAME\ISO"

To check does link already exists

if exist "D:\DATA\IT\ISO" (
goto next
)else (
ECHO Creating Symlcnc...
mklink /d "D:\DATA\IT\ISO" "\\SERVER_NAME\ISO"
)
:NEXT
PAUSE

When access a symbolic link on a file server, sometimes you may see the following error:
"The symbolic link cannot be followed because its type is disabled". This is because by default remote to remote symbolic links are disabled.

You can enable it with fsutil.

C:\Windows\system32>fsutil behavior query SymlinkEvaluation - check status
C:\Windows\system32>fsutil behavior set SymlinkEvaluation R2R:1 - enable from Remote to remote

Run phone activation in windows

Start-> Run slui 4 OK
And you get directly to the windows phone activation screen!

If cannot install .NET framework 3.5 from Windows Update under Windows 8

1. Insert Windows 8 installation DVD
2. Run cmd as administrators

3. Run the following command Dism.exe /online /enable-feature /featurename:NetFX3 /All /Source:D:\sources\sxs /LimitAccess

Excel shortcuts to insert current date and time

Current date     Select a cell and press CTRL+;
Current time     Select a cell and press CTRL+SHIFT+;
Current date and time     Select a cell and press CTRL+; then SPACE then CTRL+SHIFT+;

Get users SID

Paste command in cmd
wmic useraccount get name,sid

Get Office 365 user list

To get active users list in excel or txt file at firs you need to install:
1. Windows Management Framework
2. Windows PowerShell 3.0
3. The Microsoft Online Services Sign-In Assistant
4. Windows Azure AD Module

Then run Windows Azure Active Directory Module for Windows PowerShell. Connect to Office 365 with cmdlet Connect-MsolService and enter the corresponding administrator credentials.
After that request active users with cmdlet:

PS C:\Windows\system32> Get-MsolUser | Where-Object { $_.isLicensed -eq "TRUE" } | Select-Object UserPrincipalName, DisplayName, Country, City, Department, UsageLocation | Out-GridView
 
Source: Microsoft Support

Get Autodesk Inventor and Autocad serial nubers from windows.

Inventor Serial numbers  
C:\ProgramData\Autodesk\AdLM\*_USRegInfo.html
HKEY_LOCAL_MACHINE\SOFTWARE\Autodesk\Inventor\RegistryVersionX.Y\System\License

 AutoCAD serial numbers 
List the value of the *_PKSER variable (enter as a command on the AutoCAD commandline)
Use command ABOUT to display product information window
List the Registry key SerialNumber in a Registry hive corresponding to your application - e.g.: HKLM\SOFTWARE\Autodesk\AutoCAD\R17.2\ACAD-7001:409

Notepad++ search with regular expressions

Don't forget to select Regular expression radio button in Search mode sectio.

([\s]+)([\s]+) -search for mutiple spaces
[ ]([a-zA-Z]) -search for any letter with space in front.

Get AD group members as text

To get active directory group's  members as sext - put this in powershell

dsquery group -name ("Group name here") |dsget group -members |dsget user -display >memberlist.txt

If you get error: dsget failed:Directory object not found check user names for restricted symbols.

Almost any characters can be used in Distinguished Names. However, some must be escaped with the backslash escape character. Active Directory requires that the following characters be escaped:

Comma	,
Backslash character	\
Pound sign (hash sign)	#
Plus sign	+
Less than symbol	<
Greater than symbol	>
Semicolon	;
Double quote (quotation mark)	"
Equal sign	=
Leading or trailing spaces

The space character must be escaped only if it is the leading or trailing character in a component name, such as a Common Name. Embedded spaces should not be escaped.

NTP serveru adreses

ntp.sigmanet.lv 92.240.65.179

ntp.cert.lv 91.240.246.1, 91.240.246.3

2.lv.pool.ntp.org 85.254.216.1

1.europe.pool.ntp.org 85.12.35.12

0.europe.pool.ntp.org 148.251.9.60

How to determine which Office SP installed

Office 2003:

Start any Office application, such as Word. Click Help -> About Microsoft Word

RTM release - 11.0.5604.0 and higher
SP1 - 11.0.6255.0 and higher
SP2 - 11.0.7969.0
SP3 -  11.0.8173.0

Office 2007:

1. Start any Office application, such as Word.
2. Click on the Office Menu (upper left)
3. Click "Word options" at the bottom of the menu
4. There, select "Resources" on the left
5. The version number will be displayed alongside the "About" button on the right

RTM release - 12.0.4518.1014
SP1 - 12.0.6211.1000 and higher
SP2 - 12.0.6415.1000 and higher

Offcie 2010:

Start any Office application, such as Word. Click on File -> Help -> Version:

RTM release - 14.0.4763.1000
SP1 - 14.0.6029.1000
SP2 -   14.0.7015.1000

Windows 7 advanced search

System.FileName:="zxc" - matches exactly
System.FileName:~="zxc" - approximately equals
System.FileName:~<"zxc" - starts with
System.FileName:~>"zxc.doc" - ends with but you'll have to specify the file suffix
System.Size:>100mb - file size larger than 100MB
System.Keywords:"family" - search file tags
System.Author:~!"Tim"  - any author that doesn't contain Tim in their name
System.Kind:<> picture – "is not" picture
System.DateModified:2013 – file modified 2013

kind:=folder created:‎30.‎10.‎2018 10:00:00 .. 30.‎10.‎2018 12:00:00 - folder created in certain time period.

Microsoft Lync shows blank screen when connecting to shared desktop or program

Delete from registry key {00000000-0000-0000-0000-000000000000}

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Internet Explorer\ActiveX Compatibility\{00000000-0000-0000-0000-000000000000} (if using LYNC 2013 32 bits on Windows 8 64 bits)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\{00000000-0000-0000-0000-000000000000} (if running LYNC 2013 64 bits or running LYNC 2013 32 bits on Windows 8 32 bits)

If disappeared shortcuts to network files from desktop

If you create desktop shortcuts to removable storage places such as NAS the icons will disappear from time to time because Windows 7 has a built in task schedule to clean up broken and unused links. 
To prevent the task from running you need to disable the task in the Task Scheduler: start-> programs-> accessories-> system tools-> task scheduler
Expand the tree in the left hand pane until you get to Task Scheduler Library -> Microsoft -> Windows -> Diagnosis.
In the right hand pane, right click the task named Scheduled and click Disable.

Kā nomainīt fontu Sticky Notes

In the registry, you can change the font that Windows thinks is Segoe Print and Segoe Print Bold

1. Navigate to: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Fonts
2. First, export that key so you have a backup.
3. Find Segoe Print (TrueType)
4. Change the value to the file name of any other font that you wish to use that is already installed (navigate that registry key to find others).
5. Do the same for the Segoe Print Bold (TrueType) and match it to the Bold version of this font.
6. Then, log out and back on.