Advert info from Collection

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Advert info from Collection - Ron's Report

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Advert info from Collection - Ron's Report

Page: [1]

Message

<< Older Topic Newer Topic >>

Advert info from Collection - Ron's Report - 9/4/2008 9:54:25 AM

hwilson542

Posts: 24
Score: 0
Joined: 3/23/2006
Status: offline

Hello...
I am trying to get the Advert ID from a collection that is being used in Ron's Reports on SMS 2003.

I tried this but it doesn't work.
* * * * * * * * *
dim strCollID, CompName, strAdvert, lLocator, gService
strCollID = "GV100038"
CompName = "GVKN0116517"
set lLocator = CreateObject("WbemScripting.SWbemLocator")
Set gService = lLocator.ConnectServer("GVPW64", "root/sms/site_GV1")
strAdvert = gService.ExecQuery("Select AdvertisementID From SMS_Advertisement Where CollectionID = " & chr(34) & strCollID & chr(34))

msgbox "Advert: " & strAdvert
* * * * * * * * *

Any help is always appreciated.

_____________________________

Henry E. Wilson
Sanofi-Aventis
Malvern, PA 19355
610-889-6235