ntsmf web based reporting techniques n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
NTSMF Web-Based Reporting Techniques PowerPoint Presentation
Download Presentation
NTSMF Web-Based Reporting Techniques

Loading in 2 Seconds...

play fullscreen
1 / 11

NTSMF Web-Based Reporting Techniques - PowerPoint PPT Presentation


  • 73 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'NTSMF Web-Based Reporting Techniques' - kirk


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
agenda
Agenda
  • SasToOwc.htm
    • Historical
    • Produce charts from SAS
  • WmiToOwc.htm
    • Real-Time
    • Produce charts from WMI
office web components
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
sastoowc htm
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
wmitoowc htm
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
wsh script wmiwss vbs
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