Tuesday 17 February 2015

Windows Run Commands - Windows Shortcuts (XP /Windows 7 /Windows 8 /Windows 10 Windows 11)

To Use Below commands press (Windows + R)
a window will appear, all commands can be used there.





Control Panel Program Shortcuts

CommandPurpose
controlControl Panel
control desktopDisplay Properties (Personalisation)
control colorPersonalisation - Color and Appearance
control foldersFolders Properties
control keyboardKeyboard Properties
control mouseMouse Properties
control netconnectionsNetwork Properties
control printersPrinters Folders
control userpasswordsManager current User Account
control userpasswords2Manager all User Accounts
control updateWindows Update
control admintoolsAdministrative Tools
control schedtasksScheduled Tasks
appwiz.cplApplication Wizard (Program and Features)
powercfg.cplPower Configuration
timedate.cplDate and Time Properties
desk.cplDisplay - Screen Resolution
intl.cplRegional Settings (International)
mmsys.cplSound Properties (Multimedia System Settings)
inetcpl.cplInternet Properties (Internet Control Panel)
wscui.cplSecurity Center (Windows Security Center UI)
sysdm.cplSystem Properties
utilmanEase of Access Utility Manager
firewall.cplWindows Firewall


Commonly used Windows Tools

CommandPurpose
explorer Windows Explorer
c:Explorer C: Drive
regeditRegistry Editor
services.mscWindows Services (local)
taskmgrTask Manager
msconfigSystem Configuration Utility
mstscRemote Desktop (Microsoft Terminal Services)
logoffLog Off Windows (without confirmation!)
shutdownShuts Down Windows (don't try unless you are ready to shutdown)
calcCalculator
cmdCommand Prompt
notepadNotepad



Microsoft System Configurations

CommandPurpose
devmgmt.mscDevice Management
eventvwr.mscEvent Viewer
compmgmt.mscComputer Management including System Tools, Storage, Services and Appliations
diskmgmt.mscDisk Partition Manager
dcomcnfgComponent Services (Detailed Component Configuration)
gpedit.mscGroup Policy Editor
secpol.mscLocal Security Policy Settings
lusrmgr.mscLocal User and Groups
perfmon.mscPerformance Monitor
fsmgmt.mscShared Folders (File Sharing Management)


Other Windows Tools

CommandPurpose
shrpubwCreate a shared folder Wizard
dxdiagDirect X Troubleshooter
cleanmgrClean Manager - Disk Cleanup Utility
clipbrdClipboard Viewer
msiexecWindows Installer Details
magnifyWindows Magnifier
oskOn Screen Keyboard
msinfo32System Information
sndvolVolume Control
winverWindows Version ( shows your windows version )
compCompare Files
ftpMS-Dos FTP
labelVolume Serial Number for C:
fsquirtBluetooth Transfer Wizard
verifierDriver Verifier Utility
migwizMigration Wizard - Files and Settings Transfer Tool
sigverifFile Signature Verification Tool
fontsFonts
joy.cplGame Controllers
mrtMalicious Software Removal Tool
eudceditPrivate Characters Editor


Applications (if installed)

CommandPurpose
acrobatAdobe Acrobat ( if installed )
photoshopAdobe Photoshop ( if installed )
ccleanerCcleaner ( if installed )
chromeChrome ( if installed )
excelMicrosoft Excel ( if installed )
accessMicrosoft Access ( if installed )
powerpntMicrosoft Powerpoint
winwordMicrosoft Word ( if installed )
wmplayerWindows Media Player
writeWordpad


 IP Config Commands (leave Dos Windows open)

CommandPurpose
ipconfig /allIP Configuration (Display Connection Configuration)
ipconfig /displaydnsIP Configuration (Display DNS Cache Contents)
ipconfig /flushdnsIP Configuration (Delete DNS Cache Contents)
ipconfig /releaseIP Configuration (Release All Connections)
ipconfig /renewIP Configuration (Renew All Connections)
ipconfig /registerdnsIP Configuration (Refreshes DHCP & Re-Registers DNS)
ipconfig /showclassidIP Configuration (Display DHCP Class ID)
ipconfig /setclassidIP Configuration (Modifies DHCP Class ID)


System File Checker Utility

CommandPurpose
sfc /scannowSystem File Checker Utility ( Scan Immediately )
sfc /scanonceSystem File Checker Utility ( Scan Once At Next Boot )
sfc /scanbootSystem File Checker Utility ( Scan On Every Boot )
sfc /revertSystem File Checker Utility ( Return to Default Settings)
sfc /purgecacheSystem File Checker Utility ( Purge File Cache )
sfc /cachesize=xSystem File Checker Utility ( Set Cache Size to Size x )

Monday 12 January 2015

select Only one row from second table

SELECT * FROM tblGroup a
INNER JOIN (
SELECT * FROM tblGroupMatrix where GroupMatrixId
IN (
SELECT MIN(GroupMatrixId) OVER (PARTITION BY GroupId)
                             FROM tblGroupMatrix)) b
                             ON a.GroupId=b.GroupId


OPTIMIZED :

SELECT  *
FROM    tblGroup A
INNER JOIN tblGroupMatrix B ON A.GroupId = B.GroupId
WHERE   GroupMatrixId = ( SELECT    MIN(GroupMatrixId)
                              FROM      tblGroupMatrix
                              WHERE     GroupId = A.GroupId)

Friday 26 December 2014

How to revel Hidden password behind stars

step 1:
Go to Browser and open desired login link where password must be filled.

step 2:
press "f12" from your key board or Right click on password Box and click "Inspect Element"




browser will look like this

Step 3:
Now find that password box and change type from "password" to "text"

Your password will look like this: