• Customer Support

    (800) 247-9045

  • Email Us


  • Online Remote Support

    BIS Help.me

  • IT Support After-Hours

    (800) 247-9045, PRESS 4

Latest News

2011 TAAD Conference

Come by and visit us at Booth 19  if you are planning on going to the Texas Association of Appraisal Districts Conference in Austin. Visit their site at http://taad.org

Renaissance Austin Hotel
9721 Arboretum Blvd.
Austin, TX 78759
Phone: 512-343-2626

Get the Dell Service tag remotely via command line

Do you need to get the service tag of a computer on network? Use this handy command line script.

wmic /user:administrator /node:remote-host bios get serialnumber

Lookup MX record via the command line

If you are looking for a fast way to find the mx record of a domain run this command from the command line

nslookup -querytype=mx yourdomain

kill remote sql connections

USE master 

DECLARE @DBName varchar(50) 
DECLARE @spidstr varchar(8000) 
DECLARE @ConnKilled smallint 
SET @ConnKilled=0 
SET @spidstr = '' 

Set @DBName = 'DB_NAME' 
IF db_id(@DBName) < 4 
PRINT 'Connections to system databases cannot be killed' 
SELECT @spidstr=coalesce(@spidstr,',' )+'kill '+convert(varchar, spid)+ '; ' 
FROM master..sysprocesses WHERE dbid=db_id(@DBName) 

IF LEN(@spidstr) > 0 
SELECT @ConnKilled = COUNT(1) 
FROM master..sysprocesses WHERE dbid=db_id(@DBName) 

Dell mass driver and firmware update tool

Dell driver and firmware update tool

Download the four ISO file segments to a new, empty folder.

Open a command prompt and navigate to that directory where the 4 ISO files are saved.

Run the following command to combine them into one large ISO file.

                copy /b om* om640_suu_a00.iso

Burn the large newly created ISO fie to  a DVD.

© Copyright by BIS Consulting l Farmers Branch, TX l Simplifying IT and GIS for Government Agencies - All rights reserved.