Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

SSIS & WMI Data Reader Task Query Expand / Collapse
Author
Message
Posted Friday, May 27, 2011 8:34 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 7:50 AM
Points: 404, Visits: 1,124
try downloading the WMI code creator:

It will help you write the queries you need to retrieve the data your after.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=2CC30A64-EA15-4661-8DA4-55BBC145C30E


_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #1116293
Posted Wednesday, August 03, 2011 3:09 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 7:34 AM
Points: 18, Visits: 344
Hi great article Just modified it a bit to get a inventory via WMI of all the Physical Processors instead of cores, works great and added it into the DBA_MORNING_CHECKS ssis package
Post #1153334
Posted Wednesday, August 03, 2011 2:17 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 7:50 AM
Points: 404, Visits: 1,124


Cool. Nice to see it's been useful and aided your daily routines.

What details are you recording on the physical processors?


_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #1153865
Posted Thursday, March 22, 2012 3:12 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 8:17 AM
Points: 2, Visits: 187
This was amazingly helpful - 5 starts!
Post #1270682
Posted Thursday, October 25, 2012 5:02 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 8:38 AM
Points: 34, Visits: 545
Hi

I have followed this article step by step and get the following error.

Error at DiskUsage: The connection "ServerName=\\;Namespace=\root\cimv2;UseNtAuth=True;UserName=;" is not found. This error is thrown by Connections collection when the specific connection element is not found.

Any ideas?

thanks


Post #1376919
Posted Thursday, October 25, 2012 5:37 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 7:50 AM
Points: 404, Visits: 1,124
Hi,

looking at the error, it's not picking up the servername correctly, so check the source table column names and inparticular look at step 6 again..

Step 6 - Building The Server Query Loop
Now we have server to query, we can build the loop to iterate through the server list.

Add a For each Loop Container to the data flow work area and name it FELC Server Query. Double-Click the For Each Loop Container and select Collection. On the Collection form,

•set the ADO Object Source Variable to User::ServerList.
•Select the Enumeration mode to Rows in the first table
•Under Variable mappings, map the Variable User::ServerConnString to index 0.


make sure you are mapping the variable User::ServerConnString to an index value of 0



_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #1376934
Posted Thursday, October 25, 2012 6:20 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 8:38 AM
Points: 34, Visits: 545
Hi

Thanks for the quick response.

The source table [server_query_list] has the server name without a forward slash e.g. [Servertest]. The ServerConnString is set to 0.

thanks


Post #1376948
Posted Thursday, October 25, 2012 8:23 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 7:50 AM
Points: 404, Visits: 1,124
stick a breakpoint on the WMI task and check the variable value pre wmi query execution and check the value is ok

Also on the wmi_conn connection manage review the connection string expression.

let me know what you have in there

is short the problem is the value isn't being set in the connection string so it's pin pointing where the server name is getting lost


_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #1377015
Posted Friday, October 26, 2012 5:10 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 8:38 AM
Points: 34, Visits: 545
Hi

I finally got there at the end, it was something in the WMI connection manager

thanks again
Post #1377483
Posted Friday, October 26, 2012 11:25 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 7:50 AM
Points: 404, Visits: 1,124
No probs - glad you got it working

_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #1377757
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse