PPPoE Dialer via DOS Batch File

PPPoE Dialer via DOS Batch File

Waseem Anjum Meo@ 9:53 AM
 
 
 
 
 
 
10 Votes

Changelog:
8th Oct , 2013 9:30pm : Entry added  to create network profile folder if not already there (usually on fresh win7)
9th Oct , 2013 01:45pm : Entry added  to create new phonbook profile, it will not overwrite or delete previous one :)


Following is a simple and quickest method to create pppoe dialer using MSDOS batch file made for Windows 7, which create a new rasphone profile for PPPoE Dialer. Usually this sort of work is done using VB , or VB/VC# .NET with Dotras type programming languages which does the job nicely with lots of options and fancy look menus etc, but due to my limited knowledge towards programming, I decided to go with my traditional CLI method. I created this batch program in a very short time without much googling.

Phonebook Location to store profiles (new and old)
1
%userprofile%\AppData\Roaming\Microsoft\Network\Connections\Pbk\
This is just an example, you can modify at as per your requirements , The issue i faced while adding multiple lines was white space at the end, and if there are additional white spaces in the file , rasphone will not detect the new entry. therefore I later used algorithm to remove white spaces.
Any suggestion to improve the method will be highly appreciable . . . Please psot your comment if this batch file is working ok for you . . .
Let’s Start.
Create a new batch file like
notepad c:\dialer.bat
Paste following data and save.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
@echo off
rem
rem #########################################
rem ### PPPoE Dialer Script for Windows 7
rem ### Syed Jahanzaib / aacable@hotmail.com
rem #########################################
 
rem ### Creating pppoe profile in a temporarily text file
echo. 2>  c:\rstemp.txt
echo [AA_PPPoE_Dialer] >> c:\rstemp.txt
echo Encoding=1 >> c:\rstemp.txt
echo PBVersion=1 >> c:\rstemp.txt
echo Type=5  >> c:\rstemp.txt
echo AutoLogon=0 >> c:\rstemp.txt
echo UseRasCredentials=0 >> c:\rstemp.txt
echo LowDateTime=-582619296 >> c:\rstemp.txt
echo HighDateTime=30327625 >> c:\rstemp.txt
echo DialParamsUID=6326979 >> c:\rstemp.txt
echo Guid=359A05BF4C146640949F56383A0F18F5 >> c:\rstemp.txt
echo VpnStrategy=0 >> c:\rstemp.txt
echo ExcludedProtocols=0 >> c:\rstemp.txt
echo LcpExtensions=1 >> c:\rstemp.txt
echo DataEncryption=8 >> c:\rstemp.txt
echo SwCompression=0 >> c:\rstemp.txt
echo NegotiateMultilinkAlways=0 >> c:\rstemp.txt
echo SkipDoubleDialDialog=0 >> c:\rstemp.txt
echo DialMode=0 >> c:\rstemp.txt
echo OverridePref=15 >> c:\rstemp.txt
echo RedialAttempts=3 >> c:\rstemp.txt
echo RedialSeconds=60 >> c:\rstemp.txt
echo IdleDisconnectSeconds=0 >> c:\rstemp.txt
echo RedialOnLinkFailure=1 >> c:\rstemp.txt
echo CallbackMode=0 >> c:\rstemp.txt
echo CustomDialDll= >> c:\rstemp.txt
echo CustomDialFunc= >> c:\rstemp.txt
echo CustomRasDialDll= >> c:\rstemp.txt
echo ForceSecureCompartment=0 >> c:\rstemp.txt
echo DisableIKENameEkuCheck=0 >> c:\rstemp.txt
echo AuthenticateServer=0 >> c:\rstemp.txt
echo ShareMsFilePrint=0 >> c:\rstemp.txt
echo BindMsNetClient=0 >> c:\rstemp.txt
echo SharedPhoneNumbers=0 >> c:\rstemp.txt
echo GlobalDeviceSettings=0 >> c:\rstemp.txt
echo PrerequisiteEntry= >> c:\rstemp.txt
echo PrerequisitePbk= >> c:\rstemp.txt
echo PreferredPort=PPPoE4-0 >> c:\rstemp.txt
echo PreferredDevice=WAN Miniport (PPPOE) >> c:\rstemp.txt
echo PreferredBps=0 >> c:\rstemp.txt
echo PreferredHwFlow=0 >> c:\rstemp.txt
echo PreferredProtocol=0 >> c:\rstemp.txt
echo PreferredCompression=0 >> c:\rstemp.txt
echo PreferredSpeaker=0 >> c:\rstemp.txt
echo PreferredMdmProtocol=0 >> c:\rstemp.txt
echo PreviewUserPw=1 >> c:\rstemp.txt
echo PreviewDomain=0 >> c:\rstemp.txt
echo PreviewPhoneNumber=0 >> c:\rstemp.txt
echo ShowDialingProgress=1 >> c:\rstemp.txt
echo ShowMonitorIconInTaskBar=1 >> c:\rstemp.txt
echo CustomAuthKey=0 >> c:\rstemp.txt
echo AuthRestrictions=552 >> c:\rstemp.txt
echo IpPrioritizeRemote=1 >> c:\rstemp.txt
echo IpInterfaceMetric=0 >> c:\rstemp.txt
echo IpHeaderCompression=0 >> c:\rstemp.txt
echo IpAddress=0.0.0.0 >> c:\rstemp.txt
echo IpDnsAddress=0.0.0.0 >> c:\rstemp.txt
echo IpDns2Address=0.0.0.0 >> c:\rstemp.txt
echo IpWinsAddress=0.0.0.0 >> c:\rstemp.txt
echo IpWins2Address=0.0.0.0 >> c:\rstemp.txt
echo IpAssign=1 >> c:\rstemp.txt
echo IpNameAssign=1 >> c:\rstemp.txt
echo IpDnsFlags=0 >> c:\rstemp.txt
echo IpNBTFlags=0 >> c:\rstemp.txt
echo TcpWindowSize=0 >> c:\rstemp.txt
echo UseFlags=3 >> c:\rstemp.txt
echo IpSecFlags=0 >> c:\rstemp.txt
echo IpDnsSuffix= >> c:\rstemp.txt
echo Ipv6Assign=1 >> c:\rstemp.txt
echo Ipv6Address=:: >> c:\rstemp.txt
echo Ipv6PrefixLength=0 >> c:\rstemp.txt
echo Ipv6PrioritizeRemote=1 >> c:\rstemp.txt
echo Ipv6InterfaceMetric=0 >> c:\rstemp.txt
echo Ipv6NameAssign=1 >> c:\rstemp.txt
echo Ipv6DnsAddress=:: >> c:\rstemp.txt
echo Ipv6Dns2Address=:: >> c:\rstemp.txt
echo Ipv6Prefix=0000000000000000 >> c:\rstemp.txt
echo Ipv6InterfaceId=0000000000000000 >> c:\rstemp.txt
echo DisableClassBasedDefaultRoute=0 >> c:\rstemp.txt
echo DisableMobility=0 >> c:\rstemp.txt
echo NetworkOutageTime=0 >> c:\rstemp.txt
echo ProvisionType=0 >> c:\rstemp.txt
echo PreSharedKey= >> c:\rstemp.txt
 
