Synchronize Time Throughout Your Entire Windows Network

Synchronizing time on your Windows domain requires following the Active Directory domain hierarchy to find a reliable time source for your entire domain.  In a Windows Server 2003 Active Directory forest, the server that holds the primary domain controller (PDC) emulator role acts as the default time source for your entire network.

Each workstation and server in this network will try to locate a time source for synchronization. Using an internal algorithm designed to reduce network traffic, systems will make up to six attempts to find a time source. Here's a look at the order of these attempts:
  • Parent domain controller (on-site)
  • Local domain controller (on-site)
  • Local PDC emulator (on-site)
  • Parent domain controller (off-site)
  • Local domain controller (off-site)
  • Local PDC emulator (off-site)
To ensure that your servers are finding the proper time, you must configure your PDC emulator to receive the time from a valid and accurate time source. To configure this role, follow these steps:
  1. Log on to the domain controller.
  2. Enter the following at the command line:
W32tm /config /manualpeerlist:<timeserver> /syncfromflags:manual
<timeserver>is a space-delimited list of DNS and/or IP addresses. When specifying multiple timeservers, enclose the list in quotation marks.
  1. Update the Windows Time Service configuration. At the command line, you can either enter W32tm /config /update, or you can enter the following:
Net stop w32time
Net start w32time

If a system isn't a member of a domain, you must manually configure it to synchronize with a specified time source. Follow these steps:
  1. Go to Start | Control Panel, and double-click Date And Time.
  2. On the Internet Time tab, select a time server from the drop-down list, or enter the DNS name of your network's internal time source.
  3. Click Update Now, click Apply, and click OK.
Note: It's important to make sure that any access control lists on your network allow UDP port 123 to and from systems to the selected time source.

Birth Day

December 23rd ~ January 1st = Red
January 2nd ~ January 11th = Orange
January 12th ~ January 24th = Yellow
January 25th ~ February 3rd = Pink
February 4th ~ February 8th = Blue
February 9th ~ February 18th = Green
February 19th ~ February 28th = Brown
March 1st ~ March 10th = Aqua
March 11th ~ March 20th = Lime
March 21st = Black
March 22nd ~ March 31st = Purple
April 1st ~ April 10th = Navy
April 11th ~ April 20th = Silver
April 21st ~ April 30th = White
May 1st ~ May 14th = Blue
May 15th ~ May 24th = Gold
May 25th ~ June 3rd= Cream
June 4th ~ June 13th = Grey
June 14th ~ June 23rd = Maroon
June 24th = Grey
June 25th ~ July 4th = Red
July 5th ~ July 14th = Orange
July 15th ~ July 25th = Yellow
July 26th ~ August 4th = Pink
August 5th ~ August 13th = Blue
August 14th ~ August 23rd = Green
August 24th ~ September 2nd = Brown
September 3rd ~ September 12th = Aqua
September 13th ~ September 22nd = Lime
September 23rd = Olive
September 24th ~October 3rd = Purple
October 4th ~ October 13th = Navy
October 14th ~ October 23rd = Silver
October 24th ~November 11th = White
November 12th ~ November 21st = Gold
November 22nd ~ December 1st = Cream
December 2nd ~ December 11th = Grey
December 12th~ December 21st = Maroon
December 22nd = Teal  


RED
 

Cute And Lovable Type, You Are Picky But Always In Love... And Liked To Be Loved. Fresh And Cheerful, But Can Be 'Moody' At Times. Capable With People Nice, Soft, And That Can Love You For The Way You Are. Likes People That Are Easy To Talk To, And Can Make You Feel. Comfortable.

Orange
 

You Are Responsible For Your Own Actions, And You Know How To Treat People. You Always Have Goals To Reach And You Really Work Hard To Get There, You Are Competitive. Your Friends Are Really Important To You And You Appreciate What You Have, You Sometimes Over React That's Because You Are Sensitive. Comfortable.
 
Yellow
 

You Are Sweet And Innocent. Trusted By Many People, And Have A Strong Leadership Towards Relationships. You Make Good Decision And Make The Right Choice At The Right Time. And Always Dreaming Of Romantic Relationship.
 
Blue
 

You May Have Low Self-Esteem, And Can Be Very Picky. You Are Artistic And Like To Fall In Love, But You Let Your Love Pass By, By Loving With Your Mind, Not Your Heart. Relationship.
 
Pink
 

You Are Always Trying Your Best In Everything, And Like To Help And Care For Other People. But You Are Not Easily Satisfied. You Have Negative Thoughts, And You Look For Romantic Love Like In A Fairytale. Relationship.
 
