Bulgarian keyboard with Microsoft Deployment Toolkit

This is a personal note to me.
If you need to automate keyboard layout during mass deployment:

Create application with attached keyboard.7z
Add application installation step in task sequence.

Rittal DK 7200.221 serial cable pinout

In my work I have Rittal CMC-TC device to play with. Unfortunately it has unusual serial port. After half day googling with my colleagues we managed to find damn pin-out.

P.S.
This device is linux based and it is full with funny things.

Allied Telesis crash course

Allied Telesis

1. Password recovery procedure:

 <i>* Connect to the router using a RS-232 cable</i>
 * Connect to the router via HyperTerminal. Settings for HyperTerminal = 9600 - 8 - None - 1 Flow Control = None
 * Power cycle the router and right away press the s key continuously until you see the login prompt &gt;
 * User:manager; Password:friend

* Connect to the router using a RS-232 cable

* Connect to the router via HyperTerminal. Settings for HyperTerminal = 9600 - 8 - None - 1 Flow Control = None

* Power cycle the router and right away press the s key continuously until you see the login prompt >

* User:manager; Password:friend

2. Disable security mode:

 <i>disable system security_mode</i>

1	<i>disable system security_mode</i>

3. Set IP Address:

 <i>enable ip</i>
 add ip interface=vlan1 ipaddress=192.168.1.1 mask=255.255.255.0
 # To change Address
 set ip interface=interface ipaddress=ipadd mask=ipadd

enable ip

add ip interface=vlan1 ipaddress=192.168.1.1 mask=255.255.255.0

# To change Address

set ip interface=interface ipaddress=ipadd mask=ipadd

4. Enable GUI

 <i>set gui=d9924e22.rsc</i>
 enable gui
 show http server

set gui=d9924e22.rsc

enable gui

show http server

5. Usefull commands

 <i>show install</i>
 show file
 show sys

show install

show file

show sys

6. Update firmware

 <i>set loader method=tftp server=10.40.1.118 destination=flash</i>
 load file=89276-02.rez
 show load

set loader method=tftp server=10.40.1.118 destination=flash

load file=89276-02.rez

show load

Cyclade CS4008 password recovery procedure

This device is linux based.
Just add single to kernel boot parameters, then passwd and write-config.

That’s it.

MS SQL Quick database permission export

SELECT
p.name as ‘LoginName’, pp.name as ‘Role’
FROM sys.database_role_members roles
JOIN sys.database_principals p ON roles.member_principal_id = p.principal_id
JOIN sys.database_principals pp ON roles.role_principal_id = pp.principal_id
Order By p.name, pp.name

Joomla intranet site rendering in IE

It seems that IE turn on by default compatibility view for intranet sites. In that way most joomla DHML menus are not rendering right. To turn off that setting via GP:
Scope: User, MachinePolicy path:Windows Components\Internet Explorer\Compatibility ViewPolicy setting name: Turn on Internet Explorer Standards Mode for Local Intranet

MS AD password expire notification

This is a little VB script that runs FindExpAcc.exe, parses output and send emails to users.

Script have to be started every day with cron job. On iDayOfWeek it will send notification to every user with password expiring in iDaysToExp or less. On every other day it will send notifications only to users with password expiring in exactly iDaysToExp.

CheckPass.vbs

Author: Milan