echo NETCOMPONENTS= >> c:\rstemp.txt
echo ms_msclient=0 >> c:\rstemp.txt
echo ms_server=0 >> c:\rstemp.txt
 
echo MEDIA=rastapi >> c:\rstemp.txt
echo Port=PPPoE4-0 >> c:\rstemp.txt
echo Device=WAN Miniport (PPPOE) >> c:\rstemp.txt
 
echo DEVICE=PPPoE >> c:\rstemp.txt
echo LastSelectedPhone=0 >> c:\rstemp.txt
echo PromoteAlternates=0 >> c:\rstemp.txt
echo TryNextAlternateOnFail=1 >> c:\rstemp.txt
 
rem ### Removing white spaces so that it can be readable by phone book /zaib
rem echo. 2>  c:\rscompile.bat
rem if [%1]==[] then echo File name missing & goto :EOF >>
(for /f "tokens=1" %%a in (rstemp.txt) do echo %%a) > %~n1aa-rasphone.pbk
 
rem ### Location for rasphone.pbk [just for reference] /zaib
rem %userprofile%\AppData\Roaming\Microsoft\Network\Connections\Pbk\
 
rem ### Creating Network Profile Folder to store dialer profile, if its not there already
mkdir %userprofile%\AppData\Roaming\Microsoft\Network
mkdir %userprofile%\AppData\Roaming\Microsoft\Network\Connections
mkdir %userprofile%\AppData\Roaming\Microsoft\Network\Connections\pbk
cls
rem Copy new rasphone.pbk to user network profile /zaib
rem cd %userprofile%\AppData\Roaming\Microsoft\Network\Connections\Pbk\
rem ren rasphone.pbk rasphone.pbk.old
copy c:\aa-rasphone.pbk %userprofile%\AppData\Roaming\Microsoft\Network\Connections\Pbk\
 
rem ### Create Network Connection Center Icon on Desktop /zaib
rem ### I coulnd't found a way to create shortcut of dialer on desktop, someone please suggest
set linkName=AA-Network Connections
set linkPath=%userprofile%\desktop
set program=C:\WINDOWS\SYSTEM32\ncpa.cpl
set workDir=C:\WINDOWS\system32
set iconfile=%SystemRoot%\system32\SHELL32.dll
set icon=-18
set windowStyle=2
echo Set oWS = WScript.CreateObject("WScript.Shell") > temp.vbs
echo sLinkFile = "%linkPath%\%linkName%.LNK" >> temp.vbs
echo Set oLink = oWS.CreateShortcut(sLinkFile) >> temp.vbs
echo oLink.TargetPath = "%program%" >> temp.vbs
echo oLink.IconLocation = "%iconFile%, %icon%" >> temp.vbs
echo oLink.WindowStyle = "%windowStyle%" >> temp.vbs
echo oLink.WorkingDirectory = "%workdir%" >> temp.vbs
echo oLink.Save >> temp.vbs
 
WScript.exe temp.vbs
del temp.vbs
 
