• Customer Support


    (800) 247-9045

  • Email Us


    support@bisconsultants.com

  • Online Remote Support


    BIS Help.me

  • IT Support After-Hours


    (800) 247-9045, PRESS 4

Latest News

How to get SQL 2005 version

Run this query:
SELECT SERVERPROPERTY(‘productversion’) as ‘Product Version’, SERVERPROPERTY(‘productlevel’) as ‘Patch Level’, SERVERPROPERTY(‘edition’) as ‘Product Edition’, SERVERPROPERTY(‘buildclrversion’) as ‘CLR Version’, SERVERPROPERTY(‘collation’) as ‘Default Collation’, SERVERPROPERTY(‘instancename’) as ‘Instance’, SERVERPROPERTY(‘lcid’) as ‘LCID’, SERVERPROPERTY(‘servername’) as ‘Server Name’

Exchange 2007 Update SMTP Banner

Open Exchange Mangement Shell
Type in –
set-receiveconnector “[receive connectore name]” -Banner “220 [mail.yourdomain.com]”

Thats it

Exchange 2007 – How to bypass domain and user filtering

You can configure Content Filtering in Exchange to bypass specific users or domains.

Open the Exchange Management Shell:

# To check the Content Filter configuration, type in:

Get-ContentFilterConfig

# To set the Bypassed Senders (example):

Set-ContentFilterConfig -BypassedSenders donotspamme@calazan.com, jdoe@abc.com

# To set the Bypassed Sender Domains (example):

Set-ContentFilterConfig -BypassedSenderDomains calazan.com, *.xyz.com

Important Note: BypassedSenders and BypassedSenderDomains are multivalued properties. When you use the Set-ContentFilterConfig cmdlet, it will overwrite the values of those properties. If you just need to add more senders or domains, please follow the example below.

# To add Bypassed Senders:

$x = Get-ContentFilterConfig

$x.BypassedSenders += “jsmith@google.com”, “bhope@yahoo.com”

# To remove Bypassed Senders (can only be done one at a time):

$x = Get-ContentFilterConfig

$x.BypassedSenders -= “jsmith@google.com”

# To empty the list:

Set-ContentFilterConfig -BypassedSenders $null

PNP Device Lookup / Database

looking for a driver for an unknow device? look here – http://www.pcidatabase.com

How to unhide files and folder that are hidden from a virus

If you have a virus and your files are hidden. run unhide.exe found on http://www.bisclient.com



Printer Deleter

This app runs on your pc and you can delete Orphan printers and regular printers with it.

 http://www.kyoceramita.com.au/support/Legacy%20Utilities/Deleter.ZIP

How to add quick launch to Windows 7

Alot of people have asked me how to do this and I have finally found an article on how to setup quick launch that everyone loved in windows xp. – http://www.howtogeek.com/howto/windows-7/add-the-quick-launch-bar-to-the-taskbar-in-windows-7/

Ecommerce site Gods Affliction -Christian Store

We are now hosting Christian online store Gods Affliction. Gods Affliction is a Christian T-Shirt, Jewelery and Christian accessories store online.  They promote Christianity by wearing it! What better way to support your beliefs by showing it off! Check out their site:  http://www.godsaffliction.com

How to forcefully reboot a remote computer

Install psexec on the your local machine. Browse to that folder and run

 psexec \\pcname cmd

run – taskkill /F /FI “STATUS eq UNKNOWN” or taskkill /F /FI “STATUS eq NOT RESPONDING”

Then run

shutdown -m \\pcname -r -t 00 -f

That should do the trick. I disklike MS sometimes.

brandon

Windows 7 Printing issue resolution

Step 1

http://windows.microsoft.com/en-US/windows-vista/Troubleshoot-printer-problems

If not that doesnt work…. continue

Step 2

net stop spooler
del /Q /F /S “%systemroot%\System32\Spool\Printers\*.*”
net start spooler

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