1 / 11

NTSMF Web-Based Reporting Techniques

NTSMF Web-Based Reporting Techniques. Jim Quigley conEdison. Performance Reporting with the Microsoft Office Web Components. CMG’93 Sunday Workshops. Agenda. SasToOwc.htm Historical Produce charts from SAS WmiToOwc.htm Real-Time Produce charts from WMI. Office Web Components.

kirk
Download Presentation

NTSMF Web-Based Reporting Techniques

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. NTSMF Web-BasedReporting Techniques Jim Quigley conEdison

  2. Performance Reportingwith the MicrosoftOffice Web Components

  3. CMG’93 Sunday Workshops

  4. Agenda • SasToOwc.htm • Historical • Produce charts from SAS • WmiToOwc.htm • Real-Time • Produce charts from WMI

  5. Office Web Components • ActiveX Objects • Ship with Microsoft Office 2000c:\Program Files\MicrosoftOffice\Office\MsOwc.dll • Spreadsheet - OWC.Spreadsheet • Chart - OWC.Chart • Pivot Table - OWC.PivotTable • DSC - OWC.DataSourceControl

  6. SasToOwc.htm • Uses SAS OLE DB Provider • sas.LocalProvider • \SAS Institute\Shared Files\SAS OLE DB Data Providers\sasafbas.dll • Auto-installs with SAS version 8 • Allows direct SAS file access • Does not support SQL • Field label access is difficult from script

  7. SasToOwc.htmDemo

  8. WmiToOwc.htm • Uses WMI scripting API • WMI - Windows Management Interface • WBEM compliant CIM implementation? • Complete systems management API • Including performance management • Uses High-Performance Provider • Windows 2000 only

  9. Windows 2000Performance Monitoring

  10. WmiToOwc.htmDemo

  11. WSH Script - WmiWss.vbs Server = InputBox("Enter the name of a server to query")Set Locator = CreateObject("WbemScripting.SWbemLocator")Set Service = Locator.ConnectServer(Server, "root\cimv2")Service.Security_.ImpersonationLevel = 3 'impersonationsql = "Select Name, WorkingSetSize From Win32_Process“Set ObjSet = Service.ExecQuery(sql, , 0)For Each i In ObjSet x = i.WorkingSetSize if isnull(x) then x = 0 Msg = Msg + i.Name + " = " + CStr(x) + vbCrLf NextMsgBox Msg

More Related