So, I’ve got this cron job running to log the results of the uptime command every 5 or 10 minutes. Well, it does a timestamp and then adds in the three load values in a tab separated format. Then I can load this into excel for pretty graphs and stuff and see why over night jobs slowed down at certain points.
It is the loading into Excel point where I come a cropper. After all, windows and unix timestamps differ wildly. Although luckily for us not is a cryptic way. So that leaves two options. Store the values in the csv file as a windows value, or simple apply the following formula:
=(A1 / 86400) + 25569
And here this post comes to a sudden end…
Home > About This Post
This entry was posted by Chris Andrews on Thursday, February 1st, 2007, at 3:57 am, and was filed in Windows.
Subscribe to the
RSS 2.0 feed for all comments to this post.
Post a Comment