<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" version="2.0">

<channel>
	<title>Sys Admin Tales</title>
	
	<link>http://www.meltivore.com</link>
	<description>The endless search for the Any key</description>
	<lastBuildDate>Fri, 27 Apr 2012 00:28:58 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.0.5</generator>
		<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/SysAdminTales" /><feedburner:info xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" uri="sysadmintales" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><item>
		<title>Excel Formula Field Only Shows Last Two Characters</title>
		<link>http://www.meltivore.com/2012/excel-formula-field-only-shows-last-two-characters/</link>
		<comments>http://www.meltivore.com/2012/excel-formula-field-only-shows-last-two-characters/#comments</comments>
		<pubDate>Fri, 27 Apr 2012 00:28:58 +0000</pubDate>
		<dc:creator>Tom Thrush</dc:creator>
				<category><![CDATA[Excel]]></category>
		<category><![CDATA[Office]]></category>

		<guid isPermaLink="false">http://www.meltivore.com/?p=943</guid>
		<description><![CDATA[Okay, this is a dumb one. When highlighting any cell it only shows the last two characters in the formula field. Can&#8217;t seem to find a permanent fix yet, but it seems to happen only when using two monitors. The workaround is to view Excel in the primary monitor and the formula field then shows [...]]]></description>
			<content:encoded><![CDATA[<p>Okay, this is a dumb one. When highlighting any cell it only shows the last two characters in the formula field.</p>
<p>Can&#8217;t seem to find a permanent fix yet, <em>but it seems to happen only when using two monitors. </em>The workaround is to view Excel in the primary monitor and the formula field <em>then</em> shows all the cell&#8217;s contents.</p>
<p>And from my searches, this seems to have been happening since Excel 97&#8230;good stuff.</p>
]]></content:encoded>
			<wfw:commentRss>http://www.meltivore.com/2012/excel-formula-field-only-shows-last-two-characters/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Removing the U3 Partition from a Flash Drive</title>
		<link>http://www.meltivore.com/2012/removing-the-u3-partition-from-a-flash-drive/</link>
		<comments>http://www.meltivore.com/2012/removing-the-u3-partition-from-a-flash-drive/#comments</comments>
		<pubDate>Thu, 12 Apr 2012 22:27:03 +0000</pubDate>
		<dc:creator>Tom Thrush</dc:creator>
				<category><![CDATA[Gear]]></category>
		<category><![CDATA[Hardware]]></category>
		<category><![CDATA[Troubleshooting]]></category>

		<guid isPermaLink="false">http://www.meltivore.com/?p=929</guid>
		<description><![CDATA[I find most extra software bundled with hardware unnecessary and usually annoying; U3 luckily is both. After attempts to format, fdisk /mbr, diskpart clean, etc. all failed. I did some poking around and found the uninstaller is bundled with the startup app, clever&#8230; Insert your U3 flash drive  and Launch the U3 application. Click on [...]]]></description>
			<content:encoded><![CDATA[<p>I find most extra software bundled with hardware unnecessary and usually annoying; <a title="U3" href="http://en.wikipedia.org/wiki/U3" target="_blank">U3</a> luckily is both.</p>
<p>After attempts to format, <a title="fdisk /mbr" href="http://support.microsoft.com/kb/69013" target="_blank">fdisk /mbr</a>, <a title="Diskpart Commands" href="http://technet.microsoft.com/en-us/library/cc766465(v=WS.10).aspx" target="_blank">diskpart clean</a>, etc. all failed. I did some poking around and found the uninstaller is bundled with the startup app, clever&#8230;</p>
<ol>
<li>Insert your U3 flash drive  and Launch the U3 application.</li>
<li>Click on the <strong>U3 Launchpad Settings</strong></li>
<li>Click the <strong>Uninstall</strong> tab on the <strong>Settings </strong>menu (all windows and files accessed from the flash drive must be closed).</li>
<li>Finally, click <strong>Uninstall U3 Launchpad</strong></li>
</ol>
<p>That&#8217;s it, no more pop-ups and annoying software.</p>
]]></content:encoded>
			<wfw:commentRss>http://www.meltivore.com/2012/removing-the-u3-partition-from-a-flash-drive/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Resetting a Verizon MiFi 2200</title>
		<link>http://www.meltivore.com/2012/resetting-a-verizon-mifi-2200/</link>
		<comments>http://www.meltivore.com/2012/resetting-a-verizon-mifi-2200/#comments</comments>
		<pubDate>Mon, 02 Apr 2012 20:21:55 +0000</pubDate>
		<dc:creator>Tom Thrush</dc:creator>
				<category><![CDATA[Gear]]></category>
		<category><![CDATA[Hardware]]></category>
		<category><![CDATA[Troubleshooting]]></category>

		<guid isPermaLink="false">http://www.meltivore.com/?p=922</guid>
		<description><![CDATA[A recently returned Verizon MiFi 2200 was found to have been reset by the user, with now-forgotten settings. Luckily the reset is easy&#8230; Power on the MiFi (if it isn&#8217;t already). Take off the back cover and depress the reset button with a paperclip or similar (look for a hole labelled RESET in one of the corners). [...]]]></description>
			<content:encoded><![CDATA[<p>A recently returned <a title="Verizon MiFi" href="http://www.verizonwireless.com/b2c/mobilebroadband/?page=products_mifi" target="_blank">Verizon MiFi 2200</a> was found to have been reset by the user, with now-forgotten settings. Luckily the reset is easy&#8230;</p>
<ol>
<li>Power on the MiFi (if it isn&#8217;t already).</li>
<li>Take off the back cover and depress the reset button with a paperclip or similar (look for a hole labelled <strong><span style="color: #800000;">RESET </span></strong>in one of the corners).</li>
<li>Hold the button in until the status LED turns <span style="color: #008000;">green</span>, then blinks once <em>(this can take up to ten seconds)</em>.</li>
<li>Let it go and then you&#8217;ll find the SSID listed on the back in your available wireless networks (typically <span style="color: #800000;"><strong>Verizon MIFI4510L <em>XXXX</em></strong></span>).</li>
</ol>
]]></content:encoded>
			<wfw:commentRss>http://www.meltivore.com/2012/resetting-a-verizon-mifi-2200/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Dell Latitude Unknown Data Interface Driver</title>
		<link>http://www.meltivore.com/2012/dell-latitude-unknown-data-interface-driver/</link>
		<comments>http://www.meltivore.com/2012/dell-latitude-unknown-data-interface-driver/#comments</comments>
		<pubDate>Thu, 29 Mar 2012 21:13:54 +0000</pubDate>
		<dc:creator>Tom Thrush</dc:creator>
				<category><![CDATA[Hardware]]></category>
		<category><![CDATA[Troubleshooting]]></category>

		<guid isPermaLink="false">http://www.meltivore.com/?p=907</guid>
		<description><![CDATA[Installing a system from scratch can be a bear when it comes to finding device drivers, especially when the device in question doesn&#8217;t have a manufacturer, model or even name associated with it. The latest install in which I had to deal with this was a Dell Latitude D430, but this device seems common to [...]]]></description>
			<content:encoded><![CDATA[<p>Installing a system from scratch can be a bear when it comes to finding device drivers, especially when the device in question doesn&#8217;t have a manufacturer, model or even name associated with it. The latest install in which I had to deal with this was a <a title="D430 Review" href="http://www.notebookreview.com/default.asp?newsID=4234" target="_blank">Dell Latitude D430</a>, but this device seems common to other D-Series Latitudes like the D620.</p>
<p>It&#8217;s listed in the <a title="Device Manager" href="http://en.wikipedia.org/wiki/Device_Manager" target="_blank">Device Manager</a> simply as <strong>Data Interface</strong> with the typical unknown icon, and there were two of them. Digging further into the details of the device yielded the Hardware ID values below.</p>
<p><span style="color: #800000;">USB\VID_413C&amp;PID_8114&amp;MI_00\7&amp;24B185B&amp;0&amp;0000<br />
USB\VID_413C&amp;PID_8114&amp;MI_01\7&amp;24B185B&amp;0&amp;0001</span></p>
<p>Turns out these are for the <span style="color: #800000;"><strong><span style="color: #000000;">Verizon cellular modem card</span></strong></span> and drivers are readily available from Dell, under <a title="Dell Technical Support" href="http://www.dell.com/support/drivers/us/en/04/DriversHome/NeedProductSelection" target="_blank">Technical Support</a>, with your trusty Service Tag. I found the Verizon WWAN Card driver under the <strong>Communications </strong>heading (as <strong>VZW Mobile Broadband</strong>).</p>
]]></content:encoded>
			<wfw:commentRss>http://www.meltivore.com/2012/dell-latitude-unknown-data-interface-driver/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>E-mail to Text Message</title>
		<link>http://www.meltivore.com/2012/e-mail-to-text-message/</link>
		<comments>http://www.meltivore.com/2012/e-mail-to-text-message/#comments</comments>
		<pubDate>Wed, 28 Mar 2012 00:57:34 +0000</pubDate>
		<dc:creator>Tom Thrush</dc:creator>
				<category><![CDATA[General]]></category>
		<category><![CDATA[Phones]]></category>

		<guid isPermaLink="false">http://www.meltivore.com/?p=906</guid>
		<description><![CDATA[This has already been posted many places, but I&#8217;m tired of looking it up and dealing with glaring ads and pop-ups. As you can guess, to send an e-mail to someone&#8217;s phone as a text message, just replace the phonenumber with whomever you&#8217;re trying to message, i.e. 4085551212@vtext.com. Alltel &#8211; phonenumber@message.alltel.com AT&#38;T &#8211; phonenumber@txt.att.net Boost [...]]]></description>
			<content:encoded><![CDATA[<p>This has already been posted many places, but I&#8217;m tired of looking it up and dealing with glaring ads and pop-ups.</p>
<p>As you can guess, to send an e-mail to someone&#8217;s phone as a text message, just replace the <span style="color: #800000;"><em>phonenumber</em> <span style="color: #000000;">with whomever you&#8217;re trying to message, i.e. <em><strong>4085551212@vtext.com</strong></em>.</span></span></p>
<ul>
<li>Alltel &#8211; <span style="color: #800000;"><em>phonenumber</em></span>@message.alltel.com</li>
<li>AT&amp;T &#8211; <em><span style="color: #800000;">phonenumber</span></em>@txt.att.net</li>
<li>Boost Mobile &#8211; <span style="color: #800000;"><em>phonenumber</em></span>@myboostmobile.com</li>
<li>Sprint Nextel &#8211; <em><span style="color: #800000;">phonenumber</span></em>@messaging.sprintpcs.com</li>
<li>T-Mobile &#8211; <span style="color: #800000;"><em>phonenumber</em></span>@tmomail.net</li>
<li>US Cellular &#8211; <em><span style="color: #800000;">phonenumber</span></em>@email.uscc.net</li>
<li>Verizon &#8211; <em><span style="color: #800000;">phonenumber</span></em>@vtext.com</li>
<li>Virgin Mobile USA &#8211; <span style="color: #800000;"><em>phonenumber</em></span>@vmobl.com</li>
</ul>
<p>Etiquette is 140 characters or less and just be aware some may not have unlimited texting, so be careful on the quantity and size of messages.</p>
]]></content:encoded>
			<wfw:commentRss>http://www.meltivore.com/2012/e-mail-to-text-message/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Removing Remote Desktop Login Wallpaper</title>
		<link>http://www.meltivore.com/2012/remote-desktop-login-wallpaper/</link>
		<comments>http://www.meltivore.com/2012/remote-desktop-login-wallpaper/#comments</comments>
		<pubDate>Thu, 08 Mar 2012 07:13:08 +0000</pubDate>
		<dc:creator>Tom Thrush</dc:creator>
				<category><![CDATA[Troubleshooting]]></category>
		<category><![CDATA[Windows Server 2003]]></category>

		<guid isPermaLink="false">http://www.meltivore.com/?p=897</guid>
		<description><![CDATA[This annoyance has popped up off and on for years. You initiate a Remote Desktop connection to a system over VPN and the login screen has a large bitmap image causing it to draw and redraw while you wait. This is typical for Windows Storage Server 2003 on Dell hardware. Unfortunately there isn&#8217;t a GUI [...]]]></description>
			<content:encoded><![CDATA[<p>This annoyance has popped up off and on for years. You initiate a Remote Desktop connection to a system over VPN and the login screen has a large bitmap image causing it to draw and redraw while you wait.</p>
<p>This is typical for <a title="Windows Storage Server 2003" href="http://en.wikipedia.org/wiki/Windows_Storage_Server#Windows_Storage_Server" target="_blank">Windows Storage Server 2003</a> on Dell hardware. Unfortunately there isn&#8217;t a GUI setting for this, so it &#8216;s just better to search for the file and delete or rename it. In this case it&#8217;s: <span style="color: #800000;"><strong>C:\Windows\System32\dellwall.bmp </strong><strong><span style="color: #000000;">which is 3MB, no wonder it takes time to draw over a slower connection.</span></strong></span></p>
]]></content:encoded>
			<wfw:commentRss>http://www.meltivore.com/2012/remote-desktop-login-wallpaper/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Locked Out of Track-It! Admin Console</title>
		<link>http://www.meltivore.com/2012/locked-out-of-track-it-admin-console/</link>
		<comments>http://www.meltivore.com/2012/locked-out-of-track-it-admin-console/#comments</comments>
		<pubDate>Tue, 06 Mar 2012 19:34:46 +0000</pubDate>
		<dc:creator>Tom Thrush</dc:creator>
				<category><![CDATA[SQL]]></category>
		<category><![CDATA[Troubleshooting]]></category>

		<guid isPermaLink="false">http://www.meltivore.com/?p=888</guid>
		<description><![CDATA[Great! The only one in with admin privileges on Track-It! is no longer with the company. If you have access to the server and the Track-It! MS SQL database you&#8217;re in luck. Log into the Track-It! server and fire up the MS SQL Management Studio Drill down under &#8220;Server&#8221; &#62; Databases &#62; TRACKITX &#62; Tables [...]]]></description>
			<content:encoded><![CDATA[<p>Great! The only one in with admin privileges on <a title="Track-It!" href="http://www.numarasoftware.com/track-it/" target="_blank">Track-It!</a> is no longer with the company. If you have access to the server and the Track-It! MS SQL database you&#8217;re in luck.</p>
<ul>
<li>Log into the Track-It! server and fire up the <strong>MS SQL Management Studio</strong></li>
<li>Drill down under &#8220;<em><strong><span style="color: #800000;">Server</span></strong></em>&#8221; &gt; <strong>Databases </strong>&gt; <strong>TRACKITX</strong> &gt; <strong>Tables</strong></li>
<li>Find <strong>dbo.STAF</strong>, right-click and choose <strong>Open Table</strong></li>
<li>Choose a <em><span style="color: #800000;">username </span></em>you wish to give administrative access to, scroll to the right to the <strong>SECPOLICYID</strong> column and change the entry to the number <strong>2</strong>.</li>
<li>Close the table and Management Studio.</li>
<li>Log out of Track-It! and back in, now you have access to the Administration Console.</li>
</ul>
]]></content:encoded>
			<wfw:commentRss>http://www.meltivore.com/2012/locked-out-of-track-it-admin-console/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Free Microsoft Software Trials</title>
		<link>http://www.meltivore.com/2012/free-microsoft-software-trials/</link>
		<comments>http://www.meltivore.com/2012/free-microsoft-software-trials/#comments</comments>
		<pubDate>Mon, 20 Feb 2012 01:45:03 +0000</pubDate>
		<dc:creator>Tom Thrush</dc:creator>
				<category><![CDATA[Exchange]]></category>
		<category><![CDATA[Office]]></category>
		<category><![CDATA[SQL]]></category>
		<category><![CDATA[Websites]]></category>
		<category><![CDATA[Windows]]></category>

		<guid isPermaLink="false">http://www.meltivore.com/?p=885</guid>
		<description><![CDATA[Big project coming up, polishing the resume or just curious? Microsoft&#8217;s TechNet Evaluation Center is there to help. The trial periods may vary a bit, but even 60 days of testing and mucking about should do the trick. Want unlimited trial software? Subscribe to TechNet and no matter what the level you choose, it&#8217;s an [...]]]></description>
			<content:encoded><![CDATA[<p>Big project coming up, polishing the resume or just curious? Microsoft&#8217;s <a title="TechNet Eval Center" href="http://technet.microsoft.com/en-US/evalcenter/default.aspx" target="_blank">TechNet Evaluation Center</a> is there to help.</p>
<p>The trial periods may vary a bit, but even 60 days of testing and mucking about should do the trick.</p>
<p>Want unlimited trial software? Subscribe to <a title="TechNet Subscriptions" href="https://technet.microsoft.com/en-us/subscriptions/buy" target="_blank">TechNet</a> and no matter what the level you choose, it&#8217;s an amazing array of operating systems and applications that never expire; worth every penny.</p>
]]></content:encoded>
			<wfw:commentRss>http://www.meltivore.com/2012/free-microsoft-software-trials/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Cisco VPN Client PCF File</title>
		<link>http://www.meltivore.com/2012/cisco-vpn-client-pcf-file/</link>
		<comments>http://www.meltivore.com/2012/cisco-vpn-client-pcf-file/#comments</comments>
		<pubDate>Fri, 10 Feb 2012 19:03:38 +0000</pubDate>
		<dc:creator>Tom Thrush</dc:creator>
				<category><![CDATA[Cisco]]></category>
		<category><![CDATA[Vista]]></category>
		<category><![CDATA[Windows 2000]]></category>
		<category><![CDATA[Windows 7]]></category>
		<category><![CDATA[XP]]></category>

		<guid isPermaLink="false">http://www.meltivore.com/?p=880</guid>
		<description><![CDATA[I could have sworn you exported the pcf profile (the VPN configuration file that can be imported for new installs) within the Cisco VPN IPSec Client, but I was wrong. This little guy is actually a text file that&#8217;s created as soon as you add a new connection. And it places it within the VPN client installation [...]]]></description>
			<content:encoded><![CDATA[<p>I could have sworn you exported the pcf profile (the VPN configuration file that can be imported for new installs) within the Cisco VPN IPSec Client, but I was wrong.</p>
<p>This little guy is actually a text file that&#8217;s created as soon as you add a new connection. And it places it within the VPN client installation directory, as listed below.</p>
<p><span style="color: #800000;">C:\Program Files\Cisco Systems\VPN Client\Profiles</span></p>
<p>Once you grab your profile, you can throw it in with the installation files for the client and it will automatically be imported for use immediately upon completion (reboot is necessary, of course).</p>
]]></content:encoded>
			<wfw:commentRss>http://www.meltivore.com/2012/cisco-vpn-client-pcf-file/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Hide Your Windows System from the Network</title>
		<link>http://www.meltivore.com/2012/hide-your-windows-system-from-the-network/</link>
		<comments>http://www.meltivore.com/2012/hide-your-windows-system-from-the-network/#comments</comments>
		<pubDate>Wed, 08 Feb 2012 22:40:13 +0000</pubDate>
		<dc:creator>Tom Thrush</dc:creator>
				<category><![CDATA[Scripting]]></category>
		<category><![CDATA[Vista]]></category>
		<category><![CDATA[Windows 2000]]></category>
		<category><![CDATA[Windows 7]]></category>
		<category><![CDATA[Windows Server 2003]]></category>
		<category><![CDATA[Windows Server 2008]]></category>
		<category><![CDATA[XP]]></category>

		<guid isPermaLink="false">http://www.meltivore.com/?p=875</guid>
		<description><![CDATA[Should you wish to hide your Windows system from the Network Neighborhood just run the command below: c:\net config server /hidden:yes There&#8217;s a bevy of net commands to be used to perform all sorts of tasks; truly worth investigation.]]></description>
			<content:encoded><![CDATA[<p>Should you wish to hide your Windows system from the <a title="Network Neighborhood" href="http://en.wikipedia.org/wiki/Network_Neighborhood" target="_blank">Network Neighborhood</a> just run the command below:</p>
<p>c:\net config server /hidden:yes</p>
<p>There&#8217;s a bevy of <a title="Net commands aplenty" href="http://www.computerhope.com/nethlp.htm" target="_blank">net commands</a> to be used to perform all sorts of tasks; truly worth investigation.</p>
]]></content:encoded>
			<wfw:commentRss>http://www.meltivore.com/2012/hide-your-windows-system-from-the-network/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>