Green
 

You Get Along Well With New People. You Are Not Really A Shy Person, But Sometimes You Can Hurt People's Feelings By Your Words... You Like To Be Loved And Noticed By Your Lover, But Mostly You Are Single, Waiting For The Right Person.
 
Brown
 

You Are Active And Sportive. It's Hard For Other People To Become Close With You, But You Fall In Love Easily. But Once You Find Out You Can't Get Something, You Give Up And Let Go Easily As Well.
 
Aqua
 

Your Feelings Change Suddenly And Easily. You Are Always Lonely, And Like Traveling. You Are Truthful, But Listen And Believe Other People Too Easily. It's Hard To Find Love For You, And Get Lost In Love Easily, Sometimes Get Hurt By Love.
 
Lime
 

You Are Calm, But Easily Stressed Out. You Get Jealous Easily, And Complain Over Little Things. You Can't Get Stuck Into One Thing, But You Have A Capable Personality For Everyone To Trust You And Like You.
 
Black
 

You Are Challenging, And Have The 'Guts'. But You Don't Like Changes In Your Life. And Once You Make A Decision, You Keep It That Way For A Long Time. Your Love Life Is Also Challenging, And Different.
 
Purple
 

 
You Are Mysterious, Never Selfish And Get Interested In Things Easily. Your Day Can Be Sad Or Happy Depending On Your Mood. You Are Popular Between Friends But You Can Act Stupid At Times, And Forget Things Easliy.You Go For A Person That's Trustworthy.
 
Navy
 

You Are Attractive, And Love Your Life. You Have A Strong Feeling Towards Everything. And Very Easily Distracted. Once You Get Angry At Someone, Its Hard For You To Forgive Them.
 
Olive
 

You Are Warm And Light Hearted. You Seem To Flow Well With Friends And Family. You Don't Like Violence And Know What's Right. You Are Kind And Cheerful But Don't Envy Other People.
 
Silver
 

 
You Are Imaginative And Fun, You Love Trying New Things. You Like To Challenge Yourself And You Learn Things Easily, You're Easy To Talk To And Give Good Advice. When Comes To Friendship, You Find It Hard To Trust Someone, But Once You Find The Right Friend, You Trust Them Forever.
 WHITE
 

 
You Are Shiny Person, Cute And Intelligent Person. You Like To Make Friendship With Your Higher Persons, Which Can Sometimes Cause Trouble.
Your Strength Is Your Love Towards Friends. You Always Looks To Love Somebody And U Be Loved By Somebody. Your Intelligence May Lead To Success In Your Life

Gold
 

You Know What's Right And What's Wrong. You Are Cheerful And Out Going. It's Hard For You To Find The One You Want, But Once You Find The Right Person, You Won't Be Able To Fall In Love Again For A Long Time.
 
Cream
 

Competitive And Sportive. Don't Like Losing And Always Cheerful! You Are Trustworthy, And Very Out Going. You Choose Love Carefully, And Don't Fall In Love Easily. But Once You Find The Right One, You Don't Let Go Or A Long Time.
 
Grey
 

Ur Are Attractive, And Active. You Never Hide Your Feelings, And Express Everything That's Inside. But Can Be Selfish At Times. You Want To Be Noticed, And Don't Like To Be Treated Unequally. You Can Brighten Up People's Day. You Know What To Say At The Right Time, And You Have A Good Sense Of Humor.
 
Maroon
 

 
You Are Intelligent, And Know What's Right. You Like To Make Things Go Your Way, Which Can Sometimes Cause Trouble For Not Thinking About Other People's Feelings. But You Be Patient When It Comes To Love.. Once You Get A Hold Of The Right Person, It's Hard For You To Find A Better Love.

Up-gradation from Microsoft Dynamics GP 10 to Microsoft Dynamics GP2010 / GP 11

First upgrade Microsoft Dynamics GP 10 to Version 10.00.1400 (Hotfix KB 975174 & KB 977783) and then Install Microsoft Dynamics GP2010/GP11 with SP1.  After this run GP2010 Utilities, it will be updated without any error.

Mentor for Microsoft Dynamics GP

If you are an end user you probably already know that one of the most frustrating aspects of working with GP has to be navigating through the menu structure. Granted, improvements to the navigation bar introduced since version 9 have made things a lot easier. Nonetheless, remembering where to find an option that will take you to a specific window can be very challenging at times for both experienced and novice users. Also, what if the window you are trying to access is not a main window? What if you don’t even have security to the window you are trying to access? What if all you know of the window is a portion of the name?

