AdvertView Utility for SMS 2003?

[Jpoandl]

Our SMS Administrators really like the SMS 2.0 Advertview utility. Is there something similar for SMS 2003?

Please let me know....

Thank you!

Joseph L. Poandl
MCSE 2003

If your company is in need of experts to examine technical problems/solutions, please contact

http://www.NJCOMPUTERNETWORKS.com

(Sales@njcomputernetworks.com)

 

[Karactur]

Try this report, and let me know how you like it.
[BLUE]
select CAS.AdvertisementID,ADI.AdvertisementName,CAS.LastAcceptanceStateName,CAS.LastAcceptanceStatusTime,CAS.LastStatusMessageIDName,CAS.ResourceID
from v_ClientAdvertisementStatus CAS
Left join dbo.v_AdvertisementInfo ADI on adi.AdvertisementID = cas.AdvertisementID
Where CAS.ResourceID = @SysID[/BLUE]

You will have to create a Prompt for SysID.

Karactur

 

[McTekTips2004]

I am using SMS AdvertView v2.0.1467 and I receive the following error whenever I expand the COLLECTIONS thread. Is there anyway to prevent this?

AdvertView has encountered a problem and needs to close. We are sorry for the inconvenience.

I am trying to use this tool to capture the contents of a collection so that it can be copied into an .XLS file.