Here you will find a quick guide on how to create additional spreadsheets for the SMS Client Health Pivot Table Report.
Using the SMS Client Health Pivot Table Report can be further extended to allow you to create new Sheets in the ClientHealthPivot.xls spreadsheet that allow you to see all of the detailed information collected from the SMS 2003 Client Health Monitoring tool in one place.
Before proceeding in order to ensure that you are reviewing the latest or most recent data you should first make sure that the “Client Health Pivot Table Report” is up to date and then we can get an accurate assessment of the clients to review the unhealthy ones by following the steps below.
1. From the Programs group select “Microsoft SMS 2003 Client Health Monitoring Tool”. Then select “Client Health Pivot Table Report”.
2. The Microsoft Excel - ClientHealthPivot.xls spreadsheet opens. From the “Pivot Table” floating toolbar menu use the “Pivot Table” drop down arrow and select “Refresh Data”
Note: If the Refresh Data dialog box appears you can select “Don’t show this menu again.” If needed otherwise select “OK” to continue with the next step.
Tip: If the “Pivot Table” floating toolbar menu does not appear (Step 2) select “View” from the Excel toolbar and then select “Toolbars” and then select “Customize”. From the Customize dialog box scroll down and place a check in the box “Pivot Table”. When the “Pivot Table” floating toolbar appears click “Close” on the Customize dialog box.
3. At this point the latest client health data information is displayed
4. In Cell A16 (“Classification”) of the Microsoft Excel - ClientHealthPivot.xls spreadsheet use the drop down arrow and select “(Show All)” and then click “OK”.
5. Under Cell B16 (“LastPingResult”) of the Microsoft Excel - ClientHealthPivot.xls spreadsheet select “(Show All)” and click “OK” once again.
6. Then locate The “Grand Total” column for the item that you want to create a new sheet for in the listed “LastPingResult” column and then double click on the count and a new sheet will appear.
7. At this point you can rename the sheet as appropriate from “Sheet 1” as needed by double clicking on “Sheet 1” from the tab at the bottom of the spreadsheet. Then to save the results form the “File” menu select “Save”.
No Comments