When looking for web graphing apps which could take multiple series of data and plot them on a graph suitable for embedding on a web page I came across a simple, and free, Flash graphing application worth mentioning. Although my journey started with AJAX, I soon found the Flash-based graphs amCharts provides were more than sufficient. You can embed these into a website, or a security metrics site, while retaining control of the data. Data is formatted in xml (giving more control over the graph) or in a csv format. The simple to use settings files are also in xml, giving you a lot of control around the graph fonts, colors, and forms.
In fact, the most difficult part of using amChart graphs is going to be pulling data in from the various data sources and updating the xml data files. While this is a work in progress, I thought it would be worth sharing this and some quick examples below. I should also mention that PHP scripts exist to pull data from a database and into the correct format. For more information see the amcharts site.
The first chart below is from the amCharts site. Click and drag on a portion of the graph you would like to highlight and try out the scroll bar at the top of the graph. This is helpful for graphs that show trends, yet have granular underlying data that may be hidden. The second pie graph is my gift to Art…and fairly accurate I might add.
Please upgrade your Flash Player to view these graphs
|
Please upgrade your Flash Player to view these graphs
|
Another mention should go out to a fairly new site called Timetric. Timetric allows you to graph data by entering fields manually, uploading a csv or xls file, or pulling data through an api. I did try this out and had some issues in formatting and uploading the data to produce graphs. It would also be obvious that these graphs are stored on a third-party server…something to keep in mind should you plan on using this for any data deemed sensitive. Here is a quick example from the site.
Graphing sparklines may appeal to those who have read the Edward Tufte books (I’m looking at you AJR) on the visual representation of data. On his blog he talks about sparklines here. If you consider yourself part of this group there is a pre-written Javascript sparkline generator you may be interested in by the name of jquery sparklines.
To set this up you’ll need: 1. Some data to graph, 2. A webserver where you can host the js and html files, 3. jquery and jquery.sparklines, 4. Some basic Javascript skills…maybe PHP or Phython if you plan on generating dynamic content for the lines.
Disclaimer: I used the graphs and data directly from the sparklines site because I’m too lazy to create my own numbers. Note that I’m limited in this post as I can’t use var or span id tag in a post, so these example all have inline static data. For an example of one using dynamic data see this page.
Example Sparklines:
Inline Sparkline: 1,4,4,7,5,9,10
Bar charts negative values:
Composite inline 8,4,0,0,0,0,1,4,4,10,10,10,10,0,0,0,4,6,5,9,10
Dow 90,10,25,150,180
Chances that Art will think sparklines bring any value
So I realize this isn’t exactly security related, but I felt compelled to post since it relates to errors with the Windows Update service. I recently dusted off some old virtual machines which were running Windows Server 2003 and when attempting to update via WU I encountered error 0xC80003FB and 0xC80003FA. These errors do not quite explain what your potential issues may be and in searching for the answer I came across some posts which actually worked and others which left me scratching my head. If you encounter this error, here are a few things to try:
View the contents of your Windows Update log file to see what it is complaining about. This file is located in %windir%/WindowsUpdate.log. The last few lines will show your most recent attempt at running WU. If you see the following lines:
WSUS server: http://name ofyourinternalWSUSserver
WSUS status server: http://name ofyourinternalWSUSserver
Target group: (name of the group this system was in…may be Unassigned Computers)
Windows Update access disabled: No
Then your system was trying to connect to WSUS. What I found interesting is that I had allowed this system to go out to the internet for updates as part of the WSUS options, yet it failed. Ask yourself if you added this machine to a WSUS installation and then deleted WSUS. I was testing WSUS at some point in the past and had pointed this system to the WSUS server for updates which is not longer part of my test environment. Here are some steps you can try that worked for me:
Stop the Windows Update service by going to Start->Run->service.msc
Backup, then delete, the registry key located at HKLM/SOFTWARE/Policies/windows/windowsUpdate (you’ll notice this has the WSUS server info you may have entered at some point in the past)
Restart the Windows Update service and go Windows Update
If this doesn’t work continue on to the next steps (I have a bad habit of trying many things at once when troubleshooting)
Stop the WU service again. Go to %windir%\SoftwareDistribution and find the DataStore directory. Delete the .edb file and Logs directory from this folder and restart the WU service. Try to connect to WU. If this doesn’t work, you can stop the WU service, rename the Software Distribution folder to something else, restart the WU service and again run Windows Update. This will rebuild that entire directory and should remove any corruption you had in these files that was causing an issue. In the end, a combination of removing the reg key and deleting the database worked to get updates flowing again. Hope this help.