How to connect to and read data from Mailboxes, Calendars, … via Exchange Web Services and vbScript?
I offen wondered how I can programmatically read items from mailboxes stored within Microsoft Exchange Server. Some time ago I used Outlook with some macros that accessed the information I needed. But what if Outlook does not run? Or what if the computer crashed – who would logon and start Outlook? Sure you can find workarounds for every problem. But this never seemed to be a ‘cool’ solution to me. In the past few weeks – after I got my Exchange 2010 MCITP – I started to have a look at EWS – Exchange Web Services (available since Microsoft Exchange Server...Read More
May be some of you already got stuck with the problem about xml http calls, vbscript and secured websites with certificate problems – the others surely will… There are some problems occurring right often. For example the host name does not match the subject name of the certificate or the certificate is not valid (yet) or the certificate’s chain is broken. Here you can see 2 of those errors: Error 80072F0D in msxml3.dll: The certificate authority is invalid or incorrect Error 80072F06 in msxml3.dll: The host name in the certificate is invalid or does not match When opening...Read More
Sometimes it happened to me, that our Microsoft System Center Configuration Manager 2007 R2 (sccmsrv01) failed to login at our dedicated MS SQL 2005 2 nodes cluster (cluster: sqlclu, node 1: sqlclu01 and node 2: sqlclu02). Everything you could find in the sql logs was: Error: 18456, Severity: 14, State: 11. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 192.168.1.10] Since I knew that SCCM wouldn’t try to logon anonymously at the dedicated sql server but with its machine account the error seemed to be related on kerberos and service principal names (SPN). I checked this...Read More
This query shows all queries executed at the moment, the session id, status, used cpu time and the execution duration SELECT st.text, r.session_id, r.status, r.command, r.cpu_time, r.total_elapsed_time FROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS st The following query shows the number of connections a user has with a database SELECT db_name(dbid) as DatabaseName, count(dbid) as NoOfConnections, loginame as LoginName FROM sys.sysprocesses WHERE dbid > 0 GROUP BY dbid, loginameRead More