.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How do I access Usage Reports Top Queries programmatically

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :SharePoint
Hi, I need to retrieve the top queries from the Usage Reports? Do I need to fetch it directly from SQL or are there classes that does this for me? Regards, Martin

View Complete Post

More Related Resource Links

Provisioning: Use Web Services Provisioning to Control Access, Usage, and Billing on Your Site


Building Web Services to provide enterprise-level solutions is only the first step. You need to take care of the infrastructure aspects of your solution as well, including provisioning, billing, security, and reporting. In this article, the author uses the .NET Framework and SQL Server 2000 to design a provisioning system that will take care of all these housekeeping tasks. He discusses the general requirements of a Web Service provisioning system, walks through the implementation, and then outlines various scenarios for putting this system to work.

Chandu Thota

MSDN Magazine December 2002

Usage of Client Access Policy and crossdomain xml for sharepoint 2010>?


Hi Folks,

1.What is Clientaccesspolicy.xml in sharepoint ?

2.What is Crossdomain.xml ?

What is usage of wcf service deploy in sharepoint 2010?

Kindly give me some valuable comments ?


Thank you


Immanuel c


Search Usage Reports Missing for Site


We have Usage Analysis enabled on our employee portal farm.  The SSP in this farm crawls all local SharePoint sites and one child farm.  When we view search and query reports, one of the site collections (in a dedicated web app) is missing.  All other web apps/site collections appear in the search/query reports.  The missing site collection is using the standard search pages and web parts - no customization with the object model that might break usage logging.

Has anyone else ran into this or know the solution?

Share Point integrated SSRS reports rendering when access from external site


Our client has a SharePoint (moss2007) site on Windows 2008, SQL2008 R2 Enterprise, and Reporting service is integrated with SharePoint

The authentication on the share point integration is set to windows, else the authentication for the SSAS datasource gives and error

The extranet zone ( forms) and intranet (Customer Forms) and default (Windows) zones are all access from inside the firewall and the reports render in each with no issues, as the datasources are configured to pass a sql username and password.

However, report rendering is a problem from the internet (external site), the following error is displayed:

An unexpected error occurred while connecting to the report server. Verify that the report server is avai

SSRS - Where are the Sharepoint Report Usage Reports provided by Microsoft



Microsoft provided 3 example reports for Sharepoint report usage. Does anyone know where they are located? I used them about 2 years ago.




Problems with Usage Reports

I am having problems with the usage reports on our farm.  I cant get to the site collection usage reports or the usage reports in central admin ssp.

I get file not found, so i made the change in the web config for the error and I get:

File Not Found.   at Microsoft.SharePoint.Portal.Analytics.UI.ReportControl.CreateChildControls()
   at System.Web.UI.Control.EnsureChildControls()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Everything has been enabled and the files exist in the correct locations on the server.  I am scratching my head on this one.

All servers are server 2008 x64 enterprise moss 2007 sp2 with august cu.

How to create strongly typed datasets with access parameter queries



How can you create strongly typed datasets using an access database against access select statements that use parameters?

The problem is VS.Net doesn't allow select queries with parameters to be dragged onto a form, it only allows access queries without parameters!

I also tried the dataadapter wizard, but again it only allows me to select queries without parameters?

Many thanks in advance


Programmatically Generated Reports (RDLC) ASP.NET C#

Good Day,   I been looking for a day now and I couldn't find a good source of information. I have a one of a kind report wherein the RDLC file including all controls are programmatically generated (system generated)  by one of my asp.net page. All fields and its values to be displayed on the RDLC file are coming a stored procedure. On my stored procedure I'm using a temp table for example #MyTable and its columns can adjust programmatically/automatically base on date range. BTW I'm using C# code to generate the RDLC file and preview it on the report viewer of a page. Sample: Date Range: 01/01/2008  to 12/31/2009  My temp table may look like below AssetCode, Description, Class,  Jan2008, Feb2008, Mar2008 --> until column reach Dec2009 AAAA00001, AAAAAAA,FF, 0.00, 0.00,1,00.00 --> some month#### column may not or may contain value base on my formula. AAAA00002, BBBBBBB,FF, 0.00, 1.00,1,00.00 --> some month#### column may not or may contain value base on my formula. AAAA00003, CCCCCCC,CE, 1.00, 1.00,1,00.00 --> some month#### column may not or may contain value base on my formula. I have no problem in retrieving all data on SQL Server using temp table and showing it on a system generated rdlc file even if I'm using