I have to say, I rarely get into blogging about specific ISV solutions, but I had a chance to play around with Mentor by Rockton Software. Mentor answers the questions above and some more about any window, whether in the Dynamics dictionary or any integrating or third party product and is able to provide the exact menu path to follow to access said window.

The Installation Process
I began by downloading Mentor from Rockton Software’s website. After filling out a short registration the download process began. I extracted the downloaded zip file into my Microsoft Dynamics GP installation folder. After launching Dynamics GP, the standard dialog to acknowledge the new code was presented. Mentor is fully enabled for the Fabrikam company.

Upon accessing Fabrikam, the Mentor Setup window opened to begin the installation of the database objects. Clicking the Process button triggered the setup process.


After clicking the Yes button in the dialog window the installation process began. In addition to installing the database objects, Mentor collects information about the menu navigation for each window for all products installed on your system.

Using Mentor
Upon completing the installation you will see a new entry on your navigation menu.


By clicking on this entry you immediately gain access to the main Mentor window.


The window is pretty straight forward. I began by testing something pretty obvious. I typed Customer in the search bar. Mentor did exactly what I expected. It searched for all windows that had the word “Customer” in the title, finding 36 items in the process. In addition, Mentor presented all the navigation options for each window and provided visual cues for all windows that can only be opened from a main window.


Mentor is capable of presenting security information for each window displayed, but it also allows you to create shortcuts for these on the navigation bar and provides a quick way to establish the security tasks and roles associated to the window. Mentor is also able to establish whether you have access to a window or not.

Mentor also offers a sidekick called Inspector, which presents information about each individual field being navigated along with information on the tables associated to the form.


Mentor increases your productivity during the first weeks after going live with Dynamics GP and can even offer valuable information to experienced users. Hat tips to the folks at Rockton Software.

SEO Tips - How to Optimize Images, Videos and Audio for Your Website


If you’re an online publisher, then Google is king.  Whatever content you’re pushing to the web, you’re going to want Google to index it properly, and serve it up in its search results.  There are lots of guides on basic text and blogpost optimization out there, but what about other types of media like images, video, and audio?  Here’s a simple guide to follow so you can make the most of your multimedia content.
First things first, the general rule of optimization is to ensure a descriptive file name and URL which match what people may be searching for.  This is crucial when it comes to Google deciding if your content is relevant to search terms.  If you want to refine it, you can try using the Google keywords tool to determine search volume. 

Tip 1. How to Optimize SEO for images


Tagging of images is essential for Google’s understanding of what your image actually is.  Pay close attention to your ALT and TITLE tags when you upload an image to the web.
  1. ALT attribute is an important part of search engine optimization. It describes your image to search engine and when a user searches for a certain image this is a key determining factor for a match. 
  2. TITLE attribute plays a lesser role but is important for visitors as this text will automatically appear in the tooltip when mouse is over the image.
If you’re using WordPress, you can try SEO Friendly Images, which is a free optimization plugin that automatically updates all images on your website with proper ALT and TITLE attributes.  What this plugin does is, it changes these tags based on your image file name and your post URL.  This is a quick one click solution helps optimize all your images at once.

Tip 2. How to Optimize SEO for videos

Sitemaps are Google’s way of understanding and indexing your videos.  Check out this video for a bit more detail on this.
To get more tips on submission of setting up an mRSS feed so you can automatically submit sitemaps of your videos in the correct format, you should visit Google’s Video sitemaps page.

Tip 3: How to Optimize SEO for Audio

  1. Text Transcripts: There are several ways to optimize for audio, but the best way is to have actual transcripts of your audio on your web page.   No matter how much you optimize, having plain text is always more Google friendly.  Consider recording in conjunction with speech to text software if it’s more efficient.
  2. Descriptive Metadata: Changing your ID3 tags to give really descriptive titles and comments which are embedded within the file.  If you’re changing a few files you can simply right click the file in Windows, then go to properties, then summary.  From there you can edit all the attributes of the file.  If you’re handling this for multiple files you may want to use freeware like ID3 Tagit to help you along.

How to Make Transparent Background of SWF in Webpage


When you insert SWF file in your webpage it always show given background color and if you want transparent background color and want to use your webpage bg color then you have to need make transparent background of swf file. This is the very simple way but for this you will have to use only stage background color in flash not any rectangle on stage because this method only transparent stage bg color.

First Step:

Make flash file and use only bg color of stage. Don’t use any recangle there for background color.

Method 1: Using Flash

