June 25, 2009 at 9:20 am
cool - it's nice to know it's useful. What have you adapted it for?
I'm building another package using WMI query, to get back a list of software on each PC ( again from a DB, but this time from our helpdesk application), with a view to eventually setting up a SSAS cube for installed software on company PC and also a Report Model to assist our helpdesk team to get an nice and easy overview of all software installed on a machine.......I may possibly pump that back into our helpdesk.
Needs a little more work first, but once I have some better error handling I'll probaly stick it up on a site for sharing.
😀
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
June 25, 2009 at 9:27 am
dave (6/25/2009)Needs a little more work first, but once I have some better error handling I'll probaly stick it up on a site for sharing.
Or maybe document it in an article? :Whistling:
June 26, 2009 at 2:45 am
I've not written one before, have you got any sort of outline of what it should cover, or is it simply what I want to ramble on about?
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
June 26, 2009 at 9:29 am
June 26, 2009 at 9:50 am
Dave,
We'd be happy to work with you to get an article done.
The first step is usually stop and think essay, think about high school/college, and structure things like that. Write a sentence (I will show you how to write a WMI query that xxxx") and the refer back to that to be sure you're supporting that with your article.
Usually I have people write an intro that gives the reasoning how/why someone came up with this particular item. then go into the details. Show the code that works, maybe show what you tried that didn't work or how it evolved. Then summarize at the end.
You can submit it with the "Contribute" link on the left and we'll give you feedback.
June 29, 2009 at 2:24 am
Ok thanks. I'll hopefully have something done by the end of the week.
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
July 3, 2009 at 3:37 am
Well, i've posted my article! Hopefully it's pretty good, but let me know.
I've also uploaded a pdf versions, with nicer formating. 😀
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
July 6, 2009 at 9:29 am
July 6, 2009 at 10:03 am
It's predominately like my original guide, just with a little more explination and alot tidier. It's worth looking at the PDF if it's published, as it's a bit easier to follow with the screen shots.
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
July 15, 2009 at 8:47 am
I know this topic is somewhat old, but has anyone worked with using this looping techniques and setting the connection string to use service account or anything other than nt authentication?
July 15, 2009 at 9:38 am
Yes, but it is not really related to WMI or this thread. Can you start a new thread with your question and use a specific example of what you want to do? I'll look out for it and there are many others that give prompt help for SSIS related questions.
April 9, 2010 at 1:08 pm
Hi Dave,
I know this is a very old post but this is exactly what I want and I have also created my package almost similar to the one you have explained in your posts and your SSIS & WMI Data Reader
Task Query article. The difference is that I am assigning the Connection String dynamically with the credentials.
My connection string looks exactly like you have explained
ServerName=\\123.12.123.12;Namespace=\root\cimv2;UseNtAuth=False;UserName=user_name;PassWord=pwd;. And I pass the @User::StringConnString variable to the ConnectionString property of the WMI connection.
I get an "Access Denied" message for every server except my local machine when I try to use the WMI Data Reader Task in an FELC.
I tested out the package without the FELC trying each server at a time to make sure my connection string is of the correct format. I get the statistics for 2 of the servers and my local machine, but an "Access Denied" message for all other servers and a machine in the same network as mine where I was given administrative access.
I really do not understand where the error really is and what settings I need to check for on all the other servers where I get the error. I see in your package that you mention of a bug in SSIS and a solution if we try to use a dynamic connection string. I do not know if I understand it correctly. If my Server Computer Name is "SQLDBSERVER" and the network is domain.network.org, should my ConnectionString property now look like this "\\\\SQLDBSERVER.domain.network.org" + @[User::ServerConnString]?
Your article was of great help to solve many issues I had with the FELC. Hope to hear from you soon. Thanks in advance.
Vinesh
April 12, 2010 at 2:51 am
hi Vinesh
First off I'll clarify the bug: if you try to set the ServerName property, using an expression it doesn't work. (this is what I initially tried, but couldn't get working, so dug about and found the bug on the Microsoft Connect site). This is why I then resulted to using the connection string.
Regarding the Access denied issue, you have two options on users credentials - define a local PC logon or windows integrated security.
It's also worth noting, that to query the WMI on the remote machine you will need admin permission on the remote machine.
If you define a username and password in your connection string, then you must make sure that the username and the password is set on each remote server you want to query.
If you use, windows integrated security (which is the easier option), then you need to run the package under an account that has admin rights on the remote servers. This is easiest done, by creating a credential on SQL server and then setting up a job to execute the package, running using the credentials.
I hope that helps. Give me a shout if you still have problems.
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
April 12, 2010 at 3:29 pm
Hi Dave,
Thanks for the response. Your solution to the bug is what I am using to query the servers and I used to get the results for 2 of the servers and not for the others when I wrote you the last post. This morning however, I got nothing from all of them. After a lot of pondering and poking I recreated the tasks again from scratch and somehow now I again get the results from the original 2 servers and an "Access Denied" from the others.
So I think that it has something to do with the access or the WMI, I'm not quite sure. The credentials I use for all the servers belong to the Administrators group in the respective servers. I pass those credentials through the Connection String in the Server_List Table.
So this time I took your advice of trying to individually querying the servers by passing the credentials in the WMI Connection Manager Editor. I have attached a screenshot of the error I get. I do not get this error for 2 of the servers, which is what makes things worse.
Do provide me with any more suggestions. They are really helpful.
Thanks & Regards,
Vinesh
April 13, 2010 at 2:29 am
Hi Vinesh,
I can't seem to open the bitmap image. Could you try to PM it me. thanks.
Also, is the user account you refer to a windows domain account?
or simply an machine account added to each servers admin group - i.e. Server1\AdminUser
Server2\AdminUser
and are you still using the same connection string that you posted earlier?
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
Viewing 15 posts - 31 through 45 (of 45 total)
You must be logged in to reply to this topic. Login to reply