Use ITSMReporting go exec ReportingServices_PBM_TrendFor_ContactReasonMonthWise @Group=N'All',@User=N'FAREAST\v-srvana',@SubGroup=N'All',@ReportName=N'Trend Report Problem Records by Problem Contact Reason',@Status=N'Cancelled^@!Closed^@!Known Error^@!Open^@!Resolved^@!Reviewed',@Team=N'All',@Priority=N'1^@!2^@!3^@!4',@ProblemCategory=N'All',@ProblemSubCategory=N'All',@ServiceAffected=N'--^@!(blank)^@!Academy Support^@!Activation & Validation^@!Active Dir Risk Assess^@!Advertising and Online - Global Operations^@!Agreement Adjustment Tool^@!Anti-Malware^@!App Performance^@!Application Monitoring^@!Application Support Svcs^@!ASM E&D Service^@!ASM HSG Service^@!ASM MOPR ERP^@!ASM MSEXPENSE Service^@!ASM MSFinancing^@!ASM SAP^@!ASM STUDIOS Service^@!Asset Inventory^@!Authorization and Entitlement Services^@!Authorization Services^@!Authorize, Authent, Acctg^@!AVESupportServices^@!b^@!Backup^@!bi^@!BI Connected Sales Mrkt^@!BI Customer Support Svcs^@!BI Enterprise Services^@!BI Finance^@!BI Legal^@!BI Operations^@!BI Platform^@!Biztalk^@!Certificate Management^@!Certificate Services^@!CFIT Platform Svcs^@!Change and Release Mgmt^@!Client & Server Software^@!Client Data Analysis^@!Client Data Protection^@!Client Deployment (SCCM)^@!Client experience App mgm^@!Client Hardware^@!Client Hardware - Mobile^@!Cluster Service^@!Code Signing^@!Compensation and Benefits^@!Config, Automate & Data^@!Configuration Management^@!Connectivity Enablement Services^@!Consumer Device Access^@!Core OS Health & Diagnostic^@!Corp Telephony^@!Corporate Affairs^@!Corporate Finance Service^@!Corporate Tax^@!Create Info Agreement^@!csc^@!Cust Svc Rep CSR Tools^@!CustomCRM^@!Customer Svc & Supp (CSS)^@!Customer Svcs Regional^@!Defect Tracking^@!Development App Support^@!DHCP (NIS)^@!Digital Delivery^@!DigitalDelivery Reporting^@!Direct Internet Access^@!Directory Services^@!DMO Data Services^@!e3^@!ECC/GTS^@!eCommerce Order Fulfillment^@!ECOSE^@!ed^@!EMC^@!End Item Management^@!End User Downloads^@!Enterprise Device Access^@!Enterprise Messaging^@!Enterprise Services (ES)^@!Enterprise Svcs Regional^@!Enterprise Voice-Corp Tel^@!ESBI DB BD^@!ESBI LR BD^@!etrack^@!Exchange Corp^@!Exchange Hosted Svc VL^@!Exchange Online^@!Exchange Other Forest^@!Explore.MS^@!Fasthelp Portal^@!Federation Services^@!Field IT Infrastructure^@!Finance^@!Finance Accounting & Compliance^@!Finance Accounts Payable^@!Finance Audit Tax^@!Finance Forecast & Planning^@!Finance Internal Audit^@!Finance Physical Security^@!Finance Procurement^@!Finance Project Accounting^@!Finance RE&F^@!Finance Tax Audit^@!Finance Treasury Service^@!Finances- Regional^@!FIT Platform^@!General & Admin Regional^@!gentran^@!Global Change Operations^@!GS BD^@!Hardware Load Balancing^@!Headcount Services^@!HR People Org Capability^@!HR Platform Services^@!Human Resource Staffing^@!Human Resources- Regional^@!Identity Services^@!Imaging^@!Incentive Compensation^@!Incident Management.Incident Management^@!Info Agreement - Retrieve^@!Info Agreement - Storage^@!Info Security App mgmt^@!Information Security^@!Infra Service App mgmt^@!Infrastructure Incident^@!IntelliMirror Service^@!Internet Egress^@!IP Allocation Service^@!IP and Asset Mgmt^@!IT Cloud^@!IT Service Mgmt^@!IT Site Services^@!JADE Biz Desk^@!JADE Reports BD^@!JADEDMBD^@!LCA Tech Support^@!Learning^@!Learning and Readiness^@!Learning and Readiness^@!Learning Certification Systems^@!Legal Fees & Invoicing^@!Legal For Immigration ^@!Legal Platfrom Services^@!Legal Records Management^@!Legal Web Services^@!Legal&Corp-Regional^@!License Activation^@!License Administration^@!Licensing - Compensation^@!Licensing - Pricing^@!Licensing - Reporting^@!Licensing - Entitlement^@!Licensing - Fulfillment^@!Licensing - Order^@!Licensing - Quote^@!Licensing - Regional^@!Licensing eAgreements^@!Licensing Processing & Op^@!LIR^@!Lync Audio Conferencing^@!Lync Enterprise Voice & Corp Telephony^@!Lync Instant Messaging/Presence & Primary Services^@!Lync Online Meeting, Video, Desktop, & Application Sharing^@!Major Incident Non-Op^@!Marketing Services^@!Marketing-Regional^@!Master Data Management Services^@!Materials Management^@!mercury^@!MERT^@!Messaging and Calendar Services^@!Microsoft Service Enterpr^@!Microsoft Standard Device^@!Mobile Germany^@!MS Business Solutions^@!MS Learning Support^@!MS Retail^@!MS Retail Stores^@!mscissrvr^@!MSL^@!MSLI Help Desk^@!MSS^@!MSS/FEEDSTORE^@!Name Resolution Services^@!Network - Data Center^@!Network – MSFTOPEN^@!Network - Wired^@!Network - Wireless^@!Network Monitoring^@!Network Performance Rpt.^@!none^@!Non-Prod Mgmt - Biz Intel^@!Non-Prod Mgmt - Corp Func^@!Non-Prod Mgmt - FieldIT^@!Non-Prod Mgmt - ICOE^@!Non-Prod Mgmt - MBS^@!Non-Prod Mgmt - Partners^@!Non-Prod Mgmt - RDS-DS^@!Non-Prod Mgmt - RDS-HBI^@!Non-Prod Mgmt - RDS-MBI^@!Non-Prod Mgmt - SAP^@!Non-Prod Mgmt - VLIT^@!OA Activation^@!OA Billing^@!OA Billing Non-Prod^@!OA CBR Non-Prod^@!OA Fulfillment^@!OA Fulfillment Non-Prod^@!OA Inventory^@!OA Order Mgmt^@!OA Order Mgmt Non-Prod^@!OA Provisioning^@!OA Reporting^@!OA Returns^@!OA User Access Non-Prod^@!OEM^@!Off Site Facility^@!Outbound Royalty Svc^@!PA Applications^@!Partner Learning Services^@!Partner Member Services^@!Partner Portal Service^@!Partner Redemption Services^@!Partner Serivces^@!Partner Services^@!Partners Service Desk^@!Payroll Service^@!PrintingReleaseSRV^@!Problem Management^@!Product Activation Supp^@!Product Change Notice Mgt^@!Product Data Info Desk^@!Product Launch Svcs - EOC^@!Product Management^@!Product Pricing Reports^@!Product Reporting^@!Product User Admin^@!Program delivery App mgmt^@!PRSS ITSM Admin Srv^@!PSR BD^@!PublicPrint-DigitalCampus^@!r^@!RBF BD^@!Release and downloads^@!Release JIT PK Fulfilment^@!Release PK Fullfillment^@!Release Virus Scanning^@!Remote Connectivity^@!Replication Services^@!Response Management^@!RXD Foundation Svcs^@!Sales Services^@!Sales-Regional^@!SAP^@!SAS^@!Secure Patch^@!Self Managed Assets^@!Server Core Monitoring^@!Server Maintenance Regional^@!Server Management (ST)^@!Service App mgmt^@!SharePoint Custom Srvc^@!Sharepoint Enterprise Collab^@!SharePoint Online^@!Sharepoint Shared Services^@!SMS&P Regional^@!SMSGR BAR Support^@!SMSGR Help Desk^@!Social Enterprise Services^@!SoftwareReleaseSRV^@!Source Code Archival^@!Source Code Mgmt^@!SQL Ops^@!Storage Utility^@!Subscription Kit Mgmt^@!Subscriptions Management^@!Tenant Hosting Service^@!Test Harness support^@!Test Harness support (Windows)^@!Unicorn BD^@!VBOS^@!vlsc^@!Volume Licensing eAgreements^@!Volume Licensing Fulfillment^@!VSTF onboarding^@!Windows Debug & Diagnostic (WinDDT)^@!Windows Name Resolution^@!Windows Services Core Infra Service^@!Windows Update Svc (WSUS)^@!wired network^@!WW Incentive Comp^@!xena^@!XIT non prod service',@RootCauseCategory=N'All',@RootCauseSubCategory=N'All',@ContactReason=N'0 Labors Charged^@!Access Denied^@!ALERT: Access Point Down^@!ALERT: Application Service Failure^@!ALERT: Device Down^@!ALERT: Gateway^@!ALERT: Hardware Fault^@!ALERT: Job Failure (SQL Core)^@!ALERT: Link Down^@!Alert: OSPF - ADJCHANGE^@!AMEX Charges Not Linked to AMEX Account^@!Application Error^@!Application Issues^@!Application Performance^@!Build Connectivity Errors^@!Calendar Sharing^@!Cannot Access Internal Resources^@!Cannot Hear/Be Heard on Calls^@!Cannot Login to Lync on PC^@!Cannot Open Expense Reports^@!Cannot Print Expense Report^@!CASE Missing^@!CASE Status Issue^@!Contacts Missing^@!Content Loading Slowly^@!Customer Request^@!Dashboard Not Appearing with Correct Data^@!Data Discrepancy^@!Data Issues^@!Data Missing in Reports^@!Data Missing/Incomplete/Inaccurate (sync issue)^@!Data Not Accurate^@!Data Not Delivered to Downstream^@!Data not Visible^@!Double Labors Charged^@!Error 403: Access Forbidden^@!Error Occurred Trying to Submit Report^@!Error: Access Denied^@!Error: Accessing partnersource^@!Error: Catastrophic Failure^@!Error: CRM Error^@!Error: Exception^@!Error: General outage^@!Error: Job Failure: Client - Space Insufficient^@!Error: Monitoring OS Alert^@!Error: Monitoring SQL Alert^@!Error: Navigation^@!Error: Service Plan Quote Pricing^@!Error: Specific Error Message or Dialog^@!Error: System Alert^@!Error: System Not Available^@!Error: Webpage Cannot be Found (HTTP 400/404/410)^@!Error: Website Cannot Display the Webpage^@!ETL failure due to Data Issue^@!ETL Failure due to General Network Error^@!Function Not Working^@!History returning error^@!Incident^@!Incorrect Charged Labors^@!Incorrect Owner^@!Incorrect ROSS Details^@!Informatica Job failure due to data issue^@!interface issues^@!Issue : Performance^@!Issue : VSTF - Functionality Error^@!Issue: 3DAPI Data Pull^@!Issue: Access ^@!Issue: Accessing agreement information^@!Issue: Accessing My account^@!Issue: Accessing operations request^@!Issue: Accessing Site^@!Issue: Account^@!Issue: Agreements not reflecting in Voice for CRM on premise customer ^@!Issue: Alert: MOM/SCOM^@!Issue: Alerts^@!Issue: Application down^@!Issue: Application Launch Failure^@!Issue: Audio^@!Issue: Autobill unable to renew BREP due to error^@!Issue: Autobilling failed due to an error Timeout expired^@!Issue: Batch Job^@!Issue: BREP calcualtion for Specific Period^@!Issue: Bug template Issue^@!Issue: Building Outage^@!Issue: Calendar^@!Issue: Cannot Connect to Web Application^@!Issue: Cannot Submit Purchase Order^@!Issue: Cannoto place order^@!Issue: Certification missing^@!Issue: Client End^@!Issue: Configuration break/fix^@!Issue: Connection^@!Issue: Connectivity Failure^@!Issue: Console - Alert Storm^@!Issue: Console - Hang/Performance^@!Issue: Contract Details not udpated due to MBS Order Sync issue^@!Issue: Crash/Hang/Freeze^@!Issue: Credit Limit Sync^@!Issue: CRM Online Account Sync issue^@!Issue: Cube latency^@!Issue: Data discrepancy^@!Issue: Data Missing/Incomplete/Inaccurate^@!Issue: Data not visible^@!Issue: Data visibility^@!Issue: Depot slow performance^@!Issue: Desktop Sharing^@!Issue: Dialing^@!Issue: Drive^@!Issue: Duplicate Items^@!Issue: Email problems^@!Issue: Event Notification^@!Issue: Feature Unavailable or Not Functioning^@!Issue: File Publishing^@!Issue: File Transfer^@!Issue: Free Busy Info^@!Issue: FTC - Ping Failure^@!Issue: GTM Issues^@!Issue: High CPU / Memory Usage^@!Issue: Incentives^@!Issue: Incorrect active and inactive agreements^@!Issue: Incorrect customer add^@!Issue: Incorrect data^@!Issue: Incorrect information on profile^@!Issue: Incorrect Quote price^@!Issue: Incorrect regsitration Date^@!Issue: Incorrect Revenue for specifc month^@!Issue: Installing^@!Issue: Intermittent connectivity^@!Issue: Issue with order partner service plan^@!Issue: Job failure^@!Issue: License Key^@!Issue: Lost Data^@!Issue: Low Space / No Space on SAN^@!Issue: Maintenance Required^@!Issue: MCP Exams are not updated in VOICE^@!Issue: Missing items from view^@!Issue: MSCS Cluster - Resources / Disk Offline^@!Issue: No Response to Update Requests^@!Issue: Noise/Interference on calls^@!Issue: Non-Delivery Receipt (NDR)^@!Issue: Old account visible^@!Issue: OS Service^@!Issue: Our Apologies error message while creating quote^@!Issue: Outlook Integration^@!Issue: Permission^@!Issue: Permissions^@!Issue: Project Connectivity^@!Issue: Raise Support Incident ^@!Issue: RBA Enable^@!Issue: Receive^@!Issue: Registration^@!Issue: Renewal quote failed to generate in quote ^@!Issue: Reporting^@!Issue: Roles and Permission^@!Issue: ROQ DS vault^@!Issue: Scheduling^@!Issue: Search^@!Issue: Service Availability^@!Issue: Setup^@!Issue: Slow Performance^@!Issue: Slow Running Query^@!Issue: SQL Job failures^@!Issue: Sql server jobs issue^@!Issue: Suspended Messages^@!Issue: System not available^@!Issue: Timeout^@!Issue: Unable to access resources^@!Issue: Unable to add modules^@!Issue: Unable to Join Conference Bridge^@!Issue: Unable to Obtain IP Address^@!Issue: Unable to RDP (Terminal Services)^@!Issue: Unable to release spec^@!Issue: Unable to view status of order^@!Issue: Unsupported^@!Issue: Upgrading^@!Issue: User Education^@!Issue: Web Part/Content^@!Issue: Workflow^@!Issue:Client connectivity^@!Issue:Client performance^@!Issue:Resource Access^@!Issue:Sql\Application Job failure^@!Job Failure^@!Job Failure due to Data Issue^@!Job Issue^@!Job Not Progressing^@!Login/Access Issue^@!Major Incident^@!Manager Unable to Approve Report^@!Negative Trend Report^@!Opportunity rejected by WWLM^@!Orphan CASEs^@!Other / No Taxonomy Available^@!Other/No Taxonomy Available^@!Performance Analysis^@!Proactive Readiness^@!Project Information is Not Available^@!Receipts Not Updated^@!Reporting Access^@!Server not connected from specific domain/IPV^@!Slow Performance^@!Specific Error^@!Thematic Problem^@!Unable to Access Application ^@!Unable to Access Reports^@!Unable to Export^@!Unable to load my connect form^@!Unable to run PDF^@!Unable to see the core priorities^@!Unable to Validate^@!Unable to View Data^@!Unexpected Error Encountered^@!Unplanned Outage or Delay^@!Video Not Playing^@!Workflow Error',@ContactReasonType=N'(blank)^@!Proactive^@!Reactive',@KnownErrorFix=N'(blank)^@!NULL^@!Permanent Fix^@!Workaround',@LinkedModule=N'Problem Management^@!Incident Management^@!Major Incidents^@!Task Management^@!Change Management^@!Request Fulfilment',@FiscalMonth=N'Null',@DetailLevel=N'Detail',@ProcessingID=N'20141231074529'