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

FROM

(

SELECT d.DependencyID, d.ParentUri, p.DisplayName AS ParentDisplayName

FROM Orion.Dependencies d

JOIN System.ManagedEntity p ON p.Uri = d.ParentUri

) dp

JOIN

(

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.

FusionTables.png

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.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Table_data.png

 

 

Take a moment to admire your data, and click Next then Finish.

See your data in the Fusion Table?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Network_Graph.pngOn the "Help" Menu  Select "Switch to Classic View".  You should now see the "Labs" menu option

From the "Labs" menu, select "Network graph", and you should now see your beautiful map.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

publish.png

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.