Search
InstantDoc ID
GO

Browse By: Author | Issue

September 10, 2009 08:10 PM

Use SSIS to Access WMI Data on Multiple Servers

The WMI Data Reader task makes it possible
Rating: (0)
Gabriela Nanau
SQL Server Magazine
InstantDoc ID #102563
Executive Summary:
Through Windows Management Instrumentation (WMI), Windows OSs expose a lot of information about the hardware and software installed on the machines. This information is accessible through Windows Query Language (WQL) queries. Using WMI and WQL, you can create a SQL Server Integration Services (SSIS) package that collects hardware and software data from networked computers, then stores it in a Microsoft SQL Server table for further usage. The SSIS element that makes this possible is the WMI Data Reader task.

...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Great article. I am in the process of implementing a similar solution but I am needing to read logs from a remote machine and I am having issue with security. I am not using NT authentication. Any insight would be appreciated.

alfrye1 12/15/2009 9:00:29 AM

Great article... I haven't dealt with SSIS very much and I was able to create and run this without any issue. Many Thanks!!

tazzman2911 11/2/2009 8:42:09 AM

You must log on before posting a comment.

Are you a new visitor? Register Here

Related Resources

The Essential Guide to SQL Server 2005 BI
A Essential Guides by Dell
A Jump Start to SQL Server BI
A EBooks by Microsoft
Moving SQL Server to the x64 Platform
A EBooks by AMD
Top 8 Considerations for Sizing a Microsoft SQL Server BI Solution
A Tip Guides by Hewlett-Packard
More

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.