Lapas

piektdiena, 2014. gada 29. augusts

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

trešdiena, 2014. gada 27. augusts

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/

otrdiena, 2014. gada 19. augusts

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)

otrdiena, 2014. gada 1. jūlijs

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

otrdiena, 2014. gada 3. jūnijs

ceturtdiena, 2014. gada 29. maijs

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