Chris Stauffer at myITForum.com

I had to create a report today that only shows the newest numbers for an advertisement. I wanted to use it for the Health Checks. This report will show me the results of an advertisement for the last 24 hours. I'm using it in a dashboard to show me how well my health check solutions are working on a daily basis.

Just change the advertisement number to one that works for you.

Hope this helps someone else out.

--******************************************************

declare @Total int

declare @Accepted int

select @Total=count(*)

, @Accepted=sum(case LastState when 0 then 0 else 1 end)

from v_ClientAdvertisementStatus

where AdvertisementID= 'XXX20019'

SELECT     LastAcceptanceStateName AS C013

,count (*) as C015

,ROUND(100.0*count(*)/@Total,1) as C016

,AdvertisementID

FROM         v_ClientAdvertisementStatus

WHERE     ((AdvertisementID = 'XXX20019')and(LastStatusTime > GETDATE() - 1))or((AdvertisementID = 'XXX20017')and(LastAcceptanceStateName = 'No Status'))

GROUP BY LastAcceptanceStateName, AdvertisementID

SELECT     LastStateName AS C017

,count(*) as C015

,ROUND(100.0*count(*)/@Accepted,1)  as C016

,AdvertisementID

FROM         v_ClientAdvertisementStatus

WHERE     (AdvertisementID = 'XXX20019') AND (LastState <> 0)and (LastStatusTime > GETDATE() - 1)

GROUP BY LastStateName, AdvertisementID

I was having a weird connection issue with one of my sites this week and actually for the last few weeks. I tried everything I could remotely though another admin but it just wasn't getting resolved so I decided to go on site today. Here is the error I was seeing in the sender.log

There is no existing connection, Win32 error = 1907         SMS_LAN_SENDER      10/23/2007 8:22:33 AM  7420 (0x1CFC)

There is no existing connection, Win32 error = 53 SMS_LAN_SENDER      10/23/2007 8:22:36 AM  8128 (0x1FC0)

There is no existing connection, Win32 error = 5   SMS_LAN_SENDER      10/23/2007 8:22:56 AM  5304 (0x14B8)

The weird error was the 1907 this means "The user's password must be changed before logging on the first time." Thanks Steve Thompson for that translation.

Error 5: Access Denied

Error 53: problem in NetBIOS name resolution

Anyway here is the solution:

Here was the problem. Someone had checked off "User Must Change Password at next logon"  My guess is this caused the account to get locked out. This would explain the error 1907 and error 5. Not sure why it was also getting 53 but anyway...

I removed the checkmark and changed the password on the local account and the sender account and now everything is happy.

just got this from the list

 A hotfix rollup package is available for the Microsoft Systems Management Server 2003 client

http://support.microsoft.com/default.aspx?scid=kb;en-us;941395&sd=rss&spid=2890

The commonwealth October SMUG meeting went well yesterday. Special thanks to Tev Sanders once again for filling in some of the presentaion time for me.

 Here is my part of the presentation if anybody is interested in it.

I had to move a server to new hardware over the last 4-5 days. This document will explain how it should be done. I couldn’t find anything anywhere explaining this before and since I had issues I though I would have how to do it properly.

Hope this helps someone.

The Cause of Code 80041010

Your VBScript contains a misspelled object name.  Code 80041010 is an unusual Error in that a number is returned rather than 'Syntax Error' or other message.

But when you are dealing with SMS this is not the case because you didn’t write the code Microsoft did and it was working before so it should work now right???

A value had changed for my HKLM\SOFTWARE\Microsoft\WBEM\Scripting\ key. The
Default Namespace value changed to ROOT\DEFAULT. Change it to ROOT\CIMV2 and restarted the SMS_REPORTING service, reporting should work fine now.

Got these from the Email list.

http://support.microsoft.com/kb/936465/ (server patch)
http://support.microsoft.com/kb/937330/  (server/OSD patch)
http://support.microsoft.com/kb/939872/ (advanced client patch)
http://support.microsoft.com/kb/940619/ (server patch)
http://support.microsoft.com/kb/940182/ (sms_def.mof edit)

http://support.microsoft.com/kb/937882/