http://trunnelle.com/wiki/index.php?title=Special:Contributions&feed=atom&target=JeffCome play with my wiki - User contributions [en]2024-03-28T10:30:28ZFrom Come play with my wikiMediaWiki 1.15.1http://trunnelle.com/wiki/index.php?title=File:2011-2012-KirbyDogLicenseReceipt.jpgFile:2011-2012-KirbyDogLicenseReceipt.jpg2011-10-29T15:41:17Z<p>Jeff: </p>
<hr />
<div></div>Jeffhttp://trunnelle.com/wiki/index.php?title=The_BowersThe Bowers2011-10-29T15:40:01Z<p>Jeff: Created page with '2010 Bower Christmas Card 2010 Bower Christmas Card'</p>
<hr />
<div>[[File:2010-BowerXMas1.jpg|500px|center|thumb|2010 Bower Christmas Card]]<br />
[[File:2010-BowerXMas2.jpg|500px|center|thumb|2010 Bower Christmas Card]]</div>Jeffhttp://trunnelle.com/wiki/index.php?title=File:2010-BowerXMas2.jpgFile:2010-BowerXMas2.jpg2011-10-29T15:38:50Z<p>Jeff: </p>
<hr />
<div></div>Jeffhttp://trunnelle.com/wiki/index.php?title=File:2010-BowerXMas1.jpgFile:2010-BowerXMas1.jpg2011-10-29T15:38:15Z<p>Jeff: Eddie on the front of the Bower family Christmas Card, 2010</p>
<hr />
<div>Eddie on the front of the Bower family Christmas Card, 2010</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Ashlyn_AnnAshlyn Ann2011-10-29T15:36:29Z<p>Jeff: </p>
<hr />
<div>[[File:20111123-Ashlyn.jpg|500px|center|thumb|Ashlyn's Birth Announcement]]</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Ashlyn_AnnAshlyn Ann2011-10-29T15:36:16Z<p>Jeff: Created page with 'Ashlyn's Birth Announcement'</p>
<hr />
<div>[[File:20111123-Ashlyn.jpg|400px|center|thumb|Ashlyn's Birth Announcement]]</div>Jeffhttp://trunnelle.com/wiki/index.php?title=File:20111123-Ashlyn.jpgFile:20111123-Ashlyn.jpg2011-10-29T15:35:35Z<p>Jeff: Ashlyn Birth Announcement</p>
<hr />
<div>Ashlyn Birth Announcement</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Jimmy_and_ChristinaJimmy and Christina2011-10-29T15:33:57Z<p>Jeff: Created page with 'Jimmy and Christina's Wedding Announcement'</p>
<hr />
<div>[[File:20110916-JimmyChristina.jpg|400px|center|thumb|Jimmy and Christina's Wedding Announcement]]</div>Jeffhttp://trunnelle.com/wiki/index.php?title=File:20110916-JimmyChristina.jpgFile:20110916-JimmyChristina.jpg2011-10-29T15:33:04Z<p>Jeff: Jimmy and Christina's Wedding Announcement</p>
<hr />
<div>Jimmy and Christina's Wedding Announcement</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Madison_KatherineMadison Katherine2011-10-29T15:31:48Z<p>Jeff: </p>
<hr />
<div>[[File:20101105-Madison.jpg|400px|center|thumb|Madison's Birth announcement]]</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Madison_KatherineMadison Katherine2011-10-29T15:31:04Z<p>Jeff: Created page with 'File:Example.jpg'</p>
<hr />
<div>[[File:Example.jpg]]</div>Jeffhttp://trunnelle.com/wiki/index.php?title=File:20101105-Madison.jpgFile:20101105-Madison.jpg2011-10-29T15:30:30Z<p>Jeff: Madison birth announcement</p>
<hr />
<div>Madison birth announcement</div>Jeffhttp://trunnelle.com/wiki/index.php?title=File:20100922-Ericito.jpgFile:20100922-Ericito.jpg2011-10-29T15:28:42Z<p>Jeff: Eric Ezequiel birth announcement</p>
<hr />
<div>Eric Ezequiel birth announcement</div>Jeffhttp://trunnelle.com/wiki/index.php?title=JadenJaden2011-10-29T15:27:33Z<p>Jeff: </p>
<hr />
<div><br />
[[File:20110116-Jayden.jpg|400px|center|thumb|Jaden Joseph Ergas-Zotti]]<br />
<br />
<br />
[[File:20110601-Jayden.jpg|400px|center|thumb|Jaden at about 6 months old]]</div>Jeffhttp://trunnelle.com/wiki/index.php?title=JadenJaden2011-10-29T15:27:12Z<p>Jeff: </p>
<hr />
<div>[[File:20110601-Jayden.jpg|400px|center|thumb|Jaden at about 6 months old]]<br />
[[File:20110116-Jayden.jpg|400px|center|thumb|Jaden Joseph Ergas-Zotti]]</div>Jeffhttp://trunnelle.com/wiki/index.php?title=JadenJaden2011-10-29T15:26:42Z<p>Jeff: </p>
<hr />
<div>[[File:20110601-Jayden.jpg|400px|center|thumb|Jaden Joseph Ergas-Zotti]]<br />
[[File:20110116-Jayden.jpg|400px|center|thumb|Jaden at about 6 months old]]</div>Jeffhttp://trunnelle.com/wiki/index.php?title=JadenJaden2011-10-29T15:26:19Z<p>Jeff: </p>
<hr />
<div>[[File:20110601-Jayden.jpg|400px|thumb|Jaden Joseph Ergas-Zotti]]<br />
[[File:20110116-Jayden.jpg|400px|thumb|Jaden at about 6 months old]]</div>Jeffhttp://trunnelle.com/wiki/index.php?title=JadenJaden2011-10-29T15:22:30Z<p>Jeff: Created page with 'Images:20110116-Jayden.jpg'</p>
<hr />
<div>[[Images:20110116-Jayden.jpg]]</div>Jeffhttp://trunnelle.com/wiki/index.php?title=File:20110116-Jayden.jpgFile:20110116-Jayden.jpg2011-10-29T15:21:00Z<p>Jeff: Jayden birth announcement.</p>
<hr />
<div>Jayden birth announcement.</div>Jeffhttp://trunnelle.com/wiki/index.php?title=File:20110601-Jayden.jpgFile:20110601-Jayden.jpg2011-10-29T15:20:31Z<p>Jeff: Jayden around 6 months old.</p>
<hr />
<div>Jayden around 6 months old.</div>Jeffhttp://trunnelle.com/wiki/index.php?title=File:20110503-JudeJune.jpgFile:20110503-JudeJune.jpg2011-10-29T15:16:15Z<p>Jeff: Jude and June, twin son and daughter of Jessica and John Schwind</p>
<hr />
<div>Jude and June, twin son and daughter of Jessica and John Schwind</div>Jeffhttp://trunnelle.com/wiki/index.php?title=KeiraKeira2011-10-29T15:14:29Z<p>Jeff: </p>
<hr />
<div>[[Image:Jeff_and_Keira.jpg|400px|thumb|center|Keira and me hanging out on the floor]]<br />
<br />
[[File:20101000-Keira-Pre school.jpg|300px|thumb|center|Keira's pre-school photo]]</div>Jeffhttp://trunnelle.com/wiki/index.php?title=File:20101000-Keira-Pre_school.jpgFile:20101000-Keira-Pre school.jpg2011-10-29T15:13:24Z<p>Jeff: Keira, Oct. 2010, Pre-school picture</p>
<hr />
<div>Keira, Oct. 2010, Pre-school picture</div>Jeffhttp://trunnelle.com/wiki/index.php?title=SynergySynergy2011-10-04T23:05:13Z<p>Jeff: </p>
<hr />
<div>It was mostly guess and check, but I was finally able to get synergy to accomplish my desired 3 monitor set up.<br />
<br />
<br />
''Here is my set up:''<br />
* Windows 7 - With dual monitors heretofore named: dual-left and dual-right<br />
* Ubuntu 10.04 - Single monitor<br />
<br />
<br />
<br />
At first I tried created separate screens for my dual monitor Windows 7 machine. I don't think this is necessary and so the config might be slightly over-complicated.<br />
<br />
<br />
<br />
'''user config file:'''<br />
section: screens<br />
WIN7-LEFT:<br />
switchCorners = none<br />
switchCornerSize = 0<br />
WIN7-RIGHT:<br />
switchCorners = none<br />
switchCornerSize = 0<br />
UBUNTU:<br />
switchCorners = none<br />
switchCornerSize = 0<br />
end<br />
section: links<br />
WIN7-LEFT:<br />
left = waffle<br />
right = MADO-7019-RIGHT<br />
WIN7-RIGHT:<br />
right = waffle<br />
UBUNTU:<br />
left = MADO-7019-LEFT<br />
right = MADO-7019-LEFT<br />
end<br />
section: options<br />
screenSaverSync = false<br />
end<br />
<br />
<br />
<br />
'''Server Config file:'''<br />
C:\windows\synergy.sgc<br />
section: screens<br />
WIN7-LEFT:<br />
switchCorners = none<br />
switchCornerSize = 0<br />
WIN7-RIGHT:<br />
switchCorners = none<br />
switchCornerSize = 0<br />
UBUNTU:<br />
switchCorners = none<br />
switchCornerSize = 0<br />
end<br />
section: links<br />
WIN7-LEFT:<br />
left = waffle<br />
right = MADO-7019-RIGHT<br />
WIN7-RIGHT:<br />
right = waffle<br />
UBUNTU:<br />
left = MADO-7019-LEFT<br />
right = MADO-7019-LEFT<br />
end<br />
section: options<br />
screenSaverSync = false<br />
end</div>Jeffhttp://trunnelle.com/wiki/index.php?title=SynergySynergy2011-10-04T22:56:31Z<p>Jeff: </p>
<hr />
<div>It was mostly guess and check, but I was finally able to get synergy to accomplish my desired 3 monitor set up.<br />
<br />
<br />
<br />
<br />
'''user config file:'''<br />
section: screens<br />
MADO-7019-LEFT:<br />
switchCorners = none<br />
switchCornerSize = 0<br />
MADO-7019-RIGHT:<br />
switchCorners = none<br />
switchCornerSize = 0<br />
waffle:<br />
switchCorners = none<br />
switchCornerSize = 0<br />
end<br />
section: links<br />
MADO-7019-LEFT:<br />
left = waffle<br />
right = MADO-7019-RIGHT<br />
MADO-7019-RIGHT:<br />
right = waffle<br />
waffle:<br />
left = MADO-7019-LEFT<br />
right = MADO-7019-LEFT<br />
end<br />
section: options<br />
screenSaverSync = false<br />
end<br />
<br />
<br />
<br />
'''Server Config file:'''<br />
C:\windows\synergy.sgc<br />
section: screens<br />
MADO-7019-LEFT:<br />
switchCorners = none<br />
switchCornerSize = 0<br />
MADO-7019-RIGHT:<br />
switchCorners = none<br />
switchCornerSize = 0<br />
waffle:<br />
switchCorners = none<br />
switchCornerSize = 0<br />
end<br />
section: links<br />
MADO-7019-LEFT:<br />
left = waffle<br />
right = MADO-7019-RIGHT<br />
MADO-7019-RIGHT:<br />
right = waffle<br />
waffle:<br />
left = MADO-7019-LEFT<br />
right = MADO-7019-LEFT<br />
end<br />
section: options<br />
screenSaverSync = false<br />
end</div>Jeffhttp://trunnelle.com/wiki/index.php?title=SynergySynergy2011-10-04T22:55:30Z<p>Jeff: Created page with 'It was mostly guess and check, but I was finally able to get synergy to accomplish my desired 3 monitor set up. '''user config file:''' section: screens MADO-7019-LEFT: sw…'</p>
<hr />
<div>It was mostly guess and check, but I was finally able to get synergy to accomplish my desired 3 monitor set up.<br />
<br />
<br />
<br />
<br />
'''user config file:'''<br />
section: screens<br />
MADO-7019-LEFT:<br />
switchCorners = none<br />
switchCornerSize = 0<br />
MADO-7019-RIGHT:<br />
switchCorners = none<br />
switchCornerSize = 0<br />
waffle:<br />
switchCorners = none<br />
switchCornerSize = 0<br />
end<br />
section: links<br />
MADO-7019-LEFT:<br />
left = waffle<br />
right = MADO-7019-RIGHT<br />
MADO-7019-RIGHT:<br />
right = waffle<br />
waffle:<br />
left = MADO-7019-LEFT<br />
right = MADO-7019-LEFT<br />
end<br />
section: options<br />
screenSaverSync = false<br />
end<br />
<br />
<br />
<br />
'''Server Config file:'''<br />
C:\windows\synergy.sgc<br />
section: screens<br />
MADO-7019-LEFT:<br />
switchCorners = none<br />
switchCornerSize = 0<br />
MADO-7019-RIGHT:<br />
switchCorners = none<br />
switchCornerSize = 0<br />
waffle:<br />
switchCorners = none<br />
switchCornerSize = 0<br />
end<br />
section: links<br />
MADO-7019-LEFT:<br />
left = waffle<br />
right = MADO-7019-RIGHT<br />
MADO-7019-RIGHT:<br />
right = waffle<br />
waffle:<br />
left = MADO-7019-LEFT<br />
right = MADO-7019-LEFT<br />
end<br />
section: options<br />
screenSaverSync = false<br />
end</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Time_trackerTime tracker2011-07-08T17:23:24Z<p>Jeff: </p>
<hr />
<div>'''Background:'''<br />
<br />
Several years ago, I was asked to track my time in 20 minute increments. I worked for a company that billed their time to the customer and although that ship has sailed, the script is still in place today and it's a huge help in tracking my time. It's not the most elaborate set up, but IMHO it serves the purpose quite well.<br />
<br />
This was formerly known as Micro Manager.<br />
<br />
'''Location:'''<br />
<br />
Technically you can store the source code (and resultant log file) anywhere you want, but I've found C:\program files\timetracker works best for me.<br />
<br />
<br />
'''How to Call it?'''<br />
<br />
You'll need to set up an advanced schedule within the windows scheduler to determine which days and times for it to run.<br />
<br />
Additionally, I have a shortcut in my quick launch tray so that I can call on it in an unscheduled fashion.<br />
<br />
<br />
<br />
The source code consists of two parts:<br />
<br />
1) the vbs file which drives all the action<br />
<br />
and<br />
<br />
2) the batch file which calls the vb file<br />
<br />
<br />
<br />
==VBS CODE - TimeTracker.vbs==<br />
This is the first version and has times in a more human readable format.<br />
<br />
'* ********** GETTING USERNAME FROM ADSI OBJECT ****** *'<br />
Set objNetwork = WScript.CreateObject("WScript.Network")<br />
strUserName = objNetwork.UserName<br />
<br />
'* ********* SET THE PATH TO THE DESKTOP in A variable ****** *'<br />
'*logfilepath = "C:\Documents and Settings\" & strUserName & "\TimeTracker.txt"*'<br />
logfilepath = "C:\Program Files\TimeTracker\TimeTracker.txt"<br />
<br />
'********** IF THE FILE EXISTS, APPEND TO IT, IF NOT, CREATE IT ********'<br />
Set objFSO = CreateObject("Scripting.FileSystemObject")<br />
If objFSO.FileExists(logfilepath) Then<br />
Set objFile = objFSO.OpenTextFile(logfilepath, 8)<br />
Else<br />
Set objFile = objFSO.CreateTextFile(logfilepath)<br />
End If<br />
<br />
'******* CLEAR THE SCREEN, the poor mans way *********'<br />
counter = 15<br />
Do Until counter = 0<br />
Counter = counter - 1<br />
wscript.echo ""<br />
Loop<br />
<br />
wscript.Echo "****************************************************************************"<br />
wscript.Echo "** **"<br />
wscript.Echo "** ___________.__ **"<br />
wscript.Echo "** \__ ___/|__| _____ ____ **"<br />
wscript.Echo "** | | | |/ \_/ __ \ **" <br />
wscript.Echo "** | | | | Y Y \ ___/ **"<br />
wscript.Echo "** |____| |__|__|_| /\___ > **"<br />
wscript.Echo "** \/ \/ **"<br />
wscript.Echo "** ___________ __ **"<br />
wscript.Echo "** \__ ___/___________ ____ | | __ ___________ **"<br />
wscript.Echo "** | | \_ __ \__ \ _/ ___\| |/ // __ \_ __ \ **"<br />
wscript.Echo "** | | | | \// __ \\ \___| <\ ___/| | \/ **"<br />
wscript.Echo "** |____| |__| (____ /\___ >__|_ \\___ >__| **"<br />
wscript.Echo "** \/ \/ \/ \/ **"<br />
wscript.Echo "** **"<br />
wscript.Echo "****************************************************************************"<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "** TTTTTTTTT TTTTTTTTTT **"'<br />
'wscript.Echo "** TTTTTTTTT TTTTTTTTTT **"'<br />
'wscript.Echo "** III III **"'<br />
'wscript.Echo "** III I M E III R A C K E R **"'<br />
'wscript.Echo "** III ------- III ----------- **"'<br />
'wscript.Echo "** III III **"'<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "****************************************************************************"'<br />
'wscript.Echo "****************************************************************************"'<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "** MM MM MM MM **"'<br />
'wscript.Echo "** MMMM MMM MMM MMM **"'<br />
'wscript.Echo "** MM MM MMMM MM MM MMMM **"'<br />
'wscript.Echo "** MM MM MM I C R O MM MM MM A N A G E R **"'<br />
'wscript.Echo "** MM MM ------- MM MM ----------- **"'<br />
'wscript.Echo "** MM MM MM MM **"'<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "****************************************************************************"'<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.Echo " ", FormatDateTime(NOW, vbLongTime)<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.Echo "What are you doing right now?"<br />
Wscript.StdOut.Write ":: "<br />
strInput = Wscript.StdIn.ReadLine<br />
<br />
'* *********** ADD A SPACER BEFORE THE START OF THE HOUR ***********'<br />
Minutos = DatePart("n", Now)<br />
If Minutos < 5 Then<br />
objFile.writeline "------------------------"<br />
End If <br />
objFile.writeline FormatDateTime(Date(),1) & " - " & FormatDateTime(NOW, vbShortTime) & " -- " & strInput<br />
objFile.close<br />
<br />
<br />
<br />
==VBS CODE - TimeTracker.vbs v1.1==<br />
This second version has times in a more computer readable format. It is my hope that one day I can have this digest to some kind of database with a search engine in front of it; and maybe even some statistical analysis as well. That would be sweet!<br />
<br />
'FUNCTIONS<br />
<br />
function pd(n, totalDigits) <br />
if totalDigits > len(n) then <br />
pd = String(totalDigits-len(n),"0") & n <br />
else <br />
pd = n <br />
end if <br />
end Function <br />
<br />
<br />
'* ********** GETTING USERNAME FROM ADSI OBJECT ****** *'<br />
Set objNetwork = WScript.CreateObject("WScript.Network")<br />
strUserName = objNetwork.UserName<br />
<br />
'* ********* SET THE PATH TO THE DESKTOP in A variable ****** *'<br />
'*logfilepath = "C:\Documents and Settings\" & strUserName & "\TimeTracker.txt"*'<br />
logfilepath = "C:\Program Files (x86)\TimeTracker\TimeTracker.txt"<br />
<br />
<br />
'********** IF THE FILE EXISTS, APPEND TO IT, IF NOT, CREATE IT ********'<br />
Set objFSO = CreateObject("Scripting.FileSystemObject")<br />
If objFSO.FileExists(logfilepath) Then<br />
Set objFile = objFSO.OpenTextFile(logfilepath, 8)<br />
Else<br />
Set objFile = objFSO.CreateTextFile(logfilepath)<br />
End If <br />
<br />
<br />
<br />
'******* CLEAR THE SCREEN, the poor mans way *********'<br />
counter = 15<br />
Do Until counter = 0<br />
Counter = counter - 1<br />
wscript.echo ""<br />
Loop<br />
<br />
<br />
<br />
wscript.Echo "****************************************************************************"<br />
wscript.Echo "** **"<br />
wscript.Echo "** ___________.__ **"<br />
wscript.Echo "** \__ ___/|__| _____ ____ **"<br />
wscript.Echo "** | | | |/ \_/ __ \ **" <br />
wscript.Echo "** | | | | Y Y \ ___/ **"<br />
wscript.Echo "** |____| |__|__|_| /\___ > **"<br />
wscript.Echo "** \/ \/ **"<br />
wscript.Echo "** ___________ __ **" <br />
wscript.Echo "** \__ ___/___________ ____ | | __ ___________ **"<br />
wscript.Echo "** | | \_ __ \__ \ _/ ___\| |/ // __ \_ __ \ **"<br />
wscript.Echo "** | | | | \// __ \\ \___| <\ ___/| | \/ **"<br />
wscript.Echo "** |____| |__| (____ /\___ >__|_ \\___ >__| **"<br />
wscript.Echo "** \/ \/ \/ \/ **"<br />
wscript.Echo "** **"<br />
wscript.Echo "****************************************************************************"<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.Echo " ", FormatDateTime(NOW, vbLongTime)<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.Echo "What are you doing right now?" <br />
<br />
Wscript.StdOut.Write ":: "<br />
strInput = Wscript.StdIn.ReadLine <br />
<br />
<br />
curdate = YEAR(Date()) & Pd(Month(date()),2) & Pd(DAY(date()),2) <br />
curhour = Hour(Time) <br />
if (Len(curhour)=1) then H = "0" & curhour else H = "" & curhour<br />
curmin = Minute(Time) <br />
if (Len(curmin)=1) then M = "0" & curmin else M = "" & curmin<br />
cursec = Second(Time)<br />
if (Len(cursec)=1) then S = "0" & cursec else S = "" & cursec<br />
curtime = H & M & S<br />
<br />
<br />
objFile.writeline curdate & "." & curtime & "," & strInput<br />
<br />
objFile.close<br />
<br />
<br />
==BATCH FILE - TimeTracker.bat==<br />
cscript TimeTracker.vbs<br />
<br />
==LOG FILE - TimeTracker.txt==<br />
On the first run, the script creates the output file locally. Note that the time stamp represents an end time for the task, not a beginning time.<br />
<br />
Here is a snippet of what it looks like:<br />
Thursday, January 27, 2011 - 07:36 -- email and pit upgrade stuff<br />
Thursday, January 27, 2011 - 07:41 -- emai<br />
------------------------<br />
Thursday, January 27, 2011 - 08:06 -- email, then heading in to the office<br />
------------------------<br />
Thursday, January 27, 2011 - 10:00 -- boot up and checking email<br />
Thursday, January 27, 2011 - 10:31 -- rti meeting, then dev1g slowness meeting<br />
------------------------<br />
Thursday, January 27, 2011 - 11:03 -- dev1g meeting, then heating up some food, now email<br />
Thursday, January 27, 2011 - 11:21 -- pit mtv upgrade<br />
------------------------<br />
Thursday, January 27, 2011 - 12:03 -- SSR for tux recycle<br />
Thursday, January 27, 2011 - 12:40 -- talking to Mark about methods of improving ldap query performance<br />
------------------------<br />
Thursday, January 27, 2011 - 13:15 -- helping Tami with egate gui install and changing the doco to include additional details<br />
Thursday, January 27, 2011 - 15:20 -- all hands meeting<br />
<br />
<br />
For v1.1 it looks like this:<br />
20110622.124219,lunch - messing with vending machines, omsa crap again<br />
20110622.124504,omsa<br />
20110622.130032,installing java and reading mail<br />
20110622.131549,omsa<br />
20110622.133119,backup pc stuff with Chris.... la1.../backuppc then check for running backups<br />
20110622.134513,omsa yum and rpm<br />
20110622.140043,dmidecode,.. looking at how to extract VMWare moniker so that I can then picka good host to install OMSA on.<br />
20110622.141530,looking at backuppc<br />
20110622.143031,messing around with server inventory, tsm list<br />
20110622.145110,talking with Chris about mail and awstats stuff<br />
<br />
==SCHEDULE - Setting up the program in the windows scheduler - XP==<br />
'''Task Tab:'''<br />
<br />
Run: ''"C:\Program Files\TimeTracker\TimeTracker.bat"''<br />
<br />
Start in: ''"C:\Program Files\TimeTracker"''<br />
<br />
Run As: ''DELTADS\ca30044''<br />
<br />
Checked option: ''Run only if logged in''<br />
<br />
Checked option: ''Enabled''<br />
<br />
'''Schedule Tab:'''<br />
<br />
Scheduled Task: ''Weekly''<br />
<br />
Start time: ''7am''<br />
<br />
Schedule Taks weekly: checked are ''Mon, Tue, Wed, Thu, Fri''<br />
<br />
Advanced button:<br />
<br />
Checked option: ''Repeat Task''<br />
<br />
Every: ''20 minutes''<br />
<br />
Until: ''Duration 12 hours''<br />
<br />
'''Settings Tab:'''<br />
<br />
Checked option: ''Stop the task if it runs for 18 minutes''<br />
<br />
This means that it will close itself if you are either away from your desk or don't input anything<br />
<br />
<br />
<br />
==SCHEDULE - Setting up the program in the windows scheduler - Windows 7==<br />
<br />
Sorry, no time for detailed instructions. I used Irfanviewers screen capture tool to quickly rip some images, then used [http://www.gifninja.com GIFNinja] to wrap it up into one file.<br />
<br />
[[File:Scheduledtaskwin7.gif]]</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Time_trackerTime tracker2011-07-08T17:22:39Z<p>Jeff: </p>
<hr />
<div>'''Background:'''<br />
<br />
Several years ago, I was asked to track my time in 20 minute increments. I worked for a company that billed their time to the customer and although that ship has sailed, the script is still in place today and it's a huge help in tracking my time. It's not the most elaborate set up, but IMHO it serves the purpose quite well.<br />
<br />
This was formerly known as Micro Manager.<br />
<br />
'''Location:'''<br />
<br />
Technically you can store the source code (and resultant log file) anywhere you want, but I've found C:\program files\timetracker works best for me.<br />
<br />
<br />
'''How to Call it?'''<br />
<br />
You'll need to set up an advanced schedule within the windows scheduler to determine which days and times for it to run.<br />
<br />
Additionally, I have a shortcut in my quick launch tray so that I can call on it in an unscheduled fashion.<br />
<br />
<br />
<br />
The source code consists of two parts:<br />
<br />
1) the vbs file which drives all the action<br />
<br />
and<br />
<br />
2) the batch file which calls the vb file<br />
<br />
<br />
<br />
==VBS CODE TimeTracker.vbs==<br />
This is the first version and has times in a more human readable format.<br />
<br />
'* ********** GETTING USERNAME FROM ADSI OBJECT ****** *'<br />
Set objNetwork = WScript.CreateObject("WScript.Network")<br />
strUserName = objNetwork.UserName<br />
<br />
'* ********* SET THE PATH TO THE DESKTOP in A variable ****** *'<br />
'*logfilepath = "C:\Documents and Settings\" & strUserName & "\TimeTracker.txt"*'<br />
logfilepath = "C:\Program Files\TimeTracker\TimeTracker.txt"<br />
<br />
'********** IF THE FILE EXISTS, APPEND TO IT, IF NOT, CREATE IT ********'<br />
Set objFSO = CreateObject("Scripting.FileSystemObject")<br />
If objFSO.FileExists(logfilepath) Then<br />
Set objFile = objFSO.OpenTextFile(logfilepath, 8)<br />
Else<br />
Set objFile = objFSO.CreateTextFile(logfilepath)<br />
End If<br />
<br />
'******* CLEAR THE SCREEN, the poor mans way *********'<br />
counter = 15<br />
Do Until counter = 0<br />
Counter = counter - 1<br />
wscript.echo ""<br />
Loop<br />
<br />
wscript.Echo "****************************************************************************"<br />
wscript.Echo "** **"<br />
wscript.Echo "** ___________.__ **"<br />
wscript.Echo "** \__ ___/|__| _____ ____ **"<br />
wscript.Echo "** | | | |/ \_/ __ \ **" <br />
wscript.Echo "** | | | | Y Y \ ___/ **"<br />
wscript.Echo "** |____| |__|__|_| /\___ > **"<br />
wscript.Echo "** \/ \/ **"<br />
wscript.Echo "** ___________ __ **"<br />
wscript.Echo "** \__ ___/___________ ____ | | __ ___________ **"<br />
wscript.Echo "** | | \_ __ \__ \ _/ ___\| |/ // __ \_ __ \ **"<br />
wscript.Echo "** | | | | \// __ \\ \___| <\ ___/| | \/ **"<br />
wscript.Echo "** |____| |__| (____ /\___ >__|_ \\___ >__| **"<br />
wscript.Echo "** \/ \/ \/ \/ **"<br />
wscript.Echo "** **"<br />
wscript.Echo "****************************************************************************"<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "** TTTTTTTTT TTTTTTTTTT **"'<br />
'wscript.Echo "** TTTTTTTTT TTTTTTTTTT **"'<br />
'wscript.Echo "** III III **"'<br />
'wscript.Echo "** III I M E III R A C K E R **"'<br />
'wscript.Echo "** III ------- III ----------- **"'<br />
'wscript.Echo "** III III **"'<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "****************************************************************************"'<br />
'wscript.Echo "****************************************************************************"'<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "** MM MM MM MM **"'<br />
'wscript.Echo "** MMMM MMM MMM MMM **"'<br />
'wscript.Echo "** MM MM MMMM MM MM MMMM **"'<br />
'wscript.Echo "** MM MM MM I C R O MM MM MM A N A G E R **"'<br />
'wscript.Echo "** MM MM ------- MM MM ----------- **"'<br />
'wscript.Echo "** MM MM MM MM **"'<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "****************************************************************************"'<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.Echo " ", FormatDateTime(NOW, vbLongTime)<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.Echo "What are you doing right now?"<br />
Wscript.StdOut.Write ":: "<br />
strInput = Wscript.StdIn.ReadLine<br />
<br />
'* *********** ADD A SPACER BEFORE THE START OF THE HOUR ***********'<br />
Minutos = DatePart("n", Now)<br />
If Minutos < 5 Then<br />
objFile.writeline "------------------------"<br />
End If <br />
objFile.writeline FormatDateTime(Date(),1) & " - " & FormatDateTime(NOW, vbShortTime) & " -- " & strInput<br />
objFile.close<br />
<br />
<br />
<br />
==VBS CODE TimeTracker.vbs v1.1==<br />
This second version has times in a more computer readable format. It is my hope that one day I can have this digest to some kind of database with a search engine in front of it; and maybe even some statistical analysis as well. That would be sweet!<br />
<br />
'FUNCTIONS<br />
<br />
function pd(n, totalDigits) <br />
if totalDigits > len(n) then <br />
pd = String(totalDigits-len(n),"0") & n <br />
else <br />
pd = n <br />
end if <br />
end Function <br />
<br />
<br />
'* ********** GETTING USERNAME FROM ADSI OBJECT ****** *'<br />
Set objNetwork = WScript.CreateObject("WScript.Network")<br />
strUserName = objNetwork.UserName<br />
<br />
'* ********* SET THE PATH TO THE DESKTOP in A variable ****** *'<br />
'*logfilepath = "C:\Documents and Settings\" & strUserName & "\TimeTracker.txt"*'<br />
logfilepath = "C:\Program Files (x86)\TimeTracker\TimeTracker.txt"<br />
<br />
<br />
'********** IF THE FILE EXISTS, APPEND TO IT, IF NOT, CREATE IT ********'<br />
Set objFSO = CreateObject("Scripting.FileSystemObject")<br />
If objFSO.FileExists(logfilepath) Then<br />
Set objFile = objFSO.OpenTextFile(logfilepath, 8)<br />
Else<br />
Set objFile = objFSO.CreateTextFile(logfilepath)<br />
End If <br />
<br />
<br />
<br />
'******* CLEAR THE SCREEN, the poor mans way *********'<br />
counter = 15<br />
Do Until counter = 0<br />
Counter = counter - 1<br />
wscript.echo ""<br />
Loop<br />
<br />
<br />
<br />
wscript.Echo "****************************************************************************"<br />
wscript.Echo "** **"<br />
wscript.Echo "** ___________.__ **"<br />
wscript.Echo "** \__ ___/|__| _____ ____ **"<br />
wscript.Echo "** | | | |/ \_/ __ \ **" <br />
wscript.Echo "** | | | | Y Y \ ___/ **"<br />
wscript.Echo "** |____| |__|__|_| /\___ > **"<br />
wscript.Echo "** \/ \/ **"<br />
wscript.Echo "** ___________ __ **" <br />
wscript.Echo "** \__ ___/___________ ____ | | __ ___________ **"<br />
wscript.Echo "** | | \_ __ \__ \ _/ ___\| |/ // __ \_ __ \ **"<br />
wscript.Echo "** | | | | \// __ \\ \___| <\ ___/| | \/ **"<br />
wscript.Echo "** |____| |__| (____ /\___ >__|_ \\___ >__| **"<br />
wscript.Echo "** \/ \/ \/ \/ **"<br />
wscript.Echo "** **"<br />
wscript.Echo "****************************************************************************"<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.Echo " ", FormatDateTime(NOW, vbLongTime)<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.Echo "What are you doing right now?" <br />
<br />
Wscript.StdOut.Write ":: "<br />
strInput = Wscript.StdIn.ReadLine <br />
<br />
<br />
curdate = YEAR(Date()) & Pd(Month(date()),2) & Pd(DAY(date()),2) <br />
curhour = Hour(Time) <br />
if (Len(curhour)=1) then H = "0" & curhour else H = "" & curhour<br />
curmin = Minute(Time) <br />
if (Len(curmin)=1) then M = "0" & curmin else M = "" & curmin<br />
cursec = Second(Time)<br />
if (Len(cursec)=1) then S = "0" & cursec else S = "" & cursec<br />
curtime = H & M & S<br />
<br />
<br />
objFile.writeline curdate & "." & curtime & "," & strInput<br />
<br />
objFile.close<br />
<br />
<br />
==BATCH FILE TimeTracker.bat==<br />
cscript TimeTracker.vbs<br />
<br />
==LOG FILE TimeTracker.txt==<br />
On the first run, the script creates the output file locally. Note that the time stamp represents an end time for the task, not a beginning time.<br />
<br />
Here is a snippet of what it looks like:<br />
Thursday, January 27, 2011 - 07:36 -- email and pit upgrade stuff<br />
Thursday, January 27, 2011 - 07:41 -- emai<br />
------------------------<br />
Thursday, January 27, 2011 - 08:06 -- email, then heading in to the office<br />
------------------------<br />
Thursday, January 27, 2011 - 10:00 -- boot up and checking email<br />
Thursday, January 27, 2011 - 10:31 -- rti meeting, then dev1g slowness meeting<br />
------------------------<br />
Thursday, January 27, 2011 - 11:03 -- dev1g meeting, then heating up some food, now email<br />
Thursday, January 27, 2011 - 11:21 -- pit mtv upgrade<br />
------------------------<br />
Thursday, January 27, 2011 - 12:03 -- SSR for tux recycle<br />
Thursday, January 27, 2011 - 12:40 -- talking to Mark about methods of improving ldap query performance<br />
------------------------<br />
Thursday, January 27, 2011 - 13:15 -- helping Tami with egate gui install and changing the doco to include additional details<br />
Thursday, January 27, 2011 - 15:20 -- all hands meeting<br />
<br />
<br />
For v1.1 it looks like this:<br />
20110622.124219,lunch - messing with vending machines, omsa crap again<br />
20110622.124504,omsa<br />
20110622.130032,installing java and reading mail<br />
20110622.131549,omsa<br />
20110622.133119,backup pc stuff with Chris.... la1.../backuppc then check for running backups<br />
20110622.134513,omsa yum and rpm<br />
20110622.140043,dmidecode,.. looking at how to extract VMWare moniker so that I can then picka good host to install OMSA on.<br />
20110622.141530,looking at backuppc<br />
20110622.143031,messing around with server inventory, tsm list<br />
20110622.145110,talking with Chris about mail and awstats stuff<br />
<br />
==SCHEDULE Setting up the program in the windows scheduler - XP==<br />
'''Task Tab:'''<br />
<br />
Run: ''"C:\Program Files\TimeTracker\TimeTracker.bat"''<br />
<br />
Start in: ''"C:\Program Files\TimeTracker"''<br />
<br />
Run As: ''DELTADS\ca30044''<br />
<br />
Checked option: ''Run only if logged in''<br />
<br />
Checked option: ''Enabled''<br />
<br />
'''Schedule Tab:'''<br />
<br />
Scheduled Task: ''Weekly''<br />
<br />
Start time: ''7am''<br />
<br />
Schedule Taks weekly: checked are ''Mon, Tue, Wed, Thu, Fri''<br />
<br />
Advanced button:<br />
<br />
Checked option: ''Repeat Task''<br />
<br />
Every: ''20 minutes''<br />
<br />
Until: ''Duration 12 hours''<br />
<br />
'''Settings Tab:'''<br />
<br />
Checked option: ''Stop the task if it runs for 18 minutes''<br />
<br />
This means that it will close itself if you are either away from your desk or don't input anything<br />
<br />
<br />
<br />
==SCHEDULE Setting up the program in the windows scheduler - Windows 7==<br />
<br />
Sorry, no time for detailed instructions. I used Irfanviewers screen capture tool to quickly rip some images, then used [http://www.gifninja.com GIFNinja] to wrap it up into one file.<br />
<br />
[[File:Scheduledtaskwin7.gif]]</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Time_trackerTime tracker2011-07-08T17:20:09Z<p>Jeff: </p>
<hr />
<div>'''Background:'''<br />
<br />
Several years ago, I was asked to track my time in 20 minute increments. I worked for a company that billed their time to the customer and although that ship has sailed, the script is still in place today and it's a huge help in tracking my time. It's not the most elaborate set up, but IMHO it serves the purpose quite well.<br />
<br />
This was formerly known as Micro Manager.<br />
<br />
'''Location:'''<br />
<br />
Technically you can store the source code (and resultant log file) anywhere you want, but I've found C:\program files\timetracker works best for me.<br />
<br />
<br />
'''How to Call it?'''<br />
<br />
You'll need to set up an advanced schedule within the windows scheduler to determine which days and times for it to run.<br />
<br />
Additionally, I have a shortcut in my quick launch tray so that I can call on it in an unscheduled fashion.<br />
<br />
<br />
<br />
The source code consists of two parts:<br />
<br />
1) the vbs file which drives all the action<br />
<br />
and<br />
<br />
2) the batch file which calls the vb file<br />
<br />
<br />
<br />
==TimeTracker.vbs==<br />
This is the first version and has times in a more human readable format.<br />
<br />
'* ********** GETTING USERNAME FROM ADSI OBJECT ****** *'<br />
Set objNetwork = WScript.CreateObject("WScript.Network")<br />
strUserName = objNetwork.UserName<br />
<br />
'* ********* SET THE PATH TO THE DESKTOP in A variable ****** *'<br />
'*logfilepath = "C:\Documents and Settings\" & strUserName & "\TimeTracker.txt"*'<br />
logfilepath = "C:\Program Files\TimeTracker\TimeTracker.txt"<br />
<br />
'********** IF THE FILE EXISTS, APPEND TO IT, IF NOT, CREATE IT ********'<br />
Set objFSO = CreateObject("Scripting.FileSystemObject")<br />
If objFSO.FileExists(logfilepath) Then<br />
Set objFile = objFSO.OpenTextFile(logfilepath, 8)<br />
Else<br />
Set objFile = objFSO.CreateTextFile(logfilepath)<br />
End If<br />
<br />
'******* CLEAR THE SCREEN, the poor mans way *********'<br />
counter = 15<br />
Do Until counter = 0<br />
Counter = counter - 1<br />
wscript.echo ""<br />
Loop<br />
<br />
wscript.Echo "****************************************************************************"<br />
wscript.Echo "** **"<br />
wscript.Echo "** ___________.__ **"<br />
wscript.Echo "** \__ ___/|__| _____ ____ **"<br />
wscript.Echo "** | | | |/ \_/ __ \ **" <br />
wscript.Echo "** | | | | Y Y \ ___/ **"<br />
wscript.Echo "** |____| |__|__|_| /\___ > **"<br />
wscript.Echo "** \/ \/ **"<br />
wscript.Echo "** ___________ __ **"<br />
wscript.Echo "** \__ ___/___________ ____ | | __ ___________ **"<br />
wscript.Echo "** | | \_ __ \__ \ _/ ___\| |/ // __ \_ __ \ **"<br />
wscript.Echo "** | | | | \// __ \\ \___| <\ ___/| | \/ **"<br />
wscript.Echo "** |____| |__| (____ /\___ >__|_ \\___ >__| **"<br />
wscript.Echo "** \/ \/ \/ \/ **"<br />
wscript.Echo "** **"<br />
wscript.Echo "****************************************************************************"<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "** TTTTTTTTT TTTTTTTTTT **"'<br />
'wscript.Echo "** TTTTTTTTT TTTTTTTTTT **"'<br />
'wscript.Echo "** III III **"'<br />
'wscript.Echo "** III I M E III R A C K E R **"'<br />
'wscript.Echo "** III ------- III ----------- **"'<br />
'wscript.Echo "** III III **"'<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "****************************************************************************"'<br />
'wscript.Echo "****************************************************************************"'<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "** MM MM MM MM **"'<br />
'wscript.Echo "** MMMM MMM MMM MMM **"'<br />
'wscript.Echo "** MM MM MMMM MM MM MMMM **"'<br />
'wscript.Echo "** MM MM MM I C R O MM MM MM A N A G E R **"'<br />
'wscript.Echo "** MM MM ------- MM MM ----------- **"'<br />
'wscript.Echo "** MM MM MM MM **"'<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "****************************************************************************"'<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.Echo " ", FormatDateTime(NOW, vbLongTime)<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.Echo "What are you doing right now?"<br />
Wscript.StdOut.Write ":: "<br />
strInput = Wscript.StdIn.ReadLine<br />
<br />
'* *********** ADD A SPACER BEFORE THE START OF THE HOUR ***********'<br />
Minutos = DatePart("n", Now)<br />
If Minutos < 5 Then<br />
objFile.writeline "------------------------"<br />
End If <br />
objFile.writeline FormatDateTime(Date(),1) & " - " & FormatDateTime(NOW, vbShortTime) & " -- " & strInput<br />
objFile.close<br />
<br />
<br />
<br />
==TimeTracker.vbs v1.1==<br />
This second version has times in a more computer readable format. It is my hope that one day I can have this digest to some kind of database with a search engine in front of it; and maybe even some statistical analysis as well. That would be sweet!<br />
<br />
'FUNCTIONS<br />
<br />
function pd(n, totalDigits) <br />
if totalDigits > len(n) then <br />
pd = String(totalDigits-len(n),"0") & n <br />
else <br />
pd = n <br />
end if <br />
end Function <br />
<br />
<br />
'* ********** GETTING USERNAME FROM ADSI OBJECT ****** *'<br />
Set objNetwork = WScript.CreateObject("WScript.Network")<br />
strUserName = objNetwork.UserName<br />
<br />
'* ********* SET THE PATH TO THE DESKTOP in A variable ****** *'<br />
'*logfilepath = "C:\Documents and Settings\" & strUserName & "\TimeTracker.txt"*'<br />
logfilepath = "C:\Program Files (x86)\TimeTracker\TimeTracker.txt"<br />
<br />
<br />
'********** IF THE FILE EXISTS, APPEND TO IT, IF NOT, CREATE IT ********'<br />
Set objFSO = CreateObject("Scripting.FileSystemObject")<br />
If objFSO.FileExists(logfilepath) Then<br />
Set objFile = objFSO.OpenTextFile(logfilepath, 8)<br />
Else<br />
Set objFile = objFSO.CreateTextFile(logfilepath)<br />
End If <br />
<br />
<br />
<br />
'******* CLEAR THE SCREEN, the poor mans way *********'<br />
counter = 15<br />
Do Until counter = 0<br />
Counter = counter - 1<br />
wscript.echo ""<br />
Loop<br />
<br />
<br />
<br />
wscript.Echo "****************************************************************************"<br />
wscript.Echo "** **"<br />
wscript.Echo "** ___________.__ **"<br />
wscript.Echo "** \__ ___/|__| _____ ____ **"<br />
wscript.Echo "** | | | |/ \_/ __ \ **" <br />
wscript.Echo "** | | | | Y Y \ ___/ **"<br />
wscript.Echo "** |____| |__|__|_| /\___ > **"<br />
wscript.Echo "** \/ \/ **"<br />
wscript.Echo "** ___________ __ **" <br />
wscript.Echo "** \__ ___/___________ ____ | | __ ___________ **"<br />
wscript.Echo "** | | \_ __ \__ \ _/ ___\| |/ // __ \_ __ \ **"<br />
wscript.Echo "** | | | | \// __ \\ \___| <\ ___/| | \/ **"<br />
wscript.Echo "** |____| |__| (____ /\___ >__|_ \\___ >__| **"<br />
wscript.Echo "** \/ \/ \/ \/ **"<br />
wscript.Echo "** **"<br />
wscript.Echo "****************************************************************************"<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.Echo " ", FormatDateTime(NOW, vbLongTime)<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.Echo "What are you doing right now?" <br />
<br />
Wscript.StdOut.Write ":: "<br />
strInput = Wscript.StdIn.ReadLine <br />
<br />
<br />
curdate = YEAR(Date()) & Pd(Month(date()),2) & Pd(DAY(date()),2) <br />
curhour = Hour(Time) <br />
if (Len(curhour)=1) then H = "0" & curhour else H = "" & curhour<br />
curmin = Minute(Time) <br />
if (Len(curmin)=1) then M = "0" & curmin else M = "" & curmin<br />
cursec = Second(Time)<br />
if (Len(cursec)=1) then S = "0" & cursec else S = "" & cursec<br />
curtime = H & M & S<br />
<br />
<br />
objFile.writeline curdate & "." & curtime & "," & strInput<br />
<br />
objFile.close<br />
<br />
<br />
==TimeTracker.bat==<br />
cscript TimeTracker.vbs<br />
<br />
==TimeTracker.txt==<br />
On the first run, the script creates the output file locally. Note that the time stamp represents an end time for the task, not a beginning time.<br />
<br />
Here is a snippet of what it looks like:<br />
Thursday, January 27, 2011 - 07:36 -- email and pit upgrade stuff<br />
Thursday, January 27, 2011 - 07:41 -- emai<br />
------------------------<br />
Thursday, January 27, 2011 - 08:06 -- email, then heading in to the office<br />
------------------------<br />
Thursday, January 27, 2011 - 10:00 -- boot up and checking email<br />
Thursday, January 27, 2011 - 10:31 -- rti meeting, then dev1g slowness meeting<br />
------------------------<br />
Thursday, January 27, 2011 - 11:03 -- dev1g meeting, then heating up some food, now email<br />
Thursday, January 27, 2011 - 11:21 -- pit mtv upgrade<br />
------------------------<br />
Thursday, January 27, 2011 - 12:03 -- SSR for tux recycle<br />
Thursday, January 27, 2011 - 12:40 -- talking to Mark about methods of improving ldap query performance<br />
------------------------<br />
Thursday, January 27, 2011 - 13:15 -- helping Tami with egate gui install and changing the doco to include additional details<br />
Thursday, January 27, 2011 - 15:20 -- all hands meeting<br />
<br />
<br />
For v1.1 it looks like this:<br />
20110622.124219,lunch - messing with vending machines, omsa crap again<br />
20110622.124504,omsa<br />
20110622.130032,installing java and reading mail<br />
20110622.131549,omsa<br />
20110622.133119,backup pc stuff with Chris.... la1.../backuppc then check for running backups<br />
20110622.134513,omsa yum and rpm<br />
20110622.140043,dmidecode,.. looking at how to extract VMWare moniker so that I can then picka good host to install OMSA on.<br />
20110622.141530,looking at backuppc<br />
20110622.143031,messing around with server inventory, tsm list<br />
20110622.145110,talking with Chris about mail and awstats stuff<br />
<br />
==Setting up the program in the windows scheduler - XP==<br />
'''Task Tab:'''<br />
<br />
Run: ''"C:\Program Files\TimeTracker\TimeTracker.bat"''<br />
<br />
Start in: ''"C:\Program Files\TimeTracker"''<br />
<br />
Run As: ''DELTADS\ca30044''<br />
<br />
Checked option: ''Run only if logged in''<br />
<br />
Checked option: ''Enabled''<br />
<br />
'''Schedule Tab:'''<br />
<br />
Scheduled Task: ''Weekly''<br />
<br />
Start time: ''7am''<br />
<br />
Schedule Taks weekly: checked are ''Mon, Tue, Wed, Thu, Fri''<br />
<br />
Advanced button:<br />
<br />
Checked option: ''Repeat Task''<br />
<br />
Every: ''20 minutes''<br />
<br />
Until: ''Duration 12 hours''<br />
<br />
'''Settings Tab:'''<br />
<br />
Checked option: ''Stop the task if it runs for 18 minutes''<br />
<br />
This means that it will close itself if you are either away from your desk or don't input anything<br />
<br />
<br />
<br />
==Setting up the program in the windows scheduler - Windows 7==<br />
<br />
Sorry, no time for detailed instructions. I used Irfanviewers screen capture tool to quickly rip some images, then used [http://www.gifninja.com GIFNinja] to wrap it up into one file.<br />
<br />
[[File:Scheduledtaskwin7.gif]]</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Time_trackerTime tracker2011-07-08T17:17:32Z<p>Jeff: </p>
<hr />
<div>'''Background:'''<br />
<br />
Several years ago, I was asked to track my time in 20 minute increments. I worked for a company that billed their time to the customer and although that ship has sailed, the script is still in place today and it's a huge help in tracking my time. It's not the most elaborate set up, but IMHO it serves the purpose quite well.<br />
<br />
This was formerly known as Micro Manager.<br />
<br />
'''Location:'''<br />
<br />
Technically you can store the source code (and resultant log file) anywhere you want, but I've found C:\program files\timetracker works best for me.<br />
<br />
<br />
'''How to Call it?'''<br />
<br />
You'll need to set up an advanced schedule within the windows scheduler to determine which days and times for it to run.<br />
<br />
Additionally, I have a shortcut in my quick launch tray so that I can call on it in an unscheduled fashion.<br />
<br />
<br />
<br />
The source code consists of two parts:<br />
<br />
1) the vbs file which drives all the action<br />
<br />
and<br />
<br />
2) the batch file which calls the vb file<br />
<br />
<br />
<br />
==TimeTracker.vbs==<br />
This is the first version and has times in a more human readable format.<br />
<br />
'* ********** GETTING USERNAME FROM ADSI OBJECT ****** *'<br />
Set objNetwork = WScript.CreateObject("WScript.Network")<br />
strUserName = objNetwork.UserName<br />
<br />
'* ********* SET THE PATH TO THE DESKTOP in A variable ****** *'<br />
'*logfilepath = "C:\Documents and Settings\" & strUserName & "\TimeTracker.txt"*'<br />
logfilepath = "C:\Program Files\TimeTracker\TimeTracker.txt"<br />
<br />
'********** IF THE FILE EXISTS, APPEND TO IT, IF NOT, CREATE IT ********'<br />
Set objFSO = CreateObject("Scripting.FileSystemObject")<br />
If objFSO.FileExists(logfilepath) Then<br />
Set objFile = objFSO.OpenTextFile(logfilepath, 8)<br />
Else<br />
Set objFile = objFSO.CreateTextFile(logfilepath)<br />
End If<br />
<br />
'******* CLEAR THE SCREEN, the poor mans way *********'<br />
counter = 15<br />
Do Until counter = 0<br />
Counter = counter - 1<br />
wscript.echo ""<br />
Loop<br />
<br />
wscript.Echo "****************************************************************************"<br />
wscript.Echo "** **"<br />
wscript.Echo "** ___________.__ **"<br />
wscript.Echo "** \__ ___/|__| _____ ____ **"<br />
wscript.Echo "** | | | |/ \_/ __ \ **" <br />
wscript.Echo "** | | | | Y Y \ ___/ **"<br />
wscript.Echo "** |____| |__|__|_| /\___ > **"<br />
wscript.Echo "** \/ \/ **"<br />
wscript.Echo "** ___________ __ **"<br />
wscript.Echo "** \__ ___/___________ ____ | | __ ___________ **"<br />
wscript.Echo "** | | \_ __ \__ \ _/ ___\| |/ // __ \_ __ \ **"<br />
wscript.Echo "** | | | | \// __ \\ \___| <\ ___/| | \/ **"<br />
wscript.Echo "** |____| |__| (____ /\___ >__|_ \\___ >__| **"<br />
wscript.Echo "** \/ \/ \/ \/ **"<br />
wscript.Echo "** **"<br />
wscript.Echo "****************************************************************************"<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "** TTTTTTTTT TTTTTTTTTT **"'<br />
'wscript.Echo "** TTTTTTTTT TTTTTTTTTT **"'<br />
'wscript.Echo "** III III **"'<br />
'wscript.Echo "** III I M E III R A C K E R **"'<br />
'wscript.Echo "** III ------- III ----------- **"'<br />
'wscript.Echo "** III III **"'<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "****************************************************************************"'<br />
'wscript.Echo "****************************************************************************"'<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "** MM MM MM MM **"'<br />
'wscript.Echo "** MMMM MMM MMM MMM **"'<br />
'wscript.Echo "** MM MM MMMM MM MM MMMM **"'<br />
'wscript.Echo "** MM MM MM I C R O MM MM MM A N A G E R **"'<br />
'wscript.Echo "** MM MM ------- MM MM ----------- **"'<br />
'wscript.Echo "** MM MM MM MM **"'<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "****************************************************************************"'<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.Echo " ", FormatDateTime(NOW, vbLongTime)<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.Echo "What are you doing right now?"<br />
Wscript.StdOut.Write ":: "<br />
strInput = Wscript.StdIn.ReadLine<br />
<br />
'* *********** ADD A SPACER BEFORE THE START OF THE HOUR ***********'<br />
Minutos = DatePart("n", Now)<br />
If Minutos < 5 Then<br />
objFile.writeline "------------------------"<br />
End If <br />
objFile.writeline FormatDateTime(Date(),1) & " - " & FormatDateTime(NOW, vbShortTime) & " -- " & strInput<br />
objFile.close<br />
<br />
<br />
<br />
==TimeTracker.vbs v1.1==<br />
This second version has times in a more computer readable format. It is my hope that one day I can have this digest to some kind of database with a search engine in front of it; and maybe even some statistical analysis as well. That would be sweet!<br />
<br />
'FUNCTIONS<br />
<br />
function pd(n, totalDigits) <br />
if totalDigits > len(n) then <br />
pd = String(totalDigits-len(n),"0") & n <br />
else <br />
pd = n <br />
end if <br />
end Function <br />
<br />
<br />
'* ********** GETTING USERNAME FROM ADSI OBJECT ****** *'<br />
Set objNetwork = WScript.CreateObject("WScript.Network")<br />
strUserName = objNetwork.UserName<br />
<br />
'* ********* SET THE PATH TO THE DESKTOP in A variable ****** *'<br />
'*logfilepath = "C:\Documents and Settings\" & strUserName & "\TimeTracker.txt"*'<br />
logfilepath = "C:\Program Files (x86)\TimeTracker\TimeTracker.txt"<br />
<br />
<br />
'********** IF THE FILE EXISTS, APPEND TO IT, IF NOT, CREATE IT ********'<br />
Set objFSO = CreateObject("Scripting.FileSystemObject")<br />
If objFSO.FileExists(logfilepath) Then<br />
Set objFile = objFSO.OpenTextFile(logfilepath, 8)<br />
Else<br />
Set objFile = objFSO.CreateTextFile(logfilepath)<br />
End If <br />
<br />
<br />
<br />
'******* CLEAR THE SCREEN, the poor mans way *********'<br />
counter = 15<br />
Do Until counter = 0<br />
Counter = counter - 1<br />
wscript.echo ""<br />
Loop<br />
<br />
<br />
<br />
wscript.Echo "****************************************************************************"<br />
wscript.Echo "** **"<br />
wscript.Echo "** ___________.__ **"<br />
wscript.Echo "** \__ ___/|__| _____ ____ **"<br />
wscript.Echo "** | | | |/ \_/ __ \ **" <br />
wscript.Echo "** | | | | Y Y \ ___/ **"<br />
wscript.Echo "** |____| |__|__|_| /\___ > **"<br />
wscript.Echo "** \/ \/ **"<br />
wscript.Echo "** ___________ __ **" <br />
wscript.Echo "** \__ ___/___________ ____ | | __ ___________ **"<br />
wscript.Echo "** | | \_ __ \__ \ _/ ___\| |/ // __ \_ __ \ **"<br />
wscript.Echo "** | | | | \// __ \\ \___| <\ ___/| | \/ **"<br />
wscript.Echo "** |____| |__| (____ /\___ >__|_ \\___ >__| **"<br />
wscript.Echo "** \/ \/ \/ \/ **"<br />
wscript.Echo "** **"<br />
wscript.Echo "****************************************************************************"<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.Echo " ", FormatDateTime(NOW, vbLongTime)<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.Echo "What are you doing right now?" <br />
<br />
Wscript.StdOut.Write ":: "<br />
strInput = Wscript.StdIn.ReadLine <br />
<br />
<br />
curdate = YEAR(Date()) & Pd(Month(date()),2) & Pd(DAY(date()),2) <br />
curhour = Hour(Time) <br />
if (Len(curhour)=1) then H = "0" & curhour else H = "" & curhour<br />
curmin = Minute(Time) <br />
if (Len(curmin)=1) then M = "0" & curmin else M = "" & curmin<br />
cursec = Second(Time)<br />
if (Len(cursec)=1) then S = "0" & cursec else S = "" & cursec<br />
curtime = H & M & S<br />
<br />
<br />
objFile.writeline curdate & "." & curtime & "," & strInput<br />
<br />
objFile.close<br />
<br />
<br />
==TimeTracker.bat==<br />
cscript TimeTracker.vbs<br />
<br />
==TimeTracker.txt==<br />
On the first run, the script creates the output file locally. Note that the time stamp represents an end time for the task, not a beginning time.<br />
<br />
Here is a snippet of what it looks like:<br />
Thursday, January 27, 2011 - 07:36 -- email and pit upgrade stuff<br />
Thursday, January 27, 2011 - 07:41 -- emai<br />
------------------------<br />
Thursday, January 27, 2011 - 08:06 -- email, then heading in to the office<br />
------------------------<br />
Thursday, January 27, 2011 - 10:00 -- boot up and checking email<br />
Thursday, January 27, 2011 - 10:31 -- rti meeting, then dev1g slowness meeting<br />
------------------------<br />
Thursday, January 27, 2011 - 11:03 -- dev1g meeting, then heating up some food, now email<br />
Thursday, January 27, 2011 - 11:21 -- pit mtv upgrade<br />
------------------------<br />
Thursday, January 27, 2011 - 12:03 -- SSR for tux recycle<br />
Thursday, January 27, 2011 - 12:40 -- talking to Mark about methods of improving ldap query performance<br />
------------------------<br />
Thursday, January 27, 2011 - 13:15 -- helping Tami with egate gui install and changing the doco to include additional details<br />
Thursday, January 27, 2011 - 15:20 -- all hands meeting<br />
<br />
==Setting up the program in the windows scheduler - XP==<br />
'''Task Tab:'''<br />
<br />
Run: ''"C:\Program Files\TimeTracker\TimeTracker.bat"''<br />
<br />
Start in: ''"C:\Program Files\TimeTracker"''<br />
<br />
Run As: ''DELTADS\ca30044''<br />
<br />
Checked option: ''Run only if logged in''<br />
<br />
Checked option: ''Enabled''<br />
<br />
'''Schedule Tab:'''<br />
<br />
Scheduled Task: ''Weekly''<br />
<br />
Start time: ''7am''<br />
<br />
Schedule Taks weekly: checked are ''Mon, Tue, Wed, Thu, Fri''<br />
<br />
Advanced button:<br />
<br />
Checked option: ''Repeat Task''<br />
<br />
Every: ''20 minutes''<br />
<br />
Until: ''Duration 12 hours''<br />
<br />
'''Settings Tab:'''<br />
<br />
Checked option: ''Stop the task if it runs for 18 minutes''<br />
<br />
This means that it will close itself if you are either away from your desk or don't input anything<br />
<br />
<br />
<br />
==Setting up the program in the windows scheduler - Windows 7==<br />
<br />
Sorry, no time for detailed instructions. I used Irfanviewers screen capture tool to quickly rip some images, then used [http://www.gifninja.com GIFNinja] to wrap it up into one file.<br />
<br />
[[File:Scheduledtaskwin7.gif]]</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Time_trackerTime tracker2011-07-08T17:03:09Z<p>Jeff: </p>
<hr />
<div>'''Background:'''<br />
<br />
Several years ago, I was asked to track my time in 20 minute increments. I worked for a company that billed their time to the customer and although that ship has sailed, the script is still in place today and it's a huge help in tracking my time. It's not the most elaborate set up, but IMHO it serves the purpose quite well.<br />
<br />
This was formerly known as Micro Manager.<br />
<br />
'''Location:'''<br />
<br />
Technically you can store the source code (and resultant log file) anywhere you want, but I've found C:\program files\timetracker works best for me.<br />
<br />
<br />
'''How to Call it?'''<br />
<br />
You'll need to set up an advanced schedule within the windows scheduler to determine which days and times for it to run.<br />
<br />
Additionally, I have a shortcut in my quick launch tray so that I can call on it in an unscheduled fashion.<br />
<br />
<br />
<br />
The source code consists of two parts:<br />
<br />
1) the vbs file which drives all the action<br />
<br />
and<br />
<br />
2) the batch file which calls the vb file<br />
<br />
<br />
<br />
==TimeTracker.vbs==<br />
'* ********** GETTING USERNAME FROM ADSI OBJECT ****** *'<br />
Set objNetwork = WScript.CreateObject("WScript.Network")<br />
strUserName = objNetwork.UserName<br />
<br />
'* ********* SET THE PATH TO THE DESKTOP in A variable ****** *'<br />
'*logfilepath = "C:\Documents and Settings\" & strUserName & "\TimeTracker.txt"*'<br />
logfilepath = "C:\Program Files\TimeTracker\TimeTracker.txt"<br />
<br />
'********** IF THE FILE EXISTS, APPEND TO IT, IF NOT, CREATE IT ********'<br />
Set objFSO = CreateObject("Scripting.FileSystemObject")<br />
If objFSO.FileExists(logfilepath) Then<br />
Set objFile = objFSO.OpenTextFile(logfilepath, 8)<br />
Else<br />
Set objFile = objFSO.CreateTextFile(logfilepath)<br />
End If<br />
<br />
'******* CLEAR THE SCREEN, the poor mans way *********'<br />
counter = 15<br />
Do Until counter = 0<br />
Counter = counter - 1<br />
wscript.echo ""<br />
Loop<br />
<br />
wscript.Echo "****************************************************************************"<br />
wscript.Echo "** **"<br />
wscript.Echo "** ___________.__ **"<br />
wscript.Echo "** \__ ___/|__| _____ ____ **"<br />
wscript.Echo "** | | | |/ \_/ __ \ **" <br />
wscript.Echo "** | | | | Y Y \ ___/ **"<br />
wscript.Echo "** |____| |__|__|_| /\___ > **"<br />
wscript.Echo "** \/ \/ **"<br />
wscript.Echo "** ___________ __ **"<br />
wscript.Echo "** \__ ___/___________ ____ | | __ ___________ **"<br />
wscript.Echo "** | | \_ __ \__ \ _/ ___\| |/ // __ \_ __ \ **"<br />
wscript.Echo "** | | | | \// __ \\ \___| <\ ___/| | \/ **"<br />
wscript.Echo "** |____| |__| (____ /\___ >__|_ \\___ >__| **"<br />
wscript.Echo "** \/ \/ \/ \/ **"<br />
wscript.Echo "** **"<br />
wscript.Echo "****************************************************************************"<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "** TTTTTTTTT TTTTTTTTTT **"'<br />
'wscript.Echo "** TTTTTTTTT TTTTTTTTTT **"'<br />
'wscript.Echo "** III III **"'<br />
'wscript.Echo "** III I M E III R A C K E R **"'<br />
'wscript.Echo "** III ------- III ----------- **"'<br />
'wscript.Echo "** III III **"'<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "****************************************************************************"'<br />
'wscript.Echo "****************************************************************************"'<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "** MM MM MM MM **"'<br />
'wscript.Echo "** MMMM MMM MMM MMM **"'<br />
'wscript.Echo "** MM MM MMMM MM MM MMMM **"'<br />
'wscript.Echo "** MM MM MM I C R O MM MM MM A N A G E R **"'<br />
'wscript.Echo "** MM MM ------- MM MM ----------- **"'<br />
'wscript.Echo "** MM MM MM MM **"'<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "****************************************************************************"'<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.Echo " ", FormatDateTime(NOW, vbLongTime)<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.Echo "What are you doing right now?"<br />
Wscript.StdOut.Write ":: "<br />
strInput = Wscript.StdIn.ReadLine<br />
<br />
'* *********** ADD A SPACER BEFORE THE START OF THE HOUR ***********'<br />
Minutos = DatePart("n", Now)<br />
If Minutos < 5 Then<br />
objFile.writeline "------------------------"<br />
End If <br />
objFile.writeline FormatDateTime(Date(),1) & " - " & FormatDateTime(NOW, vbShortTime) & " -- " & strInput<br />
objFile.close<br />
<br />
<br />
==TimeTracker.bat==<br />
cscript TimeTracker.vbs<br />
<br />
==TimeTracker.txt==<br />
On the first run, the script creates the output file locally. Note that the time stamp represents an end time for the task, not a beginning time.<br />
<br />
Here is a snippet of what it looks like:<br />
Thursday, January 27, 2011 - 07:36 -- email and pit upgrade stuff<br />
Thursday, January 27, 2011 - 07:41 -- emai<br />
------------------------<br />
Thursday, January 27, 2011 - 08:06 -- email, then heading in to the office<br />
------------------------<br />
Thursday, January 27, 2011 - 10:00 -- boot up and checking email<br />
Thursday, January 27, 2011 - 10:31 -- rti meeting, then dev1g slowness meeting<br />
------------------------<br />
Thursday, January 27, 2011 - 11:03 -- dev1g meeting, then heating up some food, now email<br />
Thursday, January 27, 2011 - 11:21 -- pit mtv upgrade<br />
------------------------<br />
Thursday, January 27, 2011 - 12:03 -- SSR for tux recycle<br />
Thursday, January 27, 2011 - 12:40 -- talking to Mark about methods of improving ldap query performance<br />
------------------------<br />
Thursday, January 27, 2011 - 13:15 -- helping Tami with egate gui install and changing the doco to include additional details<br />
Thursday, January 27, 2011 - 15:20 -- all hands meeting<br />
<br />
==Setting up the program in the windows scheduler - XP==<br />
'''Task Tab:'''<br />
<br />
Run: ''"C:\Program Files\TimeTracker\TimeTracker.bat"''<br />
<br />
Start in: ''"C:\Program Files\TimeTracker"''<br />
<br />
Run As: ''DELTADS\ca30044''<br />
<br />
Checked option: ''Run only if logged in''<br />
<br />
Checked option: ''Enabled''<br />
<br />
'''Schedule Tab:'''<br />
<br />
Scheduled Task: ''Weekly''<br />
<br />
Start time: ''7am''<br />
<br />
Schedule Taks weekly: checked are ''Mon, Tue, Wed, Thu, Fri''<br />
<br />
Advanced button:<br />
<br />
Checked option: ''Repeat Task''<br />
<br />
Every: ''20 minutes''<br />
<br />
Until: ''Duration 12 hours''<br />
<br />
'''Settings Tab:'''<br />
<br />
Checked option: ''Stop the task if it runs for 18 minutes''<br />
<br />
This means that it will close itself if you are either away from your desk or don't input anything<br />
<br />
<br />
<br />
==Setting up the program in the windows scheduler - Windows 7==<br />
<br />
Sorry, no time for detailed instructions. I used Irfanviewers screen capture tool to quickly rip some images, then used [http://www.gifninja.com GIFNinja] to wrap it up into one file.<br />
<br />
[[File:Scheduledtaskwin7.gif]]</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Time_trackerTime tracker2011-07-08T17:01:13Z<p>Jeff: /* Setting up the program in the windows scheduler */</p>
<hr />
<div>'''Background:'''<br />
<br />
Several years ago, I was asked to track my time in 20 minute increments. I worked for a company that billed their time to the customer and although that ship has sailed, the script is still in place today and it's a huge help in tracking my time. It's not the most elaborate set up, but IMHO it serves the purpose quite well.<br />
<br />
This was formerly known as Micro Manager.<br />
<br />
'''Location:'''<br />
<br />
Technically you can store the source code (and resultant log file) anywhere you want, but I've found C:\program files\timetracker works best for me.<br />
<br />
<br />
'''How to Call it?'''<br />
<br />
You'll need to set up an advanced schedule within the windows scheduler to determine which days and times for it to run.<br />
<br />
Additionally, I have a shortcut in my quick launch tray so that I can call on it in an unscheduled fashion.<br />
<br />
<br />
<br />
The source code consists of two parts:<br />
<br />
1) the vbs file which drives all the action<br />
<br />
and<br />
<br />
2) the batch file which calls the vb file<br />
<br />
<br />
<br />
==TimeTracker.vbs==<br />
'* ********** GETTING USERNAME FROM ADSI OBJECT ****** *'<br />
Set objNetwork = WScript.CreateObject("WScript.Network")<br />
strUserName = objNetwork.UserName<br />
<br />
'* ********* SET THE PATH TO THE DESKTOP in A variable ****** *'<br />
'*logfilepath = "C:\Documents and Settings\" & strUserName & "\TimeTracker.txt"*'<br />
logfilepath = "C:\Program Files\TimeTracker\TimeTracker.txt"<br />
<br />
'********** IF THE FILE EXISTS, APPEND TO IT, IF NOT, CREATE IT ********'<br />
Set objFSO = CreateObject("Scripting.FileSystemObject")<br />
If objFSO.FileExists(logfilepath) Then<br />
Set objFile = objFSO.OpenTextFile(logfilepath, 8)<br />
Else<br />
Set objFile = objFSO.CreateTextFile(logfilepath)<br />
End If<br />
<br />
'******* CLEAR THE SCREEN, the poor mans way *********'<br />
counter = 15<br />
Do Until counter = 0<br />
Counter = counter - 1<br />
wscript.echo ""<br />
Loop<br />
<br />
wscript.Echo "****************************************************************************"<br />
wscript.Echo "** **"<br />
wscript.Echo "** ___________.__ **"<br />
wscript.Echo "** \__ ___/|__| _____ ____ **"<br />
wscript.Echo "** | | | |/ \_/ __ \ **" <br />
wscript.Echo "** | | | | Y Y \ ___/ **"<br />
wscript.Echo "** |____| |__|__|_| /\___ > **"<br />
wscript.Echo "** \/ \/ **"<br />
wscript.Echo "** ___________ __ **"<br />
wscript.Echo "** \__ ___/___________ ____ | | __ ___________ **"<br />
wscript.Echo "** | | \_ __ \__ \ _/ ___\| |/ // __ \_ __ \ **"<br />
wscript.Echo "** | | | | \// __ \\ \___| <\ ___/| | \/ **"<br />
wscript.Echo "** |____| |__| (____ /\___ >__|_ \\___ >__| **"<br />
wscript.Echo "** \/ \/ \/ \/ **"<br />
wscript.Echo "** **"<br />
wscript.Echo "****************************************************************************"<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "** TTTTTTTTT TTTTTTTTTT **"'<br />
'wscript.Echo "** TTTTTTTTT TTTTTTTTTT **"'<br />
'wscript.Echo "** III III **"'<br />
'wscript.Echo "** III I M E III R A C K E R **"'<br />
'wscript.Echo "** III ------- III ----------- **"'<br />
'wscript.Echo "** III III **"'<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "****************************************************************************"'<br />
'wscript.Echo "****************************************************************************"'<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "** MM MM MM MM **"'<br />
'wscript.Echo "** MMMM MMM MMM MMM **"'<br />
'wscript.Echo "** MM MM MMMM MM MM MMMM **"'<br />
'wscript.Echo "** MM MM MM I C R O MM MM MM A N A G E R **"'<br />
'wscript.Echo "** MM MM ------- MM MM ----------- **"'<br />
'wscript.Echo "** MM MM MM MM **"'<br />
'wscript.Echo "** **"'<br />
'wscript.Echo "****************************************************************************"'<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.Echo " ", FormatDateTime(NOW, vbLongTime)<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.echo ""<br />
wscript.Echo "What are you doing right now?"<br />
Wscript.StdOut.Write ":: "<br />
strInput = Wscript.StdIn.ReadLine<br />
<br />
'* *********** ADD A SPACER BEFORE THE START OF THE HOUR ***********'<br />
Minutos = DatePart("n", Now)<br />
If Minutos < 5 Then<br />
objFile.writeline "------------------------"<br />
End If <br />
objFile.writeline FormatDateTime(Date(),1) & " - " & FormatDateTime(NOW, vbShortTime) & " -- " & strInput<br />
objFile.close<br />
<br />
<br />
==TimeTracker.bat==<br />
cscript TimeTracker.vbs<br />
<br />
==TimeTracker.txt==<br />
On the first run, the script creates the output file locally. Note that the time stamp represents an end time for the task, not a beginning time.<br />
<br />
Here is a snippet of what it looks like:<br />
Thursday, January 27, 2011 - 07:36 -- email and pit upgrade stuff<br />
Thursday, January 27, 2011 - 07:41 -- emai<br />
------------------------<br />
Thursday, January 27, 2011 - 08:06 -- email, then heading in to the office<br />
------------------------<br />
Thursday, January 27, 2011 - 10:00 -- boot up and checking email<br />
Thursday, January 27, 2011 - 10:31 -- rti meeting, then dev1g slowness meeting<br />
------------------------<br />
Thursday, January 27, 2011 - 11:03 -- dev1g meeting, then heating up some food, now email<br />
Thursday, January 27, 2011 - 11:21 -- pit mtv upgrade<br />
------------------------<br />
Thursday, January 27, 2011 - 12:03 -- SSR for tux recycle<br />
Thursday, January 27, 2011 - 12:40 -- talking to Mark about methods of improving ldap query performance<br />
------------------------<br />
Thursday, January 27, 2011 - 13:15 -- helping Tami with egate gui install and changing the doco to include additional details<br />
Thursday, January 27, 2011 - 15:20 -- all hands meeting<br />
<br />
==Setting up the program in the windows scheduler - XP==<br />
'''Task Tab:'''<br />
<br />
Run: ''"C:\Program Files\TimeTracker\TimeTracker.bat"''<br />
<br />
Start in: ''"C:\Program Files\TimeTracker"''<br />
<br />
Run As: ''DELTADS\ca30044''<br />
<br />
Checked option: ''Run only if logged in''<br />
<br />
Checked option: ''Enabled''<br />
<br />
'''Schedule Tab:'''<br />
<br />
Scheduled Task: ''Weekly''<br />
<br />
Start time: ''7am''<br />
<br />
Schedule Taks weekly: checked are ''Mon, Tue, Wed, Thu, Fri''<br />
<br />
Advanced button:<br />
<br />
Checked option: ''Repeat Task''<br />
<br />
Every: ''20 minutes''<br />
<br />
Until: ''Duration 12 hours''<br />
<br />
'''Settings Tab:'''<br />
<br />
Checked option: ''Stop the task if it runs for 18 minutes''<br />
<br />
This means that it will close itself if you are either away from your desk or don't input anything</div>Jeffhttp://trunnelle.com/wiki/index.php?title=File:Scheduledtaskwin7.gifFile:Scheduledtaskwin7.gif2011-07-08T17:00:06Z<p>Jeff: This image is an animated gif file showing how to set up the time tracker in windows 7 (win7/windows7).</p>
<hr />
<div>This image is an animated gif file showing how to set up the time tracker in windows 7 (win7/windows7).</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Ldap_notesLdap notes2011-05-24T02:09:50Z<p>Jeff: Created page with 'Misc LDAP notes: Query a user by the LDAP URL: ldap://aaa-ldap-vip.deltads.ent/uid=ca30044,ou=people,dc=delta,dc=org'</p>
<hr />
<div>Misc LDAP notes:<br />
<br />
<br />
Query a user by the LDAP URL:<br />
ldap://aaa-ldap-vip.deltads.ent/uid=ca30044,ou=people,dc=delta,dc=org</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Database_notesDatabase notes2011-05-23T18:42:08Z<p>Jeff: </p>
<hr />
<div> SQL> select ora_database_name from dual;<br />
shows the database you are connected to<br />
<br />
SQL> select * from v$database;<br />
shows the catlog inof for the database you are connected to<br />
<br />
The query below will return a list of all the Tables/VIEWS in the database.<br />
SELECT table_name FROM DICTIONARY ORDER BY table_name;<br />
<br />
SQL> select sys_context('USERENV','DB_NAME') from dual;<br />
SYS_CONTEXT('USERENV','DB_NAME')<br />
--------------------------------------------------------------------------------<br />
dbname<br />
<br />
<br />
<br />
database connect string<br />
hostname:port:global database name:service name<br />
admin1-cz6gznr6:1521:infra.domain.ent:infra.ddomain.ent<br />
jdbcracle:thin@rc-sgxx.domain.ent:1521prod<br />
select count from statement where status = '30'</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Database_notesDatabase notes2011-05-23T18:41:08Z<p>Jeff: </p>
<hr />
<div> SQL> select ora_database_name from dual;<br />
shows the database you are connected to<br />
<br />
SQL> select * from v$database;<br />
shows the catlog inof for the database you are connected to<br />
<br />
The query below will return a list of all the Tables/VIEWS in the database.<br />
SELECT table_name FROM DICTIONARY ORDER BY table_name;<br />
<br />
SQL> select sys_context('USERENV','DB_NAME') from dual;<br />
SYS_CONTEXT('USERENV','DB_NAME')<br />
--------------------------------------------------------------------------------<br />
mvpit<br />
<br />
<br />
<br />
database connect string<br />
hostname:port:global database name:service name<br />
admin1-cz6gznr6:1521:infra.deltads.ent:infra.deltads.ent<br />
jdbcracle:thin@rc-sg27.deltads.ent:1521ocprod<br />
select count from statement where status = '30'</div>Jeffhttp://trunnelle.com/wiki/index.php?title=HP_Servers.htaHP Servers.hta2011-05-23T18:39:15Z<p>Jeff: </p>
<hr />
<div> <HTML><br />
<HEAD><br />
<TITLE>HPUX Servers</title><br />
<HTA:APPLICATION<br />
borderStyle="sunken"<br />
windowState="normal"<br />
icon="c:\black-server.ico"/> <br />
<br />
</HEAD> <br />
<br />
<SCRIPT LANGUAGE="VBScript"><br />
moveto 270,100<br />
resizeto 155,500<br />
<br />
Sub Run(button)<br />
<br />
Set oShell = CreateObject ("WScript.shell")<br />
<br />
Select Case button<br />
Case "RC-HP18"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp18",1,True<br />
Case "RC-HP19"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp19",1,True<br />
Case Else<br />
Set oShell = Nothing<br />
self.close<br />
End Select<br />
Set oShell = Nothing<br />
<br />
End Sub<br />
<br />
</SCRIPT><br />
<br />
<META HTTP-EQUIV="MSThemeCompatible" CONTENT="Yes"><br />
<br />
<style><br />
body<br />
{<br />
color: white;<br />
font-family: arial;<br />
font-size: 8pt;<br />
filter:progid:DXImageTransform.Microsoft.Gradient (GradientType=2, StartColorStr='#000000', EndColorStr='#0000FF')<br />
}<br />
.button<br />
{<br />
font-family: arial;<br />
font-size: 8pt;<br />
width: 100px;<br />
height=20;<br />
}<br />
.scroll<br />
{<br />
no<br />
}<br />
</style><br />
<br />
<BODY><br />
<br />
<input id=runbutton class="button" type="button" value="RC-HP18" name="ok_button" onClick="Run('RC-HP18')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP19" name="ok_button" onClick="Run('RC-HP19')"><BR><BR><br />
<input id=runbutton class="button" type="button" value="Exit" name="cancel_button" onClick="Run('CancelScript')"><br />
<br />
</BODY></div>Jeffhttp://trunnelle.com/wiki/index.php?title=HP_Servers.htaHP Servers.hta2011-05-23T18:38:34Z<p>Jeff: Created page with ' <HTML> <HEAD> <TITLE>HPUX Servers</title> <HTA:APPLICATION borderStyle="sunken" windowState="normal" icon="c:\black-server.ico"/> </HEAD> <SCRIPT LANGUAGE="VBScrip…'</p>
<hr />
<div> <HTML><br />
<HEAD><br />
<TITLE>HPUX Servers</title><br />
<HTA:APPLICATION<br />
borderStyle="sunken"<br />
windowState="normal"<br />
icon="c:\black-server.ico"/> <br />
<br />
</HEAD> <br />
<br />
<SCRIPT LANGUAGE="VBScript"><br />
moveto 270,100<br />
resizeto 155,500<br />
<br />
Sub Run(button)<br />
<br />
Set oShell = CreateObject ("WScript.shell")<br />
<br />
Select Case button<br />
Case "RC-HP18"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp18",1,True<br />
Case "RC-HP19"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp19",1,True<br />
Case "RC-HP20"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp20",1,True<br />
Case "RC-HP21"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp21",1,True<br />
Case "RC-HP22"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp22",1,True<br />
Case "RC-HP23"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp23",1,True<br />
Case "RC-HP24"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp24",1,True<br />
Case "RC-HP25"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp25",1,True<br />
Case "RC-HP26"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp26",1,True<br />
Case "RC-HP27"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp27",1,True<br />
Case "RC-HP28"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp28",1,True<br />
Case "RC-HP29"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp29",1,True<br />
Case "RC-HP30"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp30",1,True<br />
Case "RC-HP31"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp31",1,True<br />
Case "RC-HP32"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp32",1,True<br />
Case "RC-HP33"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp33",1,True<br />
Case "RC-HP34"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp34",1,True<br />
Case "RC-HP35"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp35",1,True<br />
Case "RC-HP36"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp36",1,True<br />
Case "RC-HP37"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp37",1,True<br />
Case "RC-HP38"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp38",1,True<br />
Case "RC-HP39"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp39",1,True<br />
Case "RC-HP40"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp40",1,True<br />
Case "RC-HP41"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp41",1,True<br />
Case "RC-HP42"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp42",1,True<br />
Case "RC-HP43"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp43",1,True<br />
Case "RC-HP44"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp44",1,True<br />
Case "RC-HP45"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp45",1,True<br />
Case "RC-HP46"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp46",1,True<br />
Case "RC-HP47"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp47",1,True<br />
Case "RC-HP48"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp48",1,True<br />
Case "RC-HP49"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp49",1,True<br />
Case "RC-HP50"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp50",1,True<br />
Case "RC-HP51"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp51",1,True<br />
Case "RC-HP52"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp52",1,True<br />
Case "RC-HP53"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp53",1,True<br />
Case "RC-HP54"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp54",1,True<br />
Case "RC-HP56"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp55",1,True<br />
Case "RC-HP60"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp60",1,True<br />
Case "RC-HP61"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp61",1,True<br />
Case "RC-HP62"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp62",1,True<br />
Case "RC-HP63"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp63",1,True<br />
Case "RC-HP64"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp64",1,True<br />
Case "RC-HP67"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp67",1,True<br />
Case "RC-HP70"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp70",1,True<br />
Case "RC-HP72"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp72",1,True<br />
Case "RC-HP73"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp73",1,True<br />
Case "RC-HP74"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp74",1,True<br />
Case "RC-HP80"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp80",1,True<br />
Case "RC-HP81"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp81",1,True<br />
Case "RC-HP82"<br />
oShell.run """C:\program files\putty\putty.exe"" rc-hp82",1,True<br />
Case Else<br />
Set oShell = Nothing<br />
self.close<br />
End Select<br />
Set oShell = Nothing<br />
<br />
End Sub<br />
<br />
</SCRIPT><br />
<br />
<META HTTP-EQUIV="MSThemeCompatible" CONTENT="Yes"><br />
<br />
<style><br />
body<br />
{<br />
color: white;<br />
font-family: arial;<br />
font-size: 8pt;<br />
filter:progid:DXImageTransform.Microsoft.Gradient (GradientType=2, StartColorStr='#000000', EndColorStr='#0000FF')<br />
}<br />
.button<br />
{<br />
font-family: arial;<br />
font-size: 8pt;<br />
width: 100px;<br />
height=20;<br />
}<br />
.scroll<br />
{<br />
no<br />
}<br />
</style><br />
<br />
<BODY><br />
<br />
<input id=runbutton class="button" type="button" value="RC-HP18" name="ok_button" onClick="Run('RC-HP18')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP19" name="ok_button" onClick="Run('RC-HP19')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP20" name="ok_button" onClick="Run('RC-HP20')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP21" name="ok_button" onClick="Run('RC-HP21')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP22" name="ok_button" onClick="Run('RC-HP22')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP23" name="ok_button" onClick="Run('RC-HP23')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP24" name="ok_button" onClick="Run('RC-HP24')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP25" name="ok_button" onClick="Run('RC-HP25')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP26" name="ok_button" onClick="Run('RC-HP26')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP27" name="ok_button" onClick="Run('RC-HP27')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP28" name="ok_button" onClick="Run('RC-HP28')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP29" name="ok_button" onClick="Run('RC-HP29')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP30" name="ok_button" onClick="Run('RC-HP30')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP31" name="ok_button" onClick="Run('RC-HP31')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP32" name="ok_button" onClick="Run('RC-HP32')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP33" name="ok_button" onClick="Run('RC-HP33')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP34" name="ok_button" onClick="Run('RC-HP34')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP35" name="ok_button" onClick="Run('RC-HP35')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP36" name="ok_button" onClick="Run('RC-HP36')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP37" name="ok_button" onClick="Run('RC-HP37')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP38" name="ok_button" onClick="Run('RC-HP38')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP39" name="ok_button" onClick="Run('RC-HP39')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP40" name="ok_button" onClick="Run('RC-HP40')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP41" name="ok_button" onClick="Run('RC-HP41')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP42" name="ok_button" onClick="Run('RC-HP42')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP43" name="ok_button" onClick="Run('RC-HP43')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP44" name="ok_button" onClick="Run('RC-HP44')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP45" name="ok_button" onClick="Run('RC-HP45')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP46" name="ok_button" onClick="Run('RC-HP46')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP47" name="ok_button" onClick="Run('RC-HP47')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP48" name="ok_button" onClick="Run('RC-HP48')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP49" name="ok_button" onClick="Run('RC-HP49')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP50" name="ok_button" onClick="Run('RC-HP50')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP51" name="ok_button" onClick="Run('RC-HP51')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP52" name="ok_button" onClick="Run('RC-HP52')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP53" name="ok_button" onClick="Run('RC-HP53')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP54" name="ok_button" onClick="Run('RC-HP54')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP56" name="ok_button" onClick="Run('RC-HP56')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP60" name="ok_button" onClick="Run('RC-HP60')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP61" name="ok_button" onClick="Run('RC-HP61')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP62" name="ok_button" onClick="Run('RC-HP62')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP63" name="ok_button" onClick="Run('RC-HP63')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP64" name="ok_button" onClick="Run('RC-HP64')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP67" name="ok_button" onClick="Run('RC-HP67')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP70" name="ok_button" onClick="Run('RC-HP70')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP72" name="ok_button" onClick="Run('RC-HP72')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP73" name="ok_button" onClick="Run('RC-HP73')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP74" name="ok_button" onClick="Run('RC-HP74')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP80" name="ok_button" onClick="Run('RC-HP80')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP81" name="ok_button" onClick="Run('RC-HP81')"><BR><br />
<input id=runbutton class="button" type="button" value="RC-HP82" name="ok_button" onClick="Run('RC-HP82')"><BR><BR><br />
<input id=runbutton class="button" type="button" value="Exit" name="cancel_button" onClick="Run('CancelScript')"><br />
<br />
</BODY></div>Jeffhttp://trunnelle.com/wiki/index.php?title=Database_notesDatabase notes2011-05-23T18:35:46Z<p>Jeff: </p>
<hr />
<div> SQL> select ora_database_name from dual;<br />
shows the database you are connected to<br />
<br />
SQL> select * from v$database;<br />
shows the catlog inof for the database you are connected to<br />
<br />
The query below will return a list of all the Tables/VIEWS in the database.<br />
SELECT table_name FROM DICTIONARY ORDER BY table_name;<br />
<br />
SQL> select sys_context('USERENV','DB_NAME') from dual;<br />
SYS_CONTEXT('USERENV','DB_NAME')<br />
--------------------------------------------------------------------------------<br />
mvpit<br />
<br />
<br />
<br />
database connect string<br />
hostname:port:global database name:service name<br />
admin1-cz6gznr6:1521:infra.deltads.ent:infra.deltads.ent</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Xterm_notesXterm notes2011-05-23T18:33:47Z<p>Jeff: Created page with ' /usr/openwin/bin/xterm -e sh -c "tail -f /var/adm/messages"'</p>
<hr />
<div> /usr/openwin/bin/xterm -e sh -c "tail -f /var/adm/messages"</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Designator_queriesDesignator queries2011-05-23T18:31:22Z<p>Jeff: Created page with 'To get the distinct count of designators: mysql> select designation, count(*) as Counts from info_current group by designation order by Counts; +-------------------------------…'</p>
<hr />
<div>To get the distinct count of designators:<br />
mysql> select designation, count(*) as Counts from info_current group by designation order by Counts;<br />
+---------------------------------------------+--------+<br />
| designation | Counts |<br />
+---------------------------------------------+--------+<br />
| OAS_BPEL_EBIZ | 1 |<br />
| OAS_BPEL_DAP | 1 |<br />
...<br />
| OAS_A3_CROSSPLANE_INT | 19 |<br />
| TBD | 23 |<br />
| ORACLE_DB | 24 |<br />
| JCAPS | 25 |<br />
| | 84 |<br />
+---------------------------------------------+--------+<br />
120 rows in set (0.02 sec)<br />
<br />
For one offs of the OAS stuff, list the host as well (again this only works if the count is 1):<br />
select hostname, designation, count(*) as Counts from info_current where designation like '%OAS%' group by designation order by Counts;<br />
<br />
<br />
<br />
Blank designators:<br />
mysql> select hostname from info_current where designation="";<br />
+------------+<br />
| hostname |<br />
+------------+<br />
| unix0019 |<br />
...<br />
| unix0056 |<br />
| zone0249 |<br />
+------------+<br />
84 rows in set (0.00 sec)<br />
Do the same query for TBD and "X"<br />
<br />
<br />
<br />
<br />
mysql> select hostname, designation, environment from info_current where designation like '%omca%' order by designation;<br />
+-----------+------------------+-------------+<br />
| hostname | designation | environment |<br />
+-----------+------------------+-------------+<br />
| zone0168 | LAP_TOMCAT_SRVR | MOT |<br />
| rc-sun94d | LAP_TOMCAT_SRVR | DEV |<br />
| zone0035 | LAP_TOMCAT_SRVR | PROD |<br />
| zone0129 | RACHADE - Tomcat | DEV |<br />
| zone0163 | Tomcat | MOT |<br />
| zone0044 | Tomcat | PROD |<br />
| zone0045 | Tomcat | PROD |<br />
| zone0080 | Tomcat | MOT |<br />
+-----------+------------------+-------------+<br />
8 rows in set (0.01 sec) <br />
<br />
<br />
<br />
<br />
<br />
mysql> select count(designation), designation from info_current group by designation order by count(designation);<br />
+--------------------+---------------------------------------------+<br />
| count(designation) | designation |<br />
+--------------------+---------------------------------------------+<br />
| 1 | OAS_BPEL_EBIZ |<br />
| 1 | OAS_BPEL_DAP |<br />
| 1 | SSO/OID |<br />
| 1 | JumpStart Server |<br />
| 1 | RACHADE</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Database_notesDatabase notes2011-05-23T18:29:39Z<p>Jeff: Created page with ' SQL> select ora_database_name from dual; shows the database you are connected to SQL> select * from v$database; shows the catlog inof for the database you are connected to …'</p>
<hr />
<div> SQL> select ora_database_name from dual;<br />
shows the database you are connected to<br />
<br />
SQL> select * from v$database;<br />
shows the catlog inof for the database you are connected to<br />
<br />
The query below will return a list of all the Tables/VIEWS in the database.<br />
SELECT table_name FROM DICTIONARY ORDER BY table_name;<br />
<br />
SQL> select sys_context('USERENV','DB_NAME') from dual;<br />
SYS_CONTEXT('USERENV','DB_NAME')<br />
--------------------------------------------------------------------------------<br />
mvpit</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Technical_guidesTechnical guides2011-05-16T18:00:22Z<p>Jeff: /* WORK */</p>
<hr />
<div>== Technical stuff ==<br />
'''All work and no play makes Jeff a dull boy!'''<br />
<br />
===WORK===<br />
# WORK - script - UNIX ROBOT - KSH - [[Robot for CFG2HTML]], collects and copies results to web server for presentation<br />
# WORK - script - HPOV - KSH - [[Putting Nodes in and out of maintenance]] outside of the HP OV admin server<br />
# WORK - script - METAVANCE - KSH - [[Metavance Extensions Installer/Helper script]]<br />
# WORK - script - METAVANCE - KSH - [[Copy/Syncronize Code amongst app hosts]]<br />
# WORK - script - IBM MQ - KSH - MQ Explorer TUI, replaces the need for the heavy GUI - [[mq]]<br />
# WORK - script - LDAP - KSH - [[LDAP]] maintenance script and implementation docs<br />
# WORK - script - WEB/RSYNC - KSH - [[Web publish with rsync]], copies development web content into production and vice versa<br />
<br />
<br />
# WORK - script - UNIX - KSH - [[findrecent]] - widget to find recently written to files. Good for troubleshooting.<br />
# WORK - script - UNIX - KSH - [[Find and Replace with checks]] - used to toggle flag for batch job<br />
# WORK - script - UNIX - KSH - [[LSOF-Port_to_PID]] - maps open ports to their respective pid<br />
# WORK - script - UNIX - KSH - [[Delete BA files]] with summaries<br />
# WORK - guide - UNIX - KSH - [[Solaris BSM/Audit howto]]<br />
# WORK - notes - UNIX - na - [[BSM Auditing]]<br />
<br />
<br />
# WORK - script - WINDOWS - ROBOCOPY - [[backup PST mail files]]<br />
# WORK - script - WINDOWS - ROBOCOPY - [[backup my laptop]]<br />
# WORK - script - WINDOWS - ROBOCOPY - [[backup the backup]]<br />
# WORK - script - WINDOWS - VBS - [[time tracker]] time management script<br />
# WORK - script - WINDOWS - DOS - [[map P drive]]<br />
<br />
<br />
<br />
# WORK - script - [[Epoch Time]]<br />
# WORK - guide - [[SUDOSH time file]]<br />
# WORK - script - [[DDP membership file back out]]<br />
# WORK - guide - [[Installing the BMC performance agent on UNIX]]<br />
# WORK - guide - [[Installing the BMC performance agent on LINUX]]<br />
# WORK - guide - [[Sol - NFS folder add to zone]]<br />
# WORK - guide - [[Win - Concatenate multiple Excel files into one]]<br />
<br />
===PLAY===<br />
# INFO - doco - [[Charger information]]<br />
# PLAY - guide - MYTHTV - [[manually entering show data]]<br />
# PLAY - guide - WEB - [[Resize images for web consumption]] (good candidate for an auto-it script some time later)<br />
<br />
<br />
# Have you ever wanted to change that tiny icon that appears next to the URL in the address bar? Here is the article that I used to learn how to do it. [[It's titled Setting Up a Favorite Icon (favorite.ico)]]<br />
# Wikipedia has a good article on wiki markup basics here: \\http://en.wikipedia.org/wiki/Wikipedia:How_to_edit_a_page<br />
# wiki converter - http://search.cpan.org/~diberri/HTML-WikiConverter-0.61/lib/HTML/WikiConverter.pm<br />
<br />
<br />
===LINKS===<br />
# INFO - UNIX - ROSETTA STONE - [http://antapex.org/unix.txt| Commands for all OSs]<br />
# INFO - UNIX - COMMAND REF - [http://sed.sourceforge.net/sed1line.txt SED shortcuts]<br />
# INFO - UNIX - CMDB TOOLS - [[SysInfo varients]]</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Technical_guidesTechnical guides2011-05-16T17:56:29Z<p>Jeff: /* WORK */</p>
<hr />
<div>== Technical stuff ==<br />
'''All work and no play makes Jeff a dull boy!'''<br />
<br />
===WORK===<br />
# WORK - script - UNIX ROBOT - KSH - [[Robot for CFG2HTML]]<br />
# WORK - script - HPOV - KSH - [[Putting Nodes in and out of maintenance]]<br />
# WORK - script - METAVANCE - KSH - [[Metavance Extensions Installer/Helper script]]<br />
# WORK - script - METAVANCE - KSH - [[Copy/Syncronize Code amongst app hosts]]<br />
# WORK - script - IBM MQ - KSH - MQ Explorer TUI, replaces the need for the heavy GUI - [[mq]]<br />
# WORK - script - LDAP - KSH - [[LDAP]]<br />
# WORK - script - WEB/RSYNC - KSH - [[Web publish with rsync]]<br />
<br />
<br />
# WORK - script - UNIX - KSH - [[findrecent]]<br />
# WORK - script - UNIX - KSH - [[Find and Replace with checks]]<br />
# WORK - script - UNIX - KSH - [[LSOF-Port_to_PID]]<br />
# WORK - script - UNIX - KSH - [[Delete BA files]] with summaries<br />
# WORK - guide - UNIX - KSH - [[Solaris BSM/Audit howto]]<br />
# WORK - notes - UNIX - na - [[BSM Auditing]]<br />
<br />
<br />
# WORK - script - WINDOWS - ROBOCOPY - [[backup PST mail files]]<br />
# WORK - script - WINDOWS - ROBOCOPY - [[backup my laptop]]<br />
# WORK - script - WINDOWS - ROBOCOPY - [[backup the backup]]<br />
# WORK - script - WINDOWS - VBS - [[time tracker]] time management script<br />
# WORK - script - WINDOWS - DOS - [[map P drive]]<br />
<br />
<br />
<br />
# WORK - script - [[Epoch Time]]<br />
# WORK - guide - [[SUDOSH time file]]<br />
# WORK - script - [[DDP membership file back out]]<br />
# WORK - guide - [[Installing the BMC performance agent on UNIX]]<br />
# WORK - guide - [[Installing the BMC performance agent on LINUX]]<br />
# WORK - guide - [[Sol - NFS folder add to zone]]<br />
# WORK - guide - [[Win - Concatenate multiple Excel files into one]]<br />
<br />
===PLAY===<br />
# INFO - doco - [[Charger information]]<br />
# PLAY - guide - MYTHTV - [[manually entering show data]]<br />
# PLAY - guide - WEB - [[Resize images for web consumption]] (good candidate for an auto-it script some time later)<br />
<br />
<br />
# Have you ever wanted to change that tiny icon that appears next to the URL in the address bar? Here is the article that I used to learn how to do it. [[It's titled Setting Up a Favorite Icon (favorite.ico)]]<br />
# Wikipedia has a good article on wiki markup basics here: \\http://en.wikipedia.org/wiki/Wikipedia:How_to_edit_a_page<br />
# wiki converter - http://search.cpan.org/~diberri/HTML-WikiConverter-0.61/lib/HTML/WikiConverter.pm<br />
<br />
<br />
===LINKS===<br />
# INFO - UNIX - ROSETTA STONE - [http://antapex.org/unix.txt| Commands for all OSs]<br />
# INFO - UNIX - COMMAND REF - [http://sed.sourceforge.net/sed1line.txt SED shortcuts]<br />
# INFO - UNIX - CMDB TOOLS - [[SysInfo varients]]</div>Jeffhttp://trunnelle.com/wiki/index.php?title=FindrecentFindrecent2011-03-09T22:11:39Z<p>Jeff: </p>
<hr />
<div> #!/usr/bin/ksh<br />
tRev=`tput -T xterm rev`<br />
uRev=`tput -T xterm sgr0`<br />
Month=`date '+%b'`<br />
DayOfMonth=`date '+%d' | sed 's/^[0]*//'`<br />
dat_justified=`echo "$Month $DayOfMonth"| awk '{printf "%-4s%2d", $1, $2}'`<br />
<br />
clear<br />
if [ -z "$1" ]<br />
then loc=`pwd`<br />
else loc=$1<br />
fi<br />
<br />
date<br />
cat << EOT<br />
<nowiki>-------------------------------------------------------------</nowiki><br />
Checking for recent files in ${tRev}${loc}${uRev}<br />
EOT<br />
<br />
df -k $loc<br />
echo "-------------------------------------------------------------"<br />
<br />
find $loc -xdev -mtime -3 -exec ls -ld {} \; | grep "$dat_justified" | sort -k 8,8 | tail<br />
<br />
echo "-------------------------------------------------------------"</div>Jeffhttp://trunnelle.com/wiki/index.php?title=FindrecentFindrecent2011-03-09T22:07:12Z<p>Jeff: </p>
<hr />
<div> #!/usr/bin/ksh<br />
tRev=`tput -T xterm rev`<br />
uRev=`tput -T xterm sgr0`<br />
Month=`date '+%b'`<br />
DayOfMonth=`date '+%d' | sed 's/^[0]*//'`<br />
dat_justified=`echo "$Month $DayOfMonth"| awk '{printf "%-4s%2d", $1, $2}'`<br />
<br />
clear<br />
if [ -z "$1" ]<br />
then loc=`pwd`<br />
else loc=$1<br />
fi<br />
<br />
date<br />
cat << EOT<br />
<nowiki>-------------------------------------------------------------</nowiki><br />
Checking for recent files in ${tRev}${loc}${uRev}<br />
EOT<br />
<br />
df -k $loc<br />
echo "-------------------------------------------------------------"<br />
<br />
find $loc -xdev -mtime -3 -exec ls -ld {} \; | grep "$dat_justified" | sort -k 8,8 | tail<br />
<br />
echo "-------------------------------------------------------------"</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Hutchison_Tax_IDHutchison Tax ID2011-02-16T11:40:40Z<p>Jeff: Created page with '042949680'</p>
<hr />
<div>042949680</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Delete_BA_filesDelete BA files2011-02-15T20:15:37Z<p>Jeff: </p>
<hr />
<div>This script takes no inputs, rather, it uses the logged in user to determine what to delete. I’ve keyed it to the TUXEDO user since its profile references the necessary artifacts. That account is also consistently named (rather than the batch account mbatdv3c, mtvprod,etc).<br />
<br />
In essence, this:<br />
* checks for what user you are<br />
* locates the batch directory<br />
* does a file count on data and work files<br />
* removes the files<br />
* and does a count again.<br />
<br />
SCRIPT:<br />
#!/usr/bin/ksh<br />
##########--DeleteBAFiles.ksh --################<br />
## Description/Purpose:<br />
## Delete BA files in a particular environment<br />
#set -x<br />
<br />
## MUST RUN AS a valid tux user<br />
USER=`whoami`<br />
PREFIX=`whoami | cut -c1-4`<br />
if [[ $PREFIX != mtux ]]; then<br />
print "MUST RUN AS a valid mtux user! Exiting..."; exit<br />
fi<br />
<br />
# GET batch dir<br />
export `grep BATCH_DIR $TUX_MASTER_INI_FILE`<br />
<br />
# FUNCTION to count BA FILES<br />
function countBAfiles {<br />
count1=`ls $BATCH_DIR/data/BA* | wc -l`<br />
count2=`ls $BATCH_DIR/work/BA* | wc -l`<br />
echo "\n\t$1 file count\n\t\tWork (${count1})\n\t\tData(${count2})\n"<br />
}<br />
<br />
<br />
echo "\nAbout to delete all BA files for the $DOMAIN environment"<br />
countBAfiles Before<br />
<br />
# remove work/BA files<br />
echo " - removing BA files in the work folder"<br />
#/usr/bin/rm $BATCH_DIR/work/BA*<br />
if [ $? -gt 0 ] ; then echo "Failed to delete work files";fi<br />
<br />
# remove data/BA files<br />
echo " - removing BA files in the data folder"<br />
#/usr/bin/rm $BATCH_DIR/data/BA*<br />
if [ $? -gt 0 ] ; then echo "Failed to delete data files";fi<br />
<br />
countBAfiles After<br />
<br />
# SUMMARY<br />
total=`echo "$count1+$count2" | bc`<br />
echo "Total Files deleted: $total"<br />
<br />
exit</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Delete_BA_filesDelete BA files2011-02-15T20:15:19Z<p>Jeff: Created page with ' This script takes no inputs, rather, it uses the logged in user to determine what to delete. I’ve keyed it to the TUXEDO user since its profile references the necessary a…'</p>
<hr />
<div> This script takes no inputs, rather, it uses the logged in user to determine what to delete. I’ve keyed it to the TUXEDO user since its profile references the necessary artifacts. That account is also consistently named (rather than the batch account mbatdv3c, mtvprod,etc).<br />
<br />
In essence, this:<br />
* checks for what user you are<br />
* locates the batch directory<br />
* does a file count on data and work files<br />
* removes the files<br />
* and does a count again.<br />
<br />
SCRIPT:<br />
#!/usr/bin/ksh<br />
##########--DeleteBAFiles.ksh --################<br />
## Description/Purpose:<br />
## Delete BA files in a particular environment<br />
#set -x<br />
<br />
## MUST RUN AS a valid tux user<br />
USER=`whoami`<br />
PREFIX=`whoami | cut -c1-4`<br />
if [[ $PREFIX != mtux ]]; then<br />
print "MUST RUN AS a valid mtux user! Exiting..."; exit<br />
fi<br />
<br />
# GET batch dir<br />
export `grep BATCH_DIR $TUX_MASTER_INI_FILE`<br />
<br />
# FUNCTION to count BA FILES<br />
function countBAfiles {<br />
count1=`ls $BATCH_DIR/data/BA* | wc -l`<br />
count2=`ls $BATCH_DIR/work/BA* | wc -l`<br />
echo "\n\t$1 file count\n\t\tWork (${count1})\n\t\tData(${count2})\n"<br />
}<br />
<br />
<br />
echo "\nAbout to delete all BA files for the $DOMAIN environment"<br />
countBAfiles Before<br />
<br />
# remove work/BA files<br />
echo " - removing BA files in the work folder"<br />
#/usr/bin/rm $BATCH_DIR/work/BA*<br />
if [ $? -gt 0 ] ; then echo "Failed to delete work files";fi<br />
<br />
# remove data/BA files<br />
echo " - removing BA files in the data folder"<br />
#/usr/bin/rm $BATCH_DIR/data/BA*<br />
if [ $? -gt 0 ] ; then echo "Failed to delete data files";fi<br />
<br />
countBAfiles After<br />
<br />
# SUMMARY<br />
total=`echo "$count1+$count2" | bc`<br />
echo "Total Files deleted: $total"<br />
<br />
exit</div>Jeffhttp://trunnelle.com/wiki/index.php?title=Technical_guidesTechnical guides2011-02-15T20:13:44Z<p>Jeff: </p>
<hr />
<div>== Technical stuff ==<br />
'''All work and no play makes Jeff a dull boy!'''<br />
<br />
===WORK===<br />
# WORK - script - WINDOWS - ROBOCOPY - [[backup PST mail files]]<br />
# WORK - script - WINDOWS - ROBOCOPY - [[backup my laptop]]<br />
# WORK - script - WINDOWS - ROBOCOPY - [[backup the backup]]<br />
# WORK - script - WINDOWS - VBS - [[time tracker]] time management script<br />
# WORK - script - WINDOWS - DOS - [[map P drive]]<br />
<br />
<br />
# WORK - script - UNIX - KSH - [[findrecent]]<br />
# WORK - script - UNIX - KSH - [[Find and Replace with checks]]<br />
# WORK - script - UNIX - KSH - [[LSOF-Port_to_PID]]<br />
# WORK - script - UNIX - KSH - [[Delete BA files]] with summaries<br />
# WORK - guide - UNIX - KSH - [[Solaris BSM/Audit howto]]<br />
# WORK - notes - UNIX - na - [[BSM Auditing]]<br />
<br />
<br />
# WORK - script - UNIX ROBOT - KSH - [[Robot for CFG2HTML]]<br />
<br />
# WORK - script - HPOV - KSH - [[Putting Nodes in and out of maintenance]]<br />
# WORK - script - METAVANCE - KSH - [[Metavance Extensions Installer/Helper script]]<br />
# WORK - script - METAVANCE - KSH - [[Copy/Syncronize Code amongst app hosts]]<br />
# WORK - script - IBM MQ - KSH - MQ Explorer replacement - [[mq]]<br />
# WORK - script - LDAP - KSH - [[LDAP]]<br />
# WORK - script - WEB/RSYNC - KSH - [[Web publish with rsync]]<br />
<br />
<br />
# WORK - script - [[Epoch Time]]<br />
# WORK - guide - [[SUDOSH time file]]<br />
# WORK - script - [[DDP membership file back out]]<br />
# WORK - guide - [[Installing the BMC performance agent on UNIX]]<br />
# WORK - guide - [[Installing the BMC performance agent on LINUX]]<br />
# WORK - guide - [[Sol - NFS folder add to zone]]<br />
# WORK - guide - [[Win - Concatenate multiple Excel files into one]]<br />
<br />
===PLAY===<br />
# INFO - doco - [[Charger information]]<br />
# PLAY - guide - MYTHTV - [[manually entering show data]]<br />
# PLAY - guide - WEB - [[Resize images for web consumption]] (good candidate for an auto-it script some time later)<br />
<br />
<br />
# Have you ever wanted to change that tiny icon that appears next to the URL in the address bar? Here is the article that I used to learn how to do it. [[It's titled Setting Up a Favorite Icon (favorite.ico)]]<br />
# Wikipedia has a good article on wiki markup basics here: \\http://en.wikipedia.org/wiki/Wikipedia:How_to_edit_a_page<br />
# wiki converter - http://search.cpan.org/~diberri/HTML-WikiConverter-0.61/lib/HTML/WikiConverter.pm<br />
<br />
<br />
===LINKS===<br />
# INFO - UNIX - ROSETTA STONE - [http://antapex.org/unix.txt| Commands for all OSs]<br />
# INFO - UNIX - COMMAND REF - [http://sed.sourceforge.net/sed1line.txt SED shortcuts]<br />
# INFO - UNIX - CMDB TOOLS - [[SysInfo varients]]</div>Jeffhttp://trunnelle.com/wiki/index.php?title=UpdRenee.kshUpdRenee.ksh2011-02-12T23:37:02Z<p>Jeff: </p>
<hr />
<div> $ cat UpdRenee.ksh | awk '1;{print ""}'<br />
#!/usr/bin/ksh<br />
<br />
#20101123 -JT<br />
<br />
# v1<br />
<br />
<br />
<br />
## BANNER and INTRO<br />
<br />
clear;high=`tput -T xterm rev` ; low=`tput -T xterm sgr0`<br />
<br />
cat << EOT<br />
<br />
This script might be helpful in creating some dynamic<br />
<br />
HTML for new albums on Renee's gallery page. <br />
<br />
<br />
EOT<br />
<br />
# Create HTML for gallery page<br />
<br />
## vars<br />
posteddate=`date "+(%m/%d/%Y)"`<br />
outfile=~/foo.123<br />
> $outfile<br />
<br />
## survey recently modified dirs (ie newly added image folders)<br />
newdirs=`find ~/html/renee/images/* -type d -mtime -1`<br />
for dir in $newdirs<br />
do #Directory Specific Stuff<br />
imgcount=`ls $dir | wc -l`<br />
<nowiki> lastgalnum=`grep '<!-- Gallery ' ~/html/renee/gallery.htm \ </nowiki><br />
| head -2 | tail -1 | awk '{print $3}'`<br />
galnum=`echo ${lastgalnum}+1 | bc`<br />
<br />
echo -e "\n\nFound DIRECTORY with ${high}$imgcount${low} images :\n ${high}$dir${low}"<br />
echo -en "\n Please enter the GALLERY NUMBER ( ie $galnum ) : "; read galnum<br />
echo -n " Please enter the MONTH (ie August 2010) : "; read postmonth<br />
echo -n " Please enter the ALBUM DESCRIPTION : "; read desc<br />
<br />
cat << EOT >> $outfile<br />
<!-- Gallery $galnum - $postmonth --> <br />
<br />
<nowiki><li> $desc <span class="PostedDate"> $posteddate</span> </nowiki><br />
<nowiki> <ul class="hoverbox listexpander"></nowiki><br />
EOT<br />
<br />
for picture in `ls $dir | sort | grep -v "__"`<br />
do #File Specific Stuff<br />
echo -e "\nImage : $picture"<br />
echo -n "Caption? : "; read caption<br />
<br />
subdir=""; subdir=`echo $dir | awk -F/ '{print $NF}'`<br />
#echo "Subdir = $subdir"<br />
thumb="";thumb=`echo $picture | awk -F. '{print $1"_t.jpg"}'`<br />
#echo "Thumbnail (picture - .jpg + _t.jpg) = $thumb"<br />
<nowiki><br />
cat << EOT >> $outfile <br />
<li><br />
<a href="images/$subdir/$picture" rel="lightbox[$galnum]" title="$caption"><br />
<img src="images/$subdir/$thumb" alt="" title="" /><br />
<img src="images/$subdir/$thumb" alt="" title="" class="preview" /></a><br />
</li><br />
EOT<br />
</nowiki><br />
done #File Specific Stuff<br />
<br />
echo -e " </ul>\n </li>\n<!-- End of Gallery $galnum -->" >> $outfile<br />
<br />
done #Directory Specific Stuff<br />
<br />
<br />
echo "Now run: cat $outfile -to see your code!"<br />
ls -l $outfile</div>Jeff