Home

User Manual SharePoint Farm Reporter

1. Schedule Properties Last Modified date Se 2008 2 39 14 PM Schedule At 2 38 PM every day starting 5 6 2008 rd i spadminuserz in E Actions Pane Enables you to perform operations on Tasks Actions pane is visible by default You can close it while you do not want to do any operations on the task Click Power Reports gt Show Actions Pane from the tool bar or select Tools gt Power Reports gt Show Actions Pane from menu bar or press CTRL H to activate the actions pane 63 CHAPTER 4 Power Reports Actions Pane x Task Actions hew Edit Copy E Delete Ey CleanUp History a Run Mow 1 Create Windows Task History Actions a Task activity view 2 Refresh X Remove gel Task Status 64 CHAPTER 4 Power Reports 4 3 New Task Click New from Actions Pane or press ALT N to open the New Task dialog New Task dialog is shown below Specify the following fields to create the Schedule Task Click Add to select the reports for this task Click Edit to change the settings for the selected report Click Delete to remove the selected report Task name SampleTask Run as VOVAGERYdEt spadiminuser2 Set Password Domain Mame User Mame Schedule task Daily Start time 02 38 Pl Advanced Schedule Task Daily Every fi day s Report Settings Reporth anne Scope Criteria ListT emplate Groupp D p gt View Report Settings dh Add a Edit A Delete
2. Valid site URL Basic rights view Pages Browse Directories are enabled For the corresponding web application Currently logged on user account has basic rights View Pages Browse Directories in the respective site Currently logged on user account must be an Application Pool user account or must be a member of Administrators group in SharePoint Server and Database Server 112 CHAPTER 6 References If the site URL is valid please ensure the currently logged on user has View Pages and Browse Directories rights in the respective site Also the currently logged on user must be an application pool identity account or must be a member of local Administrators group in the SharePoint server and database server SharePoint Farm Reporter Unable to connect to http ird2 ssitesylist Please ensure the A Following Valid site URL Basic rights view Pages Browse Directories are enabled For the corresponding web application Currently logged on user account has basic rights View Pages Browse Directories in the respective site Currently logged on user account must be an Application Pool user account or must be a member of Administrators group in SharePoint Server and Database Server 10 If the list URL is valid please ensure the currently logged on user has View Pages and Browse Directories rights in the respective site where the list resides Also the currently logged on user must be an
3. SlideLibrary False Biz ppsListTemplates False ReportListTemplate False DataConnectionLibrary False workflow History Lists WorkFlowHistoryList Provides support For workflow history lists True SharePoint Portal Server Report Library ReportListTemplate SharePoint Portal Server Report Library No code Workflow Libraries NoCodeWorkflowLibra Provides support for no code workflow libri Surveys Lists SurveysList Provides support for surveys lists for a site mom te tert sae mlae hes e eaim Number of rows 291 Web Application Features Report Category Audit and Compliance Reports Web Application Features to view information about activated features and its dependency details for all web applications Displays the following information Web Application Feature Name Feature Folder Name Description Action Dependency Feature Hidden 21 CHAPTER 1 About SharePoint Farm Reporter a OAN NOA O TN A Quick Reports Power Reports Custom Reports Quick Filter Custom View Find Refresh Publish Export E mail Print Preview Report Web Application Features URL Scope Jll web applications Group by Web Application web 5 Feature Folder Action Dependency Feature PageConverters SearchandProcess BulkvytorkFlow Timer Job Features such as Visio Services Access Services and Excel Services included in th icin RiDS Rid El Document to Page
4. Billy F Doctrove Billy F Doctrove AuditTest1 Form Document NA 20 03 2012 12 20 53 VY APINLAB billy Billy F Doctrove Billy F Doctrove AuditTest 1 Forms List AuditTest1 23 03 2012 12 54 40 SHAREPOINT system AuditTest1 Forms Document NA 23 03 2012 12 54 40 SHAREPOINTI system E E 7 oe Re Pare ee 7 15 CHAPTER 1 About SharePoint Farm Reporter Checked Out Documents Report Library Only Report Category Audit and Compliance Reports Checked Out Documents Library only to view the files that are checked out in the last N days or for the given date range in the connected library This report displays the following information Web URL Web Title Item URL Created By Created Date Size in MB Checked Out By Checked Out Date Check Out Status To generate report for given date range click button and enter Start date and End date After entering Start date and End date click button Size in MB Displays actual disk usage information of the current document SharePoint Farm Reporter calculates the exact size in terms of bytes for all the documents in the connected library Check Out Status Displays the status of the check out indicating whether the check out is long term or short term B Y a l 2 Quick Reports Quick Filter Custom View Find Refresh Publish Export Print Preview Report Checked Out Documents Library only URL Attosird65 5010 Shared Documen scope
5. Specify the name and Schedule the task Click Add to add reports to the task 65 CHAPTER 4 Power Reports Step 1 Report Selection page Reports Wizard Add Report Select Report Select the desired report to add to the task reports list E e D21 Standard Reports eat Audit and Compliance Reports z Ef Audit Checked In Items a Description Displays the list tems checked in in the last A days E Audit Checked Out Items a Audit Copied Items E Audit Deleted Lists Fields E Audit Deleted Sites Web URL ae Audit Group Member Changes ee B ist Mame i 5 Aue Iter Aces jean Audit Page visits Item Type a Audit Permission Changes item Name z Audit Permission Level Changes Occurred me Audit Profile Changed Performed By a E Audit Renamed Items 2 a Audit Restored Items A Audit Search Audit visited Items lt lt Back Next gt Finteh Cancel a Select the required report to add You can view a short description and the fields for the selected report in the right panel b Click Next to proceed to the next step Click Back anytime to go back to a previous step Step 2 Scope and URL page This step is applicable for all the site and list category reports This step is not applicable for few reports under web application category Perform the following steps in this screen a Select the
6. select an operator and specify a value in the value text box You can use QND to Filter OR to filter paranthesis buttons to build enhanced Filter condition Report Name Site Collection Administrators Field Operator Value MMDD Y hh mm ss Created Date gt OND to Filter Web Application Contains Test Created Date gt 07 01 08 12 00 00 AM A Cancel c Use AND to Filter and OR to Filter parenthesis etc to build an enhanced filter condition as shown in the example below Web Application Contains Test OR Created Date gt 07 01 08 12 00 00 AM d Click OK in Criteria dialog to go back to the criteria page 96 CHAPTER 5 Custom Reports The added criteria will be applied to the report as shown below Specify Report Criteria The following list shows the criteria for the custom report Click Edit to specify the criteria to filter report data Optional Click Nest to proceed Web Application Contains Test OR Created Date 07701708 12 00 00 AMH a Click Next to proceed to the next step 97 CHAPTER 5 Custom Reports Step 4 Report Summary This step displays the summary information for the selected report Report Summary The following table shows the summary details of the custom report Click Finish to save the report settings Custom Report Hame Custom Site Admin Report Description This report retieves s
7. 1 19 CHAPTER 1 About SharePoint Farm Reporter Site Collection Features Report Category Audit and Compliance Reports Site Collection Features to view information about activated features and its dependency details in site collections Displays the following information Web Application Site URL Feature Name Feature Folder Name Description Action Dependency Feature Hidden Field Name Description Feature Folder Name Displays the Feature Folder Name of the Feature Action Dependency Feature Displays Feature on which activation of this main Feature depends Hidden Displays Boolean value that indicates whether the Feature is hidden within the Windows SharePoint Services user interface eee E Wop n p re Quick Reports Power Reports Custom Reports Quick Filter Custom view Fin Refresh Publish Export E mail Print Preview Report Site Collection Features URL Scope All web applications Group by web Application Feature web E Action Dependency application Site URL Feature Mame Be Description E e http jfrd30 S080 WebPartAdderGraups WebPartAdderGraups http rd30 5051sites q SharePoint Server Enterprise Site Collection features PremiumSite Features such as InfoPath Forms Se WebPartodderGroups WebPartAdderGroups SharePoint 5060 http frd3o 5060 WebPartodderGroups WebPartidderGroups SharePoint 80 http jird30 webPartAdderaroups y 4 H oh Error Number of rows 463 20 CHAPTER 1
8. COPY ABOWE THIS LINE Image 2 How to copy license key screen 36 Chapter 2 Using SharePoint Farm Reporter 2 1 How to Get Started with SharePoint Farm Reporter Before beginning to use SharePoint Farm Reporter to generate reports you must enable a few settings and configure the application database as outlined below 1 SharePoint user permissions SharePoint Farm Reporter uses the currently logged on user account while running Quick Reports under interactive mode and uses Run As account while running Power Reports task run as a scheduled task or using Run Now option to generate the corresponding reports SharePoint Farm Reporter requires the above mentioned user account to be a Member of administrators group in SharePoint Server and Database Server This will be useful if you are generating reports for multiple SharePoint sites residing in different web applications OR b Application pool user account of a web application This will be useful if you are generating reports for a single web application hosting the SharePoint site OR c Farm Administrators group of the SharePoint farm Recommendation It may be of help to use a domain admin account who is member of administrators group in SharePoint and the SQL Servers to generate the SharePoint reports for all web applications seamlessly 2 Audit Settings SharePoint Farm Reporter provides Audit Reports across Site Collections and Lists You have to enable
9. Shared Documents Shared Documents Content Document Conkent_modifications 6 16 2012 11 25 46 4h SHAREPOINT system 6 22 2012 6 47 16 PM SHAREPOINT system Sumber of rows 11 Audit Copied Items Report Category Audit and Compliance Reports Audit Copied Items displays the list items that are copied to another location in the last N days or for the given date range This report displays the following information SharePoint 2007 Web URL Web Title List Name Source URL Destination URL Item Type Item Name Item Occurred Performed By To generate report for given date range click button and enter Start date and End date After entering Start date and End date click fd button CHAPTER 1 About SharePoint Farm Reporter Ei TTE Y Zr e Al fo amp Wl FF Quick Reports Power Reports Custom Reports Quick Filter Custom View Find Refresh Publish Export E mail Print Preview Scope All lists in the connected site Group by Web UAL Date range Last 7 days List Mame Item Type Item Mame Source URL Destination URL Web Title eb URL Bulk Migration Testi Shared Docun Shared Documents 4udit visite Http ird10 9001 fbest 4 Document Audit Visited It Shared Documents Blocked File T http frd10 9001jtest1d Document Blocked File Type Shared Documents ohared Documents Bulk Migration Testing Site xls Bulk Migration Te Sumber of rows 3 SharePoint 2010 Web URL W
10. Web Parts 7 11 Web URL 8 9 10 11 12 13 14 15 WebApplicationName 67 Windows SharePoint Services 1 16 Windows Task 47 71 72 122
11. Yersion 3 2 Program Folder C Program FilesiSharePoint Farm Reporter Application Data Users Public Documents SharePoint Farm Reporter Change F Copyright 2012 Vyapin Software Systems Private Limited All rights reserved Pots Email support yyapin com Webs www vyapin com You are on day 1 of your 30 day evaluation period License Type 30 day Evaluation Copy This software is meant solely For evaluation purposes only License Agreement Purchase Activate 3 Click Change button to change Application Data folder location of SharePoint Farm Reporter application The Browse For Folder location dialog will appear as shown below 42 CHAPTER 2 Using SharePoint Farm Reporter Browse For Folder di Administrator d adminuser 1 di adminuser2 di Classic MET 4ppPool d Default d farmadmin_spi0 1 Ji Public d setupuser_spi i d spapppooll spi0 1 Make New Folder Cancel we 4 Select a desired folder location and Click OK The folder location can be local drives or mapped network drives 5 SharePoint Farm Reporter provides an option to copy or move the existing SharePoint Farm Reporter application settings and error log to the new location once you change the Application Data Folder Once you specify the new Application Data folder location SharePoint Farm Reporter will prompt you to copy or move existing SharePoint Farm Reporter application settings to the new location as
12. appear in red colour Click Customize to specify subject body of the e mail message option to zip the report as attachment Customize E mail Settings Speci To addresses subject and body of the e mail message option to zip the report as attachment From L ljames vyapin com ES subject Report generated by SharePoint Farm Reporter Please find attached the report generated by SharePoint Farm Reporter e ip the attachment 76 CHAPTER 4 Power Reports d Print Setting Select Print check box and choose a printer from the available list Reports Wizard Add Report a Specify Delivery Options Select any delivery option Export report to a file Publish to a SharePoint library E mail to users and Print Report Name Alternate Access Mappings External Resource a Spel Export Path Eo File Format web Page htm tral Publish i URL File Fformat web Page htm hitral If file already exists Donotoverwrite Co Oyerwrite Create a new version E mail To Address al Customize File Format web Page htm html Printer Mame Microsoft MPS Document Writer redirected 2 Page Setup Apple to IY Deliver report even when there are no records to export W Print lt Back Next gt Finteh Cancel You can use the Apply to option to apply the specified settings in this step to all the selected reports Deliver report even when there
13. 70 Export Report 39 Farm Features 5 Feature Status 8 File Name Mask 67 Hardware configuration 102 History Details Pane 50 How to activate the software 3 ITS log files 18 19 22 23 IIS Log Files Directory 19 23 Install the software 3 Installer 103 105 Invited Users 8 Last Deleted Items 13 17 98 Last Modified Items 13 17 license key 3 4 List Folders Security 13 List Hits 13 18 98 List Item Security 14 List Item Summary 14 List Reports 12 33 57 75 List URL 8 13 List Workflow Settings 14 List Workflow Status 14 15 Login Credentials 7 Mask Options 67 Maximum Alerts 7 Member of administrators group 21 Merge repeated Cells 43 Microsoft SharePoint Server 2010 1 2 20 21 102 Navigation buttons 41 New Task 53 68 70 ODBC Logging 19 Office SharePoint Server 16 Page Hits 9 18 98 Page Setup button 41 Page Visits 6 8 19 98 ParentSiteName 67 Pool Status 7 Power Reports 21 22 26 4 7 48 51 70 71 74 75 77 86 88 103 Primary Administrator 6 Primary Owner 6 Print Setting 65 Profile Manager 23 73 Publish Option 62 120 Chapter 7 Index Quick Reports 21 22 27 30 33 45 103 Quick Reports Wizard 27 30 33 Recycle Bin Cleanup 7 Recycle Bin Enabled 7 Recycle Bin Retention 7 Recycle Bin Summary 9 References 97 Report Category 17 18 19 56 67 Report Criteria 58 81 91 Report Scope 56 Report
14. 89 90 91 91 102 110 110 115 116 116 119 Chapter 1 About SharePoint Farm Reporter SharePoint Reports generated using Vyapin s SharePoint Farm Reporter formerly known as ARK for SharePoint 2010 2007 provides you a comprehensive SharePoint reporting solution covering all aspects of Microsoft SharePoint Server 2010 Microsoft SharePoint Foundation 2010 Microsoft Office SharePoint Server 2007 amp Windows SharePoint Services 3 0 collaboration platform Our SharePoint reporting software presents insights into events and activities that take place in SharePoint farms on a day to day basis and collates them as useful information for SharePoint Administrators Site Administrators and Site Content Owners to take action SharePoint Farm Reporter can help you analyze SharePoint farm events and activities from audit usage security policy amp configuration changes perspective gt View more than 90 out of the box SharePoint reports across your server farm gt Address your SharePoint internal audit and compliance needs such as HIPAA and SOX using the Audit amp Compliance Reports The SharePoint audit reports provide SharePoint Administrators a meaningful picture of what actions have occurred in SharePoint gt Secure your SharePoint infrastructure with the built in SharePoint Security Reports and take complete control The SharePoint security reports provide a clear picture of how SharePoint securit
15. About SharePoint Farm Reporter Site Features Report Category Audit and Compliance Reports Site Features to view information about activated features and its dependency details in each site Displays the following information Web URL Web Title Feature Name Feature Folder Name Description Action Dependency Feature Hidden Version 5 p Y J z tr Quick Reports Power Reports Custom Reports Quick Filter Custom view Find Refresh Publish Export E mail Print Preview Report Site Features URL http rd30 5050 Scope Connected site and its sub sites Group by Web URL v Action Web URL Web Title Feature Name Feature Folder Description Dependency Version Name Feature http frd30 5050 Enterprise ROM 2010 Wiki Page Home Page WikiPageHomePage This site feature will create a wiki page ani WebPageLibrary 1 0 Wiki Page Library WebPageLibrary n interconnected set of easily editable w 1 0 Translation Management Library TransMamtLib Create a translation management library 14 0 SharePoint Portal Server Status Indicator Lig Biz4ppsListTemplates SharePoint Portal Server Status Indicator U Issues Lists IssuesList Provides support For issues lists for a site Metadata Navigation and Filtering MetaDataNay Provides each list in the site with a setting False SharePoint Server Enterprise Site features PremiumWeb Features such as Visio Services Access Sg RelatedLinksScopeSettini False
16. B Quick Reports Power Reports Custom Reports Quick Filter Custom view Find Refresh Publish Export E mail Frink Preview Scope All lists in the connected site and its sub Group by Web URL Date range Last 30 days web Title Test site List Mame Old Name New Mame Occurred Performed By testsite Testing Testing testsite Testing TestingBulk bf21 2012 4 16 31 YSSLOB andrew Web URL http hird21 8001 fhestsite Sumber of rows 5 Audit Restored Items Report Category Audit and Compliance Reports Audit Restored Items displays the list of items that are restored from the Recycle Bin in the last N days or for the given date range This report displays the following information Web URL Web Title List Name Item URL Item Type Item Name Occurred Performed By 13 CHAPTER 1 About SharePoint Farm Reporter To generate report for given date range click Efbutton and enter Start date and End date After entering Start date and End date clickladbutton EE A a ee Quick Reports Power Reports Custom Reports Quick Filter Custom View Find Refresh Publish Export E mail Print Preview Scope All lists in the connected site and its sub Group by web URL Date range Last 30 days Web URL Web Title List Mame BL Item URL Item Type Item Mame Occurred Performed By http fird21 8001 Firstsitecall Announcements ListIkern C N Lists Announcements ListIkem 4_ 000 Shared
17. Converters PageConverters Contains the converters used to convert doc Search 4nd Process Search4andProcess Provisions the Search and Process timer jobs in Publishing Timer Inhs PublishinaTiner Tabs Feature Mame Description pplication Mame SharePoint 5050 SharePoint Server Enterprise Web application Features Premium eb pplication Features such as Visio Services Access Serw Create Publishing Fimer inhs in the weh anni Sumber of rows 100 Web Application User Permissions Report Category Audit and Compliance Reports Web Application User Permissions to view the Web Application User Permissions defined for all web applications Displays the following information Web Application User Permissions 2 ea T Se ee Quick Reports Power Reports CustomReports Quick Filter Custom View Find Refresh Publish Export E mail Print Preview Beport Web Application User Permissions URL Scope 4ll web applications Web Application s User Permissions Central Administration FullMask SharePoint 5050 FullMask SharePoint 5051 FullMask SharePoint 5060 FullMask SharePoint 80 FullMask a_i Sumber of rows 6 Web Part Pages Security Report Category Audit and Compliance Reports Web Part Pages Security to view the Web Part Pages Security settings for all web applications Displays the following information Web Application Allow Web Parts To Communicate Allow Access To Web Part Catalog E e EE f
18. Displays all invited users to the site and their permissions activation status for SharePoint Enterprise Site Collection feature and Enterprise Site feature Displays the first and last activity performed on the list for last N days or for the given date range SharePoint 2007 Web URL Web Title List URL List Name Item Name Alert Title Owner Set for Alert Type Alert Filter Alert Frequency Alert Status Email Recipient Alert Day Alert Time SharePoint 2010 Web URL Web Title List URL List Name Item Name Alert Title Owner Set for Alert Type Alert Filter Alert Frequency Delivery Method s Alert Status Email Recipient Alert Day Alert Time Web Application Database Name Database Status Database Server Current Number of Sites Site Level Warning Maximum Number of Sites Disk Size Required For Backup in MB Web URL Web Title Base Template List Name File Type Count Total Size in MB Web URL Web Title Enterprise Site Collection Features Enterprise Site Features Account Display Name Account Name Account Type Permission Levels Web URL Web Title List URL List Name First Activity Item Name First Activity Item URL First Activity Date First Activity User Name First Activity Transaction Last Activity Item URL Last Activit 27 CHAPTER 1 About SharePoint Farm Reporter Item Name Last Activity Date Last Activity User Name Last Activity Transactio
19. Documents Shared Documents Mew New Words rtF bf2el2012 7 24 53 PM SHOREPOINT system Shared Documents Run Run_a_custom_report_ 6 2ef2012 7 24 53 PM SHOREPOINT system Sumber of rows amp Audit Search Report Category Audit and Compliance Reports Audit Search displays the search queries and scope used in each site in the last N days or for the given date range It displays the following information Web URL Web Title Query Search Scope Occurred Performed By To generate report for given date range click button and enter Start date and End date After entering Start date and End date clickfd button ee a VN ON N A OA Quick Reports Power Reports Custom Reports Quick Filter Custom view Find Refresh Publish Export E mail Print Prewiew Scope All sites in web application Group by web URL Date range Last 30 days 5 web URL Web Title Query Search Scope w Occurred Performed By http ird21 8001 Firstsitecall karthik site https hirdz1 SEES sozossien SHAREPOINT syster SHAREPOINT systerr ster hetpsird2tse001 ftestsita 6 18 2012 2 39 26 PM SHAREPOINT systen Tew site hthp rd21 e ee SHAREPOINT systerr SHAREPOINT systerr SHAREPOINT systerr Sa amine ca 2sonrm SHAREPOINT systen site hthp fird21 er Tr al SHAREPOINT systerr SHAREPOINT systerr SHAREPOINT systerr SHAREPOINT systen SSLAB andrew inane SHAREPOINTisysten bts ied 1 A001 fsites sitecdl Secondsitercnl SPE
20. E to toggle between the print preview and the report viewer page 6 Click the Page Setup button L to change the print parameters of the page layout CHAPTER 3 Quick Reports 7 Select the Zoom control 100 to enlarge or shrink the view size of the report 8 Click the Find button 4 to find specific text within a report The search is case insensitive and begins at the page that is currently selected Wildcards and Boolean search operators are not supported 9 Click the Next button t to search for subsequent occurrences of the same search field value 10 Click the Export button kal Export to export the report data in HTML CSV MDB PDF XLS and TIFF file formats 11 Click the Report Settings button EY Report Settings the report data Or Press Alt S to control the appearance of Report Settings Column Hame Select a column ShowrHide Columns Column settings Column width in Inches Hide repeated values B Merge cells Apply to all columns Sorting E Sat on thie column Direction e Ascending Descending Table column headers IM Repeat table header rows on each page If Table header should remain visible while scrolling Cancel To modify the Column Settings Column width The width of the report column can be increased up to a maximum of 10 inches default 2 inches for all columns Specify the values in the Column width text box
21. Lists Team Discussion ListItem Disposition Appr Item Disposition Approved lt ApprovedBy SHAR 6 18 2012 4 SHAREPOINT system 1073741823 WE List Lists WF List 4 ListItem 4 Item Disposition Approved lt ApprovedBy gt SHAR 6 19 2012 63 SHAREPOINT system 1073741823 Lists WF List F 4_ 00q ListItem fi Item Disposition Approved lt ApprovedBy SHAR 6 18 2012 1 SHAREPOINT system 1073741823 Lists WF List FIFFI _ 0 ListItem r Item Disposition Approved lt ApprovedBy gt SHAR 6 18 2012 1 SHAREPOINTisystem 1073741823 _ 4 b Number of rows 20 Audit Deleted Lists Report Category Audit and Compliance Reports Audit Deleted Lists displays the deleted lists in each site in the last N days or for the given date range Displays the following information Web URL Web Title Deleted List Occurred and Performed By To generate report for given date range click button and enter Start date and End date After entering Start date and End date clickladbutton a nme venereal Wem pee pene ane eee e AE F Quick Reports Power Reports i Custom Reports Quick Filter Custom view Find Refresh Publish Export E mail Frink Previews Scope All sites in web application Group by Web URL Date range Last 30 days 5 Web URL Web Title Deleted List Occurred Performed By http iirdz21 8001 Firstsitecall SHAREPOINT system SHAREPOINT system SHAREPOINT system SHAREPOINTsystem SHAREPOINT system SHAREPOINT system
22. Old Settings New Settings Occurred Performed By Performed By ID Web URL Web Title List Name Item URL Item Type Item Name Occurred Performed By Display Name Full Name Designation Company Name Web URL Web Title Item URL Created By Created Date Size in MB Checked Out By Checked Out Date Check Out Status Feature Name Feature Folder Name Description Action Dependency Feature Hidden Version Web URL Web Title Item URL Item Name Deleted By User Name Deleted By Display Name Deleted Date Created By User Name Created Date Last Modified By User Name Last Modified Date Size in MB Web URL Web Title Item URL Item Name Modified By User Name Modified By Display Name Modified Date Size in MB Web URL Web Title Item URL Item Name Created By User Name Created By Display Name Created Date Size in MB Web Application Site Collection URL Solution Name Solution Id Solution Status Total Average Resource Usage Last 14 days Total Current Resource Usage Today CHAPTER 1 About SharePoint Farm Reporter Site Collection Features Site Features Web Application Features Web Application User Permissions Web Part Security Pages Audit Checked In Items Displays information about activated features and its dependency details in site collections Displays information about activated features and its dependency details in each site Di
23. Pe eects een peer D Quick Reports Power Reports Custom Reporks Quick Filter Custom wiew Find Refresh Publish Export E mail Print Preview Beport Web Part Pages Security URL Scope All web applications Web Application f Allow web Parts To Communicate Allow access To Web Part Catalog e 1o Bale Sariptska False False False False False Sumber of rows 6 22 CHAPTER 1 About SharePoint Farm Reporter 1 2 Security Reports SharePoint Farm Reporter provides the following built in reports in the security reports category Report Name Authentication Providers Effective Permissions of List Items SharePoint 2010 only Effective Permissions of Lists SharePoint 2010 only Effective Permissions of Sites SharePoint 2010 only List Folders Security List Item Security List Permissions Description Displays the Authentication Providers configured in the Web Application Displays the effective permissions of the given users groups for each item in the list Displays the effective permissions of the given users groups for each list in the site Displays the effective permissions of the given users groups defined in each site Displays information about the Groups Users and their permissions assigned to each folder and its sub folders in the connected list Displays information about the users and their permissions assigned to each list item Displays information about list permissions
24. Reports Select a SharePoint List Show Sites by ff Tite Name Move the mouse over the tree node to see the tool tip ADI A SharePoint 80 A SharePoint 8000 A SharePoint 8001 ag is firstsitecoll Eg is Secondsitecol Eg i New Site lg Announcements 2 Calendar Links Master Page Gallery i Shared Documents i EE Site Assets Site Pages yy Tasks go Team Discussion Cancel When you select All lists in the connected site and its sub sites or All lists in the connected site option you may view the report data only for the lists that belongs to a particular list template e g Document Library Picture Library Click Get List Templates button to enumerate all the lists that are available in the selected URL By default All will be selected which collects data for all the lists in the site Click the Finish button to view the report a ss 5 Quick Reports Power Reports Custom Reports Quick Filter Custom view Find Refresh Publish Export E mail Print Preview Report Audit Checked In Items URL http iirda4 8000 Scope All lists in the connected site and its sub Group by web URL Date range Last 30 days ey Web Item Item web URL Title List Mame Item URL Type Rete w Occurred Performed By http ird24 8000 firstsitecoll sales Force management sales force managementfout Document MA aaz0lz 3 33 16 PM WSSLABLYyuan WSOSLABL yuan SSL
25. Scope and specify the target URL You can use the Browse dialog or type the URL directly and Click the Add button Browse dialog shows the tree nodes based on the selected Scope You can view them through their title or name b Click Edit button to edit the selected scope and Click Remove to remove the selected URL from the list c Click Next to proceed to the next step 66 CHAPTER 4 Power Reports Reports Wizard Add Report Select scope and URL Select a scope Enter a valid UAL and click Add button to add the UAL or click Browse button to select the UAL Report Name Site Collection Administrators Scope Connected web application only C All web applications SharePoint URL Add Browse Scope URL All web applications All Apply to Edit Remove lt Back Next gt Finish Cancel NOTE Browse dialog shows the SharePoint tree nodes based on the selected scope For the case of Connected Web Application only and All Sites in Web Application it allows you to select a SharePoint web Application only For the case of Connected Site only Connected site and it s sub sites All lists in the connected site and All lists in the connected site and it s sub sites it allows you to select a SharePoint site only For the case of Connected list only it allows you to select a SharePoint list only A sample browse dialog is as shown below 67 CHAPTER
26. Specify the IIS Log Files Directory for each front end web server in the SharePoint farm to run such reports Audit Settings Specify the events that should be audited for documents Items lists libraries and sites within the site collection If you are enabling Audit for the first time SharePoint will begin auditing the selected events from the configuration date time Profile Manager SharePoint Farm Reporter can store your logon information for SharePoint sites using Windows Stored User Names and Passwords applet The stored profiles will be used to connect to SQL Server when necessary Export Settings SharePoint Farm Reporter will use the Export Path and File format as default settings to export the report Publish Settings SharePoint Farm Reporter will use the Publish URL File format and File option as default settings to publish the report 41 CHAPTER 2 Using SharePoint Farm Reporter 2 3 Change Application Data Folder Location SharePoint Farm Reporter enables you to change Application Data folder location where its application settings and error log are stored at any time after installing SharePoint Farm Reporter software To change the Application Data folder location perform the following steps given below 1 Select About from Help menu Help Contents F1 Hook Shirk F1 2 The About SharePoint Farm Reporter dialog appears as shown below About SharePoint Farm Reporter SharePoint Farm Reporter
27. click Next to continue 45 CHAPTER 3 Quick Reports This will display a window as shown below Quick Reports Wizard Ea m Specify Scope and URL Select a scope Enter a valid URL or click to choose a URL Click Finish button Report Name Audit Checked In Items Scope Connected list only All lists in the connected site All lists in the connected site and its sub sites SharePoint URL http irda 2001 a e g http Server Name Sibe Name List type Jal bi Get List Types lt Back ext Emish Cancel Select any of the following scopes for the report to be viewed a All lists in the connected site and its sub sites If URL entered is a valid site URL SharePoint Farm Reporter retrieves report information for all lists in the connected site and its sub sites b All lists in the connected site Retrieves report information for all the lists in the connected site c Connected list only Retrieves report information for the connected list only By default All lists in the connected site and its sub sites option will be selected To connect to a particular site or list a Type full URL of the site in the format http servername port number sitename or http servername port number sitename listname for the scope option selected or b You can also Click A button to show the Select a SharePoint List or Select a SharePoint Site dialog as shown below 46 CHAPTER 3 Quick
28. shown below Copy or Move data Fa Do you want to Copy or Move all application settings and data From the old Folder location to the new Folder location Click the appropriate button below Move Close 6 Click the desired action Copy Move Close to proceed SharePoint Farm Reporter will use the new Application Data folder location henceforth 43 CHAPTER 2 Using SharePoint Farm Reporter 2 4 Task Status To view and manage task status of a selected task 1 Select Tools gt Show Task Status from the main window or Click l Task Status from Power Reports Actions Pane 2 The Task Status dialog appears as shown below 1 Task Status View task status for specihed number of days Show status For days l Go B Refresh E view Log File 3 Remove Ea Remove dll Task Name Start time a End Time Elapsed Time Status NewT ask 6719 2008 4 55 43 PM 6 19 2008 4 56 02 PM 00 00 19 4 record s M Show at startur Close You can perform the following actions in the Task Status dialog a b c d e 3 Show status for lt n gt days Upon clicking Go button displays task history entries of all tasks that were run within the specified number of days Refresh Reloads the task history entries and updates the newly run tasks if any View log file Displays activity log of the currently selected task history item Remove Removes the currently selected task history entry and its assoc
29. sites Zsitecol ice 6162012 11 28 42 AM SHAREPOINT system http ird21 8001 fsites 2sitecol Secondsitecol ot Error Number of rows 7 Audit Deleted Sites Report Category Audit and Compliance Reports Audit Deleted Sites displays the deleted sites in the last N days or for the given date range It displays the following information Web URL Web Title Deleted Site Occurred and Performed By CHAPTER 1 About SharePoint Farm Reporter To generate report for given date range click Efbutton and enter Start date and End date After entering Start date and End date click amp d button E aooe i Y P Quick Reports Power Reports Custom Reports Quick Filter Custom view Find Refresh Publish Export E mail Print Preview Scope All sites in web application Group by Web UAL Date range Last 30 days 5 Web URL Web Title Deleted Site Occurred Performed By http jfrd21 8001 firstsitecoll http ffrd21 8001 sites 2sitecol Secondsitecal sites 2sitecol T5 6 16 2012 11 30 59 AM SHAREPOINT system ot Error Number of rows 4 Audit Group Member Changes Report Category Audit and Compliance Reports Audit Group Member Changes displays the list of newly added deleted members in a Group in the last N days or for the given date range It displays the following information Web URL Web Title Action Performed User Name Group Name Occurred and Performed By To generate report for given da
30. steps 1 through 6 as in New Task During this process you may change the settings add a new report delete a report edit a report change the export path etc 3 The new settings will be used when the task runs the next time 4 5 Copy Task You can Copy an existing task in the Power Reports Task Manager to create a new task with the same properties You may then edit the properties of the newly created task To Copy a task from the existing task list 1 Select a task to be copied 2 Click Copy from Actions Pane 3 The Copy Task window will be displayed as shown below x Enter 4 new name for the task to be created and alzo the password for the conresponding user Copy Jlis Task i ss CS Save z Ps Run As VOYAGERA Sd6 spadminuser2 Password Poo 4 Enter a new task name and specify the Run As account and Password for the user context x Enter a new name for the task to be created and alsa the password for the corresponding user Coy flistTask Saves Lietta Password eee OS CC EAYLUS Cancel 5 Click OK The newly created task will be added to the Power Reports Task Manager 83 CHAPTER 4 Power Reports 4 6 Delete Task To delete a task from the Power Reports Task Manager Window select the task and Click Delete from the Actions Pane The deleted task will also be removed permanently from the Task Manager This action will also delete the tasks created in Windows Task Sch
31. 4 Power Reports Select a SharePoint List Show Sites by ft Title Mame Move the mouse over the tree node to see the tool tip A SharePoint 5053 SharePoint 5061 SharePoint 6000 4 SharePoint Workspace 3000 i SharePoint Workspace M055 H H ElectroSoftTech o 34 Docslib Ba pa i E Mew Contacts E Fresh Eg isi Freshz Eg is Mew site gi newsie g Project Site gi Sample Calendar Eg is Samples ite UF Cancel Scope and URL dialog is report specific The table given below summarizes the various a E applicable scopes brief description Report Scope Description Connected web application only Retrieves report information for the connected web application only All web applications Retrieves report information for all web applications in the SharePoint server All sites in web application Retrieves report information for all the sites including sub sites and top level sites in the web application Connected site and its sub sites Retrieves report information for the connected site and its sub sites Connected site only Retrieves report information for the connected site only 68 CHAPTER 4 Power Reports All lists in the connected site and its Retrieves report information for all the lists in sub sites the connected site and its sub sites All lists in the connected site Retrieves report information for the all the lists in the connected s
32. AB yuan WSSLOB yuan WSOSLABLYyuan VWOSLAB yuan WSSLAB yuan VSOSLAB yuan WSSLABL yuan s 3 2012 3 56 40 PM vSSLABLyuan i JE Sumber of rows 42 47 Chapter 3 2 Custom View Click HSM iew button in the toolbar Select the fields to view in the report Custom iew Customize the report Select the fields to view in the report Mandatory fields appear in blue web URL Web Title Base Template List Name Item UAL Item Mame Groups Users Permission Levels W Select All DK Close Click OK button to view the customized report data in the grid 48 CHAPTER 3 Quick Reports 3 3 Find Data To search for data in a report Click F 4 button and just type the character s or words you want to find in the find edit box available in the find window and then Click the Find All button Specify a Search String Eg john doe Find All Clear You can use the wildcard character in the search criteria The wildcard character acts as a place holder for zero or more characters However note that you cannot use the 2 wildcard character in the search criteria For instance if you want to search for URL in a report Type URL without quotations in the edit box and then Click on Find Button For all the matches found SharePoint Farm Reporter highlights the corresponding columns in the grid NOTE The search criteria should not be enclosed within quotation marks The followi
33. AM FiSf2012 10 38 00 AM SHAREPOINT system 1073741823 http iird 1 6001 sites SiteTemplat Site Template Testing Fisf2012 1 15 00 PM Fisf2012 1 06 00 PM SHAREPOINT system 1073741623 Web URL Web Title Date Last Deleted Gececurred Performed By Performed By ID a Error Number of rows 3 CHAPTER 1 About SharePoint Farm Reporter Audit Page Visits Report Category Audit and Compliance Reports Audit Page Visits displays the web pages visited in each site in the last N days or for the given date range It displays the following information Web URL Web Title Page URL Occurred Performed By To generate report for given date range click button and enter Start date and End date After entering Start date and End date click fd button E Ye eee Y BIBIE 0 5 D Quick Reports Power Reports Custom Reports Quick Filter Custom View Find Refresh Publish Export E mail Print Preview Scope Group by web URL Date range Last 30 days E 5 Web URL web Title Page URL Occurred Performed By http fird21 8001 Firstsitecoll _cakalogs kForms SHAREPOINT system SHAREPOINT system SHAREPOINT system SHAREPOINT system SHAREPOINT system _cakalogs itiForms Upload asp 6 16 2012 11 55 10mM SHAREPOINT system SHAREPOINT system _cabalogs masterpage SHAREPOINT system SHAREPOINT system SHAREPOINT system AMC Aisi 1 OM CHADEOTBRIT eseborn i rf Sumber of rows 9066 Audit Permission Changes Repor
34. Activity Site Collection Summary Site Hits Summary Site Hits Summary Monthly Usage SharePoint 2007 Only Site Summary Site Usage Summary Site Visitors Site Visitors Monthly Usage SharePoint Displays the first and last activity performed on the SharePoint site for last N days or for the given date range Displays site collection information such as site URL owner name email etc Displays a summary of site visits Displays the number of times a site has been visited in a given month range or all months in the last 31 months Displays site summary information like author created date web size in MB and number of sub webs etc Displays information about the number of sites lists list items storage used by sites number of visited users total hits by users in each site Displays the number of times users have visited each site Displays the number of times an user has visited each site in a given month Web URL Web Title First Activity Date First Activity User Name First Activity Transaction Last Activity Date Last Activity User Name Last Activity Transaction Web Application Site URL Created Date Last Item Modified Date Last Content Modified Date Last Security Modified Date Primary Owner Name Primary Owner Display Name Primary Owner E Mail Secondary Owner Name Secondary Owner Display Name Secondary Owner E Mail Number of Sub webs Number of Use
35. Compress the attachment Please find the attached report generated by SharePoint Farm Reporter SharePoint Farm Report provides the option to e mail the reports generated using Quick Reports For e mailing reports SharePoint Farm Reporter requires SMTP Server From E mail Address To E mail Addresses recipients separated by semicolon and the report attachment format SharePoint Farm Reporter provides check name feature for recipient s name To check name Click By button If name matches with trusted domain users in the Active directory name entered in From address text box will be replaced by corresponding active directory user CHAPTER 3 Quick Reports If there is no match for the name entered by the user in Active Directory a dialog will appear as shown below Check Names Vuapin s SharePoint Farm Reporter does not recognize asdasd Do you want to f Delete this recipient from the list Change to Lancel Properties Select Delete option in the above dialog to remove the recipient name from To address text box Click Cancel button to close this dialog and the unresolved recipient s will appear in red color Click Send button to send the report by e mail to the selected recipients Chapter 4 Power Reports 4 1 About Power Reports SharePoint Farm Reporter provides an offline report generation tool called Power Reports Power Reports tool allows the user to select multiple r
36. Connected list only Group by Web UAL Y Date range Last 7 days E Web URL Web Tithe Item URL A http rd6S 5010 Backup Bulky Shared Shared Documents dump 100 samples4 tet Shared Documents Folder1 CustomAnd MLParsersConceptualbeta pdf Shared Documents InvalidCharacters Ext Shared Documents InvalidCharacters Sample File txt Shared Documents InvalidCharacters amps txt Shared Documents InvalidCharacters ccur txt Shared Documents InvalidCcharacters hash txt Shared Documents InvalidCharacters hashor Files tet Shared Documents InvalidCharacters My New File ocurccur txt Shared Documents InvalidCharacters My New per Folder perper test per Folder perper txt Shared Documents InvalidCharacters MyFolderttest oer folder perper ktxt m 4 Farm Features Report Category Audit and Compliance Reports Farm Features to view the farm activated features and its dependency details It displays the following information Feature Name Feature Folder Name Description Action Dependency Feature Hidden Version 16 CHAPTER 1 About SharePoint Farm Reporter E Yee re eee en ene ee ee E Quick Reports Power Reports Custom Reports Quick Filter Custom View Find Refresh Publish Export E mail Print Preview Report A EMES URL Scope All web applications Group by Feature Name Action Dependency k Ta Feature Mame Feature Folder Mame Description aor Hidden Connect to Office Ribbon C TemplateDiscover
37. ND to Filter OR to Filter parenthesis buttons bo build enhanced Filter condition Report Name List Columns URL http rd61 1010 Group By web URL Operator Value String Format add to Filter OR to Filter COl amp RAL Apply to Specify the criteria to filter the report data I Choose a field name from the dropdown select an operator and specify the filter data NOTE Operators include special operators called contains and does not contains Contains determines whether or not a given character string matches a specified pattern The operator does not contain performs the reverse function of the contains operator 71 CHAPTER 4 Power Reports II Click Add to Filter The selected condition will be added to the criteria list and will be displayed as shown below Criteria Specify conditions For Filtering the report data Choose a Field name From the dropdown select an operator and specify a value in the value dropdown You can use AND to Filter OR to Filter parenthesis buttons bo build enhanced Filter condition Report Name List Columns URL http rd61 1010 Group By web URL Operator Value String Format Apply to III Use AND to Filter and OR to Filter parenthesis etc to build an enhanced filter condition as shown in the example below Web Title Starts with Sample OR Web Title Ends With Sha
38. Once the file clean up process is complete the uninstall wizard will automatically run Windows Installer applet to remove SharePoint Farm Reporter s application related files from the computer if you have selected the option Uninstall SharePoint Farm Reporter application in the wizard 118 7 index Actions Pane 26 51 53 70 71 73 77 Activate dialog 3 4 Activate screen 3 activate the software 3 Alternate Access Mappings 5 API Authentication 7 Application Data 24 25 application server 2 Audit Deleted Lists 8 Audit Deleted Sites 8 Audit Group Member 8 Audit Renamed Items 12 Audit Updated Items 12 Audit Visited Items 12 Audit report 8 12 Audit Settings 20 21 23 Authentication Provider 7 Authentication Providers 5 Blocked File Types 5 67 Blog API Enabled 7 Chapter Browse 25 54 55 97 99 100 built in reports 5 8 12 Change Log Reports 16 Cleanup History 77 cleanup process 105 command line 16 74 configure 20 21 Content Databases 5 7 67 Copy Task 70 Custom Reports 22 78 79 86 89 96 Custom View 36 data retrieval services 5 Data Retrieval Settings 5 default aspx 37 Delete Task 71 Directory Server Settings 23 Document Center 37 DOS batch file examples 75 Download evaluation trial copy 3 Edit Task 70 119 Chapter 7 Index E mail Option 63 E mail Report 45 E mail Settings 23 Export Option 62 export path 39 47
39. Point Farm Reporter shows the above alert when the audit settings are not configured for the selected site URL SharePoint Farm Reporter T Unable to load web applications in the server Ensure currently logged on user account is an Application Pool user account or a member oF Administrators group in SharePoint Server and Database Server SharePoint Farm Reporter shows the above alert if the currently logged on user does not have sufficient permissions to retrieve the web applications information in SharePoint The currently logged on user must be an application pool identity account or must be a member of local Administrators group in the SharePoint server and database server SharePoint Farm Reporter Unable to connect to http iird21 50151 Please ensure the A Following URL is a valid web application URL Web application is extended Currently logged on user account musk be an Application Pool User account or must be a member of Administrators group in SharePoint Server and Database Server If the web application URL is valid please ensure the currently logged on user has sufficient rights to access the web application The currently logged on user must be an application pool identity account or must be a member of local Administrators group in the SharePoint server and database server SharePoint Farm Reporter E4 f Unable to connect to http ijird S 7777 Idevelopers center Please ensure the Following
40. QL Server 2008 Enterprise Standard Express editions to connect and create a database SharePoint Farm Reporter will connect to the specified SQL Server based on the authentication mode and user credential to manage its own application databases You have to specify the suitable SQL Server settings in SharePoint Farm Reporter to view these reports in SharePoint Farm Reporter SharePoint Farm Reporter uses the USER ACCOUNT based on the SQL authentication mode set in SQL Server settings in SharePoint Farm Reporter to create database and store report data The USER ACCOUNT denotes the currently logged on user account while running Quick Reports under interactive mode and denotes the Run As account while running Power Reports task run as a scheduled task or using Run Now option You can also use an exclusive SQL user account to create and manage its own application database Please note that SharePoint Farm Reporter requires the USER ACCOUNT to have sufficient privileges to create add and delete database in the SQL server SharePoint Farm Reporter Features SharePoint Farm Reporter features are broadly classified as follows A Quick Reports Provides a set of SharePoint configuration permissions usage and audit reports for web application site collection site and list and their items This task option is ideally suited for quick glance of the current SharePoint information Custom Reports Facilitates customizing SharePoint Farm R
41. Settings Pane 49 Report Summary 68 85 95 RSS Feeds 7 Run Now 21 22 73 SandBoxed Solutions 6 Schedule Properties Pane 51 Secondary Administrator 6 Secondary Owner 6 Security Validation 7 Service Pack 102 SharePoint Library 40 SharePoint Settings 21 SharePoint Site 32 35 SharePoint user permissions 21 Site Activity 10 17 Site Collection Administrators 6 Site Collection Features 6 8 Site Collection Quotas 6 Site Collection Workflow 6 Site Columns 9 10 Site Content Types 9 Site Features 8 9 67 Site Hits Summary 9 18 98 Site Permission Levels 9 Site Permissions 9 Site Report 30 Site Reports 8 30 56 Site Security 10 Site Settings 10 Site Visitors 10 18 98 Site Workflows 10 SMTP Server 6 23 45 Sorting 43 SQL authentication 22 73 SQL Server Settings 22 23 SQL Servers 21 storage settings 6 System requirements 1 System Requirements 2 Task Activity View 48 50 76 121 Chapter 7 Index Task List Pane 49 Task Manager 47 48 49 51 69 70 71 task name 47 68 70 74 Task Status 10 14 15 26 Technical Support 103 Templates 6 8 35 Troubleshooting 102 uninstall wizard 103 105 Upload Size 7 User Interface 49 Version History 15 Web Application 5 6 7 19 27 28 31 55 56 66 67 83 93 web application information 7 Web application reports 27 web application URL 99 Web Pages 10 Web Part Catalog 7
42. SharePoint server and database server SharePoint Farm Reporter aN Unable to connect bo tke rd6S 5001 fshared documents Please enter a valid library URL or ensure you have access to the specified library or Folder location 13 SharePoint Farm Reporter shows this alert when the user tries to publish the report to a SharePoint library Please ensure the library URL is valid and the user account has access to the document library and the folder location where the report is to be published 114 CHAPTER 6 References 6 2 Troubleshooting Troubleshoot a Problem While using SharePoint Farm Reporter if and when a problem arises please forward the following information to support vyapin com to revert back to you with a solution 1 Version of SharePoint Farm Reporter you are evaluating or you have registered with us version information could be found in About screen and in Help 2 Additional services or resource consuming processes applications like anti virus indexing running in the background on the computer where SharePoint Farm Reporter is installed 3 Hardware configuration of SharePoint Farm Reporter installed computer 4 Service Pack version of Microsoft SharePoint Server 2010 Windows OS running currently 5 Send us the Error Log SharePointFarmReporterErrorLog txt available in the lt Application Data Folder gt SharePoint Farm Reporter Log folder e g C Users Public Documents Sh
43. User Manual SharePoint Farm Reporter sharePoint Farm Reporter Copyright 2012 Yyapin Software Systems Private Limited All nights reserved Email supporttayyapin com Webs Www vyapin com Last Updated December 2012 Copyright 2012 Vyapin Software Systems Private Ltd All rights reserved This document is being furnished by Vyapin Software Systems Private Ltd for information purposes only to licensed users of the SharePoint Farm Reporter Software product and is furnished on an AS IS basis that is without any warranties whatsoever express or implied SharePoint Farm Reporter is a trademark of Vyapin Software Systems Private Ltd Information in this document is subject to change without notice and does not represent any commitment on the part of Vyapin Software Systems Private Ltd The software described in this document is furnished under a license agreement The software may be used only in accordance with the terms of that license agreement It is against the law to copy or use the software except as specifically allowed in that license No part of this document may be reproduced or retransmitted in any form or by any means whether electronically or mechanically including but not limited to the way of photocopying recording or information recording and retrieval systems without the express written permission of Vyapin Software Systems Private Ltd i Ai s WAVYAPIN Vyapin Software Systems Private Limited Website h
44. a for the custom report Click Edit to specify the criteria to filter report data Optional Click Nest to proceed Web Application Contains Test OR Created Date 07701708 12 00 00 AMH a Click Next to proceed to the next step 107 CHAPTER 5 Custom Reports Step 4 Report Summary This step displays the summary information for the selected report Report Summary The following table shows the summary details of the custom report Click Finish to save the report settings Custom Report Hame Custom Site Admin Report Description This report retieves site collection administartars Details Source Heport Name Site Collection Administrators Selected Fields Admin Login Hame Admin E Mail Site Collection UAL Created Date Admin Type Admin Hame Web Application Criteria lt Back Hest gt Finish Cancel 1 Specify unique name and description for the custom report 2 Click Finish to save the new report and close the custom reports wizard 108 CHAPTER 5 Custom Reports You can view the newly created custom report and its settings in Custom Reports Manager window as shown below Custom Reports Manager Custom Reports Manager window shows the list of available custom reports Select a custom report to wiew its description Helde and report criteria Click New to create a custom report Click Edit to change the settings for the selected report Click Delete to delete the s
45. a task and click Run Now from the Actions Pane to run the task immediately This option enables you to run the selected task with a different user context in every task invocation Run Now dialog appears as shown below Run Mow Specify the user credential to run the selected task and the SOL authentication mode User contest to connect to the SUL Server used by SharePoint Farm Reporter SharePoint credential Task Name task User Name VSSLAB spapppool2_spt 0 1 Password ce OE SQL Server credential SOL Server rd26 Authentication mode Windows Authentication uses curently lagged on user SQL Server Authentication User Mame sollagirr2 Password ee OF Cancel 1 Specify user name and password under SharePoint credential to run the task temporarily 2 Select desired authentication mode by which SharePoint Farm Reporter has to connect to the specified SQL server 3 If SQL authentication mode is selected enter SQL user name and password In this case a user profile with the SQL user name and password will be created under the Run As account so as to connect to SQL server while the task runs under the specified Run As account Read Profile Manager for more details 4 Specify user name and password to run the task temporarily 5 Click OK to run the task with the specified user context 86 CHAPTER 4 Power Reports 4 9 Run a task from command line SharePoint Farm Reporter command line featu
46. ach site Group Name Account Type Inherit Permissions View Membership Edit Membership Join Leave Group Auto Accept Permission Levels Displays information about Web URL Web Title permission levels defined in Permission Level each site Description Permissions Displays information about Web URL Web Title site permissions groups Groups Users Account and users defined in each Type Description Group site Owner Permission Levels Members Displays site security Web URL Web Title Allow information like allow Anonymous Access anonymous access Anonymous State Allow authentication mode etc Unsafe Updates Authentication Mode Has External Security Provider Inherits Role Assignments Inherits Role Definitions Request Access Enabled Request Access E Mail 24 CHAPTER 1 About SharePoint Farm Reporter 1 3 Policy Reports SharePoint Farm Reporter provides the following built in reports in the policy reports category Report Name Blocked File Types Regional Settings Resource Throttling Settings SharePoint 2010 Only Self Service Site Management SharePoint Designer Settings Site Collection Level SharePoint 2010 Only Description Displays the list of blocked file extensions configured in the web application Displays the list of regional settings configured in the site Displays the all the Resource Throttling Settings configured in the Web Application Displays inf
47. andlers Enabled Delete Log Entries Log Retention Period in days Recycle Bin Enabled Recycle Bin Cleanup Enabled Recycle 33 CHAPTER 1 About SharePoint Farm Reporter Web Parts Displays information all the web parts available in each site user who created the web part etc 1 6 System Requirements Bin Retention Period in days Second Stage Recycle Bin Quota in Web URL Web Title Web Part Title Web Part Name Parent Folder Author Created On Last Modified SharePoint Farm Reporter must be installed in the web front end server or application server in the SharePoint 2010 2007 farm SharePoint 2010 farms Processor Disk Space Operating System Software SharePoint 2007 farms Processor Disk Space Operating System Software Intel Pentium processor Minimum of 20 MB of free disk Space Windows Server 2008 with NET Framework 3 5 or higher with the latest service packs Microsoft SharePoint Server 2010 or Microsoft SharePoint Foundation 2010 with latest Service Pack Microsoft Data Access Components MDAC only Microsoft SQL Server 2008 Enterprise Standard Developer Express edition or Microsoft SQL Server 2005 Enterprise Standard Developer Express edition running in local remote computer with latest Service Pack Intel Pentium processor Minimum of 20 MB of free disk space Windows Server 2003 or Windows Server 2008 with NET Framework 3 0 or higher wit
48. application pool identity account or must be a member of local Administrators group in the SharePoint server and database Server SharePoint Farm Reporter X Unable to connect to Att frd6S S001 Please ensure the Following Valid library URL Basic rights View Pages Browse Directories are enabled For the corresponding web application Currently logged on user account has basic rights View Pages Browse Directories in the respective site Currently logged on user account must be an Application Pool user account or must be a member of Administrators group in SharePoint Server and Database Server 11 If the list URL is valid please ensure the currently logged on user has View Pages and Browse Directories rights in the respective site where the list resides Also the currently logged on user must be an application pool identity account or must be a member of local Administrators group in the SharePoint server and database server 113 CHAPTER 6 References SharePoint Farm Reporter Cannot open database WSS Content _49acSchlarl645d0a9eechhoelOeabye requested by the login The login Failed Login Failed For user VOYAGER serverfarmadminusers Please ensure currently logged on user has permission to access the database 12 It is preferable to run SharePoint Farm Reporter using an application pool identity account or a user account that is a member of local Administrators group in the
49. are no records to export option instructs the application to not to export publish email print report when there is no record in the report By default this option is checked Click next to proceed to the next step Step 5 Specify File Settings By default SharePoint Farm Reporter will export each report for every single selected URL into a new file File Settings step displays different file name mask options namely Web Application Name Site Name List Name Parent Site Name Report Name Date and Time Stamp for each report You can choose the desired file name mask from the list and customize the export file name 77 CHAPTER 4 Power Reports Reports Wizard Add Report f r Specify File Settings Select the file name mask and report headers to export the report Report Name Audit Checked In Items File option Separate file for each selected URL File name mask lt ReportName gt lt DateandTimeStamp gt see AG EET STI Header Value Report Category Report Category gt Report Mame Report Name gt Scope lt Scope gt URL lt URL gt Number oF records lt Nurmber of records gt Criteria lt Criteria gt List Template lt List Template gt Date range Date range gt Remove Apply to Next gt Finish Cancel File Name Option x Select fle name mask s to construct file name File name masks ReportN ame Site Collection Summary WebApplicationy ame Sh
50. arePoint 9003 D ateandT imeStamp 20101015 113750 Inzert File name value lt ReportName gt lt DateandT imeStamp gt OF Cancel 78 CHAPTER 4 Power Reports You can use the file name mask options as described below Report Scope Web Application File Name Mask Options ReportName WebApplicationName DateandTimeStamp Report Scope Site File Name Mask Options ReportName SiteName ParentSiteName WebApplicationName DateandTimeStamp Report Scope List File Name Mask Options ReportName ListName SiteName ParentSiteName DateandTimeStamp lt ReportName gt lt WebApplicationName gt lt WebApplicationName gt lt DateandTimeStamp gt lt ReportName gt lt WebApplicationName gt lt ReportName gt lt ParentSiteName gt lt SiteName gt lt WebApplicationName gt lt ReportName gt lt ReportName gt lt SiteName gt lt ParentSiteName gt lt WebApplicationName gt Selected File Name Mask lt ReportName gt lt ListName gt lt SiteName gt lt ParentSiteName gt lt ListName gt lt SiteName gt lt ReportName gt lt SiteName gt lt ParentSiteName gt lt ListName gt lt ReportName gt Blocked File Types Share Point 9000 html Share Point 9000 201010105 113750 Content Databases csv Share Point 9000 Site Features pdf First Site Coll First Site Site Features html Site Features Share Point 9000 csv File Types Shared Docume
51. arePointFarmReporter Log SharePointFarmRe porterErrorLog txt 6 For Power Reports issues send also the SharePointFarmReporterErrorLog txt available in the lt Application Data Folder gt SharePoint Farm Reporter Power Reports lt lt Task Name gt gt lt lt Date and Time Stamp gt gt folder The lt Application Data Folder gt is the common location where SharePoint Farm Reporter tasks and task history will be stored in the computer running SharePoint Farm Reporter application The lt Application Data Folder gt can be found from Help gt About screen The default path of lt Application Data Folder gt is as follows gt Windows 2003 C Documents and Settings All Users Shared Documents gt Windows 2008 C Users Public Documents CHAPTER 6 References 6 3 Technical Support Technical support is available through e mail Send your questions to support vyapin com We make every effort to respond to your request on the same day you send in your e mail Please allow up to 24 hours for our technical support team to revert back to you 6 4 How to Uninstall SharePoint Farm Reporter When you create Power Report tasks in SharePoint Farm Reporter the application creates Windows Scheduled Tasks to run the Power Report tasks at the specified time interval where SharePoint Farm Reporter is installed While running the Quick Reports or Power Report task SharePoint Farm Reporter creates SharePoint Farm Reporter Settings folder to st
52. armRenorer 7 1 Renamed sites herr AONI fsitest s AAO 11 45 55 AM SHAR FROTNT systern 4 F oh Error Number of rows 198 14 CHAPTER 1 About SharePoint Farm Reporter Audit Settings Changes Report Category Audit and Compliance Reports Audit Settings Changes displays information about the audit settings changed in the site collection in the last N days or for the given date range It displays the following information Web URL Web Title Old Settings New Settings Occurred Performed By Performed By ID To generate report for given date range click button and enter Start date and End date After entering Start date and End date click button Y 5 Quick Filter Custom wiew Find Print Preview E Quick Reports Power Reports Custom Reports Refresh Publish Export E mail scope All sites in web application Group by web URL Date range Last 30 days 5 web URL Web Title Occurred Old Settings Mew Settings Performed By Performed By ID https ird21 8001 Firstsitecall 6 15 2012 2 53 44 PM Cec out or checking in SHAREPOINT system 1073741823 1073741823 1073741823 1073741823 https rd21 8001 Isitesf2sitecg Secondsitecal efleizniz24zttpm Checking out or checking in SHAREPOINT system 1073741823 1073741823 ioe beeen a 1073741823 1073741823 Sumber of rows 10 Audit Visited Items Report Category Audit and Compliance Reports Audit Visited Items displays the list items visited i
53. ary Administrator Primary Administrator Login Mame Primary Administrator E Mail Secondary Administrator gt Secondary Administrator Login Name Seconda Administrator E Mail 4 aj lt Back Next gt Finish Cancel Perform the following steps in this dialog a Select the required field s to add You can use gt to add a field to the selected aaea al DA fields list and to remove a field from the selected fields list b Select a field from the selected fields list and click or to move the field one position up or down Also click ka or E to move the field to the first or last position in the field list c Click Next to proceed to the next step Click Back anytime to go back to a previous step 93 CHAPTER 5 Custom Reports Custom Reports Wizard Custom SIte Admin Select required fields Select required fields from the available fields you can use the up down buttons to order fields in the selected field list Click Nest to proceed Report Name Site Collection Administrators Available Fields Selected Fields Admin Login Hame Admin E Mail Admin Name Site Collection UAL le Le le l 4 lt Back Next gt Finish Cancel Step 3 Specify Report Criteria This step allows you to apply specific conditions for filtering report data Custom Reports Wizard x Specify Report Criteria 7 The following list shows the criteria for the custom report Click Ed
54. ask history Cleanup scheduled tasks that are associated with export tasks Cleanup log Files and databases Uninstall SharePoint Farm Reporter application ar tr So Back Finish Cancel Click Next to proceed 2 Select required cleanup options as shown below SharePoint Farm Reporter Uninstall Wizard E4 Step 1 of 2 Cleanup Options This wizard helps you to cleanup and uninstall the SharePoint Farm Reporter completely K M Cleanup Power Reports tasks and their history instances Cleanup all Power Report tasks and task history information maintained by SharePoint Farm Reporter including Folders such as Power Reports and Log M Uninstall SharePoint Farm Reporter application Remove all application Files and uninstall SharePoint Farm Reporter application From the machine M Cleanup exported Power Reports Cleanup exported Power Reports in the application data Folder lt Back Finish Cancel Click Next to proceed 117 CHAPTER 6 References 3 Confirm the cleanup and or uninstall process SharePoint Farm Reporter Uninstall Wizard Step 2 of 2 Cleanup Process This wizard helps you to cleanup and uninstall the SharePoint Farm Reporter completely Click Finish button to remove SharePoint Farm Reporter application or Click Cancel to terminate the uninstall wizard lt Back Finish Cancel Click Finish to run cleanup and or uninstall process Click Cancel to close the wizard 4
55. ation Displays recycle bin Summary information like item name total number of items item type deleted date size of deleted item etc Item Visit URL Visit Count Action Visited By Visited Date Visited Time Web URL Web Title Base Template List Name Workflow Template Workflow Name Description Created Date Modified Date Task List History List Allow Manual Start Auto Start Workflow On Item Creation Auto Start Workflow On Item Change Permissions Web URL Web Title Base Template List Name Item URL Item Name Workflow Status Workflow Name Initiator Started On Last Run Task Title Task Assigned To Due Date Task Status Outcome Web Application Available Service Applications Group Term Set Term Level 1 Term Level 2 Term Level n Web URL Web Title File URL Total Hits Recent Month Hits Recent Day Recent Day Hits Web URL Web Title Page URL Last Accessed Date Total Hits Month1 Month2 Month31 Front end Web Server Web Application Site URL Page URL User Client IP Address Visited Date SharePoint 2007 Web URL Web Title Number of Items Last Item Deleted Date Last Item Deleted By Total Size in MB SharePoint 2010 Web URL Web Title Number of Items ID Item Name Item Type Original Location Deleted Date Deleted By Deleted By ID Deleted By Email Created By Created By ID Created By Email Size 29 CHAPTER 1 About SharePoint Farm Reporter Site
56. audit settings in Microsoft SharePoint Server 2010 MOSS WSS to view the reports in SharePoint Farm Reporter a How to configure audit settings in Microsoft SharePoint Server 2010 Please visit http office microsoft com en us sharepoint server help configure audit settings for a site collection HA102031737 aspx to view the detailed information about how to configure audit settings in Microsoft SharePoint Server 2010 You can also configure audit settings in Microsoft CHAPTER 2 Using SharePoint Farm Reporter 3 SharePoint Server 2010 using Audit Settings Manager in SharePoint Farm Reporter b How to configure audit settings in Microsoft Office SharePoint Server 2007 MOSS Please visit http office microsoft com en us sharepoint server help configure audit settings for a site collection HA010099726 aspx pid CH101237681033 to view the detailed information about how to configure audit settings in MOSS You can also configure audit settings in MOSS using Audit Settings Manager in SharePoint Farm Reporter c How to configure audit settings in Windows SharePoint Services 3 0 WSS WSS does not provide a user interface to configure the audit settings You can configure audit settings in WSS 3 0 using Audit Settings Manager in SharePoint Farm Reporter Applicable Reports Audit Checked In Items Audit Checked Out Items Audit Copied Items Audit Deleted Lists Audit Deleted Sites Audit Gro
57. ctions Task Name a Start Time End Time Status View Log 2 Task Activity View irl ny X Remove Farmadmin_spO 1 5P gil Task Status Source New Created Date 8 24 2012 1 26 49 PM Last Modified date 8 24 2012 1 27 06 PM a Task List Pane Lists the tasks created by SharePoint Farm Reporter You can view the task details when you select highlight a task Samplel ask SAmple New ListTask gt List T ask Report Settings Pane This pane shows the report settings for the selected task 61 CHAPTER 4 Power Reports Reports Report Name Scope URL Criteria List Template Export Path Export Type Publish Path Publish Type Publish Option Data Retrieval Settings All web applications Ci Users Public Documents SharePoint Farm Reporter Export Web Page htm Atm http iird24 8000 Shared Documents SharePoint Farm Reporter Web Page htm htr Overwrite Deliver report on na record Yes File Settings Separate File File Mame Mask lt ReportMame gt lt DateandTimeStamp gt Report Category lt Report Category gt Report Name Report Name gt Scope lt Scope gt Header Name Masks URL lt URL gt Number of records lt Number of records gt Criteria lt Criteria gt Date range lt Dake range gt Report Name List General Settings Scope 4ll lists in the connected site and its sub sites URL http ird24 8000 Criteria List Template Al Export Pat
58. d prompt C ProgramFiles SharePointFarmReporter gt SharePointFarmReporterTlaskRun ner MySite Reports D gt C ProgramFiles SharePointFarmReporter SharePointFarmReporterTaskRun ner MySite Reports DOS batch file examples gt gt To execute Power Reports tasks one by one from a batch file C ProgramFiles SharePointFarmReporter SharePointFarmReporterTaskRuner MySite Reports C ProgramFiles SharePointFarmReporter SharePointFarmReporterTaskRuner Sample List Reports To execute multiple Power Reports tasks simultaneously start cmd C ProgramFiles SharePointFarmReporter SharePointFarmReporter TaskRunner MySite Reports start cmd C ProgramFiles SharePointFarmReporter SharePointFarmReporter TaskRunner Sample List Reports 88 CHAPTER 4 Power Reports 4 10 Task Activity View Task Activity View shows you the full task details including start end and elapsed time for the task to run SharePoint reports that were run along with its report status and also a hyperlink to view the report from the exported path Perform the following steps to view the task activity 1 Select a task instance from the Task History pane table 2 Click Task Activity View menu item in the Actions pane Task Activity iew d The exported Files details For all or a selected history event is shown below Select a task From the top grid to view the reports and its corresponding settings in the bottom grid Task Mame taskz3
59. defined for each user group Web Application Zone Allow Anonymous Authentication Mode Allow Client Object Model Requires Use RemoteAPIs Permission Enable Client Integration Disable Kerberos Allow Use Basic Authentication User Group Web URL Web Title List Name Item URL Item Type Item Name Account Type Permission inherited from Permission levels Description User Group Web URL Web Title List Name Account Type Permission inherited from Permission levels Description User Group Web URL Web Title Account Type Permission inherited from Permission levels Description Web URL Web Title Base Template List Name Folder Name Folder URL Groups Users Permission Levels Web URL Web Title Base Template List Name Item URL Item Name Groups Users Permission Levels Web URL Web Title Base Template List Name Account Type Groups Users Display Name Full Name Designation Company Name Description Group 23 CHAPTER 1 About SharePoint Farm Reporter Owner Permission Levels Group Members Site Collection Administrators Site Group Settings Site Permission Levels Site Permissions Site Security Displays information about Web Application Site the site collection Collection URL Created administrators configured Date Admin Type Admin for the site collections Name Admin Login Name Admin E Mail Displays information about Web URL Web Title groups available in e
60. down select an operator and specify the filter data NOTE Operators include a special operator called contains and does not contain Contains determines whether or not a given character string matches a specified pattern The operator does not contain performs the reverse function of the contains operator 105 CHAPTER 5 Custom Reports b Click Add to Filter The selected condition will be added to the criteria list and will be displayed as shown below Criteria Specify conditions to Filter the report data Choose a Field name From the drop down select an operator and specify a value in the value text box You can use QND to Filter OR to filter paranthesis buttons to build enhanced Filter condition Report Name Site Collection Administrators Field Operator Value MMDD Y hh mm ss Created Date gt z AND to Filter Web Application Contains Test Created Date gt 07 01 08 12 00 00 AM A Cancel c Use AND to Filter and OR to Filter parenthesis etc to build an enhanced filter condition as shown in the example below Web Application Contains Test OR Created Date gt 07 01 08 12 00 00 AM d Click OK in Criteria dialog to go back to the criteria page 106 CHAPTER 5 Custom Reports The added criteria will be applied to the report as shown below Specify Report Criteria The following list shows the criteri
61. e After entering Start date and End date click fd button Quick Reports Power Reports 7 Custom Reports Quick Filter Custom view Find Refresh Publish Export E mail Print Preview Bepon UL Fo Scope All sites in web application Group by Web URL Date range Last 30days Permission rae Event Audit Location Level ID Permission Level Old Base New Base Permissions Permissions Occurred Performed By firstsitecoll Create http fird21 8001 1073741939 SPFR Permission Level ViewListItems Add 7 5 2012 11 34 53 4 SHAREPOINT 4 Delete http rd21 8001 1073741936 7 5 2012 12 34 34 j SHAREPOINT S Inheritance Broken http rd21 8001 spfarmreporter 7 5 2012 12 36 28 f SHAREPOINT s Modify http ird21 8001 1073741939 SPFR Permission Level ViewListItems Adi ViewListItems Add 7 5 2012 12 34 27 f SHAREPOINT g http ird21 8001 sites 2sitecol Secondsitecol Create http ird21 8001 sites 2sitecol 1073741927 Secon site Per Level YiewListItems Adc 7 5 2012 12 34 06 SHAREPOINT s Delete http rd21 8001 sites 2sitecol 1073741926 7 5 2012 12 34 43 f SHAREPOINT s Inheritance Broken http rd21 8001 sites 2sitecoli New 715 2012 12 37 29 ji SHAREPOINT g Modify http rd21 8001 sites 2sitecol 1073741927 Secon site Per Level YiewListItems Ad iewListItems Ope 7 5 2012 12 34 14 f SHAREPOINT 4 J Error Number of rows 8 p Audit Profile Changed Report Categor
62. e report should be published 3 Select a file format in which report should be published If the publish type is MDB you can additionally specify the table name 4 Select a report existence check option as required 5 Click Publish button to publish the report to a SharePoint library or folder or Click Cancel to cancel the operation CHAPTER 3 Quick Reports 3 8 Print Report Preview amp Print report z Click Print Previe the button in the toolbar to preview and print reports This will bring up the report viewer and will be displayed as shown below 1 SharePoint Farm Reporter Report iewer 1 oF 1 100 r Find Next da E H Export pif Settings Yyapin s SharePoint Farm Reporter v3 2 11 23 2012 5 45 13 PM Report Category Configuration Reports Report Mame Alternate Access Mappings Scope All web applications URL All Number of records 10 Web Application Internal URL gt URL Zone Public URL for zone http frd21 1010 Default htp frd21 1010 SharePoint Portal 8002 http portal vsslab local Default http portal vsslab local Page 1otf 1 1 Click the Navigation buttons ain UREM to navigate through the report pages 2 Click the Stop Rendering button 2 to stop report rendering the report 3 Click the Refresh button to reprocess the report and reload the data from the cache 4 Click the Print button to print the report 5 Click the Print Layout button
63. ePoint Database in the last N days or for the given date Audit report displays the web pages visited in each site in the last N days or for the given date range Audit report displays the permission changes performed in Groups Users in each site in the last N days or for the given date range Audit report displays permission levels changed in each site in the last N days or for the given date range Audit report displays the changes details about the content types in the connected list in the last N days or for the given date range Audit report displays the list items that are renamed in the last N days or for the given date range Audit report displays the list of items that are restored from the Recycle Bin in the last N days or for the given date range Audit report displays the search queries and scope used in each site in the last Web URL Web Title Action Performed User Name Group Name Occurred Performed By Web URL Web Title List Name Item URL Item Type Item Name Action Occurred Performed By Web URL Web Title Number of Rows Deleted Date Last Deleted Occurred Performed By Performed By ID Web URL Web Title Page URL Occurred Performed By Audit URL Event Group Users ID Groups Users Old Permission New Permission Changes in Permission Occurred Performed By Web URL Web Title Event Permission Level ID Permission Level Old Base Permissions New Base Pe
64. eady exists f Do not overwrite C Overwrite f Create anew version To Address Customize File Format web Page htm html Print Printer Name Microsoft PS Document Writer redirected 3 Page Setup E E mail Apply to M Deliver report even when there are no records to export Next gt Finteh Cancel b Publish Option Select Publish check box and specify a valid SharePoint library folder URL Choose a format and a file existence check option as required 74 CHAPTER 4 Power Reports Reports Wizard Add Report Specify Delivery Options Select any delivery option Export report to a file Publish to a SharePoint library E mail to users and Print Report Name Alternate Access Mappings External Resource Export Export Path FO File Format Web Page htm heml a W Publish Publish URL 9 https irdog 9002 Document library A File format Web Page htm htrml If File already exists Do not overwrite Overwrite Create anew version E mail i To Address 8 Customize File Format web Page htrn html Print Printer Name Fax redirected 2 Page setup Apply to W Deliver report even when there are no records to export lt Back Next gt Finish Cancel c E mail Option Change the To address and report file format as necessary Reports Wizard Add Report 2 Specify Delivery Options Select any deliv
65. eb Title List Name Source URL Source Item Name Destination URL Destination Item Name Occurred Performed By keat e E S eee Quick Reports Power Reports Custom Reports Quick Filter Custom View Find Refresh Publish Export E mail Frink Preview Scope All lists in the connected site and its sub Group by web URL Date range Last 30 days Source Item Destination Destination web URL Web Title List Mame Source URL Heme URL Item Name Occurred Performed B hthp fird2 1 8001 fhes site Test site Shared Documents SHAREPOIN SHAREPOIN SHAREPOIN SHAREPOIN http tird21 8001 Firstsitecall Shared Documents Shared Documents Audit Checked In Iti http tird 21 8001 ne Audit Checked In Iti 6fe2 2012 6 52 08 SHAREPOINT Shared Documents Atte fird21 8001 ne Forest doc gjzz2j2012 6 53 04 SHAREPOIN Shared Documents New Words rtf http fird21 8001 Te New Words rtf 6f22 2012 6 52 50 SHAREPOIN g i IE Sumber of rows 11 Audit Custom Events Report Category Audit and Compliance Reports Audit Custom Events displays information about the custom events occurred in the list items including changes in workflow settings in the last N days or for the given date range This report displays the following information Web URL Web Title List Name Item URL Item Type Item Name Event Name Event Data Occurred Performed By Performed By ID To generate report for given date range c
66. eduler and all sub folders amp files in the respective task folder 4 7 Create Windows Task Use this tool to create a Windows Task in Windows Task Scheduler interface to automatically run the Power Report tasks at scheduled intervals This tool helps you to re create the Windows Schedule Task in the following two scenarios gt To create Windows Schedule Task that was accidentally deleted and is required to be created again with the same schedule settings gt To create Windows Schedule Task when the SharePoint Farm Reporter Power Report tasks are migrated from an old machine to a new machine Click Create Windows Task from Actions Pane or press ALT W to open the Create Windows Task dialog Actions Pane x Task Actions New Edit Copy Er Delete Ey CleanUp History 7 Run Mor m Create Windows Task 84 CHAPTER 4 Power Reports Create Windows Task dialog is shown below In Create Windows Task dialog specify a Run As account and Password and Click OK to create a new schedule task with the same schedule settings that was previously saved by SharePoint Farm Reporter Power Report Task Wizard Create Windows Task Create Windows Schedule Task fin Windows Task Scheduler and associate it with the SharePoint Farm Reporter Power Report bask given below Task Mame Taski Run As VSSLAB spapppoolz_sp10 1 Password sccceenes Cancel 85 CHAPTER 4 Power Reports 4 8 Run Now Select
67. elected report Click Copy to create a copy of the selected report B Hew Sy Edit E gt Copy 5 Delete Web Application Site Collection UAL Created Date Admin Type Admin Hame Admin Login Name Admin E Mail 109 Chapter 6 References 6 1 Alert Messages SharePoint Farm Reporter A Invalid URI The Format of khe URL could not be determined a Check the URL format e g http server name port number sitename b Check the server instance c Spell check the URL SharePoint Farm Reporter Unable to connect to tke tird21 6001 Please ensure the r Following Valid site URL Basic rights view Pages Browse Directories are enabled For the corresponding web application Currently logged on user account has basic rights View Pages Browse Directories in the respective site Currently logged on user account must be an Application Pool user account or must be a member of Administrators group in SharePoint Server and Database Server SharePoint Farm Reporter shows the above alert if the currently logged on user does not have sufficient permissions to retrieve the site or list information in SharePoint Please ensure the currently logged on user has View Pages Browse Directories and Manage Lists rights in the connected site 110 CHAPTER 6 References SharePoint Farm Reporter Error Some errors occured while generating the report information Click Wiew to show the errors or c
68. eporter s Quick Reports output by selecting the desired fields and their field order Power Reports The Power Reports uses Task based approach that allows you to select multiple reports with customized sub set fields defines report criteria and schedule export of reports periodically This feature will enable the user to export multiple reports for several sites lists in SharePoint at periodic intervals 40 CHAPTER 2 Using SharePoint Farm Reporter 2 2 SharePoint Farm Reporter Settings SharePoint Farm Reporter requires the following settings to be configured to generate reports Description SQL Server Settings SharePoint Farm Reporter maintains its application database s in SQL Server To create and maintain database in SQL Server specify the SQL Server Enterprise Standard Developer Express edition and authentication method The user account specified must have sufficient privileges to create and delete the database in SQL Server Directory Server Settings SharePoint Farm Reporter uses the Directory Server to retrieve AD information like group membership user information etc Specify the Global Catalog Server for the Directory Server Name and the corresponding user credentials Email Settings SharePoint Farm Reporter will use the SMTP Server and From Address to e mail the reports to the respective recipients IIS Log Files Directory SharePoint Farm Reporter uses IIS log files for generating a few reports
69. eports Task Manager The Power Reports Task Manager allows you to perform the following operations LJ Create a new task LJ Edit an existing task LJ Copy an existing task 0m Delete a task LJ Run the task immediately _ Cleanup task history J Task Activity View shows the activity of each scheduled instance A Power Reports Task Manager Ctrl M Show Actions Pane Ctrl H Click or Select Tools Quick Reports Ctrl C Power Reports Task Manager CelM Custom Reports Ctrl Show Actions Pane brl H Custom Tiew Cbrl o Quick Filter Ghrl F w Show Error Alert Fe Show Task Status Cbri k ARESP Settings Or press CTRL M to open the Task Manager window 60 CHAPTER 4 Power Reports Task Manager User Interface vy r 2 y J i Be B Quick Reports Power Reports Custom Reports Quick Filter Custom view Find Refresh Publish Export E mail Print Preview gt Task 1 Report Name Data Retrieval Settings gg Task Actions Scope a 6 E New List Template l l Copy Export Path C Users Public Documents SharePoint Farm Reporter Export Export Type Web Page htm html B Delete Publish Path http ird24 8000 Shared Documents SharePoint Farm Reporter F CleanUp History Publish Type Web Page htm htmil Publish Option Overwrite Z Run Now Sen ar SET File Settings File Name Mask lt ReportName gt lt DateandTimeStamp gt z z History A
70. eports to be run for several SharePoint entities namely web applications sites and lists with powerful data filter options and finally run the reports at scheduled intervals The Power Reports tool has the ability to export publish and print the reports to different network locations SharePoint Farm Reporter Power Reports Wizard will help you create and store the settings for a task in the Power Reports Task Manager The scheduled task will take the schedule settings Schedule Type Run As parameter provided using the SharePoint Farm Reporter Power Reports Wizard The task will not run unless a valid password is specified for the Run As parameter Please note the following information prior to using the Power Reports Wizard a The report that is scheduled will be created as a task in Windows Task Scheduler The Schedule Manager allows you to export publish the reports in different file formats MDB CSV HTML PDF TIFF and XLS to the desired path location and or print the scheduled reports b The export option follows the naming convention lt lt export path gt gt lt lt task name gt gt lt lt report generated date and time gt gt lt lt report name gt gt c For each file format MDB HTML CSV XLS TIFF PDF a separate file will be created based on report category For example in MDB file format for each report category an MDB file will be created 59 CHAPTER 4 Power Reports 4 2 Task Manager Power R
71. ery option Export report to a file Publish to a SharePoint library E mail to users and Print Report Name Alternate Access Mappings External Resource Export Export Path n File Format web Page htm htrnl Bore onu I File Format web Page htm htnl If file already exists Donotovermerite gt OQyerwrite Greate a new version W E mail J To Address lane company com john company coml ES Customize File Format web Page htrn htmi Print Printer Name Microsoft XPS Document Writer redirected 2 Page Setup Apply to IY Deliver report even when there are no records to export lt Back Next gt Finteh Cancel 75 CHAPTER 4 Power Reports To check name Click By button If name matches with trusted domain users in the Active directory name entered in From Address text box will be replaced by corresponding active directory user If there is no match for the name entered by the user in Active Directory a dialog will appear as shown below if Check Names Yoapin s SharePoint Farm Reporter does not recognize asdasd Dio pou want bo i Delete this recipient from the list Change to Lancel at Properties east No suggestions anonnnn Select Delete option in the above dialog to remove the recipient name from To address text box Click Cancel button to close this dialog and the unresolved recipient s will
72. h C Users Publici Documents SharePoint Farm Reporter Export Export Type Web Page htm html Deliver report on no record Yes File Settings Separate File File Mame Mask lt Reportlame gt lt DateandTimeStamp gt Report Category lt Report Category gt Report Name lt Report Mame gt Scope lt Scope gt URL lt URL gt Number of records lt Nurnber of records gt Criteria lt criteria gt List Template lt List Template gt Date range lt Date range gt Header Name Masks History Details Pane The task history summarizes the scheduled invocation instances of the selected task in a table format You can refer the Task Activity View to view the details of a specific task schedule instance You can view the errors in the log file listed in the View Log field History Details Stark Time k End Time Status View Log 6 5 2012 11 46 08 AM 65 2012 11 46 14 4M Completed Successfully C Users Public Documents SharePoint Farm Reporter PowerReportsitasktsetlitasktset1 6 5 2012 11 44 24 AM 6fSfe012 11 44 32 AM Incomplete CiUsers Public Documents SharePoint Farm Reporter PowerReportsitasktsetlitasktsetl 6f5f2012 11 38 00 AM 6f5f2012 11 38 07 4M Completed Successfully C Users Public Documents SharePoint Farm Reporter PowerReportsitasktsetl 2012060 Schedule Properties Pane Task Manager shows the schedule properties of the selected task 62 CHAPTER 4 Power Reports
73. h the latest service packs Microsoft Office SharePoint Server 2007 or Windows SharePoint Services 3 0 with latest Service Pack Microsoft Data Access Components MDAC only Microsoft SQL Server 2008 Enterprise Standard Developer 34 CHAPTER 1 About SharePoint Farm Reporter Express edition or Microsoft SQL Server 2005 Enterprise Standard Developer Express edition running in local remote computer with latest Service Pack 1 7 How to Activate the Software Once you purchase the software online or through any one of our resellers you will receive a sale notification through e mail from our sales department We will send you an e mail with the necessary instructions to activate the software In case you do not receive an e mail from our sales team after you purchase the software please send the following information to our sales department at sales vyapin com with the sales order number gt Company Name End user Company Name gt Location City amp Country for the Company Name given above Please allow 12 to 24 hours from the time of purchase for our sales department to process your orders Activate SharePoint Farm Reporter License Type 30 day Evaluation Copy To activate the software copy and paste the license key in the textbox below Click here to see how to copy and paste the license key License Key T H conce Image 1 Activate screen Perform the following steps to activa
74. hapter 5 Custom Reports 5 1 Custom Reports Manager Custom Reports Manager allows the user to manage the custom reports available in the application A custom report can be created by selecting a set of fields from a quick report and save them as a custom report template for re use It also enables storing of criteria for a custom report The Custom Reports Manager allows the user to create edit copy and delete custom reports 3 Custom Report Click See in the toolbar or select Tools gt Custom Reports from the menu bar or press CTRL U to open the Custom Reports Manager Custom Reports Manager window will be displayed as shown below E Custom Reports Manager Custom Reports Manager window shows the list of available custom reports Select a custom report to wiew its description felds and report criteria Click New to create a custom report Click Edit to change the settings for the selected report Click Delete to delete the selected report Click Copy to create a copy of the selected report New Ey Edit ES copy E8 Delete Web Application Site Collection UAL Created Date Admin Type Admin Hame Admin Login Name Admin E Mail 91 CHAPTER 5 Custom Reports New Custom Report Click new button in Custom Reports Manager or press ALT N to open the Custom Reports Wizard Perform the following steps to create a new custom report Step 1 Report Selection page Select Report Select a report to be used as template
75. he deleted sites in the last N days or for the given date range Web URL Web Title List Name Item URL Item Type Item Name Occurred Performed By Web URL Web Title List Name Item URL Item Type Item Name Occurred Performed By SharePoint 2007 Web URL Web Title List Name Source URL Destination URL Item Type Item Name Item Occurred Performed By SharePoint 2010 Web URL Web Title List Name Source URL Source Item Name Destination URL Destination Item Name Occurred Performed By Web URL Web Title List Name Item URL Item Type Item Name Event Name Event Data Occurred Performed By Performed By ID Web URL Web Title List URL Occurred Performed By Web URL Web Title Site Name Occurred Performed By CHAPTER 1 About SharePoint Farm Reporter Audit Group Member Changes Audit Item Actions Audit Log Trimming SharePoint 2010 only Audit Page Visits Audit Permission Changes Audit Permission Level Changes Audit Profile Changed Audit Renamed Items Audit Restored Items Audit Search Audit report displays the list of newly added deleted members in a Group in the last N days or for the given date range Audit report displays the list of created deleted and updated in the last N days or for the given date range Audit report displays the audit events that are deleted from SharePoint Database in the last N days events that are deleted from Shar
76. he connected site and its sub Group by Web URL Date range Last 7 days EA Last Web URL se Item URL Item Name Deleted By User Name sear Deleted Date arial i Sgi inci By ae Name flee Date http rd81 9000 First site WebSizeTestLibrary1 E Event Cache and Log Tab YOYAGER rd81spadminuser3 rd8ispadminuser3 7 23 2009 4 10 51 f vVOYAGER rd8 amp lspad 7 20 2009 5 07 VOYAGER rd81 spy 7 20 200 WebSizeTestLibrary1 F TestFile1005 txt 7 23 2009 4 14 44 VOYAGER rd81spad 5 30 2009 12 4 VOYAGER rd81spi 7 23 200 WebSizeTestLibrary3 ChangeLogBulkFile1005 t 7 23 2009 4 17 51 7 22 2009 1 33 71231200 ChangeLogTestLibrary ChangeLogBulkFile10 txt YOYAGER rd81spadminuser2 rd81spadminuser2 7 23 2009 6 02 49 f 7 22 2009 2 41 YOYAGER rd81spi 7 23 200 ChangeLogTestLibrary ChangeLogBulkFile1008 t YOYAGER rd8ispadminuser3 rd81spadminuser3 7 23 2009 6 19 14 t 7 22 2009 2 45 7123 200 ChangeLogTestLibrary ChangeLogBulkFile1 txt 7 23 2009 6 24 55 f 7 22 2009 2 41 YOYAGER rd81spi 7 23 200 ChangeLogTestLibrary ChangeLogBulkFile100 txt 7 23 2009 6 31 28 7 22 2009 2 41 7 23 200 ChangeLogTestLibrary ChangeLogBulkFile1002 t 7 23 2009 6 33 02 7 22 2009 2 45 7 23 200 ChangeLogTestLibrary ChangeLogBulkFile1000 t 7 23 2009 6 58 27 7 22 2009 2 45 7 23 200 ChangeLogTestLibrary ChangeLogBulkFile 1005 t YOYAGER rd81spadminuser2 rd81spadminu
77. iated log folders and files Remove all Removes all task history entries and their associated log folders and files that are currently displayed Click Close button to close this window 44 Chapter 3 Quick Reports 3 1 How to Generate a Quick Report By using Quick Reports you can generate any report available under different categories like Audit and Compliance Reports Security Reports Policy Reports Usage Reports and Configuration Reports Click File gt Quick Reports to invoke Quick Reports Wizard Quick Reports Wizard Ea m Select a report Select a report For which you want to collect data g RD21 Standard Reports a Description oer Audit and Compliance Reports Displays the list items checked in in the last N days R Sudit Checked In Ikems u E Audit Checked Out Items ae Audit Copied Items s E Audit Custom Events Fields E Audit Deleted Lists Web URL 2 Audit Deleted Sites Web Title Z Audit Group Member Changes List Mame E Audit Item Actions hen i oe Audit Log Trimming ien iE pes Audit Page visits Beane H E Audit Permission Changes Performed By Head Audit Permission Level Changes E Audit Profile Changed Audit Renamed Items Audit Restored Items ae Audit Search ied Audit Settings Changes E Audit visited Items i Checked Owik Geactimente fl ihrars nnlh xl lt Back Next gt E Cancel Select any desired report and
78. ilable for the list URL Web Title Base Template List Name View Name View Type Default View Display Items in Batches Number of Items to Display SharePoint 2010 Web URL Web Title Base Template List Name View Name View Type Default View Allow Inline Editing Allow Individual Item Checkboxes Display Items in Batches Number of Items to Displa List Visits Displays information about Front end Web Server the list items that are Item URL Item ID Total accessed in last N days or Visit Count Item Name 28 CHAPTER 1 About SharePoint Farm Reporter List Workflow Settings List Workflow Status Managed Metadata Collection SharePoint 2010 Only Page Hits Page Hits Monthly Usage SharePoint 2007 Only Page Visits Recycle Bin Summary for the given date range Displays information about workflow details in the list Displays workflow task details and the various workflow status are Cancelled Completed Error Occurred Failed In Progress and Not Started for each list item in the list Displays information about term store in the web application Displays the number of times a web page has been visited in each site Displays the number of times a page in a site has been visited in a given month range or all months in the last 31 months along with last accessed date Displays information about all the pages that are visited in the web applic
79. ile Settings Separate File File Name Mask lt ReportName gt lt Dateand imeStamp gt Header Name Report Category Report Category k Rl ee ee a MML gt lt Back Hest gt Finish Cancel Click Finish completing the reports wizard This will take you back to the New Task screen with the task name and the selected reports Specify the schedule Settings for this task to run and then Click OK to create the task 81 CHAPTER 4 Power Reports New Task Specify the following fields to create the Schedule Task Click Add to select the reports for this task Click Edit to change the settings for the selected report Click Delete to remove the selected report Task name Task 1 Bun as VSSLAB spapppool3_spt o 1 Set Password Domain Mamet User Names Schedule task Daily Start time 11 22 4M Advanced schedule Task Daily Every fi day s Report Settings Report Name Scope URL Criteria Esport Path Export Format All lists in Audit Checked In the terns connected site en E C Users Public Documents SharePoint Web Page htm http dtd 5001 Farm Reporter E sport htral Vien Report Settings dh Add A Edit X Delete You can see the new task properties in Task Manager Window 82 CHAPTER 4 Power Reports 4 4 Edit Task 1 Select a task from the Power Reports Task Manager Window and Click Edit from the Actions Pane 2 Perform the
80. imit response size data source timeout etc Displays general settings information about the list such as versioning enabled version limit etc Displays information about all the list templates available in the site Web Application Internal URL URL Zone Public URL for Zone Web Application Internal URL URL Zone Public URL for Zone Web Application Inherit Central Administration Application Settings Data Retrieval Services Limit Response Size in KB Data Source Time out in seconds Services Enabled Update Support Enabled Web URL Web Title Base Template List Name Description Attachments Enabled On Quick Launch Bar Permission Inheritance Versioning Enabled Minor Versions Enabled Folder Creation Enabled RSS Enabled Major Version Limit Major With Minor Version Limit Unique Role Assignments Force Check Out Allow Content Types Allow Everyone To View Items Web URL Web Title List Template Internal Name Description Document 32 CHAPTER 1 About SharePoint Farm Reporter Site Collection Workflow Templates Site Content Types Site Settings Site Workflows SharePoint 2010 Only Web Application E Mail Settings Web Application General Settings Displays information about the workflow templates configured in each site collection Displays all the site columns that are available in the site Displays all the site content types that are available in the site Disp
81. ion for the report gt Click OK to create a new custom report with the source report settings Delete a Custom Report 1 Select the Custom Report you want to delete 2 Ensure that the custom report you want to delete is not currently in use in any of the Power Reports tasks 3 Click Delete button to delete the selected report 101 CHAPTER 5 Custom Reports 5 2 New Custom Report Click New button in Custom Reports Manager or press ALT N to open the Custom Reports Wizard Perform the following steps to create a new custom report Step 1 Report Selection page F Custom Reports Wizard Fa Select Report Select a report to be used as template to create custom report Click Nest to proceed eat Audit and Compliance Reports Description Ae n B udit Checked In Items Displays the list tems checked in in the last NH days n Audit Checked Out Items Audit Copied Items oe Audit Custom Events E Audit Deleted Lists Fields E Audit Deleted Sites Web URL n E Audit Group Member Changes pie ae ist Name a Audit Item Actions E Them URL a Audit Log Trimming Item Type Audit Page visits Item Name ae Audit Permission Changes Occurred Audit Permission Level Changes Performed By ee Audit Profile Changed E Audit Renamed Items s E Audit Restored Items E Audit Search 4x Back Nest gt gt Finteh Cancel a Select the required
82. ip Start Time lei7j2012 75543 PM End Time lej7i2012 7155 43 PM Elapsed Time 00 00 06 Files List Settings URL locked File Types al All web applications Completed 5 pet UsersiPublici Documents SharePoint F ile Types http ffrd21 8000 All lists in the connected site Completed Successfully Steauy C lUsers Public Domenia SharePoint f Report Name Scope Report Status Exported Path Click Export button to export the table contents to a file The Settings tab shows the settings for the selected report that are provided by the user 89 CHAPTER 4 Power Reports Task Activity iew d The exported Files details For all or a selected history event is shown below Select a task From the top grid to view the reports and its corresponding settings in the bottom grid Task Name taskz3 ap Start Time lef7j2012 755143 PM End Time le 7i2012 7155 49 PM Elapsed Time foo 00 06 TL Files List Settings Report Name Blocked File Types r T Criteria a O Exported Format E Criteria Exported Path C Users Public Documents SharePoint Farm Reporter Exporttask2 3 task23 SPFR RUNNOW 201 2060707554 Exported Format html List Template 4 11 Cleanup History SharePoint Farm Reporter maintains task history including log files and temporary data for each run of the Power Reports task You can cleanup task history periodically using the Cleanup History from Actions Pane 90 C
83. ise ROM 2010 Owners 56 2010 10 59 31 AM catalogs users 6 O00 Enterorise ROM 2010 Visitors SHAREPOINTisvstern hi 4 Sumber of rows 11 Newly Added Items Report Category Audit and Compliance Reports Newly Added Items to view the list items that are added in a list in the last N days or for the given date range This report displays the following information Web URL Web Title Item URL Item Name Created By User Name Created By Display Name Created Date Size in MB To generate report for given date range clickEfputton and enter Start date and End date After entering Start date and End date clickfJ button 18 CHAPTER 1 About SharePoint Farm Reporter Field Name Description Size in MB Displays actual disk usage information of the current List SharePoint Farm Reporter calculates the exact size in terms of bytes for all the items in the list 2 P Refresh Publish Export E mail Print Preview Quick Reports Power Reports i Custom Reports Quick Filter Custom view Find Report Newly Added Items URL http rd30 5050 Documents Documents Data available since 5 6 2010 5 30 00 AM Scope Connected list only Group by Web URL Date range Last 7 days 5 Web URL Web Title Item URL Item Name Created By User Name Created By Created Date Size in Display Name http frd30 5050 Docum Document Center Documents SharePoint SharePoint Designer Settings CONQUEROR rd30spad
84. it to specify the criteria to filter report data Optional Click Nest to proceed Report Name Site Collection Administrators Criteria a lt Back Next gt Fintsh Cancel 94 CHAPTER 5 Custom Reports Click Edit to create a data filter Criteria dialog will be displayed as shown below Criteria Specify conditions to Filter the report data Choose a Field name From the drop down select an operator and specify a value in the value text box You can use 4ND to Filter OR to filter paranthesis buttons to build enhanced Filter condition Report Name Site Collection Administrators Field Operator Value String Format cation Sa ddd to Filter OR bo Filter el G OK Cancel Perform the following steps in this dialog to specify the report criteria a Choose a field name from the dropdown select an operator and specify the filter data NOTE Operators include a special operator called contains and does not contain Contains determines whether or not a given character string matches a specified pattern The operator does not contain performs the reverse function of the contains operator 95 CHAPTER 5 Custom Reports b Click Add to Filter The selected condition will be added to the criteria list and will be displayed as shown below Criteria Specify conditions to Filter the report data Choose 4 Field name From the drop down
85. ite Connected list only Retrieves report information for the connected list only Apply to option is used to apply the same scope and URL to selected reports under the same report category For example if the current report refers the site category then all the selected site category reports are appended with the specified scope and URL settings Click Edit on Scope and URL page to edit the scope x Select the scope for the specihied URL Click Apply to to apply the selected scope tor other UALS Apply to Click Apply to to apply the same URL and scope setting to all the selected reports under the same category Click OK to return to the Scope and URL step 69 CHAPTER 4 Power Reports Step 3 Specify Report Criteria This step allows you to apply specific conditions for filtering report data Reports Wizard Add Report Specify Report Criteria o Click Edit or double click a row to specify the crbena to filter report data Optional Report Name List Columns Scope Filter Apply to Edit lt Back Next gt Fintsh Cancel Click Edit to create a data filter You can also specify the Group By field and number of days through the filter criteria dialog 70 CHAPTER 4 Power Reports Criteria Specify conditions For Filtering the report data Choose a field name From the dropdown BA select an operator and specify a value in the value dropdown You can use A
86. ite collection administartars Details Source Heport Name Site Collection Administrators Selected Fields Admin Login Hame Admin E Mail Site Collection URL Created Date Admin Type Admin Hame Web Application Criteria lt Back Hest gt Finish Cancel 1 Specify unique name and description for the custom report 2 Click Finish saving the new report and closing the custom reports wizard 98 CHAPTER 5 Custom Reports You can view the newly created custom report and its settings in Custom Reports Manager window as shown below Custom Reports Manager Custom Reports Manager window shows the list of available custom reports Select a custom report to wiew its description Helde and report criteria Click New to create a custom report Click Edit to change the settings for the selected report Click Delete to delete the selected report Click Copy to create a copy of the selected report E New By Edit E gt Copy 5 Delete Web Application Site Collection UAL Created Date Admin Type Admin Hame Admin Login Name Admin E Mail This feature allows you to edit an existing custom report Edit a Custom Report 1 Select the custom report you want to edit 2 Click Edit button 3 Edit the report fields and criteria You cannot change the report name but the description is editable 4 Click Finish saving the report settings During edit you can also apply the modified criteria of a cus
87. lays site settings information like time zone theme template etc Displays the information about workflows configured in each site Displays information about the e mail settings for the web application Displays web application general settings information such as default time zone default quota template maximum number of alerts etc Template Type Base Type Category Type On Quick Launch Is Custom Template Web Application Site URL Workflow Template Name Description Associations In Progress Web URL Web Title Column Name Type Type Display Name Group Description Required Web URL Web Title Content Type Description Group Document Template Document Template URL Read Only Version Column Reference Web URL Web Title Description Time Zone Theme Template Quick Launch Enabled Tree View Enabled RSS Enabled Web URL Web Title Workflow Name Initiator Started On Last Run Workflow Status Task Title Task Assigned To Due Date Task Status Outcome Web Application From Address Reply To Address Outbound SMTP Server Web Application Default Time Zone Default Quota Template Presence Enabled Maximum Upload Size in MB Alerts Enabled Alerts Limited Maximum Alerts RSS Feeds Enabled Blog API Enabled Blog API Authentication Enabled Security Validation Enabled Security Validation Expires Security Validation Timeout in minutes Send Login Credentials By E Mail Event H
88. lick Error button in the status bar to view the aN errors in future M Do not show this message again Hote To turn onoff this message press F2 or click Show Error Alert in Tools menu SharePoint Farm Reporter shows the above alert when it encounters any errors while generating a report Click View button to view the errors and the possible resolution Check Do not show this message again checkbox to turn off the alert You can turn on the alert messages again from the Tools menu You may also view the errors in a report by clicking on the Error button in the bottom status bar of SharePoint Farm Reporter application SharePoint Farm Reporter While generating the Page Visits List Visits and Last Deleted Items reports the above alert window will appear when the logging is disabled in IIS SharePoint Farm Reporter Xx A This report reguires logging to be enabled Please refer STS Log Settings section in SharePoint Farm Reporter help file for more deatails Page Hits Site Hits Summary Site Visitors and List Hits reports requires STS logging to be enabled to generate the report Enable the Enable Logging and Enable usage analysis processing options in the Usage Analysis Processing section in the SharePoint Central Administration SharePoint Farm Reporter A Audit settings are not configured For the selected site URL 111 CHAPTER 6 References Share
89. lick EPt button in the toolbar to export report data Export Options dialog will be displayed as shown below Export Select the export path format fle name and table name for the report to be exported Export Path a a aE File Format HTML File Hame Site Features a Export to time stamped sub folder Hote This evaluation version exports only 10 records Cancel 1 Select or enter a valid export path where the report should be stored 2 Enter a valid file name for the report to be stored 3 Select a file type file format for the export file If the file type is MDB you can additionally specify the table name 4 Click OK button to save the report in the specified path CHAPTER 3 Quick Reports 3 Publish Report Click Publis button in the toolbar to publish the report to a SharePoint Library Publish dialog will be displayed as shown below Publish Specify a file name and a library UAL to publish this report Click button to specity the library URL File name web Application Summary Publish to http 7165 7777 5 hared Documents Report Data e g http dbo rr r Shared Documents Falder File format HTML Table name IF a report with the same name already exists f Do not overwrite C Overvarite Create a new version Publish Cancel 1 Enter a file name for the report to be published 2 Select a SharePoint library or folder location where th
90. lick button and enter Start date and End date After entering Start date and End date clickfJ button CHAPTER 1 About SharePoint Farm Reporter 5 XK E Y eel a p Quick Reports Power Reports Custom Reports Quick Filter Custom view Find Refresh Publish Export E mail Print Preview Scope All lists in the connected site and its sub Group by Web URL Date range Last 30 days EA Web URL d a List Name Item URL miele Item Name Event Name Event Data Occurred Performed By i rformed Bal http frd21 8001 firstsitecoll BulkLib Migrate BulkLib Migrate Wwhat i Document NA Item Disposition Approved lt ApprovedBy gt SHAR 6 15 2012 2 SHAREPOINT systern 1073741823 Shared Documents Shared Documentts Document print button png Item Disposition Approved lt ApprovedBy gt SHAR 6 18 2012 4 SHAREPOINT system 1073741823 Shared Documents Document arksp iis log files Item Disposition Approved lt ApprovedBy gt SHAR 6 18 2012 4 SHAREPOINTisystem 1073741823 Tasks Lists Tasks WF FOldet ListItem Fi Item Disposition Approved lt ApprovedBy gt SHAR 6 18 2012 4 SHAREPOINT system 1073741823 Lists Tasks WF FOldet ListItem Jay Item Disposition Approved lt ApprovedBy gt SHAR 6 18 2012 1 SHAREPOINT system 1073741823 Team Discussion Lists Team Discussion ListItem NA Item Disposition Approved lt ApprovedBy gt SHAR 6 18 2012 4 SHAREPOINTI system 1073741823
91. minuser2 conqueror rd30spadminu 5 8 2010 2 42 19PM 0 96 Documents Resource TH Resource Throttling Settings bt CONQUEROR rd30spadminuser2 5 8 2010 2 42 35 PM 0 905 Documents SharePoint SharePoint Designer Settings CONQUEROR rd30spadminuser2 5 8 2010 2 42 45 PM 0 835 Documents Custom_Reg Custom_Reports bmp CONQUEROR rd30spadminuser2 5 8 2010 2 44 14 PM 0 07 Documents Splash bmp Splash bmp CONQUEROR rd30spadminuser2 5 8 2010 2 44 23 PM 0 437 Documents Quick Repor Quick Reports details bmp CONQUEROR rd30spadminuser2 5 8 2010 2 44 30PM 0 07 2 4 Number of rows 8 Sandboxed Solutions Report Category Audit and Compliance Reports Sandboxed Solutions to view the solution s resource usage and its status details Displays the following information Web Application Site Collection URL Solution Name Solution Id Solution Status Total Average Resource Usage Last 14 days Total Current Resource Usage Today ha E pee e EEE ce Mee ees aA Quick Reports Power Reports CustomReports Quick Filter Custom view Find Refresh Publish Export E mail Print Preview Report zE e Bere 8 te a URL Scope All web applications Total Average Resource Solution Status UsagetLast 14 days Total Current Resource Web Application Site Collection URL Solution Mame Solution Id Usage Today int 9000 http firdo 9000 BlogSaugeProjectiwsp Sbcb6665 bbc9 4d6d 85 Activated Error Number of rows
92. n List Columns Displays all the columns Web URL Web Title Base available in the list Template List Name Column Source Column Name Type Description Required List Hits Displays the information Web URL Web Title List about number of times a list Name Total Hits Recent has been visited in the last Month Hits Last Accessed N days or for the given Date Last Accessed Date date range Hits List Hits Monthly Displays the information Web URL Web Title List Usage SharePoint about number of times a list Name Total Hits Month1 2007 Only has been visited in the last Month2 Month31 31 months or for the given date range List Item Metadata Displays information about Web URL Web Title List SharePoint 2010 metadata of the list item URL List Name Item URL Only Item Name Column 1 Column 2 Column n List Item Summary Displays summary Web URL Web Title Base information about the list Template List Name Item items such as created by URL Item Name Created created date size etc By Created Date Modified By Modified Date Size in MB List Summary Displays summary Web URL Web Title List information about the list Name Base Template such as size number of Number of Columns users number of columns Number of Users Number etc of Folders Number of Items List Size in MB Author Created Date Last Modified Date Last Deleted Date List Views Displays all the views SharePoint 2007 Web ava
93. n the last N days or for the given date range This report displays the following information Web URL Web Title List Name Item URL Item Type Item Name Occurred Performed By Display Name Full Name designation company Name To generate report for given date range click E button and enter Start date and End date After entering Start date and End date clickladbutton Scope All lists in the connected site Group by Web URL Date range Last 7 days EA List Item Display A Company Nam Web URL f hare Item URL Type lane Occurred Performed By hana Full Name Designation http frdi0 9001 AuditCheck2 AuditCheck2 Fort List AuditCheck2 20 03 2012 12 20 55 YAPINLAB billy Billy F Doctrove Billy F Doctrove AuditCheck2 Fort Document NA 20 03 2012 12 20 55 VY APINLAB billy Billy F Doctrove Billy F Doctrove AuditCheck2 Fort List AuditCheck2 23 03 2012 12 59 16 VY APINLABYjohndoe John Doe John Doe Software Consy SS AuditCheck2 Fort Document NA 23 03 2012 12 59 16 VY APINLAB johndoe John Doe John Doe Software Consy w55 AuditCheck2 List AuditCheck2 23 03 2012 12 59 17 YYAPINLABjohndoe John Doe John Doe Software Consy w55 AuditCheck2 Blog Document Blocked File Tyg 23 03 2012 12 59 17 YYAPINLABjohndoe John Doe John Doe Software Consy v55 AuditTest1 AuditTest1 Form List AuditTest1 20 03 2012 12 20 53 YAPINLAB billy
94. nfirmation and deletion settings for unused web site collections Definition Allow Site Owners and Designers to Customize Master Pages and Layout Pages Allow Site Owners and Designers to See the Hidden URL structure of their Web Site Web Application Allow SharePoint Designer to be used in this Web Application Allow Site Collection Administrators to Detach Pages from the Site Template Allow Site Collection Administrators to Customize Master Pages and Layout Pages Allow Site Collection Administrators to see the URL Structure of their Web Site Web Application Site URL Owner Login Name Quota Template Storage Maximum Level in MB Current Storage Used in MB Storage Warning Level in MB Read Locked Write Locked Web Application Send Unused Site Collection E Mail Notification Send Notifications After in days Unconfirmed Site Collection Deletion Enabled Number of Notifications Before Deletion 26 CHAPTER 1 About SharePoint Farm Reporter 1 4 Usage Reports SharePoint Farm Reporter provides the following built in reports in the usage reports category Report Name Content Alerts Content Databases File Types Invited Users Feature Status List Activity Description Displays information about all the alerts created for notifying the changes Displays properties of the content databases in each web application Displays the file types available in the document library
95. ng table summarizes the behaviour of the find feature john doe Searches the report for john doe followed by zero characters default aspx Searches the report for default aspx starting with zero or more characters and ending with zero characters library Searches the report for library starting with zero or more characters and ending with zero or more characters Document Searches the report for Document Center starting with zero Center characters and ending with zero or more characters CHAPTER 3 Quick Reports 3 4 Filter Data Y Click Quick Filter button in the toolbar to specify the conditions for filtering report data Quick Filter a Y Specify condition For Filtering the report data Choose a field name From the dropdown select an operator and specify a value in the value Field Field Mame Operator Value String Format lear Filter OK Cancel Select a field from the drop down and specify the value for filtering the report data Click OK button to view the data filtered report 3 5 Refresh Data SharePoint Farm Reporter displays data from the local data store until the data is refreshed zs To Refresh data Click Pets button in the toolbar to recollect the data from the SharePoint again NOTE Once you closed the report window and generate the same report again SharePoint Farm Reports collects the fresh data from the SharePoint CHAPTER 3 Quick Reports 3 6 Export Report i C
96. nt Preview Scope All lists in the connected site Group by web URL Date range Last 30 days List Mame Them URL Item Mame Occurred Performed By 4 000 Updated 6 15 2012 6 56 54 P SHAREPOINTisystem Announcements Lists 4nnouncement Listtem Deleted 6 15 2012 6 56 31 P SHAREPOINTIsystem B A Lists Announcements ListItem what s new in 2 1 od Deleted 6 15 2012 6 55 44 P SHAREPOINT system_ Lists Announcements ListItem a Deleted aay i Li Sumber of rows 459 Audit Log Trimming SharePoint 2010 only Report Category Audit and Compliance Reports Audit Log Trimming displays the audit events that are deleted from SharePoint Database in the last N days or for the given date range This report displays the following information Web URL Web Title Number of Rows Deleted Date Last Deleted Occurred Performed By Performed By ID To generate report for given date range click Efbutton and enter Start date and End date After entering Start date and End date click fd button eee 4 E a a eee een vee a Quick Reports Power Reports Custom Reports Quick Filter Custom View Find Refresh Publish Export E mail Print Preview Scope All sites in web application Group by Web URL Date range Last 30 days 5 Number of Rows Deleted h 7 Firstsitecall Fiof2012 10 45 00 AM F 5f2012 10 38 00 4M SHAREPOINT system 10737419023 http iird 1 8001 sites 2sitecal Secondsitecal FiSf2012 10 45 00
97. nts First Site First Site Coll pdf First Site File Types html First Site Coll File Types html 79 CHAPTER 4 Power Reports Report Header SharePoint Farm Reporter also provides option to specify report headers that is displayed on the top of the report You can define report header by selecting header masks as available in the dialog Add Report Header Ea Spec a report header name and select headers masks to construct the report header value Header name Headert Header masks Header Value Report Category Web Application Report Mame Blocked File Types Scope All web applications UAL All Number of records 1196 Criteria web Title First Site Date range Last 7 days Insert Header value Report Names Scope OF Cancel You can use the Apply to option to apply the specified settings in this step to all the selected reports Click Next to proceed to the next and final step of adding reports 80 CHAPTER 4 Power Reports Step 6 Report Summary This step displays the summary information for each report Reports Wizard Add Report Report Summary The following table shows the summary details of the selected report Click Finish to save the report settings T Report Hame Audit Checked In Items All lists in the con http 4 rd21 8001 a Export Path C Users Public D ocuments SharePoint Farm Reporters Export Type Web Page htm htrl Deliver report Yes F
98. option the table header remains visible on the screen while the user scrolls down the page Showing and hiding the Report columns ShowsHide Cal Click Show Hide Columns button Show Hide Columns to select remove the columns to view and export them CHAPTER 3 Quick Reports Report columns selection x Choose Columns iw Web Title iw Base Template ke List Hame kel Humber of Folders kel Humber of Items kel List Size in MB kel Humber of Users kel Humber of Columns ke Author iw Created Date ke Last Modified Date ke Last Deleted Date Select All Clear All OF Cancel Report Headers data Report Settings Report Headers Application Name Vyapin s SharePoint Farm Reporter yvs 2 Date 112372012 5 45 15 PM Report Sub headers Report Category Configuration Reports Report Name dltemate Access Mappings Scope jail web applications URL All Humber of records f j CHAPTER 3 Quick Reports 3 9 E mail Report Click E mail button in the toolbar to e mail the report to e mail recipients E mail dialog will be displayed as shown below es E mail Report Fa Specify SMTP Server name From Address To address Subject Body of the e mail message attachment Format and option to attach the report as zip File Format SMTP Server Sever From janei company com it To johnicompany com e Check Subject pata Retrieval Settings Attachment Format HTML M
99. ore the application settings Log folder to store error log file Export folder for exported reports Power Reports folder for Power Reports task related information SQL Server database for data storage When you uninstall SharePoint Farm Reporter through Control Panel Add Remove Programs applet Windows Installer program will remove only the application files from your machine But the application related files created by SharePoint Farm Reporter remain in the computer In order to remove SharePoint Farm Reporter worker files completely the uninstall wizard provides a set of cleanup options to perform the cleanup operation based your selection Use this wizard to cleanup the files that are created by SharePoint Farm Reporter application selectively and uninstall SharePoint Farm Reporter completely from the machine 1 Launch the uninstall wizard by clicking Start gt Programs gt SharePoint Farm Reporter gt SharePoint Farm Reporter Uninstall Wizard 116 CHAPTER 6 References The SharePoint Farm Reporter Uninstall Wizard dialog will be shown as below SharePoint Farm Reporter Uninstall Wizard E4 Welcome to SharePoint Farm Reporter Uninstall Wizard N This wizard helps you to cleanup and uninstall the SharePoint Farm Reporter completely Ko This wizard will guide you through the steps to cleanup the files that are created by SharePoint Farm Reporter application Using this wizard vou can Cleanup export tasks and t
100. ormation about self service site creation settings for each web application Displays information about the SharePoint Designer Settings configured in the Site Collection Report Fields Web Application Blocked File Types Web URL Web Title Locale Time Zone Calendar Alternate Calendar Work Days First Day of Week First Week of Year Start Time End Time Time Format Web Application List View Threshold Object Model Override List View Threshold for Auditors and Administrators List View Lookup Threshold Daily Time Window for Large Queries Daily Unthrottled Operations Hour Daily Unthrottled Operations Minute Daily Unthrottled Operations Duration Maximum Unique Permissions Per List Change Log Retention Period Web Application Self Service Site Creation Enabled Require Secondary Contact Web Application Site Collection URL Allow Site Owners and Designers to use SharePoint Designer in this Site Collection Allow Site Owners and Designers to Detach Pages from the Site 25 CHAPTER 1 About SharePoint Farm Reporter SharePoint Designer Settings Web Application Level SharePoint 2010 Only Site Collection Quotas and Locks Web Application Use Confirmation and Deletion Displays information about the SharePoint Designer Settings configured in the Web Application Displays information about the site collection storage settings and lock settings Displays information about the co
101. re allows the user to instantiate a task from DOS command prompt anytime after a Power Reports task has been created using SharePoint Farm Reporter Power Reports task wizard To run a SharePoint Farm Reporter Power Reports task from command line 1 Usage SharePointFarmReporterTaskRunner lt task name gt Where SharePointFarmReporterTaskRunner Task name Name of the SharePoint Farm Reporter Task Runner application Specify absolute path where the SharePointFarmReporterTaskRunner located For example C Program Files SharePoint Farm Reporter SharePointFarmReporterTaskRunner Name of the SharePoint Farm Reporter Power Reports task to be run from DOS command prompt Enclose the task name in double quotes For example MySite Reports 2 The Power Reports task will be reported in a new dialog as shown below 87 CHAPTER 4 Power Reports SharePoint Farm Reporter Task Runner for Task 1 Start Time Friday August 24 2012 2 37 41 PM Report Name Data Retrieval Settings Action Retrieving Data Retrieval Settings information For SharePoint 8001 SSS nnn Overall Progress ns E Elapsed Time 00 00 00 01 3 Once the task is completed click Refresh button available in Task History pane in SharePoint Farm Reporter main application A new entry will be added in Task History section where you can view the report performed Examples of invoking a Power Reports task from the comman
102. rePoint IV Click Apply To to apply the same criteria for various URLs within the same report category and report V Click OK in Criteria dialog to go back to the reports wizard 72 CHAPTER 4 Power Reports The applied criteria will be added to the report as shown below Reports Wizard Add Report Specify Report Criteria Click Edit or double click a row to specify the criteria to filter report data Optional Report Name List Columns Scope URL Group By Filter web Title Starts With S ample Alllists in the connected site Atte rb 1010 Web UAL OR web Title Ends With SharePoint gt Apply to Edit lt Back Next gt Fintsh Cancel Click Next to proceed to the next step 73 CHAPTER 4 Power Reports Step 4 Specify delivery options Export Publish E mail and Print settings This dialog allows you to choose one or more report delivery options a Export Option Change the Export path and export file format as necessary Reports Wizard Add Report Specify Delivery Options Select any delivery option Export report to a file Publish to a SharePoint library E mail to users and Print Report Name Audit Checked In Items wf Export Export Path C Users Public Documents SharePoint Farm Reporter Export x File Format Web Page htm html Publish Publish URL P File Format web Page htm htrnl If File alr
103. report to be used as template You can view a short description and the fields for the selected report in the right pane b Click Next to proceed to the next step Click Back anytime to go back to a previous step 102 CHAPTER 5 Custom Reports Step 2 Fields Selection page This step allows you to select the required fields from the report fields Custom Reports Wizard 3 Select required fields Select required fields from the available fields You can use the up down Buttons to order helde in the selected feld list Click Nest to proceed Report Name Site Collection Administrators Available Fields Selected Fields Web Application Site Collection UAL Created Date Admin Type Admin Mame Admin Login Hame Admin E Mail El w a lt Back Next gt Fintsh Cancel Perform the following steps in this dialog a Select the required field s to add You can use gt to add a field to the selected cite ter ana Eel a fields list and to remove a field from the selected fields list b Select a field from the selected fields list and click or to move the field one position up or down Also click E or to move the field to the first or last position in the field list c Click Next to proceed to the next step Click Back anytime to go back to a previous step 103 CHAPTER 5 Custom Reports Custom Reports Wizard Custom SIte Admin Select required fields Select required fields f
104. rmissions Occurred Performed By Web URL Web Title List Name Content Type Name Group Name Performed On Performed By Web URL Web Title List Name Old Name New Name Occurred Performed By Web URL Web Title List Name Item URL Item Type Item Name Occurred Performed By Web URL Web Title Query Search Scope Occurred Performed B CHAPTER 1 About SharePoint Farm Reporter date range Audit Settings Changes Audit report displays information about the audit settings changed in the site collection in the last N days or for the given date range in the site collection in the last N days or for the given date range Audit report displays the list items visited in the last N days or for the given date range or for the given date range Audit Visited Items Checked Out Documents Displays the list of Library only documents that are checked out in a library Farm Features Displays farm activated features and its dependency details Last Deleted Items Displays the list of items that are Deleted in last N days or for the given date range Last Modified Items Displays the list of items that are Modified in last N days or for the given date range Newly Added Items Displays the list of items that are created in last N days or for the given date range Sandboxed Solutions SharePoint 2010 Only Displays the solution s resource usage and its Status details Web URL Web Title
105. rom the available fields you can use the up down buttons to order fields in the selected field list Click Nest to proceed Report Name Site Collection Administrators Available Fields Selected Fields Admin Login Hame Admin E Mail Admin Name Site Collection UAL le Le le be 4 lt Back Next gt Finish Cancel Step 3 Specify Report Criteria This step allows you to apply specific conditions for filtering report data Custom Reports Wizard i x z Specify Report Criteria The following list shows the criteria for the custom report Click Edit to specify the criteria to filter report data Optional Click Nest to proceed Report Name Site Collection Administrators Criteria e lt Back Next gt Fintsh Cancel 104 CHAPTER 5 Custom Reports Click Edit to create a data filter Criteria dialog will be displayed as shown below Criteria w Specify conditions to Filter the report data Choose a Field name From the drop down select an operator and specify a value in the value text box You can use AND to Filter OR bo Filter paranthesis buttons to build enhanced Filter condition Report Name Site Collection Administrators Field Operator Value String Format Web Application Add to Filter OR bo Filter 3 hl A OK Cancel Perform the following steps in this dialog to specify the report criteria a Choose a field name from the drop
106. rs Number of Groups Number of Alerts Content Database Name Web URL Web Title Total Hits Recent Month Hits Recent Day Recent Day Hits Web URL Web Title Total Hits Month1 Month2 Month31 Web URL Web Title Author Created Date Last Item Modified Date Web Size in MB Number of Sub webs Number of Users Number of Groups Number of Lists Number of Alerts Number of Content Types Number of Site Columns Web URL Web Title Created Date Modified Date No of sub webs No of lists No of list items Storage MB Total Hits No of visited users User User Hits Web URL Web Title User Total Hits Recent Month Hits Recent Day Recent Day Hits Web URL Web Title Site Visitors Last Accessed Date Total Hits Month1 30 CHAPTER 1 About SharePoint Farm Reporter Version History Web Application Summary Web Pages Web Parts Utilization range or all months in the last 31 months along with last accessed date Displays information about all the versions available for each file item in the list Displays web application information such as application pool name content database version etc Displays information about all the web pages that are available in each site Displays information about utilization size used web pages etc of all the web parts in the site s web part gallery Month2 Month31 SharePoint 2007 Document URL Latest Version Number of Versions Ve
107. rsion ID Created By Created Date Modified By Modified Date Size in MB SharePoint 2010 Item URL Latest Version Number of Versions Created By Created Date Version ID Modified By Modified Date Size in MB Changed Field Changed Value Web Application Version Host Name Port Number Zone Allow Anonymous Authentication Mode Authentication Provider Use Secure Sockets Layer Application Pool Name Application Pool Status Identity Type User Name Number of Content Databases Content Databases Web URL Web Title Web Page Title Web Page URL Author Web Part Title Created On Last Modified Page Size in KB Total Size in KB Web URL Web Title Web Part Title Web Part Name Web Page Title Web Page URL Parent Folder Author Created On Last Modified Size in KB 31 CHAPTER 1 About SharePoint Farm Reporter 1 5 Configuration Reports SharePoint Farm Reporter provides the following built in reports in the configuration reports category Report Name Alternate Access Mappings Alternate Access Mappings External Resource Data Retrieval Settings List General Settings List Templates Description Displays the public URLs from Alternate Access Mappings Configured in the web application Displays the public URLs from Alternate Access Mappings Configured in the external Web Application Displays information about data retrieval settings such as data retrieval services l
108. ser2 7 23 2009 6 59 35 7 22 2009 2 45 71231200 gt 17 CHAPTER 1 About SharePoint Farm Reporter Last Modified Items Report Category Audit and Compliance Reports Last Modified Items to view the list items that are modified in a list in the last N days or for the given date range This report displays the following information Web URL Web Title Item URL Item Name Modified By User Name Modified By Display Name Modified Date Size in MB To generate report for given date range click button and enter Start date and End date After entering Start date and End date click button Field Name Description Size in MB Displays actual disk usage information of the current List SharePoint Farm Reporter calculates the exact size in terms of bytes for all the items in the list Keen enna Y EEEE N W B Quick Reports Power Reports Custom Reporks Quick Filter Custom View Fin Refresh Publish Export E mail Print Preview Report URL Data available since 5 6 2010 5 30 00 AM Scope All lists in the connected site Group by JwebURL st s i sSY Date range Last 7 days B Modified Web URL Web Title Item URL Item Name eee pean 7 Modified Date Size in MB Name http rd30 S5050 Enterprise ROM 201 _catalogs users 1_ 000 conquerorird30spadminuserl SHAREPOINTisystem System Account 5 62010 10 58 07 AM SitePages Home aspx Home aspx SHAREPOINT system 0 005 0 0085 Enterpr
109. set the Change Log Retention period for the corresponding web application Central Administration gt Application Management gt Web Application General Settings gt Change Log link in SharePoint Central Administration site You can view the last run time of timer job by clicking on the Change Log job corresponding to the destination web application using Central Administration gt Operations gt Timer Job Definitions link in SharePoint Central Administration site You can view the status progress start time and server of the Change Log job using Central Administration gt Operations gt Timer Job Status link in SharePoint Central Administration site You can view modify the scheduled run time of the Change log job using the command line SharePoint Administration Tool stsadm exe as shown in the article mentioned below Windows SharePoint Services Job change log expiration Stsadm property http technet microsoft com en us library cc424964 aspx Office SharePoint Server Job change log expiration Stsadm_ property http technet microsoft com en us library cc424949 aspx Applicable Reports Newly Added Items Last Modified Items Last Deleted Items List Activity Site Activity STS Log Settings SharePoint Farm Reporter collects information from STS log files for the reports stated below These reports require STS logging to be enabled to generate the report How to configure in SharePoint 2010 Enable the Usage data collec
110. splays information about activated features and its dependency details for all web applications Displays user permissions defined for each web application Displays security information for web parts and web part pages in each web application Report Category Audit and Compliance Reports Web Application Site URL Feature Name Feature Folder Name Description Action Dependency Feature Hidden Web URL Web Title Feature Name Feature Folder Name Description Action Dependency Feature Hidden Web Application Feature Name Feature Folder Name Description Action Dependency Feature Hidden Web Application User Permissions Allow TO Allow Part Web application Web Parts Communicate Access To Cataloog Web Audit Checked In Items displays the list items checked in in the last N days This report displays the following information Web URL Web Title List Name Item URL Item Type Item Name Occurred and Performed By To generate report for given date range E click button and enter Start date and End date After entering Start date and End date clicklfadbutton A oh AHH VX i s e EEE f Y Hi E ea 53 E Quick Reports Power Reports Custom Reports Quick Filter Custom view Find Refresh Publish Export E mail Print Preview Report Audit Checked In Items URL lato ffrde4 6000 Scope All lists in the connected site and its sub Group by web URL Date range Last 30 days ey web Item I
111. t Category Audit and Compliance Reports Audit Permission Changes displays the permission changes performed in Groups Users in each site in the last N days or for the given date range It displays the following information Occurred Audit URL Event Group Users ID Groups Users Old Permission New Permission Changes in Permission Performed By B e E Torriko Bo Mee e P A Quick Reports Power Reports Custom Reports Quick Filter Custom wiew Find Refresh Publish Export E mail Print Preview Beport Audit Permission Changes URL http jird21 8001 Scope Connected site only Group by Occurred Date range Last 30 days 5 Group Users Old New Changes in f Occurred Audit URL Ever ID Groups Lsers Permission Permission Permission 6202012 5 40 54 Bato ird21 8001 Remove Permission 13 Aaron Cook M 1 SHAREPOINT system 4 d Performed By Sumber of rows 845 11 CHAPTER 1 About SharePoint Farm Reporter Audit Permission Level Changes Report Category Audit and Compliance Reports Audit Permission Level Changes It displays permission levels changed in each site in the last N days or for the given date range It displays the following information Web URL Web Title Event Audit Location Permission Level ID Permission Level Old Base Permissions New Base Permissions Occurred Performed By To generate report for given date range click button and enter Start date and End dat
112. te range click button and enter Start date and End date After entering Start date and End date click button eS a a He Ey E Quick Reports Power Reports Custom Reports Quick Filter Custom View Find Refresh Publish Export E mail Print Preview Scope All sites in web application Group by web WAL Date range Last 30 days o web URL web Title Action Performed User Mame Group Name v Occurred Performed By 2 http ird21 8001 fsites 2sil Secondsitecol Group Member 4dded SHAREPOINT system SHAREPOINTIsystem SHAREPOINT system SHAREPOINTsystem Atte ffrd21 8001 Firstsitecoll Group Member 4dded SHAREPOINT systern SHAREPOINT system Group Member Deleted SHAREPOINT system SHAREPOINT system SHAREPOINT system y 4 H ot Error Number of rows 13 Audit Item Actions Report Category Audit and Compliance Reports Audit Item Actions displays the list items created updated and deleted in the last N days or for the given date range This report displays the following information Web oO CHAPTER 1 About SharePoint Farm Reporter URL Web Title List Name Item URL Item Type Item Name Action Occurred and Performed By To generate report for given date range click button and enter Start date and End date After entering Start date and End date clickfadbutton B e Tr ETE TEN SETET gt B21 fF ob e Si A Quick Reports Fower Reports Custom Reports Quick Filter Custom view Find Refresh Publish Export E mail Pri
113. te the software 35 CHAPTER 1 About SharePoint Farm Reporter 1 Download evaluation trial copy of software from the respective product page available in our website at http www vyapin com Install the software on the desired computer You will receive a icense key through e mail aS soon as the purchase process is complete Click Activate in Help gt About gt Activate menu to see the Activate dialog as shown in Image 1 Copy the license key sent to you through email and pastes it in the License Key textbox For help on how to copy the license key click Click here to see how to copy and paste the license key link in the Activate dialog as shown in Image 2 How to copy license key x BEGIN LICENSE KEY COPY BELOW THIS LINE 4Select and then Copy the iw selected text WICTAYIKw YPBAGCH Tg Dol ICbhTCCAmKGCis GAG O Bgjd Y Au GgggJ4tlIC VOID Ag ABA p Hvatpiog3 HGrb3s Gyk S4U14gx23900 Po HF Bimxt Og 1d Lk J9 Pg Tish Ht PW SAk DALS RRS Let ES Fri Ss Tal Keie RStminn Sige WWR e SS tg0be AN OOTEO Y20F Grd bf OHpti 4isket R IviH Rvp Pts Lem ka Tdr Gyk RAO tg Ox Yrsawtg Teon E3Hbzns O01 Ap 18AluF Plow HW gqoom Tq 5 G Tage SphiBdsCfk dn OO Tn THS Me tbhDitd2 Hs CuT Y R2 Mt Nosky LOSS bk taf P C Poigiy Amdi 1Jgvirnjwer si Maw LO JSbb6m O02 P R9rvinLytlah GukOpJdp Kgalt LEIS Ff Gs Ott U txbw F Edd P B P P24 U Jp O Erdiko Ph Taw C Opg9 01 Ad P EDW Yudh r Ron Od Hewhikm Ae EHD LICENSE KEY
114. ter Web URL Title List Mame Item URL Type eee w Occurred Performed By WSSLABLyuan WSOSLAB yuan SSLAB yuan WSSLABLYyuan http rd24 3000 firstsitecoll sales Force management sales Force management touti Document MA WSSLAB yuan VSOSLOB yuan WSSLAB yuan VWOSLAB yuan SSLABL yuan WSSLAB yuan 4 H Sumber of rows 42 CHAPTER 1 About SharePoint Farm Reporter Audit Checked Out Items Report Category Audit and Compliance Reports Audit Checked Out Items displays the list items checked out in the last N days or for the given date range This report displays the following information Web URL Web Title List Name Item URL Item Type Item Name Occurred and Performed By To generate report for given date range click button and enter Start date and End date After entering Start date and End date click fd button a IN O B ra Quick Reports Power Reports Custom Reports Quick Filter Custom View Fin Refresh Publish Export E mail Print Preview Hepork 4udit Checked Gut Items URL https fird21 8001 Scope All lists in the connected site and its sub Group by Web URL Date range Last 30 days Web URL ee List Mame Them URL Them Type Item Mame Occurred Performed Bry f http fird21 6001 Firstsitecoll BulkLib Migrate BulkLib MigratesiMiB Averag Document sample metadata xlsx 6 18 2012 5 07 03 PM SHAREPOINT system 6 16 2012 5 08 55 PM SHAREPOINT system
115. tion and Configure web analytics and health data collection options in the Configure usage and health data collection section in SharePoint Central Administration Please Visit http technet microsoft com en us library ee663480 aspx to view detailed information about how to enable STS logging How to configure in SharePoint 2007 Enable the Processing Settings and Logging Settings options in Configure Usage Analysis Processing in the SharePoint Central Administration Please Visit http Ssupport microsoft com kb 825541 to view detailed information about how to enable STS logging Applicable Reports Page Hits Page Hits Monthly Usage Site Visitors Site Visitors Monthly Usage Site Hits Summary Site Hits Summary Monthly Usage List Hits List Hits Monthly Usage 39 CHAPTER 2 Using SharePoint Farm Reporter 5 6 IIS Log Settings SharePoint Farm Reporter collects information from IIS log files for the mentioned reports These reports require IIS logging to be enabled to generate the report How to configure Enable the Enable Logging option in IIS for the web application Please Visit http technet microsoft com en us library cc754631 WS 10 aspx to view detailed information about how to enable IIS logging Applicable Reports Page Visits List Visits SQL Server Settings SharePoint Farm Reporter uses SQL Server database for its data storage to generate SharePoint reports It requires SQL Server 2005 or S
116. to create custom report Click Nest to proceed eat Audit and Compliance Reports Description Bf Sudit Checked In Items ee Audit Checked Out Items Displays the list teme checked in in the last H days mI Audit Copied Items a Audit Custom Events E Audit Deleted Lists Fields E Audit Deleted Sites Web URL Audit Group Member Changes eel l ist Mame pe Audit Item Actions eee les z Audit Log Trimming itemi Tepe E Audit Page Visits tten Mane ne Audit Permission Changes Occurred re Audit Permission Level Changes Performed By E Audit Profile Changed E Audit Renamed Items s E Audit Restored Items E Audit Search 4x Back Nest gt gt Finteh Cancel a Select the required report to be used as template You can view a short description and the fields for the selected report in the right pane b Click Next to proceed to the next step Click Back anytime to go back to a previous step Step 2 Fields Selection page This step allows you to select the required fields from the report fields 92 CHAPTER 5 Custom Reports E Custom Reports Wizard Select required fields Select required fields from the available fields You can use the up down buttons to order fields in the selected field list Click Nest to proceed Report Name Site Collection Administrators Available Fields Selected Fields Site Collection UAL Created Date Prim
117. to display the report columns with the specified column width CHAPTER 3 Quick Reports ca Merge repeated cells Merge repeated Cells Select the checkbox to enable cell merging for the currently selected column This option enables the data in the specified column to be merged together if its rows are repeated with same values Apply to all columns Click the _ Apply to all columns _ button to apply the settings of the currently selected column to all the available report columns By using this the width and cell merging settings of the currently selected column can be applied to all other columns Sorting You can interactively change the sort order while viewing a report by clicking the icon located next to the column header name to sort them in ascending or descending order NOTE The interactive sort done using the icon is only for interactive viewing purposes and will not be reflected in the exported data In order to export the data in a particular sorted order you must instead use the report settings M Sort on this column checkbox to regenerate the report with the specified sort direction for that column To modify the Table column header settings Select the M Henesttable header rows on each page checkbox to display table header rows on each page on which the table appears Select the i Table header should remain visible while scrolling checkbox to use a fixed header with the table When you choose this
118. tom report to Power Reports tasks that uses this updated custom report Upon clicking Finish after editing a report Apply to dialog showing the list of tasks and URL will be displayed as shown below 99 CHAPTER 5 Custom Reports T Apply to l Zi Lists all the Power Reports tasks and ther URLs that use the selected custom report Select the tasks and URLs in which vou want to update the report critena using the current report settings and click OF to apply SelectAll OF Cancel 1 Select the tasks and URLs for which you want to update the report criteria 2 Click OK to apply the current criteria to the selected URLs la Apply to l x Lists all the Power Reports tasks and ther URLs that use the selected custom report Select the tasks and URLs in which wou want to update the report critena using the current report settings and click OF to apply SelectAll OF Cancel 100 CHAPTER 5 Custom Reports Copy a Custom Report gt Select the Custom Report you want to copy gt Click Copy button Copy Custom Report dialog will be shown as below Ea Copy Custom Report Specify a report name and description to copy an existing report to a new report This action will copy report Helde and critena of an existing report Report Hame Recent Site Collections Save As Copy of Recent Site Collections Description Site Collection Administratora OF Cancel gt Enter a valid name and descript
119. tto Awww vyapin com Sales Contact sales vyapin com Technical Support support vyapin com Table of Contents 1 About SharePoint Farm Reporter 1 1 1 2 1 3 1 4 1 5 1 6 1 7 Audit and Compliance Reports Security Reports Policy Reports Usage Reports Configuration Reports System Requirements How to Activate the Software 2 Using SharePoint Farm Reporter 2 1 2 2 2 3 2 4 How to Get Started with SharePoint Farm Reporter SharePoint Farm Reporter Settings Change Application Data Folder Location Task Status 3 Quick Reports 3 1 3 2 3 3 3 4 3 5 3 6 3 7 3 8 3 9 How to Generate a Quick Report Custom View Find Data Filter Data Refresh Data Export Report Publish Report Print Report E mail Report 4 Power Reports 4 1 About Power Reports 23 25 27 32 34 35 37 37 41 42 44 45 45 48 49 50 50 51 52 53 57 59 59 Table of Contents 4 2 Task Manager Power Reports Task Manager 4 3 New Task 4 4 Edit Task 4 5 Copy Task 4 6 Delete Task 4 7 Create Windows Task 4 8 RunNow 4 9 Runa task from command line 4 10 Task Activity View 4 11 Cleanup History 5 Custom Reports 5 1 Custom Reports Manager 5 2 New Custom Report 6 References 6 1 Alert Messages 6 2 Troubleshooting 6 3 Technical Support 6 4 Howto Uninstall SharePoint Farm Reporter 7 Index 60 65 83 83 84 84 86 87
120. up Member Changes Audit Item Actions Audit Page Visits Audit Permission Changes Audit Permission Level Changes Audit Profile Changed Audit Renamed Items Audit Restored Items Audit Search Audit Visited Items Change Log Settings Change Log Reports display information about the newly added last modified and last deleted items in a SharePoint list library default built in list or custom list for a period of last N days or for the number of days in a data range SharePoint Farm Reporter retrieves change information using SharePoint objects from the content database to present the reports to the user How to configure in SharePoint 2010 You can set the Change Log Retention period for the corresponding web application in its resource throttling settings Central Administration gt General Settings gt Resource Throttling gt Change Log link in SharePoint Central Administration site You can view the last run time of timer job by clicking on the Change Log job corresponding to the destination web application using Central Administration gt Monitoring gt Review Job Definitions link in SharePoint Central Administration site You can view the status progress start time and server of the Change Log job using Central Administration gt Monitoring gt Timer Job Status link in SharePoint Central Administration site 38 CHAPTER 2 Using SharePoint Farm Reporter 4 How to configure in SharePoint 2007 You can
121. y Adds entry points in the rb Fab ia Administrative Reporting Corf AdminReportCorePushdown This feature activates the AY me o Base Ste Features Stoping BaseSitesteping Staple Bass features me a BDC Profle Pages Tenant Sta ObaProflePagesTenantStapl Staples Profle Pages feature The 140 Buk workflow process butter BulkWorkflow Adds the process altasks by me ia DM Content Type Setting Link DMContentTypesettings DLC Document Management True o Enhanced Html Editing EnhencedHtmiEdting Enhanced Html Edting forth me 1 Version Sumber of rows 42 Last Deleted Items Report Category Audit and Compliance Reports Last Deleted Items to view the list items that are deleted in a list in the last N days or for the given date range This report displays the following information Web URL Web Title Item URL Item Name Deleted By User Name Deleted By Display Name Deleted Date Created By User Name Created Date Last Modified By User Name Last Modified Date Size in MB To generate report for given date range click button and enter Start date and End date After entering Start date and End date click button Field Name Description Size in MB Displays actual disk usage information of the current List SharePoint Farm Reporter calculates the exact size in terms of bytes for all the items in the list Report URL http rd81 9000 Data available since 7 12 2009 4 38 42 PM Scope All lists in t
122. y Audit and Compliance Reports Audit Profile Changed displays the changes details about the content types in the connected list in the last N days or for the given date range This report displays the following information Web URL Web Title List Name Content Type Name Group Name Occurred Performed By To generate report for given date range click button and enter Start date and End date After entering Start date and End date clickfadbutton 12 CHAPTER 1 About SharePoint Farm Reporter A a E E E T E F Quick Reports Power Reports CustomReports Quick Filter Custom View Find Refresh Publish Export E mail Frink Preview Beport Audit Profile Changed URL Jhttp frd21 8001 fkestsite Look Up Fields Library Scope Group by weblRL Z Date range taxsodeys web URL Web Title List Marne Content Type Name Group Name Occurred Performed By Atta iird2 18001 fbestsite Test site Look Up Fields Library SHAREPOINT system Sumber of rows 10 a Audit Renamed Items Report Category Audit and Compliance Reports Audit Renamed Items displays the list items that are renamed in the last N days or for the given date range This report displays the following information Web URL Web Title List Name Old Name New Name Occurred Performed By To generate report for given date range click button and enter Start date and End date After entering Start date and End date click button Mess Ej Y mi
123. y is currently configured and the permissions rights granted for users amp groups on various objects gt Analyze your SharePoint usage and track user activity with the detailed Usage Reports gt View and Tweak your SharePoint configuration parameters for better control and performance using the in depth Configuration Reports gt Enforce internal business process policies to control how information is managed in SharePoint using the Policy Reports CHAPTER 1 About SharePoint Farm Reporter 1 1 Audit and Compliance Reports SharePoint Farm Reporter provides the following built in reports in the audit and compliance reports category Report Name Audit Checked In Items Audit Checked Out Items Audit Copied Items Audit Custom Events Audit Deleted Lists Audit Deleted Sites Description Audit report displays the list items checked in in the last N days or for the given date range Audit report displays the list items checked out in the last N days or for the given date range Audit report displays the list items that are copied to another location in the last N days or for the given date range Audit report displays information about the custom events occurred in the list items including changes in workflow settings in the last N days or for the given date range Audit report displays the deleted lists in each site in the last N days or for the given date range Audit report displays t

User Manual SharePoint Farm Reporter

Contents

Download Pdf Manuals

Related Search

Related Contents