SQLServerCentral / Discuss Content Posted by Roy Carlson / Article Discussions / Article Discussions by Author / No Outlook for Alerts! / Latest Posts

RE: No Outlook for Alerts!

Bart Snyder — Tue, 12 Sep 2006 14:28:00 GMT

I get this error when I try and run the script. Any thoughts.

[Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error

RE: No Outlook for Alerts!

rscarlson — Fri, 16 Sep 2005 08:23:00 GMT

No http - no go.

You could redirect the output to open an instance of word, excel, etc., then use this accross the lan but there are some issues with this especially with XP, SP2. I will consider this for a future article.

RE: No Outlook for Alerts!

Ryan-209402 — Wed, 14 Sep 2005 07:49:00 GMT

There are several lines in Alert.vbs that reference Microsoft's site. If my SQL server does not have HTTP access do the web what are my options here? Thanks.objEmail.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 'name of notesserverhost ? objEmail.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/smtpserver") = _ "mailserver" objEmail.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25

RE: No Outlook for Alerts!

rscarlson — Tue, 13 Sep 2005 06:48:00 GMT

Sorry the line strClass = "Win32_NTEventLog"

Should read:

strClass = "Win32_NTLogEvent"

RE: No Outlook for Alerts!

rscarlson — Tue, 13 Sep 2005 06:43:00 GMT

If you go to command prompt and type in wbemtest and enter.

Hit connect.

Change the location from:

root\default to root\cimv2 and hit login

Hit enumerate classes, use recursive radio button, hit ok

You will no have a list of all the classes and their properties. You can scroll down to Win_NTLogEvent to see the properties in the middle window.

Or you can cut and paste this script as ClassInfo.vbs

Const wbemFlagReturnImmediately = &h10Const wbemFlagForwardOnly = &h20

On Error Resume Next

arrComputers = Array(".")

For Each strComputer In arrComputers WScript.Echo WScript.Echo "==========================================" WScript.Echo "Computer: " & strComputer WScript.Echo "==========================================" strClass = "Win32_NTEventLog"Get objWMIService = _ GetObject("winmgmts:{impersonationLevel=impersonate}root\cimv2")

Set colClasses = objWMIService.ExecQuery("SELECT * FROM " & strClass, "WQL", _ wbemFlagReturnImmediately + wbemFlagForwardOnly)

i = 0For Each objClass In colClasses i = i + 1 If i = 1 Then WScript.Echo "* Properties *" For Each objProperty In objClass.Properties_ WScript.Echo objProperty.Name Next

WScript.Echo vbNewLine & "* Methods *" For Each objMethod In objClass.Methods_ WScript.Echo objMethod.Name Next End IfNext

Hope this helps

RE: No Outlook for Alerts!

philcart — Mon, 12 Sep 2005 16:27:00 GMT

Good article. Just proves there is more than one way to skin a cat

"I cannot find Win32_NTLogEvent anywhere"This is a WMI class. There is a whole bunch of them in Windows http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/wmi_reference.asp

"...you know that MAPI is a goner in 2005"Well it's not actually gone, it's still there but you have the option of using a new thing called DatabaseMail which is SMTP based. Realistically, I don't know that many DBA's given the option would use SQL Mail and rely on MAPI and Exchange.

RE: No Outlook for Alerts!

Grazyna Trzesicka — Mon, 12 Sep 2005 15:30:00 GMT

Sorry, but I cannot find Win32_NTLogEvent anywhere. What is it - an mssql table, a file?

RE: No Outlook for Alerts!

noeld — Mon, 12 Sep 2005 10:06:00 GMT

One more thing: Isn't it possible to filter also on the DATE in the query?

btw: Very nice script!

RE: No Outlook for Alerts!

Dale Corey — Mon, 12 Sep 2005 06:36:00 GMT

Roy,

Pretty slick! By the way, you know that MAPI is a goner in 2005?

No Outlook for Alerts!

rscarlson — Tue, 23 Aug 2005 17:19:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rcarlson/nooutlookforalerts.asp