Enterprise Vault Message Queue Monitor

hello all 

what do these below lines represents exactly? i didnt manage to figure out.

what do $warning = 85
$critical = 90

thanks

Hello AKL,

I found that it is needed to also add the $freeSpaceFileName variable as follow:

$MSMQFileName = "D:\gertjan\MSMQCheck\LastVersion\Result\EV_MSMQ.htm"
$freeSpaceFileName = "D:\gertjan\MSMQCheck\LastVersion\Result\EV_MSMQ.htm"
$serverlist = "D:\gertjan\MSMQCheck\LastVersion\EVServers.txt"
$queuecountwarning = 100
$queuecountcritical = 200
$queuesizewarning = 10
$queuesizecritical = 20
$email_warning = 0
$email_critical = 0

If not, you get an error about a path.

I also re-adjusted the percentages in section: Function writeTableMemHeader to improve the layout (as below)

param($fileName) 
 Add-Content $fileName "<tr bgcolor=#CCCCCC>"
 Add-Content $fileName "<td width='5%' align='center'>Server Name</td>"
 Add-Content $fileName "<td width='50%' align='center'>Queue Name</td>"
 Add-Content $fileName "<td width='11%' align='center'>Message Count in Queue</td>"
 Add-Content $fileName "<td width='11%' align='center'>Message Size in QUeue (MB)</td>"
 Add-Content $fileName "<td width='11%' align='center'>Message Count in Journal Queue</td>"
 Add-Content $fileName "<td width='11%' align='center'>Message Size in Journal QUeue (MB)</td>"
 Add-Content $fileName "</tr>"

For the rest A+OK!

Hello All

Sorry for "long" delay in response but I was swarmed up in recent few weeks, either way, I've updated the main zip file attached with the original post.

Updates Made:

1. Remove initial common characters like "\server\private" from name: I've added a line in script (mentioned below) which strips off first 20 characters from queue name for making it look more compact. The figure 20 was for my environment, you'll have to edit it based on your organization requirement: $queuen = $queuen.Substring(20)
2. Added server name to header: As requested earlier, if no queue to report, script will still add server name in header for ease of read (cosmetic change)
3. All other updates which've been discussed originally have been incoroporated into main file.

Apart from same, though I couldn't make to blog but I was still reading updates via email. Unfortunately I haven't been able to figure out WMI class for clustered MSMQ yet, as soon as I get some information on same, I'll update here accordingly.

For purging MSMQ, we can add the code in script but I won't recommend purging of MSMQ to be automated task because it is very rare occassion when you've to purge EV MSMQ or any other application queues. If you're facing that issue frequently due to which you've a need to automate it, I'll recommend troubleshooting why issue has been happening frequently and remediate accordingly.

Please let me know if any further changes required in script - cosmetic or functionality.

Has anyone seen a script that can purge the msmqs?

Get-WmiObject -Class Win32_PerfRawData_MSMQ_MSMQQueue -ComputerName $server | Where-Object {$_.Name -like "*Enterprise Vault*"}

will not return any results if MSMQ is clustered.  It works only for standalone MSMQ.

Do you have the cluster name in the EVServers.txt file or just the physical server name(s)?

Hello,

I have a quick question: the script is using the following WMI query:

Get-WmiObject -Class Win32_PerfRawData_MSMQ_MSMQQueue -ComputerName $server | Where-Object {$_.Name -like "*Enterprise Vault*"}

Which seems to be working only for stand alone MSMQ.

Does anybody have a success to have this work in the clustered MSMQ?

Thank you in advance,

Victor

And, out of curiosity, what other monitoring scripts you have? Specifically for EV...

Hello AKL,

Fantastic! I am not (yet) a Powershell Guru, so thanks for looking into this.

Last (I think question/remark).

The report now indeed shows only queues larger than the value as given. However, when there is a server where all queues are less than the value, it only shows a greybar with the headings. See JPG for example.

Would it be possible to add the servername to the header "ServerName"? and/or

Would it be possible to add a line like: "no queues over threshold on "servername" " when a server has no queues below the threshold?

I assume you uploaded the edited PS1 to your initial post?

Thanks again!

Gertjan

Thanks a lot Gertjan for the modifications made to make the query better and stable. I apologize for late response.

For remaining points:

To Leave out the queues that are below threshold values.

You can replace below line in original script:

writememInfo $MSMQFileName $server $queuen $queuec $queues $queuejc $queuejs

With this line:

If (($queuec -ge $queuecountwarning) -and ($queues -ge $queuesizewarning)) {writememInfo $MSMQFileName $server $queuen $queuec $queues $queuejc $queuejs}

This will make sure only queues that are above thresholds are reported in email.

I must say, this idea was BRILLIANT and it helped me update remaining of my monitoring scripts as well. The filtered results are easier to view on smartphones and we don't have to scroll through complete thing now !

To Sort the queues with their names.

Replace below line in original script

$queues = Get-WmiObject -Class Win32_PerfRawData_MSMQ_MSMQQueue -ComputerName $server | Where-Object {$_.Name -like "*Enterprise Vault*"}

With this line

$queues = Get-WmiObject -Class Win32_PerfRawData_MSMQ_MSMQQueue -ComputerName $server | Where-Object {$_.Name -like "*Enterprise Vault*"} | Sort-Object -Property Name

I should've thought that in first place, it's a good learning point.

Lastly, Truncating name of queue is something I didn't spend much time on yet as it is tricky to truncate the strings and I haven't played with string values a lot so far. I'll try to update that as well, but however I hope that it is just tailoring correction and it doesn't reduces script's ability for monitoring.

Thanks again for the ideas - They helped a lot !