OIS - Data Extraction and Reporting Kit 1.0

Rating: No reviews yet
Downloads: 262
Released: Dec 17, 2010
Updated: Nov 3, 2011 by charlesjoy
Dev status: Stable Help Icon

Recommended Download

Example OpalisDataExtractionandReportingKit
example, 133K, uploaded Dec 17, 2010 - 262 downloads

Release Notes

Opalis Data Extraction and Reporting Kit

The Opalis Data Extraction and Reporting Kit is a sanitized* and packaged “kit” of examples you can use as a guide for your own Opalis powered Reporting use case. This example content is based on and directly related to the following blog post: http://blogs.technet.com/b/charlesjoy/archive/2010/12/16/8-minute-demo-scdemo-reporting-powered-by-opalis.aspx

Included in this Data Extraction and Reporting Kit:

Download File: OpalisDataExtractionandReportingKit.zip
  • Example Sanitized Workflows
    • RPTDBWorkflowTemplates.ois_export
  • Example Hyper-V PowerShell Script
  • Example OS PowerShell Script
    • VMHostOSAudit.ps1
  • Example OS CLI Commands
    • CLICommands.txt
  • Example SQL Database Table and View Structure
    • SQL Scripts for the DROP/CREATE and SELECT Statements
    • 16 Individual .sql DROP/CREATE files
  • Example C# Script for Parsing Input
    • ParseGroupMembers.cs
  • Example Sanitized Excel 2010 Report
    • RPTDBUsageReport.xlsx

*SCDEMO has been changed to RPTDB, all production names and references have been removed, all non-reporting workflows have been removed, etc.

Reviews for this release

No reviews yet for this release.