rem #
rem ### Show Popup Message box after everything completed /zaib
rem #
 
mshta javascript:alert("Dialer Installation Completed!!!\n\Please Restart you computern ,Thank You\n\Syed.Jahanzaib! aacable@hotmail.com");close();
 
rem # THE END #

Now execute it from c:\dialer.bat & then restart your computer. If you dont want to restart the newly created connection will not show in network connections, You have to press F5 in the network connections to display the newly created profile. After restart it will appear auto in network and sharing center.

After successful lab testing, its time to make it a distributable package. To convert it in executable package, you download BATCH to EXE converter.
extract and run Bat_To_Exe_Converter.exe
Fill up the required info as shown in teh images below and click on compile.

1- compile
and click on COMPILE , it will create .exe Package. You can also add additional info like ICON file , or product version or info
As showed in the image below . .
2- compile
.
.
End results :)
3- info

Regard’s
Syed Jahanzaib

April 3, 2013

Windows Server 2008 R2 Active Directory Reference Guide.

 
 
 
 
 
 
8 Votes

Howto enable RECYCLE BIN in Widnows 2008 Active Directory Server.

Pre requisite to enable Recycle Bin in Windows 2008 Active Directory.
1- Domain controller must be Windows 2008 R2 or later.
2- Forest and domain functional levels must be Windows Server 2008 R2, If not , then first raise functional level to windows 2008 R2 using ADUC
3- Enable Recycle Bin using Power Shell. Follow the below to do so
> Open powershell by using CMD and type powershell
> Load AD module by using following command.

Import-Module ActiveDirectory
Now activate Recycle BIN using following command
Enable-ADOptionalFeature -Identity ‘CN=Recycle Bin Feature,CN=Optional Features,CN=Directory Service,CN=Windows NT,CN=Services,CN=Configuration,DC=zaib,DC=com’ -Scope ForestOrConfigurationSet -Target ‘zaib.com’
Note: Change the zaib , com and zaib.com to match your local domain name

Delete any single user from AD for test purpose

> Now delete any user for test purpose via AD or net command
> From Powershell , Search for deleted items using following commands (TIP: To execute commands related to AD, always load module ActiveDirectory after you launch PowerShell)
Get-ADObject -Filter {name -like “*test*” -and deleted -eq $true} -IncludeDeletedObjects
Note: Change the *test to match the name or portion of delete user name

Restore Deleted User

To restore the deleted account, use following command
Get-ADObject -Filter {name -like “*test*” -and deleted -eq $true} -IncludeDeletedObjects | Restore-ADObject
If you want to use GUI for easy access, then you can try ADRecycleBin.exe (Active Directory Recycle Bin) which allows administrators to quickly restore deleted Active Directory objects via an easy to use GUI (Graphical User Interface). This is a free Active Directory Recycle Bin tool. You can download it from
http://www.overall.ca/index.php?option=com_content&view=article&id=40:adrecyclebin&catid=15:adrecyclebinexe&Itemid=66

Backup and restore system state in windows 2008

Following is an small howto of ‘Backup and restore system state in windows 2008

BACKUP

1- First install the backup features from the Server Manager.
2- Open command prompt and type

wbadmin start systemstatebackup -backuptarget:d:
and press enter. It will ask for confirmation, Type Y to continue
Note: You can use a different backup target of your choosing, it must be a local drive of your server.
When the backup finishes running, you should get a message that the backup completed successfully. Goto your backup drive and you will find folder name WindowsImageBackup with backup data.

RESTORE (Authoritative)

- To restore backup, Boot Windows 2008 in Directory Services Restore Mode (DSRM)
- Open command prompt , First you need to get backup version number so that you may restore correct version of backup, use the followign command to get the version number
wbadmin get versions
- Write down the version you need to use.
- To restore AD in AUTHORITATIVE mode (Usually used for DC), use the following command
wbadmin start systemstaterecovery -version:04/04/2013-15:00 –authsysvol
Note: Change the -version: to match your backup number that noted from wbadmin get version command
- To restore AD in non-authoritative mode, remove the –authsysvol syntax at the end of the command (Usually used at ADC)
To get mroe info, please visit http://www.trainsignal.com/blog/backup-and-restore-active-directory-on-windows-server-2008 for more detailed step by step guide with snapshots
Regard’s
Syed Jahanzaib

March 26, 2013

Howto remove your mail server IP from HOTMAIL black list

Filed under: Microsoft Related — Tags: , — Syed Jahanzaib / Pinochio~:) @ 1:32 PM
 
 
 
 
 
 
4 Votes