The HTML for a Flash movie can be created using the Publish Settings feature in Flash. The Publish Settings dialog box provides an option to affect the WMODE setting. The options selected in the Publish Settings will be added to the HTML source code automatically:

Step 1:

Choose File > Publish Settings. Select the HTML tab. or press Shift + F12.

Step 2:

Choose “Transparent” in the WMODE setting to make the Flash movie’s background disappear in browsers which support this feature.

Step 3:

Publish the document.
You will find this "wmode=transparent" code in html file which make swf file transparent.

Method 2: Editing HTML code manually for Wmode

To edit an existing HTML page, add the WMODE parameters to the HTML code.
Add the following parameter to the OBJECT tag:
<param name="wmode" value="transparent">
Add the following parameter to the EMBED tag:
wmode=transparent

Method 2: Using Dreamweaver

Follow the below steps, and Dreamweaver will insert the correct HTML code automatically.

Step 1:

In Dreamweaver, insert the Flash movie into an HTML page.

Step 2:

Select the Flash movie in the Design View.

Step 3:

In the Properties panel, choose Parameters.

Step 4:

For the Parameter, enter “wmode” (without quotes). For the Value, enter “transparent”.
or
In property panel choose wmode dropdown.

Step 5:

Save the document. The HTML page is complete.

What's New in Microsoft Dynamics GP 2010

Foundation enhancements
E-mail functionality
  • Sending customized messages
Electronic Signatures workflow
Home Page
  • Viewing reminders as text or Cues
  • Viewing Reporting Services metrics
  • Viewing multiple metrics
  • Viewing additional information
Installation and deployment features
Rapid Migration Tool for Microsoft Dynamics GP
Lookups
Microsoft Dynamics Online Connect
Navigation pane
Reporting
  • Report lists
  • Report destinations
Right-click menu enabled
Security
  • Display security roles and tasks
  • Copy user security settings
  • Automatically logging on to Microsoft Dynamics GP and a company
Unified Communications
Word templates
Workflow
Integration Manager
  • Microsoft Dynamics GP eConnect adapter enhancement
  • Displaying error message details
Excel Report Builder
  • Excel report PivotTables
  • Excel report totals
  • Publish Excel Report Builder reports
  • Drill Down Builder

Financial enhancements
General Ledger
  • Exclude inactive accounts in Accounts lookup
  • Clear recurring batch amounts
  • Combine multiple General Ledger budgets into a single, master budget
  • Comply with International Financial Reporting Standards (IFRS) requirements
  • Create budget transactions
Payables Management
  • Exclude inactive vendors in Vendors lookup
  • Exclude expired discounts from payments
  • Select multiple ranges for payables check runs
  • Vendor approval workflow added
Receivables Management
  • Enter negative cash receipts
  • Enter recurring cash receipts batches
  • Exclude inactive customers in Customers lookup
  • Exclude inactive salespeople from Salespeople lookup
  • Set up lockboxes at payment processing centers
Collections Management
  • View un-posted cash amounts
  • Receive collection reminders
  • Print collection letters by address ID
Analytical Accounting
  • Integrate with Payroll (United States)
  • Automatic security for transaction dimension codes
Electronic Banking
Encumbrance Management
  • Configure encumbrance behavior for approved purchase orders

Distribution enhancements
Inventory Control
  • Exclude discontinued items from Items lookup
  • Go To navigation added
Purchase Order Processing
  • Roll down promised date and promised ship date changes
  • Link invoicing to whether any received goods are returned
  • Define lot number masks
  • Receive in-transit transfer items
Sales Order Processing
  • Print back ordered items on picking tickets

Human Resources and Payroll enhancements
Human Resources
  • Assign employee secondary status codes
  • Easier setup of position control plans and funding
U.S. Payroll
  • Exclude inactive employees in Employees lookup
  • Map pay, deduction, and benefit codes to multiple W-2 boxes
  • More flexibility when deducting multiple garnishments
  • Process concurrent pay runs
  • Reprint paystubs and earnings statements
  • Track fiscal year values for pay, benefits, and deductions
  • Use workflow to manage employee on boarding
  • Use workflow to manage employee maintenance
Advanced Human Resources
  • Use security tasks and roles for the Human Resources and Payroll Suite
  • View and print Excel-based reports for Certification, License and Training Manager
Advanced Payroll
  • Use menu navigation for pay policy management “Use Add-On” functionality Benefit Self Service
  • Track the benefit enrollment process
  • View and print benefit self service confirmation statements
U.S. Payroll Extensions
  • Create differential pay transactions more easily
  • Use multiple overtime rate calculation methods per pay code
  • Specify payroll edit report preferences
