Here you will find a trick to use that will allow you to export a specified SMS web report to a file name and location of your choosing from the Web Reporting page on your local workstation.
Say you are executing the SMS Web Report “Count Clients assigned and installed for each site” and you want to save the results as a CSV or even as a text file. You can do so by selecting “Export” from the menu bar or you can add the following to the end of the URL for the report:
&ExportTo=C:\YourFileName.Csv
Example:
Http://SmsServerName/SmsReporting_XXX/Report.asp?ReportId=103&ExportTo=C:\YourFileName.Csv.
Note: It is important to note here that the C:\ drive specified will not be the C:\ drive on the Workstation or server that web report is run from but will be the C:\ drive of the specified SmsServerName in the URL. You can however redirect the URL to use a UNC path to an existing file share as in the following:
&ExportTo=\\ServerName\ShareName\YourFileName.Csv
Http://SmsServerName/SmsReporting_XXX/Report.asp?ReportId=103&ExportTo=\\ServerName\ShareName\YourFileName.Csv
Tip: The above can also be used for ConfigMgr 2007 as well as SMS 2003.
This means of saving a report is not any faster or simpler than choosing Export and browsing for a place to save the report file however from a scripting aspect it can be used in a number of ways.
For example you can create a VBS or PowerShell script to allow you to export those web reports that you use quite often without having to memorize the Report ID for the report. You can also use the redirect syntax as a scheduled task to run after hours or at a specified interval so that the report will be waiting for you when you need it.
No Comments