Recently Hotmail started to reject emails coming from our domain , giving following error.
Error transferring to mx4.HOTMAIL.COM; SMTP Protocol Returned a Permanent Error 550 SC-001 (SNT0-MC2-F23) Unfortunately, messages from xxx.xxx.xxx.xxx weren't sent. 
Please contact your Internet service provider since part of their network is on our block
I checked at mxtoolbox.com website mail server blacklist checker and all over the internet in all possible dns black lists but my IP address was not listed and it was clean. I then signed in to Microsoft Smart Network Data Services at  https://postmaster.live.com/snds/ and found out that my IP address was in Hotmail black list.
blocked-1
I found out that Microsoft has an Eform for De-Listing / removing spam black listed mail server IPs not able to deliver to Hotmail and live.com.
Fill out the below form
https://support.msn.com/eform.aspx?productKey=edfsmsbl2&ct=eformts
It will ask you Contact name, Contact e-mail address, Enter your Email Server Public IP in  Outbound IP(s) or range(s) and submit, You will receive an ticket number and it may take upto 2-4 days for your request to be entertained. Hopefully they will remove it from there black list. It also happens if you sent email to any user and he mark it as junk/unwanted then it auto adds in Hotmail monitoring system.
TIP- 1: Using Internet Explorer I receive an error has occurred while submitting the above form, After using Firefox I was able to successfully submit the form.
More info can be found here.
http://pc-freak.net/blog/howto-remove-delist-your-mail-server-ip-from-hotmail-live-com-and-msn-mail-server-blacklist/
TIP- 2: In such situation when your public ip added to black list, you can use your ISP smtp/smart host to relay mail. This way your ip wont be used and usually ISPs maintain there mail relay system upto date.
Regard’s
Syed Jahanzaib

March 25, 2013

NTBACKUP commmon issue and there fixes

 
 
 
 
 
 
5 Votes


In our company, we are using TAPE drives to backup our data on various servers. It was running successfully since many years, but from past few weeks, it started to create strange issues and backup were failing with multiple errors in logs , for example

Logs Error # 1

Volume shadow copy creation: Attempt 1.
Timeout before function completed
Error returned while creating the volume shadow copy:0x80042319.
Error returned while creating the volume shadow copy:80042319
Aborting Backup.
----------------------
The operation did not successfully complete.
----------------------

Logs Error # 2

Volume shadow copy creation: Attempt 1.
Timeout before function completed
Error returned while creating the volume shadow copy:0xffffffff.
Error returned while creating the volume shadow copy:ffffffff
Aborting Backup.
----------------------
The operation did not successfully complete.
----------------------

This error occurs when the creation of the Volume Shadow Copy times out.
This is more common during periods of high disk activity, or on disks that are heavily fragmented.

To solve it, Try following solutions

1- Make sure you have Latest Service pack for windows 2003 Server, If don’t Update it first,
Now Download HOTFIX from
http://support.microsoft.com/kb/833167/en-us
OR
http://hotfixv4.microsoft.com/Windows%20Server%202003/sp1/Fix67560/3790/free/158865_ENU_i386_zip.exe
After applying, restart your server and try NTBACKUP again. If the problem persists, then continue below
2- Set following services startup type to AUTOMATIC , and start them
- Microsoft Software Shadow Copy Provider
- Virtual Shadow Copy

- Volume Shadow Copy (VSS)

- Remote Procedure Call (RPCSS) – should be enabled as “Automatic”

– COM+ Event System (eventsystem)

– System Event Notification Service (sens) – should be enabled as “Automatic”

Adjust above services accordingly and now try NTBACKUP again.
3- Re-Register few dll’s ,Open command prompt and copy paste following lines.
Net stop vss
Net stop swprv

regsvr32 ole32.dll  

regsvr32 oleaut32.dll

regsvr32 vss_ps.dll  

vssvc /Register

regsvr32 /i swprv.dll

regsvr32 /i eventcls.dll
regsvr32 stdprov.dll
regsvr32 es.dll
regsvr32 vssui.dll

regsvr32 msxml.dll

regsvr32 msxml2.dll

regsvr32 msxml3.dll

regsvr32 msxml4.dll

Now Restart your server and try NT.Backup again. Hopefully it will work fine :) , at least in my case, it DID :)

Mounting the media . . .

If you run NTBackup from Windows, and it says “Waiting for a previous media operation to finish” but actually there is none. OR if you see MOUNTING THE MEDIA  and it keep stucked on this message. Then Try following . . .
Go to Computer Management -> Removable Storage and check under the Work Queue for any errors. Deleting any jobs that are failing should resolve your problem. However, you may be experiencing hardware issues with the drive or the media, which would be worth checking out.
In some cases restarting the Removable Storage service has worked OR
In some cases, rebuilding the Removable Storage Database has worked for me.

To rebuild RSM Database, Follow below steps

1) Go to Start > Control Panel > Administrative Tools > Services and find the Removable Storage service.
2) Right click on the Removable Storage service, select Properties, change the ‘Startup type:’ to Disabled and click ok.
3) Restart the machine
4) When the machine is running again open Windows Explorer and navigate to the C:\Windows\system32\ntmsdata\ directory  (or some other variation depending on the operating system, just pick the directory where Windows is installed and go from there)
5) In that directory rename all the files to *.OLD or move them to another temp folder.
6) Go back to the Removable Storage service (see step 1) go to properties and change the ‘Startup type:’ back to Automatic.
7) Restart the machine again

The device reported an error on a request to write data to media.

IF you receive the following error in NTBACKUP logs
Error: The device reported an error on a request to write data to media.
Error reported: Bad data.

There may be a hardware or media problem.

# Clean your tape drive either by using Cleaning Tape or other means (by service technician)