PTO Manager
  • Assign paid time off (PTO) configurations to employees

Manufacturing enhancements
Right-click menu enabled

Production Functions enhancements
Manufacturing Core Functions enhancement
  • Changing standard costs

Field Service Series enhancements
Service Call Management
  • Automatically move billed service calls to history
  • Check links in the Field Service Series
  • Enter non-inventoried items
  • Escalate service calls to multiple manager levels
  • Generate payables vouchers for subcontractor charges
  • Post labor information to U.S. Payroll
  • Use kit items in the Field Service Series
Contract Administration
  • Assign multiple service hour ranges per day on contracts
  • Check links in the Field Service Series
  • Enhanced contract lookup windows
  • Bill contract activity for each site to a specific address
  • Consolidate billing for multiple contracts on one invoice
  • Define more flexible billing frequencies
  • Reconcile contract revenue with General Ledger
  • Use kit items in the Field Service Series
Depot Management
  • Use kit items in the Field Service Series Returns Management
  • Use kit items in the Field Service Series Preventive Maintenance
  • Preventive maintenance event generation options
  • Use kit items in the Field Service Series

Project Accounting enhancements
Benefit allocation feature enhanced
  • Benefit Allocation window
  • Cost Category Class Setup window
  • Benefit Cost Category Accounts window
  • Budget Maintenance window
  • Benefit Allocation Error List
Reporting
  • Trial balance
  • Billing
  • Project status
  • Performance

Country/region-specific enhancements
VAT Daybook
  • Available worldwide
  • Canadian GST/HST return
Fixed Asset Enhancements
Export Financial Data
GDPDU (Grundsätze zum Datenzugriff und zur Prüfbarkeit digitaler Unterlagen)

Script for Delete Stranded User Activity in Microsoft SQL Server

In this article, we will going to use a script to delete the activity table records for a specific stranded user in Dynamics GP. This will enable us not to have all the users log out of GP in order to execute these scripts. This is typically handy when we have many users signed into the system from various regions and its a tough job to have all the users sign off the system for this maintenance to be done. Please make sure that you must take a back up of DYNAMICS database before you execute this script.


DECLARE @USERID CHAR(15)
DECLARE @CMPNYNAM CHAR(30)

SET @USERID = 'testuser'
SET @CMPNYNAM = 'Fabrikam, Inc.'

/*Deleting the user record from the DEX_LOCK table*/
DELETE FROM tempdb.dbo.DEX_LOCK
WHERE session_id = ( SELECT SQLSESID
FROM DYNAMICS.dbo.ACTIVITY
WHERE USERID = @USERID
AND CMPNYNAM = RTRIM(@CMPNYNAM)
)

/*Deleting the user record from the DEX_SESSION table*/
DELETE FROM tempdb.dbo.DEX_SESSION
WHERE session_id = ( SELECT SQLSESID
FROM DYNAMICS.dbo.ACTIVITY
WHERE USERID = @USERID
AND CMPNYNAM = RTRIM(@CMPNYNAM)
)

/*Deleting the user record from the SY00801 table*/
DELETE FROM DYNAMICS.dbo.SY00801
WHERE USERID = @USERID
AND CMPANYID = ( SELECT CMPANYID
FROM DYNAMICS.dbo.SY01500
WHERE CMPNYNAM = RTRIM(@CMPNYNAM)
)

/*Deleting the user record from the SY00800 table*/
DELETE FROM DYNAMICS.dbo.SY00800
WHERE USERID = @USERID
AND CMPNYNAM = RTRIM(@CMPNYNAM)

/*Deleting the user record from the ACTIVITY table*/
DELETE FROM DYNAMICS.dbo.ACTIVITY
WHERE USERID = @USERID
AND CMPNYNAM = RTRIM(@CMPNYNAM)

