Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

No Outlook for Alerts! Expand / Collapse
Author
Message
Posted Tuesday, August 23, 2005 5:19 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 22, 2011 8:36 AM
Points: 28, Visits: 6
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rcarlson/nooutlookforalerts.asp


Post #213196
Posted Monday, September 12, 2005 6:36 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, February 15, 2012 9:18 AM
Points: 415, Visits: 4

Roy,

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




All the best,

Dale

Author: An Introduction to SQL Server 2005 Management Studio
Post #218786
Posted Monday, September 12, 2005 10:06 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 6:06 AM
Points: 6,259, Visits: 2,030

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

btw: Very nice script!

 




* Noel
Post #218867
Posted Monday, September 12, 2005 3:30 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 24, 2006 11:52 AM
Points: 112, Visits: 1
Sorry, but I cannot find Win32_NTLogEvent anywhere.  What is it - an mssql table, a file?
Post #218969
Posted Monday, September 12, 2005 4:27 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:44 PM
Points: 2,693, Visits: 1,213

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.

 



Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface

Australian SQL Server User Groups - My profile
Phills Philosophies
Murrumbeena Cricket Club
Post #218988
Posted Tuesday, September 13, 2005 6:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 22, 2011 8:36 AM
Points: 28, Visits: 6

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 = &h10
Const 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 = 0
For 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 If
Next

Next

 

Hope this helps




Post #219138
Posted Tuesday, September 13, 2005 6:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 22, 2011 8:36 AM
Points: 28, Visits: 6

Sorry the line strClass = "Win32_NTEventLog"

Should read:

strClass = "Win32_NTLogEvent"

 

 




Post #219139
Posted Wednesday, September 14, 2005 7:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 19, 2013 8:55 AM
Points: 121, Visits: 101
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
Post #219615
Posted Friday, September 16, 2005 8:23 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 22, 2011 8:36 AM
Points: 28, Visits: 6

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. 




Post #220694
Posted Tuesday, September 12, 2006 2:28 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 19, 2008 9:50 AM
Points: 15, Visits: 7

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

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

Post #308023
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse