Using Visifire Charts in Sharepoint with SQL data – Part 1 has a nice silverlight charting library that does animated charts and graphs.

My employer was looking to do up a Dashboard in SharePoint and I used Visifire, the Sharepoint Content Editor Web part and a few back end aspx pages to grab data from various sql servers to present the graphs.

I’m doing a video series on the basics of how to do it.

This first video introduces visifire, downloads some samples and walks through getting the sample to work locally on your PC.

Part 2 will discuss the Visifire Chart Designer.
Part 3 will show how to copy the needed files to SharePoint and how to put the relevant HTML in a SharePoint Content Editor WebPart.
Part 4 talks about how to move Source XAML to a separate file.
Part 5 talks about one way to construct a back end ASPX page to produce the XAML and feed it back.
Part 6 talks about how to modify the ASPX page to query a database and produce live data
Part 7 talks about how to move that page onto the SharePoint Server.

Remove stubborn/stuck computer objects from MS SCOM

I work with a network monitoring tool from Microsoft called System Center Operations Manager (SCOM for short)
The version of SCOM I use (2007 R2 with Fix rollup 2) has an issue that seems to affect computers that are part of a cluster –
The computers could not be deleted, which is a bit of a pain.

This query was provided by a MS support rep, the first query should return a GUID for the object(s) that match the computer name
The second gives you a preview of what you’ll change.
the 3rd actually changes the objects in the database to deleted status.
note that it doesn’t actually delete anything, it just updates the values.

Select TopLevelHostEntityId from basemanagedentity where Name like ‘%ComputerName%’

Select * from basemanagedentity where TopLevelHostEntityId = ‘GUID’

Update BaseManagedEntity Set Isdeleted=1 where TopLevelHostEntityId = ‘GUID’