Solved

batch file to check my login status MSSQL machines

Posted on 2013-11-05
6
399 Views
Last Modified: 2013-11-06
Intend to come up with a batch script that will verify which servers I am currently logged into.
Seen all the powershell scripts but would like help getting this to work.

Script name is login.bat  username to verify

sqlcmd -L>servers.log


for  /f  %%? in  (servers.log))  do
 ('qwinsta /server:%i | find %1 ')
  SET EXITRC=%ERRORLEVEL%GOTO
  if EXITRC==0
 ( 'echo %pathName% is logged into %? ') >output.log

Thanks in advance
MNT
0
Comment
Question by:mngong_rc
  • 3
  • 3
6 Comments
 
LVL 83

Accepted Solution

by:
oBdA earned 500 total points
ID: 39626610
Try this (currently queries servers with more than one SQL instance multiple times; this could be changed if it is an issue for you):
@echo off
setlocal
set LogFile=output.log
if "%~1"=="" (
	echo Syntax:
	echo %~nx0 ^<User name^>
	pause & goto :eof
)
set User=%~1
if exist "%LogFile%" del "%LogFile%"
for /f "skip=2 tokens=1 delims=\ " %%a in ('sqlcmd.exe -L') do (
	if /i not "%%a"=="(local)" (
		qwinsta.exe /server:%%a | findstr.exe /i "\<%User%\>" >NUL
		if errorlevel 1 (
			echo %%a: %User% not logged on.
		) else (
			echo %%a: %User% logged on.
			>>"%LogFile%" echo %%a;%User%
		)
	)
)

Open in new window

0
 

Author Comment

by:mngong_rc
ID: 39627333
Thank you, that came as close as it ever got.
This scans all the hundreds of servers in the domain and returns a value for each server.
************
What do I need to do to  show only servers with a  LOGIN. Not interested in servers
without a login and those the user is not allowed to login to.
*************

Thanks again
MNT
0
 
LVL 83

Expert Comment

by:oBdA
ID: 39627352
The log file should only show machines where the user is logged on; only the console output shows both.
If you want to suppress it from the console output as well, just put a REM in front of line 15.
0
ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

 

Author Comment

by:mngong_rc
ID: 39627404
I've requested that this question be closed as follows:

Accepted answer: 0 points for mngong_rc's comment #a39627333

for the following reason:

Gave me what I wanted.
0
 
LVL 83

Expert Comment

by:oBdA
ID: 39627405
You should accept the answer that helped you, not your own comment.
0
 

Author Comment

by:mngong_rc
ID: 39628662
Not a problem
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION The purpose of this document is to demonstrate the Installation and configuration of the Data Protection Manager product. Note that this demonstration was prepared on the basis of Windows OS is 2008 R2 and DPM 2010. DATA PROTECTI…
The password reset disk is often mentioned as the best solution to deal with the lost Windows password problem. In Windows 2008, 7, Vista and XP, a password reset disk can be easily created. But besides Windows 7/Vista/XP, Windows Server 2008 and ot…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question