How to Access DCom Programmatically

Hi,   I am accessing the Excel sheet using interop components in my .NET c# application. To read or Write the Excel file i need to provide the permission in the Dcomcnfg.   At present, i am doing it mannaully. ie. opening DComcnfg.exe and location Microsoft Excel application and changing. How should i do it programmatically. ie. using C#/ VB .NET code   Thanks R.VasanthThanks Vasanth

How to link SharePoint List with MS Access 2007 programmatically

Hi, can anybody tell me how to link SharePoint List with MS Access 2007 without opening Access environment. I want to do it programmatically through C#/VB.net doesn't matter. Your help will very much appreciated. Thank you so much! -Jarexs

How to programmatically hide SSRS reports

I've built a process to deploy several reports to SSRS in either native mode or SharePoint integrated mode.  I'd like to programmatically hide several SSRS reports when deploying them to a sharepoint site.  I believe I need to do something like this -  http://www.mssqltips.com/tip.asp?tip=1357.  Any pointers?  I'm new to SharePoint development. Thx.

Farm or Web App Level Usage Reports?

Hi, I was wondering if any OOTB tools can be used to view/generate usage reports at a level higher than site or site collection?  I found the search queries and search results reports through Central Admin which provide some of this higher level/scoped info I'm looking for, but I'd love to find more (perhaps Farm Usage Summary, Farm Requests, Farm Destination Pages, etc.). thank you

Programmatically export reports


Hi all

I have the following configuration MOSS 2007 + SSRS 2005 running in moss integrated mode.

I have a bunch of reports in the MOSS 2007 document library and I'm looking for a way to do the following:

From a custom web part, when user clicks some button pass parameters selected by user on a web part to a report and export report to a fileshare.

I've tried to cope with subscriptions but I can't find how I can override reports parameters. It seems to me that I have to deal with SSRS service model directly since I wasn't able to find any other API.

So the question is how to do that with SSRS web services from MOSS web part programmatically? Maybe there is another way?

can i use Microsoft Access Queries with ADO.net ?


Hello all , 

can i use Microsoft Access Queries with ADO.net like Stored Procedures in SQL Server ? 

Thanks in advance 

Kareem Naguib

Cannot Access Reports from Computers Within Network




I am able to access reports from my computer that has the SQL Server (2008) installed, but can't seem to access from other computers in the network. All I get is

"The permissions granted to user 'MyComputerName\Guest' are insufficient for performing this operation. (rsAccessDenied)"

Can someone please help?

I tried creating user "MyComputerName\Guest" and assign permission to view reports, but still cannot get it to work. Am I doing something wrong?

Here are some details from my Report Services Configuration Manager

Service Account is set up to Use built-in account : Network Service

Current Report Server Database

SQL Server Name : MyComputerName\ServerName

Database Name : ReportServer$ServerName

Report Server Mode : Native

Current Report Server Database Credential

Credential : SQL Account

Login : sa

Password : **********



Public Access to Reports


I'm designing some reports to summarize recently compiled research findings.  These reports are going to be posted on an ASP.NET page (via the report control) on the web site.  I do not want to authenticate users, as the findings are meant to be public and requiring users to register and authenticate would add a barrier and is likely to decrease traffic.

I've seen similar posts where reports are meant to be viewed by everyone on an intranet and permissions could be set using a designated workgroup.  I need alternative solutions to the problem of making a report viewable by everyone who visits a site.  I'm also currently unfamiliar with Kerberos (and I know that will probably pop up as a potential solution), so if there's a convenient way outside of that it would be great.

user access reports


We've got a Sharepoint 2010 infrastructure that we're going to need to audit in a "who has access to what" type of report. Complicating things a bit is that we're using AD groups, so SharePoint often doesn't seem to know who's in whatever AD group, they just know the group has access. 

But our auditors want to know what no-kidding-human-being has access to what. I was wondering if there is a native way to do this, and if not, any recommendations on third party software approaches? Thanks so much!

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend