Business Intelligence: Using SQL 2008 Reporting Services and SQL Report Builder 2.0 with Log Parser
来源:互联网 发布:哪里有淘宝号买 编辑:程序博客网 时间:2024/05/20 06:27
转载:http://blogs.msdn.com/saveenr/archive/2009/02/01/business-intelligence-using-sql-2008-reporting-services-and-sql-report-builder-2-0-with-log-parser.aspx
Business Intelligence: Using SQL 2008 Reporting Services and SQL Report Builder 2.0 with Log Parser
This post will illustrate a very simple end-to-end walkthrough of how you can use SQL 2008 reporting features to expose and analyze system administration information. This post will demonstrate the creation and deployment of a simple SSRS report that shows all the events in the "System" event log.
Step 1: reparation
What you'll need
- Log Parser 2.2: Download details- Log Parser 2.2
- SQL Report Builder
- SQL 2008 (with Reporting Services installed)
Assumptions
- You have two machines - a development workstation and a separate SQL server that has the database and reporting services installed
- IIS installed and configured in your windows server machine
Notes about the demo:
- Be aware that all the server screenshots are done on a beta build of Window Server 2008 R2. You will see some obvious differences from Windows Server 2008 UI.
- The name of the SQL server in this example is "isotope"
Step 2: Create a Database in SQL to hold the data from LogParser
Launch SQL Management Studio, and create a new Database called "DemoLogParser"
One the DemoLogParser DB is created, you'll see there are no tables.
We'll change that in a moment.
Step2: Populate the DemoLogParser DB with a table of data from the System event log
Start LogParser and run this command
LogParser.exe "SELECT * INTO eventlog_system from System" -o:SQL -server:isotope -database:DemoLogParser -createtable:ON
Now if you example the DemoLogParser database you'll see a table called "dbo.eventlog_system" has been created. Examine the table and you'll see all the columns that logparser created
Step 3: Design a Report With Report Builder 2.0
NOTE: for these steps, the demo assumes they are being done from a separate developer workstation. (in this example they are being done on my primary desktop called "saveenr10")
Launch SQL Report Builder
Create a new DataSource to the DemoLogParser database. Call this DataSource "DataSourceLogParser"
Create a new DataSet to for the event log table, call this "DataSetSystemEventLog"
Then add the DataSet as a table to the report. Some of the fields will be automatically aggregated (for example with "Sum") so clear that from the fields.
Preview the report
Step 4: Deploy the Report to the SSRS Server
Save the Report as an RDL file and upload it to the SSRS Server
Step 5: View the Report
Now you can see the report via SSRS
Parting Thoughts
- Security - this is a demonstration. Event logs can contain sensitive information; don't expose data like without without thinking through who can see it.
- The end report isn't very fancy - as you explore the feature set of Report Builder 2.0 you can easily make create an appealing layout and style.
- logparser is a nice way to get some quick simple demo data if you need to explore building reports. Again, be aware of inadvertently revealing sensitive information.
- logparser - it is far more powerful than this post shows.
- Business Intelligence: Using SQL 2008 Reporting Services and SQL Report Builder 2.0 with Log Parser
- Working with Report Snapshots in SQL Server Reporting Services Hyperlink
- Using Reporting Services to Search the SQL Server Log
- Practical Business Intelligence with SQL Server 2005
- The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence T
- SQL Server 2008 Reporting Services
- Using Visual Studio 2005 to Perform Load Testing on a SQL Server 2005 Reporting Services Report Server
- SQL Reporting Services配置
- Using Reporting Services SharePoint Web Parts in SQL Server 2000 Reporting Services Service Pack 2
- Using Reporting Services SharePoint Web Parts in SQL Server
- Top 3 open source business intelligence and reporting tools
- Pro SQL Server 2008 Reporting Services
- Applied Microsoft SQL Server 2008 Reporting Services
- SQL Server 2005 Integration Services (SSIS) (3) - Business Intelligence Development Studio
- SQL Server 2005 Integration Services (SSIS) (3) - Business Intelligence Development Studio
- Ten Common SQL Server Reporting Services Challenges and Solutions(转)
- Business Intelligence Reporting through Datazen
- 添加条码生成和打印功能到SQL Server Reporting Services report 中
- 竟然上传了有bug的资源,自责下
- 颠覆C#王权的“魔比斯环” — 实现AOP框架的终极利器
- 中国经济要掌握好分寸啊
- c#全角半角转换
- javascript访问frame,iframe框架和href的定向
- Business Intelligence: Using SQL 2008 Reporting Services and SQL Report Builder 2.0 with Log Parser
- Selenium与JavaScript--Selenium深入浅出之三
- 解析SQL Server中如何得到自动编号字段
- 认识ASP.NET配置文件Web.config
- 大家好!欢迎加入QQ技术交流群。
- C/C++编程新手错误语录(续二)
- Flex笔试 (面试题)
- 什么是Linux系统,Linux与UNIX系统区别和Linux的创始人简介
- 应用程序域