For those of you not familiar with Google Fusion, it's the latest (beta) data visualization tool to come out of the Mountain View Chocolate Factory. Among other things, it can make some pretty awesome charts and maps.
Since we here at SolarWinds subscribe to all sorts of geekery, we thought it only fitting to pump our topology and dependency data into it and see what came out. As you can see from the video below, the results are pretty awesome.
So how does one go about creating such a cool map and putting it in NPM?
First, you'll need the SolarWinds SDK installed (http://thwack.solarwinds.com/thread/39001)
Then open SWQL Studio and attach to SWISv3 with your Orion Credentials.
For topology data, use the below query:
SELECT d.Caption AS DestCaption, s.Caption AS SrcCaption FROM Orion.TopologyData t
JOIN Orion.Nodes s ON s.NodeID = t.SrcNodeID
JOIN Orion.Nodes d ON d.NodeID = t.DestNodeID
For Dependencies, you would use the below query:
SELECT dp.ParentDisplayName, dc.ChildDisplayName
SELECT d.DependencyID, d.ParentUri, p.DisplayName AS ParentDisplayName
FROM Orion.Dependencies d
JOIN System.ManagedEntity p ON p.Uri = d.ParentUri
SELECT d.DependencyID, d.ChildUri, c.DisplayName AS ChildDisplayName
FROM Orion.Dependencies d
JOIN System.ManagedEntity c ON c.Uri = d.ChildUri
) dc ON dp.DependencyID = dc.DependencyID
Right click on the results and save as a CSV file to your local hard drive.
Now let's go over to Google and search for "Fusion Table"
Select "Create" (you may need to login with your Google account credentials)
Select "Choose File" and select the file you have saved from SWQL Studio and click Next.
Take a moment to admire your data, and click Next then Finish.
See your data in the Fusion Table?
From the "Labs" menu, select "Network graph", and you should now see your beautiful map.
Click on the "Get embeddable code" button and select the "Change Visibility" link
Select "Anyone with the link". Click "Save"
Change the Height and Width to your desired size. This size will need to be smaller than your column width in your Orion Page you will be putting the resource on minus about 50 pixels. So if my Orion page column in 850, then I set 800 Width here.
Copy the "Paste HTML to embed in website" text. Keep in your clip board for future use
Go to NPM, navigate to the page you want to place your Fusion Graph Map on.
From here it's a simple process of creating a Custom HTML resource. This has been covered previously here: http://thwack.solarwinds.com/community/solarwinds-community/product-blog/blog/2010/08/05/hidden-gem-the-custom-html-resource
Once complete, get ready to impress your friends, family, and co-workers. Well, perhaps not, but you likely won't be able to stop playing with the new map.