connect to SCCM

[mrorange]

Hi!

I'm really new to AutoIT but think it's a great tool to automate things and want to use it more but have now run into a big brick wall...

My problem:

I want to connect to our SCCM database and run (for starters) a simple query and catch the result of that query. I've searched the Internet and this forum for some hints or examples but didn't find anything really useful. So if someone please just can get me started with a really basic example on how to do this I would be really grateful.

Here is my first few struggling steps (got all of the code from another thread: http://www.autoitscript.com/forum/index.ph...mp;hl=query+sms ) but it doesn't work.

Dim $Services, $Query, $CollectionSet, $Collection
$Services = objget("winmgmts:\\SERVERNAME\root\sms\site_SITECODE")
$Query = "SELECT SYS.Netbios_Name0, MAC.MAC_Addresses0, IP.IP_Addre......
$CollectionSet = $Services.ExecQuery($Query, "", 48)
For $Collection In $CollectionSet
MsgBox(4096,"Test",$Collection.sys.Properties_("Netbios_Name0"))
Next

Is this the way you are "suppose" to connect to a SCCM database and run a query? If anybody have a good example that actully works I'll be thrilled! ´

Thanks! /Peter