Regard’s
Syed Jahanzaib

March 5, 2013

Windows 2008 Group Policy ! Fun Things to DO

 
 
 
 
 
 
6 Votes

Howto disable Windows Firewall using Group Policy in Windows 2008

I personally don’t think it’s the best way to disable windows firewall specially in a large network environment, but recently I was in a situation where I needed it to avoice some arguments with few co workers. Here is how you can do it on a Windows 2008 server.
Open Group Policy Management,
Select the policy to edit (Usually: the default policy), right-click and choose Edit.
Go to Administrative Templates > Network > Network connections > Windows Firewall > Domain Profile.
Disable the “Protect All Network connections” rule.  Do the same for the “Standard Profile”, as well.

Now, all that’s left to do is update the clients.  Default Update time for group policy is 6 hours, but you can push it forcefully by using following command:
gpupdate / force
then simply log off and log on the client again.

Disabling Action Center’s Firewall Notification through GPO

As far as I know, there is not a policy that will disable only the Firewall Notification. The closest options we could configure are two policies that are related but neither is really a complete solution and will block other types of notifications as well:
1) Disable all balloon notifications:
User Configuration \ Administrative Templates \ Start Menu and Taskbar \ Turn off all balloon notifications
2) Disable Action Center itself:
User Configuration\Administrative Templates\Start Menu and Taskbar \ Remove the Action Center icon
(Thanks for the TIP from http://social.technet.microsoft.com/Forums/en-US/winserverGP/thread/e78a30cb-6cf2-4de6-afda-e0c90a3d2e34/ )

Disabling Your Security setting level puts your computer at risk notification

If your users are complaining of the appearance of the message box in Internet Explorer 7/8 telling that
Your Security setting level puts your computer at risk.”

To fix it, There are two ways to resolve this:
1. Set “Initialize and script ActiveX controls not marked as safe for scripting” to Disable (recommended) under Security SettingsInternet Zone or Restricted Sites Zone
2. Enable the following GPO via Domain Group Policy at your Domain controller.
Goto Local Computer Policy
User Configuration
Administrative Templates
Windows Components
Internet Explorer
ENABLE this setting >  Turn off the Security Settings
Regard’s
Syed Jahanzaib

February 22, 2013

Start windows service under different user credentials

Filed under: Microsoft Related — Tags: , , — Syed Jahanzaib / Pinochio~:) @ 3:02 PM
 
 
 
 
 
 
5 Votes

To start windows service under another user credentials , Use following
In Windows 2003:
IF the user belongs to local system
sc.exe config SERVICENAME obj= .\USERNAME password= 123456
net start “SERVICENAME”

OR
IF the user belongs to Domain
sc.exe config SERVICENAME obj= DOMAIN_NAME\syed.jahanzaib password= 123456
net start “SERVICENAME”

TIP: Make sure you add SPACE after each equal sign in command .
For example: obj= SERVICENAME
It was required for me to start SAP services, after configuring user account with password in services console, they remove password after every restart of system, therefore I made this batch file to execute on startup so they start automatically upon reboot.
Regard’s
Syed Jahanzaib

January 16, 2013

Active Directory DSQUERY & Miscellenous Commands with Syntax

 
 
 
 
 
 
10 Votes

Recently We were asked by the Auditors to provide some data of Active Directory for yearly Audit purpose. I already have few scripts that saved a lot of time. I also linked these scripts with the Linux base WEBMIN, so they can be called by nice GUI as showed in the example below.
Image
.
<How to link Linux base scritps with the webmin>

Following are scripts

Show All users in your domain
dsquery * dc=yourdomainname -filter “(&(objectCategory=Person)(objectClass=User))” -limit 0
Show All Users Created Since 1st January, 2012 till date
dsquery * dc=yourdomainname -filter “(&(objectCategory=Person)(objectClass=User)(whenCreated>=20120101000000.0Z))”
Show Users For Specific Period (Jan-2012 till Dec-2012)
e.g: Display Users Created from 1st January 2012 till 31st December 2012 (1 Year) Only.

dsquery * dc=yourdomainname -filter “(&(objectCategory=Person)(objectClass=User)(whenCreated>=20120101000000.0Z-)(whenCreated<=20121231000000.0Z-))”
> = greater then
< = less then
~ = approx
= equals

Miscellaneous commands . . .

Show All Users Info (Active/Non Active)
dsquery user -limit 0 | dsget user -dn -disabled

Show Inactive Users Only (Users that haven’t logged on since last 2 weeks)
dsquery user “dc=Your_Domain_Name” -inactive 2

Show DISABLED Users Only
dsquery user -disabled | dsget user -display -email -dept -title

Show ACTIVE Users Only
dsquery * -filter “(&(sAMAccountType=805306368)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))” -limit 0 | dsget user -display -email -dept -title

Show Users from Specific Group Only
dsquery group DC=yourdomainname -name “Type Group Name” | dsget group -members |sort |dsget user -display -email -dept -title

Show Only Specific User Details
Net user USERID /domain

Delete Only Computer Name from AD Computers
dsquery computer -name PCNAME  |dsrm  -subtree -c -noprompt