Important Notes for Microsoft Dynamics GP

  • All un posted transactions mostly goes to 10000 series table in every module
  • All un posted transactions mostly detail/line times goes to 10001 tables
  • All posted transactions mostly goes to 20000 series table in every module
  • All posted transactions mostly detail/line times goes to 20001 tables
  • All history transactions mostly goes to 30000 tables
  • 40000 series tables are mostly related to setups
  • Two types of posting setups for every module as follows:
    • Post to General Ledger (Transactions posted from module reside in GL as un posted Batch)
    • Post Through General Ledger (Transactions posted from module also posted in GL)
  • If using transaction posting then every transaction goes to GL as un posted regardless of post TO and Through
  • Cash Receipts Updated AR Module and GL Module but not updated Bank/Checkbook
  • Bank Deposit then update checkbook/bank and have no effect on GL
  • One of the method to call Crystal report in GP is through Dexterity/VBA Code
  • Through Business Portal we can generate and process Purchase Requisition and then converted into GP as Purchase Order, But in GP 10 we can utilize Work Flows to directly create purchase order and to manage hierarchy and approvals without using Business Portal
  • VBA, Modifier, Dexterity and .Net are used for GP Customization
  • FRx is Reporting tool that can be utilized for financial reporting
  • Financial Reporting are namely (Balance Sheet, P&L, Income Statement, Cash Flow, etc)
  • From GP we can use, Smart List, Inquiry and Report for viewing data
  • Two types of posting mostly follows in GP:
    • Transaction Posting (User who enter transaction can immediately post it and it will reside in GL as un posted regardless of posting setup POST TO or POST THROUGH
    • Batch Posting (one users make X No. of transactions in one batch, another user review that batch and then post that batch and in batch posting system take care of POST TO and POST THROUGH
  • Debit memo will increase customer balance in Account receivable (mean we have to take more from customer)
  • Credit Memo will decrease customer balance in Accounts Receivable (mean we have to take less from customer)
  • Credit Memo will decrease supplier/vendor balance in Accounts Payable (Mean we have to pay less to Vendor)
  • No Debit memo available in Accounts Payable
  • National Accounts are utilized in sale/Accounts receivable as Distributor/Retailer or Parent/child relationship

Tips for Microsoft FRx

  1. If you have added a new budget, but do not see it in the drop down for bookcodes, you may need to rebuild your index. Likewise if you have added a new account, but the account is not included on your report, again the solution is likely to be rebuilding the index. The index is a file that ends with the extension *.G32. To rebuild the index, go to the catalog screen, choose from the menu, Admin > Build Local Index.
  2. If you get an error message that starts with “Check OFSI connection…”, check the information in the Company > Information screen. Be sure to check the System Specific Information tab.
  3. KEEP REGULAR BACKUPS!! This is the most important step a company must follow for a software program that stores data, including FRx Financial Reporting. Backups should be run nightly if FRx Financial Reporting is used on a day-to-day basis; otherwise backups should be run at least once a week. If frequent backups are not kept, reports and other FRx Financial Reporting data may be lost due to any number of circumstances. While you can attempt to repair a corrupted file, there are no guarantees that repairs will be successful. A frequent backup of the entire Sysdata directory is recommended.
  4. Compact the FRx System Database and FRx Specification Sets regularly. This should be done weekly or bi-weekly depending on the usage of FRx Financial Reporting. The FRx System Database contains Companies, Registration Information, FRx Security Information, Users, font styles and other information pertaining to the operation of FRx Financial Reporting. Specification Sets contain Row Formats, Column Layouts, Reporting Trees, and Catalogs, all of which make up the reports that are designed by FRx Financial Reporting users. When one of these databases is compacted, a new file is created with the same structure. User deleted records and other unnecessary information is removed and the remaining information is moved into the new file. When compacted regularly, these files will remain smaller in size and less likely to cause errors and/or lost data.
  • To compact these databases:
  • Have all other users exit out of FRx Financial Reporting – the user performing these steps must have exclusive access to the FRx Financial Reporting files.
  • Select from the menu File > Compact FRx Database > FRx System Database. If all other users are out of the program, this should compact successfully.
  • Select from the menu File > Compact FRx Database > Current Spec Set.
  • If more than one specification set is being used in FRx Financial Reporting, repeat the previous step for each company that uses a different spec set.

Windows Commands for Administrators

How many users are logged on/connected to a server?

Sometimes we may need to know how many users are logged on to a (file) server, like maybe when there is a performance degradation.
At the server's console itself, with native commands only:
NET SESSION | FIND /C "\\"
Remotely, with the help of SysInternals' PSTools:
PSEXEC \\servername NET SESSION | FIND /C "\\"
 
By replacing FIND /C "\\" by FIND "\\" (removing the /C switch) you'll get a list of logged on users instead of just the number of users.

Who is logged on to a computer?

We often need to know who is currently logged on to a remote computer.

With native Windows commands only:
NBTSTAT -a remotecomputer | FIND "<03>" | FIND /I /V "remotecomputer"
 
The first name in the list usually is the logged on user (try playing with the NET NAME command to learn more about the names displayed by NBTSTAT).
This is the fastest way to find the logged on user name, and the results that you do get are correct, but NBTSTAT won't always return a user name, even when a user is logged on.
Using WMIC (Windows XP Professional and later):
WMIC /Node:remotecomputer ComputerSystem Get UserName
 
This is arguably the most reliable (native) command to find out who is logged on.

With the help of SysInternals' PSTools:
PSLOGGEDON -L \\remotecomputer
or:
PSEXEC \\remotecomputer NET CONFIG WORKSTATION | FIND /I " name "
or:
PSEXEC \\remotecomputer NET NAME
or:
PSEXEC \\remotecomputer NETSH DIAG SHOW COMPUTER /V | FIND /i "username"
or:
FOR /F %%A IN ('REG Query \\remotecomputer\HKU ˆ| FINDSTR /R /B /C:"HKEY_USERS\\S-1-5-[0-9][0-9]-[0-9-]*$"') DO (FOR /F "tokens=3 delims=\" %%B IN ('REG Query "\\remotecomputer\%%A\Volatile Environment"') DO (
SET LoggedinUser=%%B))
 
NETSH and WMIC are for XP or later, and are the most reliable of all commands shown here.
WMIC requires WMI enabled remote computers and Windows XP on the administrator's computer; NETSH requires Windows XP on the remote computers.
PSLOGGEDON is a more accurate solution than NBTSTAT, but it will return the last logged on user if no one is currently logged on.
The NET and NBTSTAT commands show more or less identical results, but the NBTSTAT command is much faster.
The REG command is accurate, but may need to be modified depending on the version used. As displayed here, the code is written for REG.EXE 3.0 (XP).
If you want to search lots of computers for logged on users, I recommend you try NBTSTAT first (fast, but it won't always return the user name!), and only switch to NETSH, REG or WMIC (accurate) if NBTSTAT doesn't return a user name.
Credits: Jiří Janyška (WMIC command) and Matthew W. Helton (NETSH command).

What is this collegue's login name?

My collegues often forget to mention their logon account name when calling the helpdesk, and the helpdesk doesn't always ask either. I suppose they expect me to know all 1500+ accounts by heart.
With (native) Windows Server 2003 commands only:
DSQUERY USER -name *lastname* | DSGET USER -samid -display
Note: Windows Server 2003's "DSTools" will work fine in Windows 2000 and XP too, when copied.
Keep in mind, however, that some Windows Server 2003 Active Directory functionality is not available in Windows 2000 Active Directories.

What is the full name for this login name?

With the native NET command:
NET USER loginname /DOMAIN | FIND /I " name "
With (native) Windows Server 2003 commands:
DSQUERY USER -samid *loginname* | DSGET USER -samid -display
Note: The NET command may seem more universal, because it requires neither Active Directory nor Windows Server 2003 commands, but it is language dependent!
For non-English Windows you may need to modify FIND's search string.

What groups is this user a member of?

In Windows NT 4 and later, users usually are members of global groups. These global groups in turn are members of (domain) local groups. Access permissions are given to (domain) local groups.
To check if a user has access to a resource, we need to check group membership recursively.
With (native) Windows Server 2003 commands:
DSQUERY USER -samid loginname | DSGET USER -memberof -expand

What permissions does a user have on this directory?

One could use the previous command to check what permissions a user has on a certain directory.
However, sometimes SHOWACLS from the Windows Server 2003 Resource Kit Tools is a better alternative:
CD /D d:\directory2check
    SHOWACLS /U:domain\userid

When did someone last change his password?

With the native NET command:
NET USER loginname /DOMAIN | FIND /I "Password last set"

How do I reset someone's password?

With the native NET command:
NET USER loginname newpassword /DOMAIN
With (native) Windows Server 2003 commands:
DSQUERY USER -samid loginname | DSMOD USER -pwd newpassword
Note: To prevent the new password from being displayed on screen replace it with an asterisk (*); you will then be prompted (twice) to type the new password "blindly".

Is someone's account locked?

With the native NET command:
NET USER loginname /DOMAIN | FIND /I "Account active"
The account is either locked ("Locked") or active ("Yes").

How to unlock a locked account

With the native NET command:
NET USER loginname /DOMAIN /ACTIVE:YES
or, if the password needs to be reset as well:
NET USER loginname newpassword /DOMAIN /ACTIVE:YES

List all domains and workgroups in the network

With the native NET command:
NET VIEW /DOMAIN

List all computers in the network

With the native NET command:
NET VIEW
or, to list the names only:
FOR /F "skip=3 delims=\  " %%A IN ('NET VIEW') DO ECHO.%%A
delims is a backslash, followed by a tab and a space.

List all domain controllers

With native Windows 2000 commands:
NETDOM QUERY /D:MyDomain DC
NETDOM is part of the support tools found in the \SUPPORT directory of the Windows 2000 installation CDROM.
With (native) Windows Server 2003 commands (Active Directory only):
DSQUERY Server
or, if you prefer host names only (tip by Jim Christian Flatin):
DSQUERY Server -o rdn

Find the primary domain controller

With native Windows 2000 commands:
NETDOM QUERY /D:MyDomain PDC
or, to find the FSMO with (native) Windows Server 2003 commands (Active Directory only):
NETDOM QUERY /D:mydomain.com FSMO
NETDOM is part of the support tools found in the \SUPPORT directory of the Windows 2000 installation CDROM.

List all member servers

With native Windows 2000 commands:
NETDOM QUERY /D:MyDomain SERVER
NETDOM is part of the support tools found in the \SUPPORT directory of the Windows 2000 installation CDROM.

List all workstations

With native Windows 2000 commands:
NETDOM QUERY /D:MyDomain WORKSTATION
NETDOM is part of the support tools found in the \SUPPORT directory of the Windows 2000 installation CDROM.

Delete a computer account

With native Windows 2000 commands:
NETDOM /DOMAIN:MyDomain MEMBER \\computer2Bdeleted /DELETE
NETDOM is part of the support tools found in the \SUPPORT directory of the Windows 2000 installation CDROM.

"I need an up-to-date list of disk space usage for all servers, on my desk in 5 minutes"

Sounds familiar?
With (native) Windows XP Professional or Windows Server 2003 commands:
FOR /F %%A IN (servers.txt) DO (
        WMIC /Node:%%A LogicalDisk Where DriveType="3" Get DeviceID,FileSystem,FreeSpace,Size /Format:csv | MORE /E +2 >> SRVSPACE.CSV
    )
The only prerequisites are:
  1. SRVSPACE.CSV should not exist or be empty,
  2. a list of server names in a file named SERVERS.TXT, one server name on each line,
  3. and WMIC.EXE, which is native in Windows XP Professional, Windows Server 2003 and Vista.
The CSV file format is ServerName,DeviceID,FileSystem,FreeSpace,Size (one line for each harddisk partition on each server).
If you have a strict server naming convention, SERVERS.TXT itself can be generated with the NET command:
FOR /F "delims=\  " %%A IN ('NET VIEW ^| FINDSTR /R /B /C:"\\\\SRV\-"') DO (>>SERVERS.TXT ECHO.%%A)
Notes: (1) assuming server names start with "SRV-"; modify to match your own naming convention.
(2) delims is a backslash, followed by a tab and a space.

List all drivers on any PC

With (native) Windows XP Professional or Windows Server 2003 commands:
DRIVERQUERY /V /FO CSV > %ComputerName%.csv
Or, for remote computers:
DRIVERQUERY /S remote_PC /V /FO CSV > remote_PC.csv

List all printers on any PC

With (native) Windows XP+ commands:
WMIC /Node:remote_PC Path Win32_Printer Get DeviceID

List all local administrators

With (native) Windows NT 4+ commands:
NET LOCALGROUP Administrators
Or, to remove header and footer lines:
FOR /F "delims=[]" %%A IN ('NET LOCALGROUP Administrators ˆ| FIND /N "----"') DO SET HeaderLines=%%A
    FOR /F "tokens=*"  %%A IN ('NET LOCALGROUP Administrators') DO SET FooterLine=%%A
    NET LOCALGROUP Administrators | MORE /E +%HeaderLines% | FIND /V "%FooterLine%"

Locate rogue DHCP servers

Never had an "illegal" router wreaking havoc on your network yet...?
With a (native) Windows Server 2003 command:
DHCPLOC -p local_IP_address [ valid_DHCP_server1 [ valid_DHCP_server2 [ .. ] ] ]
DHCPLOC.EXE is native in Windows Server 2003, and will run in Windows XP if copied/installed.
I didn't test this in Windows Server 2003 yet, but in Windows XP you need to press "d" to start the discovery, or "q" to quit.

Disable Windows Firewall for domain only

Disable the firewall only when the computer (e.g. a laptop) is connected to the domain:
NETSH Firewall Set OpMode Mode = DISABLE Profile = DOMAIN

Completely disable Windows Firewall (not recommended)

Disable the firewall comletely (not recommended unless an alternative enterprise firewall is used that requires you to do so):
SC [ \\Remote_computer ] Stop SharedAccess
    SC [ \\Remote_computer ] Config SharedAccess start= disabled