{"id":545,"date":"2007-04-27T10:57:37","date_gmt":"2007-04-27T14:57:37","guid":{"rendered":"http:\/\/www.wehuberconsultingllc.com\/wordpress\/?p=545"},"modified":"2008-01-27T23:44:40","modified_gmt":"2008-01-28T03:44:40","slug":"publishing-isa-reports-on-your-sharepoint-site","status":"publish","type":"post","link":"https:\/\/wehuberconsultingllc.com\/wordpress\/2007\/04\/27\/publishing-isa-reports-on-your-sharepoint-site\/","title":{"rendered":"Publishing ISA Reports on your Sharepoint site"},"content":{"rendered":"<p>Here&#8217;s the problem. You want to look at your firewall reports regularly. You have gone so far as to set up ISA to publish the daily and monthly reports to a directory on the server but getting to yesterday&#8217;s report is a real pain in the butt. It would be nice to send the report via email as a pdf like Trend does or to have it appear on the home page of your sharepoint site. Although I may do the email option in the nearby future I have already completed the second option. Here is how I did it.<\/p>\n<ol>\n<li>Publish the ISA reports you are interested in to a directory if you have not already done it.<\/li>\n<li>Add a virtual directory to your default web site and point it at your report directory. For this example I will use <code>srv1<\/code> as the server name and <code>isa<\/code> as the virtual directory name. This virtual directory points to my ISA reports directory located at <code>h:\\reports<\/code>. To get to the Daily report for 4\/25\/2007 I would use the following URL, <code>http:\/\/srv1\/isa\/Daily_(4.25.2007-4.25.2007)\/report.htm<\/code>. As you can see entering this URL can get pretty tedious.<\/li>\n<li>To solve this problem I created a small web page with some javascript that calculates the URL to yesterday&#8217;s ISA report and then redirects you there. I called that page, <code>daily.htm<\/code>, and put it in the <code>Reports<\/code> directory. So if I wanted to see yesterday&#8217;s ISA report, I would enter the following URL into my browser, <code>http:\/\/srv1\/isa\/daily.htm<\/code>, and the latest ISA daily report would pop up.<\/li>\n<li>Now since we have a URL that will always point to the latest ISA daily report, the Page Viewer Web Part becomes a simple solution to the problem. The Page Viewer Web Part gives me a peak at the Daily report and it makes it easy for me to browse the rest of the report. I created a similar web page that produces Monthly report. I put links to both pages and the directory in my Sharepoint Links list and My Favorites.<\/li>\n<\/ol>\n<p>Although I used this technique for looking at firewall reports it could be easily modified to show a web page with key business indicators that you create daily, weekly, or monthly.<\/p>\n<p>Here is the code for the <code>daily.htm<\/code> web page.<\/p>\n<pre class=\"brush: xml; title: ; notranslate\" title=\"\">&lt; !DOCTYPE html PUBLIC &quot;-\/\/W3C\/\/DTD XHTML 1.0 Strict\/\/EN&quot; &quot;http:\/\/www.w3.org\/TR\/xhtml1\/DTD\/xhtml1-strict.dtd&quot;&gt;\r\n&lt;html xmlns=&quot;http:\/\/www.w3.org\/1999\/xhtml&quot; xml:lang=&quot;en_US&quot; lang=&quot;en_US&quot;&gt;\r\n&lt;head&gt;\r\n&lt;meta name=&quot;generator&quot; content=&quot;HTML Tidy&quot; \/&gt;\r\n&lt;meta http-equiv=&quot;content-type&quot; content=&quot;text\/html; charset=UTF-8&quot; \/&gt;\r\n&lt;script type=&quot;text\/javascript&quot;&gt;\r\n\/\/&lt; !&amp;#91;CDATA&amp;#91;\r\nfunction getRptDate()\r\n{\r\nvar now = new Date();\r\nvar ydate = new Date(now.getTime() - 86400000);\r\nvar yday = ydate.getDate();\r\nvar ymon = ydate.getMonth() + 1;\r\nvar yyear = ydate.getFullYear();\r\nvar datetext = ymon + '.' + yday + '.' + yyear + '-' + ymon + '.' + yday + '.' + yyear;\r\nreturn datetext;\r\n}\r\n\/\/&amp;#93;&amp;#93;&gt;\r\n&lt;\/script&gt;\r\n&lt;\/head&gt;\r\n&lt;body&gt;\r\n&lt;script type=&quot;text\/javascript&quot;&gt;\r\n&lt;!--\r\nvar d = getRptDate();\r\nvar path = 'http:\/\/srv1\/isa\/';\r\nwindow.location = path +'Daily_(' + d + ')\/report.htm';\r\n\/\/--&gt;\r\n&lt;\/script&gt;\r\n&lt;\/body&gt;\r\n&lt;\/html&gt;<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Here&#8217;s the problem. You want to look at your firewall reports regularly. You have gone so far as to set up ISA to publish the daily and monthly reports to a directory on the server but getting to yesterday&#8217;s report is a real pain in the butt. It would be nice to send the report &hellip; <a href=\"https:\/\/wehuberconsultingllc.com\/wordpress\/2007\/04\/27\/publishing-isa-reports-on-your-sharepoint-site\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Publishing ISA Reports on your Sharepoint site&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[6],"tags":[21,125,17],"class_list":["post-545","post","type-post","status-publish","format-standard","hentry","category-sbs2k-sbs2k3","tag-isa","tag-sbs","tag-sharepoint"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4iN3d-8N","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/posts\/545","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/comments?post=545"}],"version-history":[{"count":0,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/posts\/545\/revisions"}],"wp:attachment":[{"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/media?parent=545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/categories?post=545"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/tags?post=545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}