Regard’s
Syed Jahanzaib

Backup Files via CMD/Batch/ntbackup Scripts [Personnel Notes]

Filed under: Microsoft Related — Tags: , — Syed Jahanzaib / Pinochio~:) @ 8:55 AM
 
 
 
 
 
 
10 Votes

Salam to All,
Following are few backup batch files that I have used at my office to perform backup operation using scheduled backup tasks. I am posting them just for reference so they can be used as archiving or possibly useful for others too having same task.
+++++++++++++++++++++++++++++++++++++++
Few days back, a new oracle server was added in our IT dept. It is an oracle database server which serves many users request in our company. There was an annoying manual backup task that we have to perform on it on daily basis , the :@ task was to run 2 shortcut which creates backup dump files in E: drive, and then we have to manually rename the 2 dump files according to current date and then move them in other date-wise folder.
Quite annoying , isn’t it ? I mean still do we have to perform simple tasks like taking backup manually where every task is being done Automatically ?
Stupid enough ! :P

It was quite easy to do this task automatically in LINUX environment, but as currently i am working in MS (Microshit or Microsoft environment) I manage to done it with built-in DOS commands. Following is the complete dos batch file or call it the Backup script ;) , I just added in Schedule task, Now it runs daily and saves my time.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
@echo off
Echo Oracle Backup Organizer Script.
Echo Developed by Syed Jahanzaib / aacable@hotmail.com
Echo Make sure you have the backkup folder where backup is copied on daily basis by other script.
Echo Setting current date
set dt=%date:~-4,4%%date:~-10,2%%date:~-7,2%
 
Echo Map File Server backup folder in local computer using admin account.
net use B: \\FILES_SERVER\D$\home\cic /USER:zaib-admin@localdomain admin-passwd
 
Echo Copying already created oracle Dump files (which you can create by using backup file scheduled to run daily)
Echo into remote file server with current date for backup - FILES_SERVER
 
copy e:\backup\Cic_final.Dmp B:\cic-backup.%dt%.dmp
copy e:\backup\nae_final.dmp B:\nae-backup.%dt%.dmp
 
Echo Renaming dump files to current date for the date wise backup
ren e:\backup\Cic_final.Dmp cic-backup.%dt%.dmp
ren e:\backup\nae_final.dmp nae-backup.%dt%.dmp
 
echo.
echo All Backup done. Allah Hafiz

NTBACKUP with EMAIL the LOGS and START/END Time Report

This Script will first backup the data defined in “backup-data” to Tape Drive (In my case it was IBM LTO-3) and then email the LOG to your defined email addresses (in “mail-to” section) It will also record the total time of the backup and will attache it to the email.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
@echo off
rem # Syed Jahanzaib # SERVER X Backup SCRIPT
rem #######################################################
rem Setting various Descriptions via environment variables
rem #######################################################
 
setlocal enableextensions enabledelayedexpansion
set starttime=%time%
set dt=%date:~-4,4%%date:~-10,2%%date:~-7,2%
set logpath="C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\Windows NT\NTBackup\data"
set srvname=SERVERx
set backup-data=C:\backup\FULL-backup.bks
set description=Full Backup for My Server / ZAIB
set jobname=Full Backup for My Server / ZAIB
set attachment=C:\backup\serverx-ntbackup-%dt%.log
set mail-subject=Full Backup LOG for My Server / ZAIB
set mail-body=Full Backup LOG for My Server / ZAIB
set mail-to="aacable@hotmail.com","myemail2@xyz.com"
set footer=Automated Backup & Email Logs Script Created by Syed Jahanzaib
 
rem set stopsap=C:\BACKUP\STOPSAP_R3D.cmd
rem set startsap=C:\BACKUP\STARTSAP_R3D.cmd
 
rem ##############################
rem Stopping SAP & ORACLE Services
rem ##############################
 
rem %stopsap%
 
 
rem ######################################
rem Starting Backup in IBM LTO3 Tape Drive
rem ######################################
 
start /wait C:\WINDOWS\system32\ntbackup.exe backup "@%backup-data%" /n "%jobname%" /d "%description%" /j "%jobname%" /l:s /p "LTO Ultrium" /UM /v:no /r:yes /rs:no /hc:on /m normal
 
rem ############
rem NTBackup END
rem ############
 
rem ### Copy current date LOG to C:\backup for email purpose
 
forfiles -p %logpath% -s -m *.log -d 0 -c "cmd /c copy @file %attachment%"
 
rem #########################
rem STart END Time Algorithm
rem #########################
 
ping -n 2 127.0.0.1 >nul: 2>nul:
set endtime=%time%
set total="echo Total   = %tot%"
 
set /a hrs=%endtime:~0,2%
set /a hrs=%hrs%-%starttime:~0,2%
 
set /a mins=%endtime:~3,2%
set /a mins=%mins%-%starttime:~3,2%
 
set /a secs=%endtime:~6,2%
set /a secs=%secs%-%starttime:~6,2%
 
