Sharepoint 2010 - Web analytics API

Do you want to customize your Webanalytics report?
then probably you should be using webanalytics API to generate a custom report.

Here is the link on how to use the webanalytics API
 
http://blogs.technet.com/b/sharepointdevelopersupport/archive/2012/07/23/how-to-use-webanalytics-api-frontenddataretriever-querydata.aspx

WSS : Delete orphan records in sharepoint

We can use stsadm -o databaserepair  to delete orphan items
Please check out the msdn article http://msdn.microsoft.com/en-us/subscriptions/cc288636%28v=office.12%29.aspx

List of stsadm operations

Here is the list
http://msdn.microsoft.com/en-us/subscriptions/cc288413%28v=office.12%29.aspx