MSCRM-Admin
SharePoint 2010 Developer Dashboard
Developer Dashboard is one of the hidden features in SharePoint 2010. It is turned off by default.
Enabling this feature will help you get critical information such as Execution time, log ID, critical events, database queries, service calls, SPRequest allocation and webpart events.
Developer Dashboard Modes:
‘On’ Mode:
STSADM:
stsadm -o setproperty -pn developer-dashboard -pv on
Powershell:
$sp2010 = [Microsoft.SharePoint.Administration.SPWebService]::ContentService.DeveloperDashboardSettings;
$sp2010.DisplayLevel = [Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::On;
$sp2010.RequiredPermissions = [...]
Generating/Rendering a PDF from a sql reporting services report - CRM 4
sounds simple dosen’t it - my objective is to run an estimate report and render to PDF all from the click of a button as shown in the screenshot below:
Heres the code –
string oppID = Request.QueryString["oppID"].ToString();
[...]
This report requires a default or user-defined value for the report parameter ‘Parameter’. To run or subsribe to this report, you must provide a parameter value
ahhh sql reports — i mean come on this sounds like a simple parameter problem — however what seems to be the problem here is that in the report i was requesting from sql srs web services for CRM4 — you must define data source credentials with the datasource name being the datasource name on the report!!
then you get this error:
An error [...]
Server did not recognize value of HTTP Header SOAPAction http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices/Render
You will get this error with SQLSRS if you are using the ReportExection URL with webservices.
the correct URL is: http:///reportserver/ReportService.asmx
SRS 2005: Add a Page No to each Page
Adding a Page Number to a Footer
To display a page number in the header or footer of a report, create a text box in the footer and add the following expression:
=Globals.PageNumber & ” of ” & Globals.TotalPages
Linux: Quickly block an IP address from HTTP/HTTPS access using IPTables
/sbin/iptables -A INPUT -p tcp -s <source IP: 4.2.2.2> –dport 80 -j DROP
/sbin/iptables -A INPUT -p tcp -s <source IP: 4.2.2.2> –dport 443 -j DROP
Two quick MySQL tips
MySQL: Running a SQL script from the command line:
mysql mydatabase -u<mysql username> -p<mysql password> < /home/mysqlscript.sql
MySQL: Stopping a long query:
mysqladmin processlist
Get the id from the first column then run:
mysqladmin kill <ID>
Activating Windows shortcut command
c:\windows\system32\oobe\msoobe.exe /a
Get Mailbox Sizes in Exchange 2007 using Powershell
Paste the following into the powershell command prompt:
Get-MailboxStatistics -Database “mailbox database” | Sort -Property DisplayName | ft DisplayName, @{expression={$_.totalitemsize.value.ToMB()};label=”Mailbox Size(MB)”}, itemcount > c:\mailboxes.txt
a text file located at c:\mailboxes.txt should now contain the mailbox size information with item counts for each user.