if %secs% lss 0 (
set /a secs=!secs!+60
set /a mins=!mins!-1
)
if %mins% lss 0 (
set /a mins=!mins!+60
set /a hrs=!hrs!-1
)
if %hrs% lss 0 (
set /a hrs=!hrs!+24
)
set /a tot=%secs%+%mins%*60+%hrs%*3600
 
echo End     = %endtime%
echo Start   = %starttime%
echo Hours   = %hrs%
echo Minutes = %mins%
echo Seconds = %secs%
echo Total   = %tot%
 
rem ##########
rem Email LOGS
rem ##########
 
c:\blat\blat.exe -to %mail-to% -i %srvname% -s "%mail-subject%" -body "%mail-body%|Backup Report:|Start   = %starttime%|End     = %endtime%|Hours   = %hrs%|Minutes = %mins%||%footer%" -attach %attachment%
 
endlocal
 
rem ##############################
rem Starting SAP & ORACLE Services
rem ##############################
 
rem %startsap%
 
rem ## THE END ###
rem ## Syed Jahanzaib

To delete files olde then X days using FORFILES

forfiles /p “C:\test” /s /m *.* /c “cmd /c del @path” /d -15
Change /d -15 to match your requirements. you can change the del command to any other like to show the files, use echo. FORFILES is builtin command with Windwos 2003 /7. You can download it from
http://www.ipass.net/davesisk/forfiles.zip

Delete Files Over 15 Days Old using ROBOCOPY

set _robodel=%TEMP%\~robodel
MD %_robodel%

ROBOCOPY “C:\source_folder” %_robodel% /move /minage:15

del %_robodel% /q

Batch File to create SQL Backup

First create .sql file that can be called from batch file to create any specific DB backup.
for example c:\zaibdb.sql
1
2
BACKUP DATABASE [Promo] TO  DISK = N'D:\DataBaseBackup\zaibdb.Bak' WITH NOFORMAT, INIT,  NAME = N'Promo-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO
now create a batch file which will call the above .sql file to start backup.
for example c:\start_backup.bat
1
2
3
4
5
6
7
8
9
10
@echo off
echo Creating FULL backup in D:\zaibdb.back
echo %Date% >> D:\DataBaseBackup\zaibdb.txt
sqlcmd -S .\SQLEXPRESS -i c:\zaibdb.sql > D:\DataBaseBackup\zaibdb.txt
echo.
echo Done
rem ping 127.0.0.1 -n 10 > null
echo . >> D:\DataBaseBackup\zaibdb.txt
echo This backup set was last created at %Date%  >> D:\DataBaseBackup\zaibdb.txt
echo.

Another Backup script that map remote  server folder locally
and then copy the required files and then delete the files older then 20 days

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
@echo off
rem Syed Jahanzaib / ??? (Pvt) Ltd. IS Dept.
rem This file will copy the today's SAP exports and cofiles only to files_server\export folder,
rem which is actually mapped locally as B: drive.
rem #
rem #
rem #
rem # Mapping files_server Folder via agpis Credentials
net use B: \\files_server\
 
rem # Copying Last Date Export files to \\file-server\B:\export folder
forfiles -p "J:\required_folder" -s -m *.* -d 0 -c "cmd /c copy @path B:\"
 
rem # Copying Last Date cofiles data to \\file-server\B:\cofiles folder
forfiles -p "J:\required_folder" -s -m *.* -d 0 -c "cmd /c copy @path B:\"
 
rem # Deleting export older then 20 Days . . .
forfiles -p "J:\required_folder" -s -m *.* -d -20 -c "cmd /c del @path"
 
rem # Deleting cofiles Logs older then 20 Days . . .
forfiles -p "J:\required_folder" -s -m *.* -d -20 -c "cmd /c del @path"
.

Daily Backup of Required Folder using ROBOCOPY

Robocopy method which will copy only new file by matching source and destination folder/file timstamps. Its much better as it displays results in command prompt with percentage and all the necessary info any admin want. :) its my favorite. You can downlod Robocopy by downloading Microsoft Resource Kit from following link.
http://www.microsoft.com/en-us/download/details.aspx?id=17657

1
2
3
4
5
6
@echo off
Robocopy /E /LOG+:h:\Softwares\Servers_Related\mail-backup-log.txt B:\archive\.  T:\backup\archive
 
Robocopy /E /LOG+:h:\Softwares\Servers_Related\mail-backup-log.txt T:\mailserver\c$\mt\.  T:\backup\mt
 
Robocopy /E /LOG+:h:\Softwares\Servers_Related\mail-backup-log.txt T:\mailserver\mail\.  T:\backup\mail
The above commands description is as follows.
/E 
= Copy sub-directories, including Empty ones
/LOG
+ = Output status to LOG file (append to existing log, so previous entries along with new one should be saved together, if you don’t use + , it will overwrite existing log-file, means delete old entries and overwrite new one)).

XCOPY Method

Following file will copy all the data from the source folder to target folder using windows builtin copy tool XCOPY.
1
2
3
4
5
6
7
8
9
@echo off
 
echo * * *  >> C:\backup-log.txt
echo Mail Backup Starts at %date% - %time%  >> C:\backup-log.txt
 
C:\windows\system32\xcopy.exe B:\source-folder\*.*  T:\targetfolder /S /D /C /Y
 
echo Mail Backup Ends at %date% - %time%  >> C:\backup-log.txt
echo * * * >> C:\backup-log.txt
The above commands description is as follows.
/S = Copies directories and sub-directories except empty ones.
/D =  If no date is given, copies only those files whose  source time is newer than the destination time.
/C = Continues copying even if errors occur.
/Y  = Overwrite existing files if any without prompting, its necessary when you are running xcopy via batch / script file.

Regard’s
Syed Jahanzaib

January 10, 2013

Personnel short notes for BLAT and Delete Files Older then X Days

Filed under: Microsoft Related — Tags: , , , — Syed Jahanzaib / Pinochio~:) @ 10:50 AM
 
 
 
 
 
 
5 Votes

To send email from windows command using your local company SMTP , use BLAT tool.
BLAT guide.
A wonderful guide is already available here.
http://cybergav.in/2010/10/28/how-to-send-emails-using-blat/

+++++++++++++++
First Download BLAT from following URL:
http://sourceforge.net/projects/blat/files/Blat%20Full%20Version/32%20bit%20versions/Blat%20v3.0.0/blat300_32.full.zip/download?use_mirror=autoselect

Unzip it to any folder you like.
+++++++++++++++
To install SMTP in BLAT use the below command . . .
blat -installSMTP 10.0.0.1  your-user-id@xyz.com.pk  5  25
+++++++++++++++
To send email using blat command, use the below command

blat -s “test mail” -i “test” -to  your-user-id@xyz.com.pk
+++++++++++++++
To send email with attachment of file using blat command, use the below command

blat -s “test mail” -i “Syed Jahanzaib / Admin” -to your-user-id@xyz.com.pk -body “Please see attached file” -attach c:\test.txt
+++++++++++++++

Email/Delete Files OLDER then X days Examples:

CORE EXAMPLE
forfiles -p “C:\test” -s -m *.* -d 0 -c “cmd /c c:\blat\blat.exe -to your-user-id@xyz.com.pk -i myname -s INFRA_LOGS -body INFRA_SERVERS_LOGS -attach @path”

Working EXAMPLE for file_server/ For TAPE BACKUP LOGS

forfiles -p “C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\Windows NT\NTBackup\data” -s -m *.* -d 0 -c “cmd /c c:\blat\blat.exe -to your-user-id@xyz.com.pk -i myname -s INFRA_LOGS -body INFRA_SERVERS_LOGS -attach @path”

TO show (DELETE removed from syntax) FILES OLDER THEN X DAYS (in the below example its 30 days)

FORFILES /p c:\temp /d -30 /m * /c “cmd /c echo @file”

TO show (DELETE removed from syntax) FILES For TODAY

FORFILES /p c:\temp /d 0 /m * /c “cmd /c echo @file”
Windows 2003/7/2008 already have forfiles installed. but you can download it from here http://www.ipass.net/davesisk/forfiles.zip
.
Regard’s
Syed Jahanzaib

Howto send email from command via Windows using GMAIL account

Filed under: Microsoft Related — Tags: , , — Syed Jahanzaib / Pinochio~:) @ 10:37 AM
 
 
 
 
 
 
4 Votes

Send Email from Windows via command prompt using GMAIL Account  :) ~
If you want to send email from windows using command prompt using gmail account, first down mailsend utility from following URL and extract it to any folder you like.
http://www.muquit.com/muquit/software/mailsend/mailsend1.16.exe.zip
Now to send email using command via your GMAIL account, use the below syntax. Remember to change the email addressees and password to match your account details.
1
mailsend.exe -to aacable@hotmail.com -from your-gmail-id@gmail.com  -ssl -smtp smtp.gmail.com -port 465 -sub "Testing Email via Windows cmd using GMAIL test %time%" -M "This is body text of Testing Email via Windows cmd using GMAIL. %date% %time% sending / zaib." +cc +bc -q -auth-plain -user "your-gmail-id" -pass "yourpass"
To send email with attachment, use the following
1
mailsend.exe -to aacable@hotmail.com -from your-gmail-id@gmail.com  -ssl -smtp smtp.gmail.com -port 465 -sub "Testing Email via Windows cmd using GMAIL test %time%" -M "This is body text of Testing Email via Windows cmd using GMAIL. %date% %time% sending / zaib." +cc +bc -q -auth-plain -user "your-gmail-id" -pass "yourpass" -attach "c:\test.txt"
It’s very handy and useful in many conditions. For example I used it to send daily tape backup log OR daily backup file to my email in the morning by scheduling it.

.
For more info, please read this details guide at
http://www.codeproject.com/Tips/418420/Send-email-from-command-line-using-GMail-account

.
Regard’s
Waseem Anjum Meo

Comments

  1. A very interesting article. The insights are really helpful and informative. Thanks for posting. Visit here for more info.

    D-link australia
    D-link Customer Support
    dlink admin password

    ReplyDelete

Post a Comment

Popular posts from this blog

DMASOFTLAB RADIUS MANAGER BILLING SYSTEM v 4.1 Finally Released

How To Configure Nano Station M2 As Access point